Prepping for Certification, Part 3 of ?

After I have understood the details for a certification test (part 1), including format and the rules for taking it and after I have taken time to learn how...

SQL Training Black Friday Deals

If you're looking for particular "Black Friday" deals, here is what I've seen advertised in the community. I have not taken any of these classes, so I can't give...

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...