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

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