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