What is production grade code? : T-SQL Tuesday #156
It’s that time of the month again! It’s T-SQL Tuesday and this month Tom Zika (blog|twitter) is hosting. Tom would ... Continue reading
2022-11-23 (first published: 2022-11-08)
365 reads
Blog Posts
Daily Coping 22 Nov 2022
Today’s coping tip is to do something playful outdoors. Easy. Skiing today. First day of the season. I started to add a daily coping tip to the SQL Server...
2022-11-22
13 reads
Daily Coping 21 Nov 2022
Today’s coping tip is to revisit a coping tip from the past and see if it helped you.. I came up with this one after I tried to do...
2022-11-21
13 reads
Leaving (or minimizing) Twitter
Fairly short post here. Due to the recent events around Twitter (which I will not get into), I’m making an effort to reduce or completely cease my activity on...
2022-11-21
34 reads
Sale on SQL Server 2022 Query Performance Tuning
Just a quick post to let you know that there’s a great sale right now at Springer on my brand new, completely rewritten, query performance tuning book. Get your...
2022-11-21
51 reads
SQL Temporal Tables — Gotcha!!!
Hello, again reader… Today, I will discuss a gotcha I ran across with SQL Server Temporal Tables. In my day-to-day environment, we do not use Temporal Tables widely. However,...
2022-11-21 (first published: 2022-11-01)
995 reads
Tales From The Field Weekly Wrap Up for the Week of 11-14-2022 Live! 360
Hello Dear Reader! Last week was a week we have been building towards since the launch of Tales from the Field. My favorite conference every single year, Live! 360. ...
2022-11-21
31 reads
Where Is My SQL Server Errorlog?
If you need to find the SQL Server ErrorLog in a hurry and don’t want to spend 30 minutes drilling into every drive on the server: “I don’t watch...
2022-11-21 (first published: 2022-11-01)
253 reads
Session Materials – PASS Data Community Summit and Cloudbrew
You can find the slides and demo scripts for my sessions at Cloudbrew (Snowflake) and PASS Data Community Summit (Migrate SSIS skills to ADF) in my Github repo. If...
2022-11-19
16 reads
2022 PASS Data Community Summit Recap: Power BI Meets Programmability – XMLA, TOM, C#
Thank you to everyone who made it out to PASS Data Community Summit! I have greatly enjoyed meeting so many fellow data nerds and have learned so much from...
2022-11-18 (first published: 2022-11-17)
17 reads
Blogs
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Forums
Why the following cmds in sequence do not work
I need to delete rows from both the temporal main and history tables. The...
When SQL Server Central Went Down
Comments posted to this topic are about the item When SQL Server Central Went...
The String Distance I
Comments posted to this topic are about the item The String Distance I
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers