Performance Tuning Pre-con and More at SQLSaturday 277 RVA
Join me for 2 days of fun and education at SQL Saturday #277 in Richmond, VA on March 21 and...
2014-02-04
954 reads
SQL Server Soldier :: News from the frontlines of the database wars
Schema-only Backups and Restores
I was reading the blog post Time for a Quick Rant by Grant Fritchey (blog|@GFritchey) about people who choose to...
2014-01-20
1,534 reads
DBA: Guardian of the Data
I was asked recently by Idera to take a look at the things that could cost a DBA their job....
2014-01-17
1,164 reads
T-SQL Tuesday #50: Doing More With Less
It’s time once again for that monthly geek party again we like to call T-SQL Tuesday. T-SQL Tuesday #50 is...
2014-01-14
992 reads
Who Owns SQL Backups?
I was asked by Idera to take a look at the things that could cost a DBA their job. This...
2014-01-10
1,055 reads
When DMVs Cost Me My Job
Back in early 2006, I was still working at my first ever DBA job. I had only been a DBA...
2013-12-27
976 reads
T-SQL Tuesday #49: Wait For It Roundup
A huge round of applause and my thanks to all of the participants and spectators for this month’s edition of...
2013-12-14
1,658 reads
Enabling High Performance Power Plan via PowerShell
One of the projects I’ve been working on recently was to automate our production SQL Server installs including our standard...
2013-12-13
1,963 reads
T-SQL Tuesday #49: My Go-To Query For Waiting Tasks
I’m not just hosting T-SQL Tuesday, I’m a customer as well. Err, I mean participant. Topic for this month’s T-SQL...
2013-12-10
1,215 reads
Never an Infinite Loop Around When You Need One
You may be thinking, “You’re a DBA. I thought DBAs hated infinite loops.” Well, you’re right, most of the time....
2013-12-09
1,360 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