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
43 reads
The Voice of the DBA
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
9 reads
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...
2025-12-05 (first published: 2025-11-24)
55 reads
A New Word: Dead Reckoning
dead reckoning– v. intr. finding yourself bothered by somebody’s death more than you would have expected, even if they were only an abstract presence in your life, like a...
2025-11-21
13 reads
Finding the Last Last Name in SQL: #SQLNewBlogger
I wrote a piece on the new SUBSTRING in SQL Server 2025 and got asked a question. How do we get the last last name, such as only getting...
2025-11-19
137 reads
SQL Server 2025 GAs Today
If you aren’t watching the Ignite keynotes today, then you might have missed the announcement that SQL Server 2025 officially releases today. The main SQL Server page gives you...
2025-11-18
44 reads
The Roundup for T-SQL Tuesday #192
Last week I asked you to write about SQL Server 2025 and what things you might be looking forward to in the new version. First, as usual, is Rob...
2025-11-18
136 reads
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)
410 reads
SQL Server 2025 RegEx and AI
One of the language changes in SQL Server 2025 that I’ve seen a lot of people mention is the addition of RegEx functions to T-SQL. I decided to take...
2025-11-12
149 reads
T-SQL Tuesday #192: SQL Server 2025 Backup Changes
I hosted this month, but I decided to put my own entry in as well. There are more things in this release than I expected, probably because of the...
2025-11-11
37 reads
Blogs
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Self-Hosting a Photo Server the Whole Family Can Use
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Forums
Happy Holidays, Let's Do Nerdy Stuff
Comments posted to this topic are about the item Happy Holidays, Let's Do Nerdy...
UNISTR Escape
Comments posted to this topic are about the item UNISTR Escape
Celebrating Tomorrow
Comments posted to this topic are about the item Celebrating Tomorrow
Question of the Day
UNISTR Escape
In SQL Server 2025, I run this command:
SELECT UNISTR('*3041*308A*304C\3068 and good night', '*') as "A Classic";
What is returned? (assume the database has an appropriate collation)
A: 
B: 
C: 
See possible answers