Ways to save money on Microsoft Software
If you are a developer and are on your own, or working for a company that does not have an...
2011-09-16
952 reads
James Serra's Blog
SQL Server “Denali”: Installing on a Virtual Machine
With CTP3 for SQL Server Denali available, a lot of us want to play with all the new cool features, as well as...
2011-09-14
1,722 reads
SQL Server 2012 (“Denali”): Installing on a Virtual Machine
With CTP3 for SQL Server 2012 (code name of “Denali”) available, a lot of us want to play with all the new...
2011-09-14
1,640 reads
How to prevent blocking in your SQL Server database
As a SQL Server DBA, usually the largest databases in size and in number of users that I had to manage was an ERP...
2011-09-12
826 reads
Using a Display Folder for a SSAS calculation
I was having a problem getting the display folder to work for a calculation in SSAS. Turns out, it will...
2011-09-09
1,371 reads
Thinking about taking a contract position? Questions to ask
Over the years, I have accumulated a set of questions that I usually ask the placement firm about a contract position...
2011-09-07
1,160 reads
System Center and Visual Studio Team Foundation Server 2010
Because the relationship between application development and the IT operations teams is critical, Microsoft has released a CTP of a new...
2011-09-06
1,081 reads
Preventing projects from deploying when debugging a SSIS package
This is a quick tip to help quickly solve a problem I run into sometimes, and now that I am...
2011-09-02
1,415 reads
Receive error #13119 in toolbox instead of tools in Visual Studio 2008
A couple of times over the past few months, while in Visual Studio 2008 working on an SSIS package, I went...
2011-08-31
2,155 reads
When to use T-SQL or SSIS for ETL
When doing ETL, you have the choice of using T-SQL or SSIS. What things should you consider when deciding which...
2011-08-29
10,233 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