SSG Blog
Insights and news from the SQL Solutions Group.
Featured
Recent
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
Backup Just Got Smarter: What’s New in Microsoft SQL Server 2025
In a recent webinar, Randy Knight walked through the backup enhancements in SQL Server 2025—and one update in particular changes everything for Availability Groups. True
Fixing Full-Text Index Issues
We’ve had Full-Text index issues come up with surprising frequency lately, so I thought I’d share the fix with all of you lovely people who read this blog. For reference, the customer in this example asked us to look at this problem on a server that is not managed by us.