PASS Nepal Chapter Monthly Meetup September 2017
Everything You Always Wanted to Know about Data Partitioning but Were Afraid to Ask
Abstract :Data partitioning is the valuable technique that may dramatically simplify database administration and improve system availability and performance. Contrary to popular believe, it is not limited to partitioned tables and may be implemented with any version and edition of SQL Server.
This session will explain how to properly architect and implement data partitioning in your systems. You will learn the benefits and downsides of different data partitioning techniques and understand how to combine them together to get the most from the solution especially in the systems with the mixed workload.
You will see how data partitioning may help with the common tasks, such as implementation of the data purge with sliding window pattern; improving system availability and shorten the downtime with piecemeal restore; reducing index maintenance overhead; improving cardinality estimations on the large tables and several others.
Finally, the session will demonstrate how to address the issues that may arise with data partitioning and optimize queries against partitioned data.
Presenter: Shree Khanal
Shree Khanal is a Database Architect, Speaker and Trainer having 12+ years of professional experience on database solution development and optimization. Mr. Khanal is a Data Platform MVP & Microsoft Certified Database Professional since 2000 to till date. Starting with SQL Server 7, he has been working with all the version of SQL Server up to 2016 in production environment. In context of OLAP cube development, he started working on it from SQL Server 2000 to latest SSAS 2016. He has worked number of years providing SQL BI solutions to various enterprise clients most of them from BI sector. He founded and has been leading the Himalayan SQL Server User Group (www.sqlpassnepal.org) based in Kathmandu, Nepal since 2010.
Location:
Program Details:
Date: 30th Sep, 2017
Time: 2:00 P.M
Venue: Mercantile Communications Pvt. Ltd (Durbar Marg, Kathmandu, Nepal)
Register:
Or mail to [email protected]
Event start: 9/30/2017 2:00:00 PM