How should you respond when you get the dreaded Email/Slack/Text/DriveBy from someone yelling at you that SQL Server is slow? Stop. Don’t Open SSMS Yet. You’ve heard it...
2025-10-08 (first published: 2025-09-17)
433 reads
Flexibility and Scale at the Database Level When SQL Server 2012 introduced Availability Groups (AGs), they changed the HA/DR game. Unlike Failover Cluster Instances (FCIs), which protect the whole...
2025-09-10
28 reads
Old Reliable Still Matters If you’ve been around SQL Server for a while, you’ve heard of Failover Cluster Instances (FCIs). They’ve been part of SQL’s high availability toolbox since...
2025-09-19 (first published: 2025-09-03)
219 reads
It’s not glamorous, but it works In a world where shiny new HA/DR features get all the press, there’s one SQL Server technology that just keeps doing its job....
2025-09-15 (first published: 2025-08-27)
230 reads
If you’re responsible for a SQL Server instance, you need working, consistent backups. Not just a .bak file here and there, but a plan that runs automatically and covers...
2025-08-20
53 reads
Corruption isn’t a “maybe someday” problem – what you need to do now. Stop. Don’t panic. You just ran DBCC CHECKDB for the first time in a while (or...
2025-08-13
27 reads
“SQL Server is slow.” We’ve all heard it. But that doesn’t always mean SQL Server is the problem. And “slow” means nothing without context and ability to verify. More...
2025-08-27 (first published: 2025-08-06)
513 reads
If you’re a DBA, sysadmin, IT manager, or Accidental DBA, you’ve probably seen SQL Server’s built-in Maintenance Plans. They live right there in SSMS under the “Management” node, quietly...
2025-08-15 (first published: 2025-07-30)
447 reads
The SQL Server installer has gotten better: tempdb configuration, MAXDOP, and even max memory can now be configured during setup. But don’t be fooled: there’s still a post-install checklist...
2025-07-23
74 reads
Why You Shouldn’t Overlook This Quiet but Critical SQL Server Setting If you’ve ever upgraded a SQL Server instance and something just broke in your application, chances are...
2025-07-16
469 reads
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Security has long been a problem for me. Every time I think I understand...
Comments posted to this topic are about the item BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers