DB Automation with Azure DevOps
I sincerely believe the key to your future as a DBA is your ability to automate everything you do. However, the single hardest thing that you have to do...
2020-03-31 (first published: 2020-03-25)
450 reads
Blog Posts
Goal Progress Report for March 2020
I made goals at the end of February, when I returned from sabbatical. Since then, the world has been turned upside down with a pandemic, and I’ve been struggling...
2020-03-31
10 reads
Moving Your SQL Workload to the Cloud
Every day, more IT organizations decide to move their SQL Server databases to Azure. In fact, over a million on-premises SQL Server databases have been moved to Azure. There’s...
2020-03-31 (first published: 2020-03-25)
381 reads
Speaker at PASS Marathon – 2020
I’m very happy to share that I will be speaking at the next PASS Marathon event. Here are the details of the session I will be presenting on April...
2020-03-31
13 reads
Unit Testing & Intelligent Query Processing
Actually, these two topics don’t have anything to do with one another. I just ran out of days to promote everyone individually who was taking part in putting on...
2020-03-31
10 reads
Administration Basics: Point in time recovery
Nowadays, data is a precious asset for companies today. If you are a database administrator (by decision or by mistake) or simply you are the "IT guy," you have...
2020-03-30
20 reads
Daily Coping 30 Mar 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-03-30
5 reads
Extended Events: Queries and Waits
Wouldn’t it be great to be able to put together queries and waits at the same time? You all capture query metrics using some method. Most of us query...
2020-03-30
18 reads
It’s Not April Fools – Redgate Streamed is Coming
Next week is April 1, typically April Fools Day, where we have jokes, pranks, and false stories. I’ve done my share of them, but this isn’t one. With the...
2020-03-30 (first published: 2020-03-25)
326 reads
Living with Bipolar During a Pandemic
Introduction Today is World Bipolar Day. I wanted to write a blog about my experience with bipolar to help others that have mental health challenges know that aren’t alone...
2020-03-30
5 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
Optimism Without Illusion or Why AI Needs Blunt Technologists
Comments posted to this topic are about the item Optimism Without Illusion or Why...
SSIS with VS2022 64/32 issue with Excel files
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Case part is sloooooow
Hi So the case statement is slowing this down - but for the life...
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