PowerShell and T-SQL: Implementing UNION, INTERSECT, and EXCEPT
I’ve been thoroughly enjoying my experience this year with the Scripting Games. This is the first year I've competed and...
2012-04-16 (first published: 2012-04-12)
6,757 reads
Blog Posts
Script to analyse space usage by your Service Broker
I believe that service broker is one of the best features from SQL server 2005, well along with the xml...
2012-04-16
2,444 reads
SQL Saturday #111 Atlanta recap and links and stuff and things….
I particularly enjoy SQL Saturdays in Atlanta for a few reasons. It gives me an excellent excuse to come out...
2012-04-16
697 reads
SQL Saturday 136 – Wellington. Speakers review.
TweetG’day,
On Saturday 16th April 2012, I attended SQL Saturday #136 in Wellington, New Zealand.
The day was run by Dave Curlewis [Blog...
2012-04-16
1,104 reads
SQLSaturday #151 Announced–Orlando!
Just got the email, Orlando will be having its sixth annual SQLSaturday this year on September 29th, 2012, at Seminole...
2012-04-16
569 reads
SQLSaturday in Houston
I will be speaking at the Houston SQLSaturday this upcoming Saturday (April 21st). Below is info on my session, which...
2012-04-16
627 reads
Three Mistakes Managers Make
I suppose there is an almost limitless number of mistakes that managers can do and do make, it’s the nature...
2012-04-16
1,008 reads
Adding , Deleting and Updating a Column in a table
Many times we need to alter the table definition by adding , deleting or updating a column in the table. In...
2012-04-15
1,418 reads
Derived Table In Sql Server
Derived tables:- Derived tables are the tables which are created on the fly with the help of the Select statement. It is...
2012-04-15
18,006 reads
Massively Parallel Processing and the Parallel Data Warehouse
Data growth is related to Moore’s law. As computers get faster and more powerful, we are using them to process...
2012-04-15
7,795 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