A Bug: Log Shipping in Contained Availability Groups
We’ve recently come up across a fun little bug with log shipping in contained availability groups. A cursory Google search
November 3, 2025
Category: SQL Server
Slimming Down your SQL Database Could be the Answer to your Performance Issues
Explore in-memory/memory-optimized tables in SQL Server and if you should use this feature in your production environment.
November 2, 2025
How AI is Becoming the DBA’s New Assistant : Insights from Microsoft Certified Master, Randy Knight
Explore in-memory/memory-optimized tables in SQL Server and if you should use this feature in your production environment.
October 31, 2025
Wrestling with Full-Text Search in SQL Server
Explore in-memory/memory-optimized tables in SQL Server and if you should use this feature in your production environment.
September 30, 2025
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