SQL PASS Summit 2017 Day 2 – Keynote Notes and Ideas
This morning, Dr Rimma Nehme tells us the story of the birth of Azure Cosmos DB, a global, scale-out database system. At the beginning of the talk, I can already...
2017-11-02
11 reads
Blog Posts
Avoiding confusion with SQLCMD variables
SQLCMD variables can be a useful way of having changeable parameters for your SQL scripts, allowing you to specify the...
2017-11-01
9,958 reads
Azure SQL Database Automatic Tuning – Questions Answered
I used to be on the fence regarding whether or not Automatic Tuning should be on as the default when...
2017-11-01
376 reads
Changing The Stars
If you’ve never seen the movie “A Knights Tale” I recommend that you do. In the movie, the character William...
2017-11-01
346 reads
Changing The Stars
If you’ve never seen the movie “A Knights Tale” I recommend that you do. In the movie, the character William...
2017-11-01
139 reads
Contained Databases
Today's post is in regards a feature that was released with SQL Server 2012, it hasn't gotten the attention or...
2017-11-01
514 reads
DB Mail error “File attachment or query results size exceeds allowable value of 1000000 bytes”
Issue : One email report is working fine from long time but suddenly it failed today with below error.
Error :
Msg 22051,...
2017-11-01
1,303 reads
Gimmicks that work: XE Profiler in SQL Server Management Studio
I have a favourite new feature of SQL Server Management Studio 17.3 (SSMS), and that’s XE Profiler, which allows you to...
2017-11-01
493 reads
New Pluralsight Course – SQL Server on Linux Administration Fundamentals
New Pluralsight Course – SQL Server on Linux Administration Fundamentals
My new course “SQL Server on Linux Administration Fundamentals” in now available on Pluralsight here!...
2017-11-01
493 reads
New Pluralsight Course – SQL Server on Linux Administration Fundamentals
New Pluralsight Course – SQL Server on Linux Administration Fundamentals
My new course “SQL Server on Linux Administration Fundamentals” in now available on Pluralsight here! If you want to learn about the...
2017-11-01
13 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