Creating a Synapse Workspace
As part of my job, I needed to research how a few things work with Synapse and Fabric. The latter includes the former, mostly. I decided to setup a...
2024-09-11 (first published: 2024-08-26)
149 reads
The Voice of the DBA
One Month with the Dell Latitude 7450
It was just over a month ago that I got a Dell Latitude 7450 from our corporate IT group. It wasn’t my first choice, but as Redgate grows, they’re...
2024-08-23
16 reads
A New Word: Midding
midding – n. the tranquil pleasure of being near a gathering but not quite in it – hovering on the perimeter of a campfire, talking quietly outside a party,...
2024-08-23
61 reads
Back to Syracuse for SQL Saturday
Syracuse is having their first SQL Saturday on Sept 7, 2024. I’ll be there and hope to see you there as well. If you’re anywhere close, come on over...
2024-08-22
29 reads
Creating a Test Pipeline in Azure DevOps using a Windows Agent
A customer was having some trouble getting started with Azure DevOps (AzDO) and building their database, so we took a step back and decided to create a simple test...
2024-09-06 (first published: 2024-08-21)
535 reads
Monday Monitor Tips: Changing the Fragmentation Alert
I had a customer that was concerned about the fragmentation alert for indexes and wanted to know how to change it. This post discusses the change. This is part...
2024-08-19
30 reads
SQL Saturday Denver 2024 Resources
Here are the resources from my talks today. Best Practices for Seamless Database Deployments PPTX slides Architecting Zero Downtime Deployments git repo: https://github.com/way0utwest/ZeroDowntime PPTX slides Some good questions today,...
2024-08-18 (first published: 2024-08-17)
46 reads
A New Word: Povism
povism – n. the frustration of being stuck inside your own head, unable to see your face or read your body language in context, only ever guessing how you...
2024-08-16
25 reads
Speaking at SQL Saturday Denver 2024
It’s just a couple of days away from SQL Saturday Denver 2024. This Saturday, come join me at the Lowry Convention Center in Aurora for some great talks. We...
2024-08-14
12 reads
Expanding Northwind with Prompt+
I was trying to do a little testing of our subsetter and needed a larger database. So I decided to ask Prompt + to help me with a little...
2024-09-02 (first published: 2024-08-14)
204 reads
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
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...
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