When your index rebuilds are stuck at 0% (but lying to you)
Ever had a situation where you’re rebuilding a large index but when you check sp_whoisactive, you see 0% complete …
September 10, 2026
Category: SQL Server
The Mysterious Case of the Bloated templog
This is a real customer problem that we’ve dealt with, but it was “edge case” enough that we thought it
September 1, 2026
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, and twice the fix turned out to be a single hint on one line of code.
August 3, 2026
“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
July 14, 2026
California Educational Computer Consortium: “The ROI has been substantial in both risk reduction and operational efficiency”
The case study below was submitted by Harry Harrison — Program Manager, Software Services — from the California Educational Computer
June 19, 2026
“Their experience and attention to detail helped reduce risk”
An anonymous client shares their experience using SSG’s expertise to support a zero-downtime migration of their SQL Server environment.
June 18, 2026
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.
June 10, 2026
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.
May 25, 2026
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
May 18, 2026
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
May 4, 2026