Main

related bits

0

processing priority

4

site type

3 (personal blog or private political site, e.g. Blogspot, Substack, also small blogs on own domains)

review version

11

html import

20 (imported)

Events

first seen date

2024-08-11 01:55:21

expired found date

-

created at

2024-08-11 01:55:21

updated at

2026-01-27 18:18:35

Domain name statistics

length

26

crc

591

tld

2211

nm parts

0

nm random digits

0

nm rare letters

0

Connections

is subdomain of id

13642151 (wordpress.com)

previous id

0

replaced with id

0

related id

-

dns primary id

0

dns alternative id

0

lifecycle status

0 (unclassified, or currently active)

Subdomains and pages

deleted subdomains

0

page imported products

0

page imported random

0

page imported parking

0

Error counters

count skipped due to recent timeouts on the same server IP

0

count content received but rejected due to 11-799

0

count dns errors

0

count cert errors

0

count timeouts

0

count http 429

0

count http 404

0

count http 403

0

count http 5xx

0

next operation date

-

Server

server bits

server ip

-

Mainpage statistics

mp import status

20

mp rejected date

-

mp saved date

-

mp size orig

121427

mp size raw text

23250

mp inner links count

9

mp inner links status

20 (imported)

Open Graph

title

Joel Fillmore

description

image

site name

Joel Fillmore

author

updated

2026-01-25 21:10:50

raw text

Joel Fillmore Joel Fillmore Skip to content Home About Me Compressed UTF-8 Strings in SQL Azure Posted on August 31, 2011 by joelfillmore SQL Azure costs are primarily based on which size database you choose to provision. Given the premium over the cost of blob storage you’ll want to avoid storing large amounts of data that could be kept in files. However, most applications have several medium sized text fields which aren’t used as query modifiers. It might be something like user comments to a blog post or in my case, product descriptions on a shopping site. These fields are ideal candidates for compression to reduce costs. The enterprise edition of SQL Server has both row and page level compression, but unfortunately this feature hasn’t made it to SQL Azure yet. Wayne Berry has a great post which discusses which columns are good candidates for manual compression and walks through the process of converting a column to use .NET GZipStream compression. In this po...

Text analysis

redirect type

0 (-)

block type

0 (no issues)

detected language

1 (English)

category id

Other [en] (231)

index version

2025123101

spam phrases

0

Text statistics

text nonlatin

0

text cyrillic

0

text characters

17199

text words

3462

text unique words

1026

text lines

351

text sentences

129

text paragraphs

47

text words per sentence

26

text matched phrases

3

text matched dictionaries

1

RSS

rss status

32 (unknown)

rss found date

2024-08-22 05:47:23

rss size orig

72061

rss items

6

rss spam phrases

0

rss detected language

1 (English)

inbefore feed id

-

inbefore status

0 (new)

Sitemap

sitemap status

10 (sitemap found, awaiting processing)

sitemap review version

2

sitemap urls count

8

sitemap urls adult

0

sitemap filtered products

0

sitemap filtered videos

0

sitemap found date

2024-08-13 06:37:36

sitemap process date

2024-08-13 06:37:36

sitemap first import date

-

sitemap last import date

-