SQL Server 2005 CLR execution error after restore
I recently restored a SQL Server 2005 database to a testing environment. The database contained several CLR assemblies, when the...
2010-02-21
1,169 reads
Blog Posts
Automate Back Slashes in Your File Path Expressions in SSIS
One of the most aggravating things when work with the SSIS expression language is when you have to combine file...
2010-02-20
2,280 reads
Carrier Pigeon Beat Local Telcom
It’s not often that we find stories that make us laugh out loud, unless they have to do with situations...
2010-02-20
244 reads
Connecting to DB2 AS\400 with SSIS
We have a lot of projects in our organizations that require us to work with database systems other than SQL...
2010-02-20
1,655 reads
Connecting to DB2 AS\400 with SSIS
We have a lot of projects in our organizations that require us to work with database systems other than SQL...
2010-02-20
4,504 reads
Don’t Miss our Upcoming Webinar Series in February and March
More awesome happenings from Pragmatic Works, Wrox, and SQLServerCentral.com. Check out our Upcoming Webinar Series next week. They are free,...
2010-02-20
250 reads
Free SQL Server Webinar Series
Are you new to SQL Server?Do you want to learn about its many features and capabilities? If so, please join...
2010-02-20
774 reads
I’m Speaking at the SSWUG VConference in April
Hey All ! I wanted to let you know I will be speaking at the SSWUG Virtual Conference this Spring. This...
2010-02-20
210 reads
Important SSAS Dimension Properties
When configuring a SSAS Dimension, there are many important properties to pay attention to. This blog will give you a...
2010-02-20
439 reads
Improve your SSMS Interaction
Ever wanted to liven up your life some with some color in your day to day DBA duties. There are...
2010-02-20
250 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