Why I am not an MVP
On October 1st the emails went out notifying existing MVP’s in the Oct cycle if they were fortunate enough to...
2013-10-02
760 reads
Blog Posts
Awarded Microsoft MVP
Today I’m extremely excited, honored and humbled to announce that I have been recognized as a Microsoft MVP for first...
2013-10-01
686 reads
Detaching a database
In my general quest to figure out the T-SQL to do common GUI tasks I did some browsing through BOL...
2013-10-01 (first published: 2013-09-26)
1,659 reads
Enable Instant File Initialization to accelerate database restore
Today my colleague come to me and ask me why her database restore query was hang. She was going to...
2013-10-01
1,237 reads
I’m a Microsoft SQL Server Most Valuable Professional (MVP)!
I have been honored to be chosen a Microsoft SQL Server Most Valuable Professional (MVP). Here is a video on my...
2013-10-01
2,355 reads
PowerShell – Script to Monitor Disk Space of a Group of servers – HTML Formatted Email Output
This post explains how to monitor DiskSpace of a group of listed servers in a text file.
The function Get-DiskSpaceReport comprises...
2013-10-01
4,399 reads
SQL Server :Part 1 : Architecture of Transaction Log
In our earlier post, we have discussed in detail about the architecture of the data file and different types of pages. In this post, we will be discussing about...
2013-10-01
169 reads
Stupid me #3 – Building the script component
After over 6 months of silence, it is time again for another Stupid me™®©! For those unfamiliar with the concept:
Every...
2013-10-01
644 reads
Stupid me #3 – Building the script component
After over 6 months of silence, it is time again for another Stupid me™®©! For those unfamiliar with the concept:
Every...
2013-10-01
356 reads
What’s the Age Limit for Becoming a DBA?
I received an email from a nice chap recently, concerning a subject that I’m often asked about and I wanted to share my thoughts with you here. Since I only...
2013-10-01
18 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