Contained Availability Groups in SQL Server 2022: What You Need to Know
Overview One of the more intriguing features introduced in SQL Server 2022 is Contained Availability Groups (AGs). At first glance,
September 15, 2025
Category: SQL Server
An introduction to Memory-Optimized Tables in SQL Server
Explore in-memory/memory-optimized tables in SQL Server and if you should use this feature in your production environment.
September 15, 2025
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
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