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…
Your talk, or someone else’s?
Having withdrawn from my speaker spot at the PASS Data Community Summit 2022, the organisers have asked me to suggest people who might be able to deliver my session. I'm…
Speaker diversity
I was really pleased to have a session accepted for the PASS Data Community Summit in Seattle this coming November. The acceptance email said that 516 individuals had submitted 863…
Coding standards or values?
As a consultant, I see code written in plenty of different organisations. Some of them have rules about their code, and many don't. I have to work within their standards,…
