Learn more about SQL Server tools

mssqltips logo
giveaway
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

Leveraging compression for SQL Server performance

Sponsored by - Tegile

Webcast Abstract

Indexing is king when it comes to achieving the highest levels of performance in SQL Server. When indexing is correctly combined with compression (an Enterprise only feature), you can gain significant advantages. During this session, we will demo how to query dynamic management views (DMVs) to identify the right objects on which to implement compression, ways to measure performance and identify impact on memory and other resources. We will cover advanced scripts that provide details on fragmentation, memory caching and compression levels. We will also look at how someone who does not have the Enterprise Edition of SQL Server or latest edition of SQL Server can still leverage compression and gain the performance advantage using the right Flash Storage solution.

Speaker - Neil Hambly and Sumeet Bansal

Neil Hambly is the SQL Server & BI Practice lead at Northdoor PLC (MSFT Data Platform Gold partner). He has held critical roles at several key companies like ABN AMRO, Accenture, ASOS, BBC, and Confio Software. Neil has over 17+ years in SQL Server experience. He has presented at over 120 events including the Pass Summit, 24HOP, SQLBits, SQLRelay covering over 10 countries. He is the current Leader of PASS London (UK) & Professional Development VC, Melissa Data MVP (2015), and a SQL Cruise Technical Lead.

Sumeet Bansal was a VP of IT and lead DBA implemented flash technology at wine.com in late 2009 to solve critical business problems. He implemented the first data warehouse at wine.com to streamline analytical reporting. He has over 16 years of IT experience covering database platforms such as Oracle and SQL Server along with datacenter architectures. His database experience involves extensive hands-on work with database performance, application acceleration and systems administration. Sumeet has been the resident SQL Server and database expert at several top flash companies including: Fusion-io, Violin Memory and most recently Tegile.

To access materials please fill out the form below.



































By submitting this data you are accepting to receive newsletters, account updates and special offers about SQL Server from MSSQLTips and our sponsors. We respect your privacy and you can unsubscribe at any time.



More SQL Server Solutions











Learn more about SQL Server tools