Inside My PASS Summit
As you read this, I’m in Seattle for the PASS Summit 2017. I have four roles that I satisfy at...
2017-10-30
564 reads
Blog Posts
Networking, and other things to do while at PASS Summit
If you are headed to Seattle for the PASS Summit, not only are you in for a week of intense...
2017-10-30
332 reads
Quick Model Database Tidbit
Are you using your Model Database to its full potential?
I am finding more and more that Database Admins are not...
2017-10-30
736 reads
Redgate at Summit 2017
I’ll be heading out to the PASS Summit next week, spending Halloween in a conference center with a lot of...
2017-10-30 (first published: 2017-10-24)
1,192 reads
UNDERCOVER TOOLBOX: Using Python To Copy A SQL Login From One Server To Another
Recently I’ve been thinking about Python and whether it can be useful to the DBA as well as the data...
2017-10-30
391 reads
What’s that SSIS Password
A recurring theme over the past several weeks (there are always recurring themes it seems) has been an issue that...
2017-10-30
1,359 reads
What’s that SSIS Password
From time to time it is necessary to find a way into an SSIS package that is password protected. This article will help you find your way in to...
2017-10-30
45 reads
A Pretty PowerBi Pester Results Template File
I have left the heat and humidity of Singapore where I have been presenting at the PowerShell Conference Asia and...
2017-10-29
598 reads
Columnstore Indexes – part 114 (“Machine Learning Services”)
Continuation from the previous 113 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blogpost is focusing on the unsung...
2017-10-29
712 reads
It’s All About The Joins
One of the most common mistakes I see made when creating tables (and I’ve been guilty of this myself too...
2017-10-29
518 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