TSQL Tue #79: When the Memory is All Gone
I used to blog. Today I ashamedly realized it’s been nearly six months since my last post. That’s pretty pathetic. I was doing a couple a month there for a nearly 2 years … Continue reading
Informed Decision – FORCE_SERVICE_ALLOW_DATA_LOSS
Recently we had a disaster recovery event on a couple of mirrored servers. By that, I mean we were required to move primary database operations to an offsite mirror partner. Because … Continue reading
The Single Greatest Feature of Microsoft SQL Server
SQL 2014 RTM was just announced! I started working with SQL Server at version 7.0. It was upgraded to 2000 a few months later so I don’t have tons of experience with 7.0 but … Continue reading
Cardinality of dm_exec_sessions and dm_exec_connections
For my own edification I have been working on a simplified entity relationship map of some of the more popular DMVs. Yes I know Microsoft already makes this available. But working it … Continue reading