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

SQL Server 2012 AlwaysOn Availability Groups – Part 4: Adding new Replicas

In the last 2 blog postings you have learned how to setup your first Availability
Group with SQL Server 2012. Today...

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

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

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