Chapter 4: Understanding Synapse SQL Pools and SQL Options
In this chapter, you will learn what Massively Parallel Processing (MPP) means in terms of a cloud PaaS database service. You will examine the concepts of distributing and replicating data in a database. Furthermore, you will see how to manage the workload in this database to your benefit by avoiding early scaling and leveraging all the performance capabilities of the service. Partitioning will extend your options when it comes to massive amounts of data when you need to grow from terabytes to petabytes. You will also learn how to load data efficiently into your database service.
Finally, we will have a look at the next evolutionary steps of the SQL pools in Azure Synapse and other ...
Get Cloud Scale Analytics with Azure Data Services now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
