# Not the GDPR News -t minus 10 days
# Not the GDPR News -t minus 10 days
There is ten days to go and there are still some seats left for...
2018-04-09
301 reads
Blog Posts
Code Snippet Cove on the #SQLPrompt Treasure Map
I’ve been away a bit in the last week with personal and family commitments. As a result, I feel a...
2018-04-09
916 reads
Encrypting SQL Server Database Backups
We all go to great lengths to make sure that our databases are secure (or at least I really hope...
2018-04-09 (first published: 2018-04-04)
2,472 reads
How to Check SQL Server View Utilization
If you are working on SQL Server optimization delicately, you may get often queries that how to find if any...
2018-04-09
957 reads
Why didn't my Azure ARM deploy work?
I have been using Octopus to deploy ARM templates for a while now and the default task that comes with...
2018-04-09 (first published: 2018-04-04)
1,653 reads
Why Doesn’t CONTEXT_INFO() Return the Exact Value Set by SET CONTEXT_INFO?
(last updated: 2019-01-05 @ 23:15 EST / 2019-01-06 @ 04:15 UTC )
Let’s say that you execute the following T-SQL:
SET CONTEXT_INFO 1234;
SELECT CONVERT(INT, CONTEXT_INFO());
The...
2018-04-09
1,128 reads
Brief Description about SQL Server Encryption
Encryption is a good technique using which a particular data is obfuscated with a key or password. This makes the...
2018-04-07
563 reads
Brief Description about SQL Server Encryption
Encryption is a good technique using which a particular data is obfuscated with a key or password. This makes the data useless until any decryption key or password is...
2018-04-07
4 reads
Hide and Abstract the physical layer
How to build an abstraction layer between physical and logical layers in the database code
2018-04-07
172 reads
Friday Reading 2018-04-06
Feels like an age since I posted some links. So busy these days!
I’m really excited today as tomorrow I head...
2018-04-06
264 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