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

reconfigure vs reconfigure with override

You can change server properties of SQL Server using sp_confgure and to "save" it you need to use reconfigure. In...

SQL Saturday #150 & TechDay in Baton Rouge–Sharepoint

This year’s SQLSaturday in Baton Rouge includes a Sharepoint track with 2 local speakers(Cody Gros & Eric Trivette), MCM Tom Resing...