Daily Coping 28 Dec 2022
Today’s coping tip is to look for something positive to say to everyone you speak to. This works well during the holiday season as most people are in a...
2022-12-28
12 reads
Blog Posts
Recommended Approach to Encryption in SQL Server
We looked earlier at the various places our data lives – on disk, in memory, in-transit across the network. A good strategy will protect all of these locations –...
2022-12-28 (first published: 2022-12-14)
543 reads
Daily Coping 27 Dec 2022
Today’s coping tip is to share a happy memory or inspiring thought with a loved one. This is a memory for me: This came up in a Google Photo...
2022-12-27
11 reads
Join me at VS Live Las Vegas 2023
I’m heading back to VS Live in March 2023 for the Las Vegas show. This time it’s at Planet Hollywood, which is a hotel I’ve never visited. I’m excited...
2022-12-27
43 reads
More DevOps with the SQL Solutions Group
I’m doing another webinar on Jan 18, 2023 with the SQL Solutions Group. You can register here and reserve a spot. Scott Klein and I did a webinar last...
2022-12-27
37 reads
Seeking Home Network Happiness
TL;DR: My home firewall/router is slow, please help me pick out a new one.
After replacing my firewall/router/WiFi access point one too many times, I’m ready to get off the...
2022-12-27
106 reads
Book Review – SQL Server Query Tuning and Optimization (2nd Edition)
The nice people from Packt Publishing sent me a digital copy of Benjamin Nevarez new book to review: SQL Server Query Tuning and Optimization – Optimize Microsoft SQL Server...
2022-12-26 (first published: 2022-12-02)
334 reads
Daily Coping 26 Dec 2022
Today’s coping tip is to see how many people you can smile at today. Easy one for me. I find this makes me happier and my day better when...
2022-12-26
12 reads
My Stats from 2022
I wrote last week about my travel, 23 trips in 2022. However, I’ve been gathering some other stats about my life and what I do, so I wanted to...
2022-12-26
19 reads
Types of data consulting engagements and what you can expect from them
There are multiple ways organizations can engage with a data (DBA/analytics/data architect/ML/etc.) consultant. The type of engagement you choose affects the pace and deliverables of the project, and the...
2022-12-26 (first published: 2022-12-06)
219 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