Tracking End of Support/Life Software
I wanted to save this link to the Microsoft Support Lifecycle page and thought I’d share as well. It’s a...
2012-12-22
1,175 reads
Tempdb Contention That Can’t be Soothed
Tempdb Contention That Can’t be Soothed By Adding Files
Tempdb Contention via Idera diagnostic manager
I’ve talked a lot in the past...
2012-12-21
1,461 reads
Recharging Again
I’m off again, taking a week in Steamboat Springs with my family for the Christmas holiday. We’re spending a week...
2012-12-21
918 reads
It’s A Data Type Conversion Chart
This may not be the coolest thing in the world, but it is quite useful. From the annals of Books...
2012-12-21
665 reads
Reblog: December 14 to December 20
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2012-12-21
902 reads
Long time no blog…
So, you may have noticed that things have been a little quiet around here of late. Sorry about that, I’ve...
2012-12-21
819 reads
Dude Where Did my AD Account Go? Troubleshooting Duplicate SID's.
Hello Dear Reader! I've been working on Setting up a Virtual Lab in using Virtual Box on my work laptop....
2012-12-21
1,489 reads
On the Ninth Day…
Creating a custom data collector can be very handy for a DBA. Especially in times of troubleshooting. These collectors are also quite useful for trending and analysis. Consider this...
2012-12-21
19 reads
On the Ninth Day…
It’s the end of the world as we know it. And as the song goes…I feel fine! But hey, we...
2012-12-21
1,235 reads
Introduction to Microsoft’s Master Data Services (MDS) Presentation Slides
Thanks to everyone who attended my “Introduction to Microsoft’s Master Data Services (MDS)” for the Data Architecture Virtual Chapter. The recording...
2012-12-21
1,179 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
Massive Table Growth Issue – How to Set Up Filegroup Usage Alerts?
Hello We recently encountered an issue where a SQL table unexpectedly grew in size...
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers