Deadlocks can feel like a mystery, but they don’t have to be! In today’s episode, we’ll explore how to simulate…
Browsing: SQL
I had to demo the Flyway Autopilot system recently and created a GitHub Actions runner as a part of that.…
Sorting large datasets in SQL Server can significantly impact performance, especially when it leads to tempdb spills. This post explores…
I wrote about getting the Redgate Test Data Manager set up in 10 minutes before, and a follow up post…
Execution timeout in SSMS are a small but important feature that can help you manage query performance. By default, SSMS…
(2025-Feb-12) I will jump straight to the problem statement without a “boring” introduction, which, in a sense, already feels like an…
ANSI PADDING is an often-overlooked yet impactful setting in SQL Server that determines how trailing spaces are handled in CHAR…
Introduction Do you remember the effort of tidying up your BI and reporting systems, only to find yourself facing a…
The AI revolution isn’t coming – it’s here. Companies are racing to integrate artificial intelligence into their operations, eager to…
I’m excited to be speaking at the Microsoft Fabric Community Conference this year, which takes place March 31 through April…