I saw an article recently about implicit transactions and coincidentally, I had a friend get caught by this. A quick…
Browsing: SQL
I’m starting a long trip at Boston this weekend. I’ll be there Saturday speaking, two sessions I think. At least…
I have also witnessed what happens when organizations try to shortcut these foundational steps. The damage is predictable and costly: User…
Not long ago, a colleague of mine was completely shocked when he first heard about SQL Server’s Batch Mode feature. His immediate reaction was: “Wait,…
A customer wanted a report they could email to their boss about jobs, something that showed failures. This isn’t hard…
Do you know if your SQL Server is really running at its best? To help you answer that question, I’ve…
You can find the slides of my session on the €100 DWH in Azure on Github. The post Retro Data…
This value is something that I still hear today: our best work is done in teams. On the facing page,…
Have you ever received the dreaded error from SQL Server that the TempDB log file is full? Only to open…
I’ve used Logic Apps a couple of times over the past years for simple workflows, like sending an email (still…