As a Consultant, I would typically answer with – it depends! Then a typical conversation starts with an expression of…
Browsing: SQL
The Never-Ending Question in IT: Which Approach to Take? As a Consultant, I would typically answer with = it depends!…
There are three Azure SQL products with so many different deployment options, service tiers, and compute tiers that it can…
One interesting concept in SQL Server is Deferred Name Resolution. This is something many developers struggle with understanding how this…
I grabbed this book over the 2024 holiday season as it was on sale and recommended by the DevOps practitioners…
I was asked to do some a little thinking and brainstorming recently. Rather than send some emails or get on…
When running queries in SQL Server, small changes in query design can lead to big differences in performance. Today, we’re…
Deadlocks can feel like a mystery, but they don’t have to be! In today’s episode, we’ll explore how to simulate…
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…