Saving Costs in Azure
Nobody wants to waste money and being in the cloud is no exception! Luckily for us Azure is very efficient...
2018-02-27 (first published: 2018-02-15)
1,785 reads
Blog Posts
Splitting It Up: Side by Side Queries In SSMS
There are times when you are writing a query while referencing another piece of information: the results of another query,...
2018-02-27
281 reads
Splitting It Up: Side by Side Queries In SSMS
There are times when you are writing a query while referencing another piece of information: the results of another query, a variable value, a webpage, etc...
If using two monitors...
2018-02-27
10 reads
Typing Alternative Characters
I tend to work in the US English world. I’m somewhat embarrassed to note that I really only know one...
2018-02-27
467 reads
What Do Read Counts On Your SQL Server Execution Plans Even Mean?
If you’ve ever spent any time looking at execution plans you will have almost definitely noticed all the read counts...
2018-02-27
90 reads
Who installed SQL Server?
Recently, I was working with the team and got stuck up with SQL Server Installation information. We got an urgent...
2018-02-27
17,007 reads
Change the name of master database files – SQL Server on Linux
In my recent blog, I discussed about how to move master database to another location. One of the readers requested...
2018-02-26
742 reads
Double hop error when using SQLCMD
tl;dr; SQLCMD v2014 and up has special requirements for Kerberos.
One of the problems with linked servers (no rude noises please)...
2018-02-26
2,077 reads
Execute Multiple Files Using SQLCMD/SQLClient – Which Is Faster?
Hello!
I’ve been working on a PowerShell module that will migrate the schema of an Azure Data Warehouse from one database...
2018-02-26 (first published: 2018-02-15)
2,349 reads
GDPR: Your Hair Is Not On Fire
Along with a lot of other people, I’ve been attempting to call people’s attentions to the new General Data Protection...
2018-02-26
477 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