SQL Server, Troubleshooting

Trust Your SQL Performance Research

You’re never too experienced to learn a new lesson.  Hopefully the following story will save you from a similar predicament.   Background I provide DBA/Architect services for a very large corporation with a very busy mobile application.  After a major application upgrade including a migration to new VMs, we were experiencing intermittent outages.  We’re talking… Continue reading Trust Your SQL Performance Research

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