The sp_invoke_external_rest_endpoint stored procedure that’s available in 2025 allows for SQL Server to hit external rest endpoints…which opens up quite a few interesting options. I was thinking about this...
2025-08-20 (first published: 2025-07-31)
523 reads
Migrating databases to the cloud can be complex, but Azure Database Migration Service (DMS) simplifies the process with a robust, fully managed solution. Whether you’re transitioning from SQL Server, MySQL, PostgreSQL,...
2025-08-20 (first published: 2025-07-31)
470 reads
If you’re responsible for a SQL Server instance, you need working, consistent backups. Not just a .bak file here and there, but a plan that runs automatically and covers...
2025-08-20
34 reads
This weekend was one of my favorite Data Saturday events, Data Saturday Columbus! If you’re in the area, I highly recommend it. Always some great speakers, amazing lunch, and...
2025-08-19
19 reads
Let’s be honest; technical teams don’t thrive under a microscope. They thrive under a mission. In a world where innovation moves at the speed of thought, the difference between...
2025-08-18 (first published: 2025-07-31)
471 reads
A customer was asking about how to track all the stored procedures that execute on their system. We have a section in Redgate Monitor that’s set to look at...
2025-08-18
21 reads
If you are responsible for securing databases, SQL Servers and others, I would strongly urge you to read the following post by Andreas Wolter, former data security PM for...
2025-08-18 (first published: 2025-07-30)
522 reads
Learn how to take a 20-minute power nap without embarassment. – from Excellent Advice for Living I don’t like naps. In fact, I try to avoid them and keep...
2025-08-15
24 reads
I’m back. My last day of work was Jun 27 and I came back a few days ago, on Aug 13. Just over six weeks away and I am...
2025-08-15
18 reads
If you’re a DBA, sysadmin, IT manager, or Accidental DBA, you’ve probably seen SQL Server’s built-in Maintenance Plans. They live right there in SSMS under the “Management” node, quietly...
2025-08-15 (first published: 2025-07-30)
438 reads
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
By DataOnWheels
This is a blog that I am writing for future me and hopefully it’ll...
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Comments posted to this topic are about the item Pro SQL Server Internals
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Comments posted to this topic are about the item Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers