Using MDX to work with the File System
There are sometimes some cool things you can do with a language that is not really it’s primary focus. T-SQL...
2010-02-20
391 reads
Blog Posts
Why don’t lookup columns appear in no match output?
I often get asked when we are discussing loading dimension tables in SSIS, why the key columns from the table...
2010-02-20
353 reads
Bikes for Almost Grownups
Ran across this in Make Magazine, http://www.bigkidbike.com/, these are totally custom bikes, with names like Bigger Wheel, Lizard, and Kitten....
2010-02-19
550 reads
Feedback from Connect : Allow Snapshot Backups
I posted a note to allow snapshots to be backed up in SQL Server. The inability to do so, and...
2010-02-19
1,475 reads
On Ethics
I was having a conversation recently with a friend and former co-worker of mine. He's bounced around here and there,...
2010-02-19
797 reads
Playing With SQL Azure Data Synch
Microsoft has provided a free tool that allows you to easily create a SQL Azure database, and then synchronize the...
2010-02-19
1,566 reads
Reporting Services Switch Function
Recently a client requested to create a Reporting Services expression that emulated the CASE WHEN statement from T-SQL. The expression...
2010-02-19
4,279 reads
So You Want to Write a Book?
What the heck is wrong with you?
Still interested? Fine. I’ll tell you my take on this whole business. I’m only...
2010-02-19
700 reads
Speaking at the PASS DBA Virtual Chapter
Next week, I’ll be “in the cloud” as I give a presentation for the PASS DBA Virtual Chapter. The topic...
2010-02-19
349 reads
SQL Azure Database Service Update 1 Released on February 17
Microsoft’s David Robinson has announced on the SQL Azure Team Blog that they have released Service Update 1 for SQL...
2010-02-19
522 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