Mix & Match – Day 1
I’ve been scouring my notes (old & new), wading through all my previous research and unearthing advice, tips & tricks that have...
2010-07-04
499 reads
Blog Posts
T-SQL Tuesday #008: Gettin’ Schooled
T-SQL Tuesday #008: Gettin’ Schooled
“Thank you fans and friends & odds and ends. And now for you gals and guys, a...
2010-07-04
9,231 reads
A Special Belated Happy Canada Day to Leader of the Official Opposition
Dearest Michael Ignatieff, Leader of the Liberal Party of Canada, Official Leader of the Opposition,
First of all, 'appy appy Birthday...
2010-07-03
1,310 reads
Database Configuration Checklist
This is number four in a series of checklists that I am putting together for a new book I am...
2010-07-03
3,536 reads
Extracurricular Activities
Extracurricular Activities
Recently I presented two sessions at SQL Saturday #43 in Redmond, WA. The night prior to the event, many...
2010-07-03
703 reads
PAL 2.0 Beta Released
Back in 2008, I wrote a blog post about version 1 of the Performance Analysis of Logs (PAL) tool. This...
2010-07-03
1,109 reads
SQL Blog (Basic)
1. SQL Objects
a. Stored Procedures : a bunch of SQL statement which can be stored under one name.
Adventages :
can be used...
2010-07-02
1,054 reads
Taking Time Off
I’m trying to better manage my workload. When I owned this site, I struggled to find time off, and typically...
2010-07-02
347 reads
The Raw Bloopers
A raw dump of stuff from Memorial Day 2010 until July 4, 2010
Since Community Server has trouble with this,...
2010-07-02
609 reads
There will be no 'Free Lunch' -just great feelings of accomplishment
NEW: Project Criteria and Submission Here I was again awarded the ‘Most Valuable Professional’ (MVP) designation from Microsoft for my...
2010-07-02
552 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