Xp_cmdshell Use Cases
Today Steve asks for the ways in which you use xp_cmdshell in your environment.
2024-07-03
253 reads
Editorials
The Cost of Rework
Steve notes that we're always better doing things better the first time. That takes some effort.
2024-07-01
156 reads
Shout Your Successes
I was at a customer this week (sorry, can't share who). I spent the day talking about Redgate Monitor and how it can help with query tuning, server management, and estate management. Through the day, the data pros at the company were sharing how they were managing hundreds of servers and several thousand databases. They […]
2024-06-29
109 reads
What Metrics Do You Collect?
Monitoring and observability are becoming more important in today's 24x7x365 environment for applications. Steve asks what data helps you solve problems today. Tell us what's important to you.
2024-06-28
199 reads
Where to Test Your Code
When and where should you test code? Steve has a few thoughts when we consider the database as a crucial part of our software.
2024-06-26
176 reads
What Do You Want to Learn?
There's a survey available to give your input for what topics you'd like to learn about at the next SQL Saturday.
2024-06-24
111 reads
Cloud Transformation
There are lots of companies moving databases to the cloud. Steve has a few thoughts on how to evaluate this for your company.
2024-06-21
169 reads
SQL Injection Is Not Acceptable
An alert from the US government says that SQL Injection isn't an acceptable problem.
2024-06-19
320 reads
2024-06-17
222 reads
Baseball Everywhere
Last week was supposed to be my turn to curate Database Weekly and write an editorial to go along with it. Graciously, Mr. Louis Davidson (@drsql) offered to switch weeks while I was in Cambridge, England with most of the Redgate Marketing team for our yearly global gathering at HQ. As a remote worker on […]
2024-06-15
55 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