SSG Blog
Insights and news from the SQL Solutions Group.
Featured
Recent
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.
Why a SQL Server Health Check isn’t a Luxury
Does the integrity of your SQL Server databases keep you up at night? Is an outage of your system a matter of when and not if? Do you dread a call from the C-suite asking why everything is down?
Track Database File Sizes with PowerShell: A Quick Guide for DBAs
Database files (mdf, nds, ldfs, etc.) can get out of hand quickly and easily, leading to issues down the road. This can be due to
Contained Availability Groups in SQL Server 2022: What You Need to Know
Overview One of the more intriguing features introduced in SQL Server 2022 is Contained Availability Groups (AGs). At first glance, they look very similar to