Dry-run xp_delete_file Before Actually Deleting Files?

Dry-run xp_delete_file Before Actually Deleting Files?

xp_delete_file doesn’t really have a built-in dry-run option to preview which files it would remove. But there’s a simple workaround,...

Happy Thanksgiving! (USA Holiday)

In the United States, today is Thanksgiving. The intent behind the holiday is to remember all that we have to be thankful. I have a lengthy list from friends...

Getting SQL Server 2025 RTM Running in Containers on macOS

SQL Server 2025 RTM is here, and if you’re running Docker on macOS, you might have hit a wall trying to get it running. Here’s what happened when I...

The PASS Data Community Summit 2025 Recap

It’s Monday. I’ve been home since Fri night, but with a busy weekend, I’m still recovering from the PASS Data Community Summit. There’s a nice wrap from the crew,...

Microsoft Post-Quantum Crypto APIs Are Now Generally Available

I mentioned this in my talk on Quantum Computing at the PASS Data Community Summit: Microsoft has announced that the post-quantum cryptography APIs are now generally available.

SQL Server 2025 Generally Available

This was announced last week at Microsoft Ignite and it's been covered by others such as Brent Ozar, but if you haven't heard, SQL Server 2025 is now generally...

Chatting with Power BI: Who Benefits from This Conversation?

"Dave: Open the pod bay doors, HAL.HAL: I’m sorry, Dave. I’m afraid I can’t do that.Dave: What’s the problem?HAL: I think you know what the problem is just as...

SQL Server 2016 End of Extended Support

Many organizations are still running SQL Server 2016 in production. Sadly, many are running versions older than 2016 as well, however with SQL Server 2016, the end of extended...

A Quick Look at Redgate Data Modeler

Redgate acquired a data modeling tool from Vertabelo recently and I wanted to explore how it works. This is a short look at this tool and how it might...

Prepping for Certification, Part 2 of ?

The advantage of understanding the make-up of the exam: I can tailor my efforts for best results.