Understanding SQL Server Full-text Indexing – (Part 1)
SQL Server allows applications and users to execute full- text search queries against character based data in SQL Server tables....
2013-09-17
637 reads
Blog Posts
Understanding SQL Server Full-text Indexing – (Part 2)
Checkout the final part of this two part article series here, in which I discussed how to create full-text index...
2013-09-17
540 reads
Understanding SSIS Package Configurations
Managing changes to environment dependent variables is common and critical in any ETL application, especially during deployment of SSIS packages....
2013-09-17
760 reads
Why Government Required Backdoors Are a Bad Idea
I've heard the argument, "I've got nothing to hide. If it helps them catch the next guy, I'm all for...
2013-09-17 (first published: 2013-09-11)
3,977 reads
10 signs you're not talking to a developer
Reblogged from the pluralsight blog: There are many types of developers out there. And while not all speak the same...
2013-09-16
844 reads
A Rickety Stairway to SQL Server Data Mining, Part 14.3: Debugging and Deployment
By Steve Bolton
…………Throughout this series of amateur self-tutorials in SQL Server Data Mining (SSDM), I’ve often said that working with...
2013-09-16
1,434 reads
Announcing the SQLpassion Online Academy
Over the last weeks it was a little bit silent on my Weblog for a very good reason: I’m very...
2013-09-16
823 reads
Backups, Encryption and Branding in San Diego
This weekend is SQL Saturday #249 in San Diego. I’m looking forward to the trip for a few reasons, but...
2013-09-16
824 reads
Certifications: What are they good for?
Reblogged from SQL Studies: Since Microsoft decided to drop the MCM/MCA program there has been an enormous amount of discussion...
2013-09-16
618 reads
DBA Myths: You can’t use an alias in an UPDATE statement.
I’ve found a very common belief among users of T-SQL (both DBAs and Developers) is that you can’t use an...
2013-09-16
882 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