Know When it’s Good Enough
Here’s a newsflash: You may not thing so, but you are expensive. There’s no point in endless performance tuning. I love...
2014-01-28
709 reads
Blog Posts
Movie Adaptations of Books
I’ve never written a novel or a movie script, but I’ve sure consumed a lot of both and enjoy both....
2014-01-28
790 reads
SQL Server Data Tools (SSDT) – January 2014 update
The SSDT January 2014 release has been updated to support both SQL Server 2012 Parallel Data Warehouse Appliance Update 1...
2014-01-28
1,472 reads
Applied SQL: LIKE ‘whatever’
Today let’s play around with the LIKE operator. Like, totally. Like, Introduction Like “determines whether a specific character string matches...
2014-01-27
733 reads
February 2014 – SQL Server Monthly Maintenance Checklist
image source
It’s a cold, cold day here in Minnesota. A great day for staying in and working on some in-home...
2014-01-27
537 reads
Last Weeks Top “Reading” Links #68
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-01-27
972 reads
Myths and Misconceptions about Transaction Isolation Levels
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email...
2014-01-27 (first published: 2014-01-21)
3,977 reads
Powershell in a Month Day 13 – Remote Control
This is part of my Powershell Challenge, to learn more about PowerShell (PoSh) using the Learn Windows Powershell 3 in a Month...
2014-01-27
1,048 reads
Quick tip, ever needed to manipulate SQL on many lines in SSMS? now you can….
Have you ever had the need to select values that are directly on the next line down but drag-and-drop selects...
2014-01-27
274 reads
Security, Compliance, and SQL Server Webinar on January 29, 2014
My first webinar of the year! I’m joining forces with the GreenSQL and MSSQLTips to present Security, Compliance, and SQL...
2014-01-27 (first published: 2014-01-13)
978 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