Category: SQL Server

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

May 1, 2026

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

April 3, 2026

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,

March 11, 2026

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

March 2, 2026

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.

February 5, 2026

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

January 21, 2026

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.

January 14, 2026

A SQL Server health check is a worthwhile investment

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?

January 8, 2026

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.

December 29, 2025

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,

November 22, 2025