The best overlooked addition to SQL 2016
Many of the widely advertised and talked about features of SQL Server or other software products focus exclusively on the...
2018-03-07
368 reads
Blog Posts
UNDERCOVER TOOLBOX: sp_WhatsMyAG
Here’s a quick one for you. If you happen to be managing SQL Servers with a large number of databases...
2018-03-07
339 reads
Which Blogs Do I Recommend?
One of the most important parts of continuing learning as a DBA (or probably an IT Professional) is reading blogs. ...
2018-03-07
374 reads
2.5 Ways Your ORM Is Vulnerable To SQL Injection
Someone recently told me that they don't need to worry about SQL injection because they are using an ORM.
Oh boy.
ORMs don't automatically prevent SQL injection
Watch this week's video on YouTube
Object-relational...
2018-03-06
7 reads
Azure SQL Database Managed Instance is now private preview
Today is the day that Azure SQL Database Managed Instance is available for the world to explore. Private preview means...
2018-03-06
297 reads
Classifying your data in Azure SQL DB for GDPR
Azure SQL DB is a robust data platform that’s cloud native and can be managed from SQL Server Management Studio...
2018-03-06
425 reads
Finding Top Offenders with Extended Events
This week at MVP Summit I got to talk with a friend who loves profiler. We were talking about capturing workloads and doing analysis on them. T-SQL or other...
2018-03-06
3 reads
Finding Top Offenders with Extended Events
This week at MVP Summit I got to talk with a friend who loves profiler. We were talking about capturing...
2018-03-06
286 reads
Killing A Service Broker SPID
Killing a SPID shouldn’t be complicated. Execute the command KILL [SPID] and that should kill the session. But there are situations...
2018-03-06 (first published: 2018-02-20)
6,152 reads
Packt $10 Sale
One sale today, my Getting Started with SQL Server 2016 Administration video. You can get this for $10 today, and...
2018-03-06
337 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