Register
Register

Azure Synapse Analytics | Table Partition | Best Practices

By: Arshad

View Recording
Welcome
##login_user##

You have requested to attent Azure Synapse Analytics | Table Partition | Best Practices.

Attend

Or Register below by entering your details:-


To raise question, join our telgram channel now.
By Registering You Agree To Our Terms , Condition and Disclaimer.

9 (Enrolled)

You are the 10 technologist to register for Arshad Ali master class.

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

1.Table Partition - Introduction
2. Data Lifecycle Management with Partition Switch-In and Switch Out
3. Range Partitioning - Right Range vs Left Range
4.Demo - Table Partition
5.Demo - Data Load, Data Archival, and Partition Split
6. Demo - SQL pool considerations
7.Table Partition - Guidelines and Best Practices for dedicated SQL pool

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

View Recording
Rate and Review

You can share it with others

Instructed by

Arshad Ali
Principal 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.

View Mentor Profile
Who is this Azure Synapse Analytics | Table Partition | Best Practices for?
data lifecycle management switch-in switch out range left range data load data archival partition split sql pool table partition
Benefits Of Joining Our Events And Sessions
Our Integrated Approach To Open Learning.
Benefits Of Joining Our Events And Sessions
Upcoming Events