SSG Blog
Insights and news from the SQL Solutions Group.
Featured
Recent
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.
SQL Server 2025 Performance Enhancements: What Developers and DBAs Need to Know
SQL Server 2025 continues Microsoft’s steady focus on performance, reliability, and intelligent automation. Rather than introducing one dramatic overhaul, this release delivers a collection of
Enhancements to TempDB in SQL Server 2025
The latest edition of SQL Server comes with many enhancements, and updates to TempDB in SQL Server 2025 are one of our favourites.