SSG Blog
Insights and news from the SQL Solutions Group.
Recent

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.

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 the ongoing demands of managing

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 to deal with on a

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 of SQL Server Management Studio

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 its sleek, modernized interface. For
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 faces. Enter cost-effective scalability—a solution