SQL Agent – Giving non-SA users permissions on jobs
There are some new database roles in the MSDB database in SQL Server 2005 that allow you to grant more...
2010-02-28
15,111 reads
Blog Posts
Weekly Electrical Usage from Google PowerMeter
Since I like to measure and monitor things (maybe that is why I am a DBA), and I care about...
2010-02-28
1,568 reads
Batch Starting SQL Server Services
Many times when going from demo to development to client demo, we are always starting and stopping our SQL Server...
2010-02-27
1,555 reads
Rocky Mountain Tech Trifecta 2.0 – First Thoughts
It was a good day down in downtown Denver at the Rocky Mountain Tech Trifecta 2.0. I presented a session...
2010-02-27
1,436 reads
Should DBAs be Paid Overtime?
For the past several weeks, I have been running a poll on www.bradmcgehee.com, asking visitors if they thought that DBAs...
2010-02-27
3,106 reads
Starting a SQL Server Blog
This is day one of my SQL Server blog so I’m not looking to write anything deep or insightful or...
2010-02-27
1,762 reads
Tally Table - Delimited list to Table
Dealing with delimited lists (Usually separated by a comma) in SQL is a problem easily handled by a simple function...
2010-02-27
3,772 reads
Article in SQL Server Magazine on SQL IO Stastics.......
Article on I/O tips appearing on SQLMag.com
If you've followed my blog, you know I've written on various topics, including I/O...
2010-02-26
1,942 reads
Book Review: Orbit by John J. Nance
Just finished re-reading Orbit ($15 or less at Amazon) after picking it up for a $1 at Books a Million...
2010-02-26
1,558 reads
Dr. DMV Script for Rocky Mountain Tech Trifecta
Here is the script that has the diagnostic queries that I will be using during my presentation at the Rocky...
2010-02-26
2,768 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