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,027 reads
Blog Posts
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
564 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
348 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
669 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,352 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,708 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,020 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
435 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,356 reads
Differential Backups
My last few posts have been backup orientated, I have a post on Full Backup, a post on Transaction Log...
2010-04-04
1,303 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
When And How to Automate?
Comments posted to this topic are about the item When And How to Automate?
Hyperscale Replicas II
Comments posted to this topic are about the item Hyperscale Replicas II
Practical Reporting Queries with CROSS APPLY (Part 3)
Comments posted to this topic are about the item Practical Reporting Queries with CROSS...
Question of the Day
Hyperscale Replicas II
How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?
See possible answers