Reverse Engineering a Physical Model Diagram
I recently wrote about a logical diagram with Redgate Data Modeler. That was interesting, but creating all the objects is a pain. I decided to try creating a physical...
2025-12-01
47 reads
Blog Posts
Advice I Like: Failure
If it fails where you thought it would fail that is not a failure. – from Excellent Advice for Living This is a great quote, especially for those of...
2025-11-28 (first published: 2025-11-14)
428 reads
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...
2025-11-28
38 reads
Why Databases Still Fascinate Me
I get asked a lot about why or how I began working with databases years ago. I did not wake up one day and decide, “I am going to...
2025-11-28 (first published: 2025-11-10)
415 reads
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...
2025-11-27
19 reads
Export a Power BI Report that cannot be Downloaded
Yes, you’re reading that right, we’re going to download a report that cannot be downloaded. Well, it cannot be downloaded from the user interface, that is. Suppose you have...
2025-11-26 (first published: 2025-11-06)
314 reads
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.
2025-11-26
143 reads
Query Intelligence in SQL Server 2025: What Developers Need to Know
When Microsoft announced SQL Server 2025, I was curious about what would truly change the way developers and DBA’s interact with data. Over the years, we have seen incremental...
2025-11-26 (first published: 2025-11-05)
694 reads
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,...
2025-11-26
10 reads
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...
2025-11-25
179 reads
Blogs
AI: Blog a Day – Day 6: Embeddings – How AI Understands
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
The Book of Redgate: Mistakes
By Steve Jones
This is kind of a funny page to look at. The next page has...
ADF Pipeline Debugging Fails with BadRequest – The Sequel
A while ago I blogged about a use case where a pipeline fails during...
Forums
Why End-User Testing Is Even More Important with AI
Comments posted to this topic are about the item Why End-User Testing Is Even...
Dynamic Unpivot
I have a table I didn't design that has tons of repeating groups in...
Writing as an Art and a Job
Comments posted to this topic are about the item Writing as an Art and...
Question of the Day
String Similarity II
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers