Advice I Like: Ranch Rules

Leave a gate behind you the way you first found it. – from Excellent Advice for Living This is a ranch rule. Leave something as you found it. If...

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...

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...

26ai Quick Tip for Database Links

It seems an odd thing that so many facilities on the cloud environment take advantage of the concept of stored database credentials when it comes to authenticating/authorising access to...

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...

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...

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...

PASS Data Community Summit 2025 Recap

This is long overdue but life and distractions happened. It’s been a little over two months since I returned home from PASS Summit 2025.

Using AI for Git Hooks

Recently I had someone internally ask about whether SQL Source Control supports Git Hooks. Since it was after UK work hours, I decided to run a quick test. One...

Flyway Tips: AI Helps with Commit Messages

At Redgate, we’re experimenting with how AI can help developers and DBAs become better at their jobs. Everyone is asking for AI, as well as the ability to turn...