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,…
New website, thanks to Paper Sword B2B
It's so exciting! In case you haven't noticed, you're reading this on a new design now. And if you followed a URL that was in the blogs subdomain, it's redirected…
My first technical job
Technically my first job was in newspaper delivery, but Ken Fisher (@sqlstudent144)'s challenge is to write about my first technical job, which came much later. And no, I'm not planning…
Advice about T-SQL for beginners
Following on from my last post... what advice would I give about T-SQL to my younger-self? Well, for that I'm going back a long way. To when I had learned…
