Category Archives for "SQL Development"

Jun 16


By Lori Brown | Beginner , Performance Tuning , SQL Administration , SQL Development , SQL Server

–By Lori Brown @SQLSupahStah SQL Server 2016 has introduced a couple of new functions that can be very useful and save storage space to boot. COMPRESS and DECOMPRESS offers the benefit of compressing column data thereby saving storage space. COMPRESS uses the GZIP compression algorithm and actually compresses data before it is stored in a […]

Continue reading
Jan 28

SQL Server 2012/2014 Extended Events for Developers – Part 1

By Jeffry Schwartz | Expert , Performance Tuning , SQL Development , SQL Server

— By Jeffry Schwartz Microsoft introduced Extended Events, a.k.a. XEvents, in SQL Server 2008 to aid in the analysis of performance problems. Both the capabilities and syntax were changed significantly on SQL Server 2012, and new (and very important) features were added in SQL Server 2014. Therefore, the focus of this document will be on […]

Continue reading