X on XMLA: iii. Basic DDL Functions in XMLA (Create, Alter, Delete)

XMLA can be used to manage the structure of your multidimensional databases.  While many developers use Visual Studio (BIDS), to...

April #Meme15 Assignment

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

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

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

Nifty queries using a Numbers helper table

(The complete usable code is in the very bottom of this blog post)
Some of you may have seen this “numbers...

Onward and Upward!

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

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

SQL Azure Saturday, WIT NYC and other local events!

Good day!  Just wanted to share some exciting upcoming local events in the NYC/NJ area.
Hosted by the NJ SQL User...

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

SQL Saturday #107–Houston

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