Blog

SQL Server

How to Build a Local SQL Server Availability Group

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… Continue reading How to Build a Local SQL Server Availability Group

SQL Server, Troubleshooting

SQL Profiler vs XEvents: Quick Start

Overview As mainstream support for SQL Server 2012 comes to an end this summer (2017), 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… Continue reading SQL Profiler vs XEvents: Quick Start