Writing With More Than One Voice
I’ve been blogging for a couple of years now and have slowly settled into the style and pattern of blogging...
2010-04-06
301 reads
Blog Posts
A DMV a Day – Day 5
The DMV for Day 5 is sys.dm_db_mirroring_auto_page_repair, which is described by BOL as:
Returns a row for every automatic page-repair attempt...
2010-04-05
1,022 reads
Express Yourself Clearly
Recently my son had a short paper to write for school. He’s a sixth grader, and this year is a...
2010-04-05
559 reads
Get Users By Connection
Introduction
I was recently working a production issue that required me to log in via the Dedicated Administrator Connection (DAC). When...
2010-04-05
342 reads
HTC Pro Trade-In
I saw a note that T-Mobile is accepting trade-ins of an iPhone for credit towards a new HTC HD2. That’s...
2010-04-05
662 reads
Microsoft Drops Support For Itanium after SQL Server 2008 R2
Microsoft’s Dan Reger has announced that Microsoft will not be supporting the Itanium architecture after Windows Server 2008 R2, SQL...
2010-04-05
2,336 reads
Nested views causing query performance woes....
Just ran into an interesting issue AGAIN. It seems that when you nest views in a query you are opening...
2010-04-05
8,687 reads
nHibernate, First Look at TSQL
I’ve blogged in the past about the nHibernate project that has been going on at my company for the last...
2010-04-05
1,017 reads
Product Review: Fences
Fences is a free utility for the Windows desktop that lets you drag shortcuts into boxes you define (fences) and...
2010-04-05
429 reads
A DMV a Day – Day 4
The DMV for Day 4 is sys.dm_os_sys_memory, which is described by BOL as:
Returns memory information from the operating system. SQL...
2010-04-04
1,347 reads
Blogs
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Forums
Purpose of the Rice Purity Test
The main purpose of the Rice Purity Test is entertainment and self reflection. Many...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers