|Data Platform & Business Intelligence|
|09:30 - 10:30|
You may already heard about partitioning as a way to split large tables into smaller pieces. However, is it the only way of partitioning usage? When to start using it and what are pros and cons? What are different ways to partition table? How to choose right columns, functions and schemas? I will answer all these questions by using the real world examples.
I have been working with SQL Server since SQL Server 2000 version as a database administrator, developer, consultant and trainer, focusing on high availability and disaster recovery solutions, ETL, troubleshooting and performance tuning, developing high performance solutions. I'm a regular speaker at SQL Server user group meetings, SQL Saturday events and other conferences. An owner of MCM certification and MVP award on SQL Server.