SQL Server Blog quarterly review
This SQL Server blog roll talks about the few blog articles I have published in last couple of months. I am certain you would like reading
The post SQL...
2024-01-08 (first published: 2024-01-01)
226 reads
Blog Posts
2023 in Review – Steve’s Perspective
2023 was another transition year as I continue to navigate my ALS with work. It has become harder to write or at least more work is required. I use...
2024-01-05
38 reads
A New Word: agnosthesia
agnosthesia – n. the state of now knowing how you really feel about something, which forces you to sift through clues hidden in your own behavior, as if you...
2024-01-05
54 reads
Creating a Scripts Folder in SQL Compare
While I was at a conference recently, someone asked me about the Scripts Folder feature in SQL Compare and how to set that up. This post just looks at...
2024-01-05 (first published: 2023-12-20)
535 reads
SELECT FORMAT(COUNT(1),’N’) FROM TableName WITH (NOLOCK);
Alternate title: How do I tell how far I am on that command? This little command (frequently with a WHERE ... Continue reading
2024-01-05 (first published: 2023-12-26)
1,070 reads
Skipping SQL Bits 2024
SQL Bits has been my favorite data platform event for years. Both it and the PASS Data Community Summit hold special places in my heard and I enjoy going,...
2024-01-04
28 reads
Create failed for Availability Group
Ever since the release of Always On Availability Group (AG or HADR) in SQL Server 2012 the adoption ratio is increasing. A lots of my clients too are adopting...
2024-01-03 (first published: 2023-12-25)
3,921 reads
Kusto (KQL) for Azure SQL Audit
According to Rod Trent, Kusto is named after Jacques Cousteau. He says, “We are exploring the depths of our data” by searching and querying our Azure log data. His...
2024-01-03 (first published: 2023-12-26)
319 reads
Career Plan for 2024
It’s a holiday today, but I’m dropping this as I spent last week working on it. I wrote about having a career plan on Friday, with a few notes...
2024-01-01
40 reads
Clearing Intellisense in SQL Prompt
I got this question from an account rep: if a customer is using SQL Prompt and a snippet, for example AT, that was also used as an alias, is...
2024-01-01 (first published: 2023-12-13)
275 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
Huge frustration - Database watcher with two elastic pools
Think there's a reason why this is still in preview, but have someone manage...
SQL Server 2025 Query Performance Tuning: Troubleshoot and Optimize Query Performance
Comments posted to this topic are about the item SQL Server 2025 Query Performance...
Is it uncommon for Dev's to have a data model of the source data
This is a generic question. To the moderators, I wasn't sure where to place...
Question of the Day
Creating JSON I
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( 'City':'Denver') GOSee possible answers