April #Meme15 Assignment

Before the advent of the modern “Social Network”, many of us were already connected through tools that had much less...

SSIS How-To: Reuse Existing Connection Manager to Execute SQL in Script Task

There’s a myriad of examples out there on how to execute a sql task via OLEDB connections and C# in a...

Enabling Contained Databases in SQL Server 2012

One of the new features in SQL Server 2012 is the Partially Contained Database feature. I gave a talk on...

Onward and Upward!

As you may have heard by now, I am joining the wonderful team at SQLskills as a Principal Consultant starting...

SQL Saturday #107 in Houston, TX

SQL Saturday #107 in Houston, TX
Houston Skyline

SQL Saturday #107 in Houston, TX is almost here. I will be leaving for...

SSAS development quick tip

When creating a new cube in SSAS, you are frequently making changes that cause the whole cube to reprocess when...

Thoughts on Twitter

We hear a lot about social media these days:  Facebook, LinkedIn, Google+, Twitter, etc.  More and more, we’re expected to...

Quick Reference: How Do I Read an Excel XSLM (Macro-Enabled) File in SSIS?

Excel 2010 (and presumably the next version of Excel) have taken some security precautions with regards to macros in Excel files.  If a spreadsheet has macros in it, you...

Need a Blogging Nudge? Try Plinky

If you want to blog you need ideas, something to write about, and sometimes that leads to the blank stare...

SQL Saturday #107–Houston

Wow, blessed to speaker at another SQL Saturday in Houston #107. The first task of this weekend is Friday. Kalen...