Book from a library. Learning never stops for data professionals.
[2017-Oct-31] If you have never read the "Iacocca: An Autobiography" book by Lee Iacocca, I highly recommend it. I read it...
2017-10-31
617 reads
Blog Posts
SQL Server 2017: Making Backups Great Again!
In some DBA circles, backups are just as popular as politicians! However, recoverability is the most important task for database administrators. While SQL Server 2017 added so many great...
2017-10-31
54 reads
The Quickest Way To Get SQL Command Help
Formula One …. F1 …. Photo by Jp Valery on UnsplashEvery once in a while I discover a SQL Server Management Studio trick that’s apparently...
2017-10-31
390 reads
The Quickest Way To Get SQL Command Help
Every once in a while I discover a SQL Server Management Studio trick that's apparently been around forever but is completely new to me.
Today I want to point out...
2017-10-31
7 reads
Why I Believe in the Data Architecture Review
We have a solution called Data Architecture Review. With this solution, we conduct a complete review of the customer’s data...
2017-10-31 (first published: 2017-10-23)
2,205 reads
Can’t Connect to Analysis Services – Invalid Connection Information
I have a new installation of SQL Server 2017, along with an instance of Analysis Services Tabular 2017. I tried...
2017-10-30
1,521 reads
DevOps Basics – Ignoring Files in Git
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-10-30
1,516 reads
Don’t “Test” Against Production
A few months ago, I was participating in a threat hunting exercise on the security side. The gentleman leading the...
2017-10-30 (first published: 2017-10-18)
2,061 reads
Haunted SQL: The ghost of Management Studio
Have you ever had a query change performance unexpectedly? Intellisense all of a sudden stops working, or gives inconsistent results?...
2017-10-30
666 reads
If You’re Stuck at Home for the PASS Summit
Conferences are a great place to network, to see new technologies or to see existing technologies being used in new...
2017-10-30
673 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