Tag : data compression - SentryOne Team Blog

Tag: data compression

I'm Speaking at SQL Saturday Edmonton #SQLSat594

I'm Speaking at SQL Saturday Edmonton #SQLSat594

Melissa Connors (@MelikaNoKaOi) discusses her upcoming trip to speak at SQL Saturday Edmonton and provides links to Data Compression posts and slides.

Visualizing Data Compression: See it for Yourself

Visualizing Data Compression: See it for Yourself

Melissa Connors (@MelikaNoKaOi) explains how visualizing data compression (through DBCC PAGE) helps you better understand SQL Server compression methods.

Erin Stellato : Compression and its Effects on Performance

Erin Stellato : Compression and its Effects on Performance

Erin Stellato (@erinstellato) takes a look at the new COMPRESS and DECOMPRESS functions, comparing their impact on space and performance to traditional data compression.

Photo credit: rsdio

#EntryLevel : Compression & Data Types

Melissa Connors (@MelikaNoKaOi) walks through the basics of when SQL Server data will benefit from compression and illustrates cases when it will not.

Applying Data Compression to the SQL Sentry Database : Part 4

Melissa Connors (@MelikaNoKaOi) concludes her 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 3

Melissa Connors (@MelikaNoKaOi) continues her 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 2

Melissa Connors (@MelikaNoKaOi) continues her series on data compression, focusing on costs of implementation, index maintenance, and running SQL Sentry.

Applying Data Compression to the SQL Sentry Database : Part 1

Melissa Connors (@MelikaNoKaOi) investigates the approach, costs, and space/performance benefits of applying data compression to the SQL Sentry database.