Enabling Growth Through Performance
Enabling Growth Through Performance

Creating an Extended Events Session

By Josh Patterson | December 12, 2018 | 0 Comments

Creating an extended events session is pretty straight forward with SQL Server 2012 as Microsoft has finally introduced a graphical user interface. During my time as a DBA, I often needed to create a quick trace to capture query activity for a particular table. So, let’s run through how we might do this with extended…

Tracing Events in SQL Server

By Josh Patterson | November 16, 2018 | 0 Comments

When you want to trace or instrument SQL Server activity, whether it be for performance purposes, security, auditing, etc. – you really have two baked in methods. Well, there are a few others – but they are not all that robust. Tracing with SQL Profiler Tracing with SQL Server profile is the good ol’ way…

SQL Server Data Compression

By Josh Patterson | October 26, 2018 | 0 Comments

When people talk about data compression they are typically discussing archival – but Microsoft has used this very popular technology in a way that has managed to fall into the category of performance improvement. Here I am going to give you an example of how we can use compression to decrease disk latency, maximize memory…