I recently took and passed the DP-700 exam, which is required for the Microsoft Certified: Fabric Data Engineer Associate certification.…
Browsing: SQL
I had someone reach out about generate_series() recently, saying they hadn’t realized this was a new feature in SQL Server…
As a Consultant, I would typically answer with – it depends! Then a typical conversation starts with an expression of…
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…