The internet relies on IP (Internet Protocol) addresses to identify devices and route traffic. Two versions of IP exist today: IPv4 and IPv6. While IPv6 was introduced to overcome...
2025-07-14
43 reads
During a demo of Redgate Monitor Enterprise to a customer, they asked about how to search for permission changes. This post examines how you can do that in Redgate...
2025-07-14 (first published: 2025-06-23)
293 reads
AI is no longer a niche capability – it is a leadership catalyst. As Microsoft continues to push boundaries with tools like Azure and Fabric, the demands on today’s...
2025-07-14
19 reads
A friend was asking for help with some data analysis. This was in PowerBI, and the source data was PII. I asked them to mask the data for me...
2025-07-14
32 reads
I am responding late to a T-SQL Tuesday invite from John Sterrett. John’s call is about various ways to grow young data community/speakers. I’m going to take a brief...
2025-07-13
19 reads
I may think I'm trying to reach the crowd, but I'm really trying to reach each person within the crowd. The "crowd" doesn't actually exist.
2025-07-11 (first published: 2025-06-24)
107 reads
Measuring and Improving SQL Server Query Plan Cache Efficiency
The query plan cache hit ratio in SQL Server indicates the percentage of queries that are executed...
2025-07-11 (first published: 2025-06-24)
584 reads
I am honored to announce that I have been renewed as a Microsoft MVP for the ninth consecutive year, recognized in the Azure SQL and SQL Server technical areas...
2025-07-11
27 reads
I am honored to announce that I have been renewed as a Microsoft MVP for the ninth consecutive year, recognized in the Azure SQL and SQL Server technical areas...
2025-07-11
3 reads
It’s been forgotten about and neglected for few years but I’ve decided to dust off the cobwebs and revive our YouTube channel. Keep an eye on it, every new...
2025-07-11
19 reads
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
By John
Today is Christmas and while I do not expect anybody to actual be reading...
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Comments posted to this topic are about the item UNISTR Escape
Comments posted to this topic are about the item Celebrating Tomorrow
Comments posted to this topic are about the item SQL Art: I Made a...
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