Enabling Growth Through Performance
Enabling Growth Through Performance

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…