SSG Blog
Insights and news from the SQL Solutions Group.
Recent
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
A Bug: Log Shipping in Contained Availability Groups
We’ve recently come up across a fun little bug with log shipping in contained availability groups. A cursory Google search did not bring up any
Slimming Down your SQL Database Could be the Answer to your Performance Issues
Explore in-memory/memory-optimized tables in SQL Server and if you should use this feature in your production environment.