On-demand Video
Watch one module per day and complete the assignment at your pace.
Azure Synapse Analytics | Table Partition | Best Practices
Login for RecordingTable partitioning is a powerful feature to optimize the performance of data load and data querying. This feature is available with almost all the data platform technologies we have available today an......
View More
View More
Azure Synapse Analytics | Table Partition | Best Practices
Table partitioning is a powerful feature to optimize the performance of data load and data querying. This feature is available with almost all the data platform technologies we have available today and Azure Synapse Analytics – SQL pool is no exception here.In this video, you will learn about Table partition, how it works and how it helps in both data load (or data lifecycle management) and data querying and finally what are important considerations for using this feature in SQL pool, in particular.1.Table Partition - Introduction2. Data Lifecycle Management with Partition Switch-In and Switch Out3. Range Partitioning - Right Range vs Left Range4.Demo - Table Partition5.Demo - Data Load, Data Archival, and Partition Split6. Demo - SQL pool considerations7.Table Partition - Guidelines and Best Practices for dedicated SQL poolThank you for watching, in my next video, I am going to talk in detail about workload management and concurrency – an important concept and consideration when working with SQL pool. Stay tuned.
Close
Login for Recording
Welcome
##login_user##
##login_user##
You have requested to attent Azure Synapse Analytics | Table Partition | Best Practices.
AttendInstructed by
Arshad AliPrincipal Architect
Seasoned technical architect with deep experience in architecting and delivering enterprise scale data warehousing, business intelligence, big data and advance analytics solutions for enterprise customers across globe. Engages with strategic customers for digital transformation and business prioritization processes, particularly focused on data platform modernization and data analytics, to enable them to better utilize their data platform assets, and drive new insights and scale from their investment in cloud solutions through a combination of batch or real-time data consumption & processing (Lambda or Kappa architecture), predictive analytics as well as intuitive visualizations that enables users to make smarter, faster decisions.
A technical thought-leader who manages and collaborates with multi-stakeholders ecosystem - customers, engineering, marketing and sales, consulting, partners etc.
Presented in several technical events both internally and externally. Has co-authored a book on big data analytics (Big Data Analytics with Microsoft HDInsight by Sams\Pearson) and has written 200+ technical and performance optimization technique articles on data platform and analytics which have been published on several sites.
Who is this Azure Synapse Analytics | Table Partition | Best Practices for?
Benefits Of Joining Our Events And Sessions
Our Integrated Approach To Open Learning, Elevated Branding And Hiring
Upcoming Events