SELECT * feels convenient, but in SQL Server it bloats I/O, burns network bandwidth, blocks covering-index usage, and makes code…
Browsing: SQL
At SQL Saturday Boston 2025, I gave a presentation on local LLMs and there was a great question that I…
Are you diversifying your DBA skillset? My recent job search made one thing clear: the database landscape is broader than…
In every organization there is a hidden currency more valuable than capital, more enduring than strategy, and more transformative than…
Slack is a popular tool for team interaction. To describe it quickly, it’s a feature-rich persistent chat room, with threads,…
Change is not a disruption in technology; it is the rhythm. New frameworks appear, markets shift, customer expectations evolve, and…
I saw an article recently about implicit transactions and coincidentally, I had a friend get caught by this. A quick…
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,…