A DMV a Day – Day 28
The DMV for Day 28 is sys.dm_io_pending_io_requests, which is described by BOL as:
Returns a row for each pending I/O request...
2010-04-28
1,265 reads
BLOB Index Columns
For the April T-SQL Tuesday, I blogged about a report to find information on the BLOBs in a database. I...
2010-04-27
1,235 reads
SQL Server 2008 and 2008R2 Diagnostic Information Queries
Since SQL Server 2008 R2 has gone RTM, and will be available on MSDN Subscribers on May 3, I thought...
2010-04-27
1,932 reads
The PowerShell and XML Corollary
Girl Property Surrounded by Geek Objects
I’ve just started watching The Big Bang Theory so I figured I’d borrow a naming...
2010-04-27
805 reads
In, Exists and join – a roundup
Over the last several months I’ve had a look at IN, Exists, Join and their opposites to see how they...
2010-04-27
1,355 reads
A DMV a Day – Day 27
The DMV for Day 27 is sys.dm_tran_locks, which is described by BOL as:
Returns information about currently active lock manager resources....
2010-04-27
7,554 reads
PASS Summit, Kilt Wednesday
Last year at the PASS Summit we held a silly little event called Kilt Wednesday. Only three people took part,...
2010-04-27
1,405 reads
SQLSaturday #49 Call for Speakers is Open & Call for Our PreCon Seminar
SQLSaturday #49 will be held in Orlando on October 16th, 2010, and our call for speakers is now open. We’re...
2010-04-27
593 reads
One Trip Booked – TechEd 2010
Tia thinks I’m crazy to book early, but I like to have a choice of flights, and I like to...
2010-04-27
781 reads
SQL Server Replication Overview
For my next series of blog posts I intend to document and write about SQL Server replication. This is a...
2010-04-27
2,506 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
How Can Database Performance Improve the Overall Website Experience?
I’ve been looking into ways to improve the connection between a website and its...
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
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