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

Instance Wide Wait Stats

Over the last many weeks we have written quite a few blog post about query debugging, using Extended Events, Blocking...

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 server failed to start the system cannot find the path specified

AdvertisementsRecently one of our SQL server unable to start it. The problem with the storage LUNs.
 

 
Things you have to do:...

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