Keeping MS Docs Up to Date
One of the things that I like about the SQL Server docs (MS Learn Docs) is that I can fix things I find wrong. For years we had downloaded...
2025-12-29 (first published: 2025-12-10)
9 reads
One of the things that I like about the SQL Server docs (MS Learn Docs) is that I can fix things I find wrong. For years we had downloaded...
2025-12-29 (first published: 2025-12-10)
9 reads
2025-12-29
762 reads
2025-12-29
49 reads
This month Mike Walsh hosts T-SQL Tuesday. It’s been quite some time since he hosted (back at #4), but he answered my call for hosts and I appreciate that....
2025-12-26 (first published: 2025-12-09)
190 reads
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia I miss Brad. I enjoyed traveling around and working with him. I’d forgotten about Bob...
2025-12-26
30 reads
The tally table is a valuable tool for a SQL Server developer, but how many of you understand how to create and use one?
2025-12-26 (first published: 2015-08-13)
785 reads
2025-12-26
895 reads
On the first day of Christmas my new DBA sent to me A table with a primary key On the second day of Christmas my new DBA sent to me Two Foreign Keys, and A table with a primary key On the third day of Christmas my new DBA sent to me Three stored procs […]
2025-12-24 (first published: 2019-12-24)
348 reads
2025-12-22
510 reads
We might be smart in one area, but not others. That's worth remembering.
2025-12-22 (first published: 2016-06-16)
189 reads
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
Hi experts, I have a 3+ TB database on a 2019 sql server which...
Comments posted to this topic are about the item The North Star for the...
Comments posted to this topic are about the item Multiple Escape Characters
In SQL Server 2025, I run this code (in a database with the appropriate collation):
SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';
What is returned? See possible answers