id
name
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)
first seen date
2024-02-23 19:54:51
expired found date
-
created at
2024-06-10 20:31:38
updated at
2024-08-03 12:52:19
length
14
crc
26568
tld
2211
nm parts
0
nm random digits
0
nm rare letters
0
is subdomain of id
-
previous id
0
replaced with id
0
related id
-
dns primary id
dns alternative id
0
lifecycle status
0 (unclassified, or currently active)
deleted subdomains
0
page imported products
0
page imported random
0
page imported parking
0
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 bits
—
server ip
-
mp import status
20
mp rejected date
-
mp saved date
-
mp size orig
120688
mp size raw text
23217
mp inner links count
0
mp inner links status
1 (no links)
title
Joel Fillmore
description
image
site name
Joel Fillmore
author
updated
2025-12-23 06:59:23
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...
redirect type
0 (-)
block type
0 (no issues)
detected language
1 (English)
category id
Other [en] (231)
index version
2025123101
spam phrases
0
text nonlatin
0
text cyrillic
0
text characters
17174
text words
3457
text unique words
1026
text lines
349
text sentences
129
text paragraphs
47
text words per sentence
26
text matched phrases
3
text matched dictionaries
1
links self subdomains
0
links other subdomains
links spam adult
0
links spam random
0
links spam expired
0
links ext activities
0
links ext ecommerce
0
links ext finance
0
links ext crypto
0
links ext booking
0
links ext news
1
links ext leaks
0
links ext ugc
102 - s0.wp.com, joelfillmore.wordpress.com, wp.me, s1.wp.com, wordpress.com, joelfillmore.files.wordpress.com, flickr.com, twitter.com, en.wordpress.com
links ext klim
0
links ext generic
4
dol status
0
dol updated
2025-12-23 06:59:23
rss path
rss status
1 (priority 1 already searched, no matches found)
rss found date
-
rss size orig
0
rss items
0
rss spam phrases
0
rss detected language
0 (awaiting analysis)
inbefore feed id
-
inbefore status
0 (new)
sitemap path
sitemap status
1 (priority 1 already searched, no matches found)
sitemap review version
1
sitemap urls count
0
sitemap urls adult
0
sitemap filtered products
0
sitemap filtered videos
0
sitemap found date
-
sitemap process date
-
sitemap first import date
-
sitemap last import date
-