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

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

Why use PowerShell when you can use T-SQL?
Why use PowerShell? I’ve lost count of how many times I have been asked this question. Most of the time, the inquirer is asking out

