SSG Blog
Insights and news from the SQL Solutions Group.
Recent
Table Variables, TVPs, and the One-Line CPU Fix
Twice in the last two weeks I’ve been pulled into a “the server is pegged at 100% CPU and we don’t know why” fire drill,
“Is anyone still using this database?” How to find stagnant databases
“Is anyone still using this database?” I have been asked this question a surprising number of times lately. The answer can be trickier to find
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