sp_DBPermissions V2.0
Last month I posted my stored procedures sp_SrvPermissions and sp_DBPermissions. I’m posting V2.0 of each with a few fixes. The...
2013-09-23 (first published: 2013-09-18)
2,448 reads
Blog Posts
sp_SrvPermissions V2.0
Last month I posted my stored procedures sp_SrvPermissions and sp_DBPermissions. I’m posting V2.0 of each with a few fixes. The...
2013-09-23 (first published: 2013-09-18)
2,078 reads
VMware vSphere 5.5 Enhancements That DBAs Should Care About
Last month at VMworld, VMware announced the upcoming release of their virtualization suite, vSphere 5.5. As you all know, I...
2013-09-23
1,222 reads
Will You Vote?
Voting is one of the many privileges that I have as an American citizen. It’s a privilege that most Americans...
2013-09-23
566 reads
Current Thoughts on Interviewing and Hiring Conundrums
For many organizations, data is the lifeblood that keeps them in business. If the data becomes imperiled, the very existence...
2013-09-22
512 reads
Current Thoughts on Interviewing and Hiring Conundrums
For many organizations, data is the lifeblood that keeps them in business. If the data becomes imperiled, the very existence of the organization is threatened. The folks entrusted with...
2013-09-22
7 reads
Current Thoughts on Interviewing and Hiring Conundrums
For many organizations, data is the lifeblood that keeps them in business. If the data becomes imperiled, the very existence of the organization is threatened. The folks entrusted with...
2013-09-22
15 reads
MDX #30 – Get The Book: MDX with SSAS 2012 Cookbook
MDX with SSAS 2012 Cookbook
by Sherry Li and Tomislav Piasevoli
Packt Publishing 2013
The book is now available in both paperback...
2013-09-22
1,398 reads
SQL #50–Deleting or updating data from a table of 20+ GB
I don’t have a definition of what is considered a large SQL table. I am pretty sure, however, that a...
2013-09-22
5,036 reads
Counting Work Days
Don’t forget that most holiday’s aren’t work days.
Recently while working with a client I was faced with some seriously convoluted...
2013-09-21
1,788 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