SSG Blog
Insights and news from the SQL Solutions Group.
Recent
Intermittent “Cannot Generate SSPI Context” in SQL Server? Here’s the 2022 Kerberos Trap (and How to Fix It)
Windows logins to a SQL Server AG started throwing “Cannot generate SSPI context” — but only sometimes, and only for some people. We solve it.
Full-Text Index Breaking Change in SQL Server 2025
Upgrading to SQL Server 2025 means addressing a full-text index breaking change. We walk you through the steps to do that.
Why Delaying a SQL Server Upgrade Could Cost More Than You Think
During a recent webinar focused on SQL Server 2025, Rich explored one of the most common patterns seen across enterprise IT environments. Organizations know they
Moving System Databases: A How-To
As consultants, we often see system databases existing on the C drive on SQL Servers. There are some issues with this setup, and the biggest
Group Managed Service Accounts and SQL Server: What You Actually Need to Know
Service account management is one of the quietest ways a SQL Server estate goes wrong. Passwords get set once during install, written down somewhere (or
Still Running SQL Server 2016? Here’s Why It’s Time to Upgrade
Many organizations are still relying on SQL Server 2016 to power critical systems. It’s familiar, stable, and “still working”—so it’s easy to push an upgrade