SSAS Trending KPI
KPI’s (Key Performance Indicators) in Analysis Services are a great way to show visually if a measure is trending in...
2014-01-27
797 reads
Blog Posts
Transact-SQL (T-SQL) query to return the status and detail information for all SQL Server Full-Text Catalogs on an SQL Server instance
We have about 200 user databases in which we have the full-text search enabled and these databases contain several tables....
2014-01-27
1,727 reads
What does “challenging” really mean?
I had lunch with an old friend last week. We hadn’t spoken in a while and we were catching up...
2014-01-27
839 reads
Does @StrateSQL Need a Unicorn Tattoo?
As I mentioned in a post a couple weeks back, I’ll be jumping into Lake Calhoun in a few weeks...
2014-01-26
541 reads
Master Data Services for the Beginner Part 01
Introduction
About 12 months ago, I started to look at Master Data Services in a serious manner. I had toyed with...
2014-01-26
5,291 reads
Master Data Services Disaster Recovery Challenges
Introduction
While Master Data Services is the best tool to come along to permit user to update their qualitative and quantitative...
2014-01-25
3,585 reads
Blogtrottr – RSS to Email
Anyone who is a fan of RSS Feeds will likely know that the discontinuing of service by Google Reader caused...
2014-01-24
972 reads
Friday Followup For January 24, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-01-24
517 reads
More On The Target Breach
Over the past week there has been information finally coming out about how the Target breach occurred. This write up...
2014-01-24
931 reads
Moving WordPress to Windows Azure
For the past year or so I’ve hosted this blog at Godaddy using their web hosting service. It took a...
2014-01-24 (first published: 2014-01-21)
1,596 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