Fix Slow, Bloated MSDB: Purge Old History And Add Missing Indexes

Fix Slow, Bloated MSDB: Purge Old History And Add Missing Indexes

After tempdb, msdb is often the most abused system database, growing unchecked until it tanks...

SSMS 22 still inserting tabs instead of spaces

I’m not trying to start up a debate whether you should use tabs or spaces when indenting code. Personally, I prefer spaces because when I copy the code to...

Three Ways to Use Snowflake Data in Microsoft Fabric

Organizations increasingly want Snowflake and Microsoft Fabric to coexist without duplicating data or fragmenting governance. With Fabric OneLake and open table formats like Iceberg and Delta, there are now...

Who’s the Winningest Coach (with AI Help)

I was listening to the radio the other day and the hosts were discussing the NFL playoffs in 2026. Someone mentioned the winningest coach was Nick Sirianni of the...

Deploying an Updated Model with SQL Compare 16

In a previous post, I deployed a model to a database using SQL Compare 16. This used a new feature in that connects to Redgate Data Modeler. In this...

Getting Your Data GenAI-Ready: The Next Stage of Data Maturity

I remember a meeting where a client’s CEO leaned in and asked me, “So, we have tons of data… Why can’t we just add AI and call it a...

Looking Back at the Redgate 2026 Company Kickoff

Last week I spent a few days in Cambridge, UK for the Redgate Company Kickoff. I landed at 1130a Monday and flew away at 1215p Thursday. I wish I...

Runing tSQLt Tests with Claude

Running tSQLt unit tests is great from Visual Studio but my development workflow isn’t just write tests, run tests, fix tests, run tests anymore, it is 2026 and...

Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022

Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022

If you’ve spent any time tuning SQL Server, you’ve probably heard “Turn...

Azure SQL Managed Instance Next-Gen: Bring on the IOPS

If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to boost memory or I/O, you had to scale the whole instance, paying for extra CPU...