Today, I spoke about SQL Server Data Compression for the #PASSWIT virtual group. Thanks so much to Kathi Kellenberger for organizing and for having me present!
The PASS Women in Technology virtual group is an active chapter with many more events coming up soon. Check out their list of Future Webinars. Kendra Little is discussing "How Keys & Included Columns Work" next week!
As promised in the presentation, the slides are available for download here. Scripts that appear in the images are in the notes for copy/paste.
The recorded version is available on the PASSWIT YouTube channel, and I've embedded it below as well. Videos from past presentations are posted to their channel regularly, so be sure to catch up on any sessions that you missed.
- #EntryLevel : Compression & Data Types – walks through the basics of when SQL Server data will benefit from compression and illustrates cases when it will not.
- Visualizing Data Compression: See it for Yourself – explains how visualizing data compression (through DBCC PAGE) helps you better understand SQL Server compression methods.
- Applying Data Compression to the SQL Sentry Database : Part 1 – investigates the approach, costs, and space/performance benefits of applying data compression to the SQL Sentry database.
- Applying Data Compression to the SQL Sentry Database : Part 2 – continues the series on data compression, focusing on costs of implementation, index maintenance, and running SQL Sentry.
- Applying Data Compression to the SQL Sentry Database : Part 3 – continues the compression series, looking at disk I/O, memory usage, and decision-making tables for selecting compression.
- Applying Data Compression to the SQL Sentry Database : Part 4 – concludes the data compression series, providing the DDL commands you can apply to your own SQL Sentry database.
- Applying Data Compression to the SQL Sentry Database : Part 5 (Follow-up) – follows up on the data compression series, providing details on wait statistics, MAXDOP settings, and Performance Analysis.