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.
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.