Author : Bill Lescher

Bill has over 20 years of database administration and development experience. He is a co-founder of the Chicago chapter of the Professional Association for SQL Server (PASS), where he served as President for its first decade. He is a recipient of the “Outstanding PASS Volunteer” award, and he was a top 5 finalist of the Exceptional DBA Award. Bill has been a key organizer of the annual “SQL Saturdays” in Chicago. An Alum of Illinois State University, he was born and raised in Chicagoland.

Written on Jul, 05, 2017 by in | Leave a comment

Overview The following procedures are meant to be used for creating a Windows Server Failover Cluster (WSFC) hosting a SQL Server Availability Group in a LAB environment.  More specifically, this lab should not be connected to any kind of corporate domain.  The lab should be on an isolated laptop or possibly a home network.  The focus is on being able …

Continue Reading...
Written on Mar, 30, 2017 by in | Leave a comment

Overview As main stream support for SQL Server 2012 comes to an end this summer, somewhere between 60% and 80% of us are still on SQL Server 2008 R2.  My bet is that means most of us are still using the tried and true SQL Server Profiler for troubleshooting.  Despite some amazing blog posts and speaker sessions, lots of us are still …

Continue Reading...
Written on Jan, 14, 2015 by in | Leave a comment

As we embark on the 22nd year of everyone’s favorite RDBMS, I decided to create a tuple of SQL Server New Year’s resolutions.  Hopefully you can find some things in this list that ring true for you. Test your database backups – When is the last time you successfully restored a production database backup file?  Ideally this is a regularly …

Continue Reading...