Adding a VLDB database to an SQL Server Availability Group
Recently, I was tasked with making an 60TB database highly available by adding it to an availability group. The following,...
2015-08-26 (first published: 2015-08-18)
2,096 reads
Blog Posts
Agile Development – A DBA’s Initial Thoughts
I recently had the opportunity to attend a three day Agile development workshop. At a very high level, Agile development...
2015-08-26
627 reads
Critical Virtualized Database Education at VMworld
If you are one of the lucky ones who gets to attend VMworld USA this year, and you have any...
2015-08-26
631 reads
Nesting Aggregates with Window Functions
Recenty I was writing an article for MSSQLTips where I had to create a treemap (it will be published soon)....
2015-08-26 (first published: 2015-08-18)
2,600 reads
Shredding XML in XEvents
One of the biggest pains with Extended Events is the thing we love to hate - XML. XML is so foreign to many DBAs. It's not relational and often...
2015-08-26
17 reads
Shredding XML in XEvents
One of the biggest pains with Extended Events is the thing we love to hate – XML. XML is so foreign...
2015-08-26
944 reads
Slides and Demos for #SQLSupper August meeting
Last night I had a lot of fun presenting on one of my favorite topics, MARS and SQL Server protocols...
2015-08-26
495 reads
Slides and Demos for SQLSupper August meeting
Last night I had a lot of fun presenting on one of my favorite topics, MARS and SQL Server protocols including a rather fun live demo.
The slides and demo...
2015-08-26
8 reads
Slides and Demos for SQLSupper August meeting
Last night I had a lot of fun presenting on one of my favorite topics, MARS and SQL Server protocols...
2015-08-26
42 reads
Slides and Demos for SQLSupper August meeting
Last night I had a lot of fun presenting on one of my favorite topics, MARS and SQL Server protocols...
2015-08-26
51 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