Abstract
The focus of this chapter is to break open the mysteries of each SQL storage engine and understand why a particular flavor of Azure SQL technology suits one scenario over another. We will analyze the underlying architecture of each service so that development choices can be well informed and well reasoned. Once we understand how each implementation of the SQL engine in Azure processes and stores data, we can look at the direction Microsoft is taking that technology and forecast whether the same choice would be made in the future. The knowledge gained in this chapter should provide you with the capability to understand your source data and therefore to choose which SQL engine should be used to store and process that data.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2020 Matt How
About this chapter
Cite this chapter
How, M. (2020). The SQL Engine. In: The Modern Data Warehouse in Azure. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-5823-1_2
Download citation
DOI: https://doi.org/10.1007/978-1-4842-5823-1_2
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-5822-4
Online ISBN: 978-1-4842-5823-1
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)