Xp_cmdshell Use Cases
Today Steve asks for the ways in which you use xp_cmdshell in your environment.
2024-07-03
273 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
183 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
128 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
243 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
210 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
118 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
196 reads
SQL Injection Is Not Acceptable
An alert from the US government says that SQL Injection isn't an acceptable problem.
2024-06-19
349 reads
2024-06-17
253 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
98 reads
Blogs
Lift and shift vs modernizing your data warehouse
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
Power BI Fun With Travels
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
Forums
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Choose the Second One
Comments posted to this topic are about the item Choose the Second One
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers