SQL Sever Data Compression: The Deeper Dive by Bob Pusateri скачать в хорошем качестве

SQL Sever Data Compression: The Deeper Dive by Bob Pusateri

Abstract: Data compression may be best-known for reducing a database's size on disk, but it's also an effective tool for increasing query performance. Come see how reduced disk usage and increased performance mean that with compression, less really can be more! This session will arm you with the knowledge and understanding to capitalize on both of these aspects of SQL Server's row and page compression features, as well as columnstore and updateable columnstore indexes. We'll combine a lesson on the internals of compression with real-world scenarios to show you how to determine the most appropriate compression type for any situation. Bio: Bob Pusateri is a Microsoft Data Platform MVP, Microsoft Certified Master, and systems architect with over 15 years experience on SQL Server and the Microsoft Data Platform. His interests involve internals, performance optimization, and cloud technologies. He is very active in the Chicago data platform community, and a frequent speaker at local, national, and international events.