Using the MERGE statement

I love MERGE.  You know all those awful IF BEGIN END ELSE BEGIN END blocks you need to write for...

XQuery for the Non-Expert – @Variable Use

Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post.
Talk to the Experts
In a...

31 Days of SSIS – 10 Things About Expressions (16/31)

31 Days of SSIS
Sixteen days in and we are past the half way point for the 31 Days of SSIS...

Check that what you expected is actually what you got - DB's and SQLCMD

I feel that it is wise move for a script to actually check itself that the database connection that is...

31 Days of SSIS – Every Which Way Outputs (15/31)

31 Days of SSIS
Saturday morning and you can watch your favorite cartoon, or jump into some fun with SSIS.  Today...

PASSMN January Meeting Announced

The details are up and we have the meeting planned for January for the Minnesota SQL Server User Group (PASSMN). ...

SQL Saturday #62

I presented a one hour session at SQL Saturday #62 in Tampa on SQL Server PowerShell Extensions (SQLPSX): “In this...

SSMSDeploy Demo #2 - new features

I've made some changes to the addin, adding some new features:

Comments: You can now add a comment to your request....

SSMSDeploy will be available, with source, for donation

After much um-ing and ah-ing I have decided to release my addin, with source code, under the GNU GPL.

I've also...

31 Days of SSIS – Instant Excel Spreadsheet (14/31)

31 Days of SSIS
It’s day fourteen of the 31 Days of SSIS blog series.  It’s also Friday, so I’m taking...