SCRIPT: Basic Information About Indexes

I’m having a little fun with documenting basic information about indexes in my current project. I’m posting the scripts here...

Reading Excel into SSIS via OpenXML Scripting

Reading Excel data isn't easy.  It should be, but there's a lot of unfortunate barriers in the way that I've...

Improve DBA Operation Productivity – Part Two

As a DBA, we have to take various actions based on huge amount of information received. In one perspective, our...

SQLSaturday #171 Pittsburgh Prep Continues

Hey, did I mention that Pittsburgh is having a SQLSaturday this year?

Pittsburgh, Pennsylvania. Photo:Herbert Spencer, used under Creative Commons...

#GetHawt – The Summer 2012 Edition

Jen McCown started a #GetHawt set of posts last year and I think it went well. It must have, so...

August 2012 S3OLV Meeting

Well well well.  It has certainly been a long time between announcements on the blog about meetings for the Las Vegas SQL Server Users Group. We have had to...

August 2012 S3OLV Meeting

Well well well.  It has certainly been a long time between announcements on the blog about meetings for the Las...

Syncing your contacts

In the same vein as my blog post about Syncing your calendars, I wanted to post how to sync your contacts...

SQL Server Orphanage – Using sp_change_users_login to find and fix all orphaned SQL users

Every wonder who all your orphaned SQL Server users are on your server? Just run the script below and copy...

Video Enable PowerPivot Add-in

This is one of our first PowerPivot video tutorials and this short 1 minute tutorial we show how to enable...