Stop Wasting Time Rebuilding Indexes Every Night

Too many IT teams run index rebuild jobs on autopilot. Every night. Every index. No questions asked. Here’s the truth: if you’re doing this daily on indexes smaller than...

SQL Data Type Conversions: Your Key to Clean Data & Sharp Queries

If you're a data analyst juggling varied datasets, mastering SQL data type conversions isn't just handy—it's crucial. Whether you’re making different data types play nice together or boosting query...

T-SQL Tuesday #186–Agent Jobs

It’s that time of the month again, when the T-SQL Tuesday blog party takes place. I manage this site, and am looking for hosts all the time. This month...

T-SQL Tuesday #186 - Agent Job History Visualization

I’m hosting T-SQL Tuesday this month and our topic is Managing SQL Agent Jobs. In this post, we’ll be taking a look at a very handy combination of dbatools...

KDA: Echoes of Deception - Case 2

The people of Digitown are being targeted by phishermen, and they need my help to stop them in their tracks.
The problem

The police have asked for our assistance, and we’ve...

SQL Saturday NYC Recap 2025

My first time at SQL Saturday New York City was an absolute blast! Thank you so much to the organizers and the incredible people who chatted with me during...

SSMS 21

Just a quick one this morning. I’m on the road and haven’t worked up a full blog post, apologies. I’ve been using the preview for SQL Server Management Studio...

Why Data Silos Hurt Your Business Performance

Businesses rely on data for decision-making and strategy, but data silos hinder productivity. These silos lead to ineffective decisions from incomplete data, wasted resources through redundant efforts, and missed...

SQL Server Engineering in Austin

I was lucky enough to attend SQL Saturday Austin 2025 a little over a week ago in conjunction with some work at the Redgate office. The opening keynote at...

Solar-Powered, Proxmox-Driven: A Tour of My Ultimate SQL Server Home Lab

Back in 2018, I wrote a blog post about my Home Lab environment, which I had built around VMware vSphere to showcase various SQL Server workloads and demonstrate how...