EPM Framework and SQL 2008 R2

This weekend at SQLSaturday 62 in Tampa, I presented my policy-based management presentation. During my presentationone of the cool things...

Notes from SQLSaturday #62

The weekend started with a later afternoon drive to Tampa, returning a couple calls and then chatting with Steve Jones...

Isolation Levels–MCM Prep

I was watching the Isolation Levels video for my MCM prep and learned something about the isolation levels. I knew...

Using the MERGE statement

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

2011.....So (long pause), what's next for me?

I've actually sat down to write this blog several times.  I am never indecisive when it comes to my thoughts...

TechEd: Session Preference Survey

TechEd has listed some potential sessions for TechEd North America 2011 here:  http://northamerica.msteched.com/sessionpreference?fbid=I1Ydc71JM4a.  They want to know which sessions you...

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...

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 – 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...