WHERE to begin
Many people, once they start getting comfortable writing SQL, begin asking the same questions. One such common question is “Does...
2010-07-07
1,300 reads
Blog Posts
Why Work on a SQL Saturday?
I was having a long call with Andy Warren (blog | Twitter), fellow founder of SQLServerCentral and SQL Saturday. We were...
2010-07-07
629 reads
Before You Begin Auditing...
There is a fine line between auditing and attacking. The line actually is one built based on authorization. Same tools,...
2010-07-06
949 reads
MDX Puzzle #2 Solution
MDX Puzzle #2 Solution
Download Script
This puzzle was a little more challenging than the first, but it was definitely fun and...
2010-07-06
1,057 reads
MDX Puzzle #3
The next puzzle comes from a BIDN.com forum post. Here are the requirements:
Columns: Internet Order Quantity and Percentage Of Total...
2010-07-06
518 reads
Mix & Match – Day 2
I’ve been scouring my notes (old & new), wading through all my previous research and unearthing advice, tips & tricks that have...
2010-07-06
437 reads
MS Access Annoyance: Yes, Save the Password, Again
Here’s another quirk that has been there forever. Open up the linked table UI and select a handful of tables,...
2010-07-06
301 reads
Newest Pragmatic Works’ Team Book on Amazon
Check out our latest book on Amazon. It’s not for sales yet, but just seeing the title up there is...
2010-07-06
338 reads
Q2 Goal Review
I have a monthly reminder, which is currently making me feel guilty. It’s there to tell me to review my...
2010-07-06
379 reads
Q2 Goal Review
As we close out the Second Quarter of 2010 it is time to review progress made on the Goals I...
2010-07-06
521 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