August 2012 S3OLV Meeting

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

PASS Is Hiring Another Evangelist–Could It Be You?

Just about a year ago PASS hired Karla Landrum to fill the vacancy of the Community Evangelist and that marked...

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

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

Stop Storing Unencrypted Passwords!

I was called over today by a person doing application support to help troubleshoot a database connectivity issue. This isn't a...

Syncing your contacts

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

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

How to move master and resource system databases?

I received an phone call from a friend today asking how to move master and resource system databases in Microsoft...

The effects of an SSD on SQL Server Performance

I.                    Introduction A little while ago, my wonderful wife Renee got a Solid State Drive (SSD) for me.  Being a...

Learning solid SQL Server and Business Intelligence skills through online training

I have just signed up for a one year standard subscription of Pluralsight Hardcore Developer Training. I’m focusing on SQL...