OpenAI developments
T-SQL Tuesday this month sees Damien Jones (@amamzonwebshark) ask about our wishlist for OpenAI in the Microsoft space. Normally I'd have spent a week thinking about the T-SQL Tuesday topic,…
Why I like “IS [NOT] DISTINCT FROM”
This month, Deepthi Goguri (@dbanuggets) asks us about our favourite new feature in SQL Server 2022 or Azure. And while there are always a few, I'm going to write about…
Ignoring best-practice
"If best-practice was always worth following, they'd take the option away." I don't know who said this - certainly it's something that I've said before. It's not entirely true, but…
Happy End of Year!
I remember two years ago when 2020 ended, people figured life would return to how it was in the beforetimes. Here we are two years later and the predictions that…
sp_invoke_external_rest_endpoint is a game changer!
This internal procedure is new in Azure SQL DB in 2022. I think it presents a significant change to the way we do things in the world of SQL, and…
Production-Grade Code
Tom Zika (@Zikato25) asks "What quality makes code production grade?" And... I'm not sure I know the answer. I'm a consultant, so I see quite a lot of organisation's "production…
The dangers of Dynamic SQL and how to avoid them
That's "Dynamic SQL", with a capital D, because I feel like it's a thing in its own right and deserves to be in Title Case. Steve Jones (@way0utwest) has invited…
SQL Windows
Let's not get confused about Microsoft SQL Server vs Microsoft Windows Server. I'm writing here about windows of data when running a query, and the enhancements in SQL Server 2022…
Conferences
"Tell us the story of how attending an IT conference or event resulted in an amazing career or life opportunity." writes Kevin Kline (@kekline). Except that I don't know that…
A quick rant about Sargability
Deborah Melkin (@dgmelkin) said "give us that rant" in her invitation for this month's T-SQL Tuesday. And I suspect I've been known for getting a little wound up about code…
