What’s stopping you?
I mentioned earlier this week that I’m working on a new presentation for SQLSaturday #119 next month. The talk revolves...
2012-04-04
529 reads
Blog Posts
Oracle Tips for MSBI Devs #4: Executing an Oracle Stored Proc with IN Parameters in SSIS Execute SQL Task
The first tip I published discussed how to execute an Oracle procedure with no parameters. In this tip, I will...
2012-04-03
728 reads
Powershell – Validating an IP Address
A task that I have had to do several times over the years is determine if an IP Address string...
2012-04-03
4,186 reads
SQL SERVER Replication – Troubleshooting Steps for Beginners
Few days back there was a replication issue in one of the QA servers. Since the DBA was out of...
2012-04-03 (first published: 2012-03-26)
5,411 reads
The first blog post….
Daunting! By way of introduction, I’m Mat This blog is mostly for myself, to document what I know and maybe...
2012-04-03
602 reads
Why an employer should never ask about accessing your Facebook page
There's a brilliant piece of work posted as a fictitious resignation letter that gives some scenarios as to why an employer could...
2012-04-03
1,347 reads
Backup script skipping databases – and the fix!
A real head-scratcher
I’ve been using my RYO Maintenance scripts for a little while now, and they’ve been working great. Almost....
2012-04-02 (first published: 2012-03-26)
1,939 reads
Execution Plans – Table, Clustered Index and Non-Clustered Index Scan
An important operator to understand in execution plans is a scan. A Scan can be good and bad, so understanding...
2012-04-02
4,302 reads
Goals – 9 month checkup
Nine months down, three to go*. It’s time once again to see where I’m at with the goals I set...
2012-04-02
967 reads
Mirroring Support for SharePoint 2010 Databases
Like all systems built on top of SQL Server SharePoint 2010 needs to have a plan for availability. There are...
2012-04-02
1,218 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