On April 22, I'll be speaking at SQL Saturday Edmonton (#SQLSat594) about SQL Server Data Compression. If you're in the Edmonton area, you should register and join us for a fun and free day of Microsoft SQL Server training. There will even be prizes! SentryOne is sponsoring the event and we'll be giving away a license for SQL Sentry, which provides SQL Server and Windows Performance Monitoring, Event Management, Top SQL, Block Chain and Deadlock Analysis, Intelligent Alerting, and so much more! I dare say you will be the envy of other attendees if you win this prize.
Last week, I presented the session at the Maine PASS user group. That's about as close of a Canadian test audience that I can get in the States. ;-) The slides from that presentation can be downloaded here. As I mentioned during my presentation, please check the notes for additional information and T-SQL to copy/paste.
I've blogged a lot about SQL Server Data Compression. Here's a list of those blog links mentioned in the slides:
- #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.
I'm looking forward to speaking in Edmonton. Not only will it be my first time in the city, it'll be my first visit to the province of Alberta.
It appears that I didn't leave enough time to walk there. Also, why would I walk there? That path looks like it goes directly through where the hungry bears are currently waking. Hmm… "bears" might make a good GPS avoidance option now that I think about it.