Understanding Wait Stats in SQL Server: A Practical Guide
When working with SQL Server, one of the best tools DBA’s can use for diagnosing performance issues is wait statistics
August 14, 2025
Category: SQL Server
Removing Personally Identifiable Information in Development Environments
When testing code, it’s critical to have enough robust data. This often requires removing personally identifiable information. Find out how!
July 30, 2025
A Common Misconception About SQL Server Backups
The misconception about SQL Server backups: file-level backups are the same thing or as good as a native SQL Server backup of the database.
July 14, 2025
SQL Server AG Won’t Become Primary After Force Quorum? Here’s Why and How to Fix It
If you’ve encountered a situation where none of your SQL Server Always On Availability Group (AG) replicas become PRIMARY after a cluster failure — you’re not alone. We recently had a customer with this exact scenario (AG won’t become primary after force quorum), and it is both uncommon and difficult to troubleshoot so I thought it would be worth posting about.
June 5, 2025
Safeguarding Your Data: Navigating SQL Backup, Compliance, Maintenance, and Support Challenges
As businesses become increasingly data-driven, the role of SQL databases has become critical to day-to-day operations. Yet, many organizations underestimate
May 30, 2025
Removing Stubborn Partitions in SQL Server
What are stubborn partitions in SQL Server and how do you delete them? This was an interesting issue I recently had
April 11, 2025
SSMS Essential Settings
With the recent announcement by Microsoft that they’re removing Azure Data Studio alongside the release of the new 64-bit version
March 20, 2025
SSMS 21 Gets a Fresh New Look: What’s Changed?
Microsoft just unveiled preview #5 of SQL Server Management Studio (SSMS) 21, and one of the most exciting updates is
March 14, 2025
Achieving Cost-Effective Scalability with Modern SQL Databases
Introduction As businesses grow, so do their data needs. Managing massive datasets while controlling costs is a challenge every organization
February 20, 2025
How Streaming Data is Revolutionizing SQL Databases
Microsoft recently announced SQL Server Management Studio (SSMS 21). Here’s a quick look at what’s included in this latest iteration.
January 20, 2025