A Career of Memories

Annabel retired from Redgate Software this week. Across most of my career at Redgate, I’ve participated in many events, some we hosted, some we sponsored. At most of these...

Five Ways Redshift Serverless Quietly Eats Your Budget

It is Friday, the queries are running, and nobody is watching the bill. That is the whole charm of Redshift Serverless: you stop thinking about nodes and resizes. It...

No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger

I was messing around with SQLCMD and I realized something I hadn’t known. I’ve never tried it, but the batch separator has to be separate, which I’ll show. Another...

Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead

As a SQL Server DBA with years of experience tuning production environments, I’ve seen the same patterns repeat: nightly index maintenance jobs running for hours, consuming massive CPU and...

SQL Server instance metadata inventory with PowerShell and SMO

SQL Server instance metadata inventory with PowerShell and SMO

The purpose of this article is to introduce a PowerShell script that I wrote and published on...

T-SQL Tuesday #199: Back to the on-prem

It’s the second tuesday of the month, which means T-SQL Tuesday time! This month’s topic is chosen by myself, and it’s inspired by a blog post of Alexander Arvidsson....

T-SQL Tuesday #199: Roundup

A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited the community the blog about the idea of what would happen if we would need...

5 Starter Projects for Your AI and Data Engineering Portfolio

Reading tutorials is fine. Shipping something is better. If you are trying to break into data engineering or AI, nothing on your resume carries more weight than a GitHub...

Creating a SQL Stored Procedure to Load a SCD2

This is a blog that I am writing for future me and hopefully it’ll help a few of you save some time too! It’s not often that I get...

EightKB 2026 – Schedule and Registration

Hello Hello, We. Are. Back! The schedule for EightKB 2026 Edition has been announced! We’re kicking off at 1pm UTC on August 20th…here’s the schedule: – N.B. – If...