What I Want For My Birthday
Dell has teased us with some images of their upcoming 12th Generation servers (that will support the Intel Sandy Bridge-EP...
2012-02-29
1,793 reads
Blog Posts
Write a Variable To a File Using SSIS
Problem
I’ve a SSIS package. When it fails execution, I want to write a custom message including the package name and error...
2012-02-29
5,942 reads
A Script A Day - Day 24 - Object Qualification
Today’s script is one I use as an example to explain that there is method behind my standards that some...
2012-02-28
1,503 reads
How’s Microsoft doing with community involvement? (updated)
Update: Jen Lussier has blogged a summary of the talks she had at the MVP summit last week. Take a...
2012-02-28
1,604 reads
Misadventures in TDE: How to Restore an Encrypted SQL Server Database Completely Wrong
Doing things by the book isn’t necessarily the only way to learn a new skill. Sometimes, experiencing everything that can...
2012-02-28
4,052 reads
Presenting at SQL Saturday #110
On Saturday, March 10, 2012, I’ll be presenting “Table Vars and Temp Tables – What you NEED to know!” at SQL...
2012-02-28
1,402 reads
Removing Identical Duplicate Rows
Deleting duplicate rows out of a table can be tricky. A brute force way to do this is with a...
2012-02-28 (first published: 2012-02-21)
4,231 reads
SQL Server 2008/2008 R2 Diagnostic Queries for March 2012
Since it is nearly March, I will go ahead and jump the gun by a few days and post an...
2012-02-28
1,840 reads
SQL Server Agent Job Steps
To list a SQL Server Agent Job Steps use the T-SQL example below.
This example displays the step id, SQL Server...
2012-02-28
1,965 reads
A Script A Day - Day 21 - The HAVING Clause
Today’s post is about the HAVING clause which specifies a search condition for a group or an aggregate. HAVING is...
2012-02-27
546 reads
Blogs
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...
Start with the FabricTools PowerShell module
By Kamil
Managing Microsoft Fabric at scale quickly becomes painful if you rely only on the...
Forums
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
SQL Art: I Made a Christmas Card In SSMS
Comments posted to this topic are about the item SQL Art: I Made a...
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