Cloud Data Design, Orchestration, and Management Using Microsoft Azure (eBook)

Francesco Diaz joined Insight in 2015 and is responsible for the cloud solutions & services area for a few countries in the EMEA region. In his previous work experience, Francesco worked at Microsoft for several years, in Services, Partner, and Cloud & Enterprise divisions. He is passionate about data and cloud, and he speaks about these topics at events and conferences.Roberto Freato works as a freelance consultant for tech companies, helping to kick off IT projects, defining architectures, and prototyping software artifacts. He has been awarded the Microsoft MVP award for seven years in a row and has written books about Microsoft Azure. He loves to participate in local communities and speaks at conferences during the year.

1 Overview of data architecture on Microsoft Azure Introduction Technologies: everyone touched in the book plus some other edge technologies just mentioned. We explain the scenarios of the book.This chapter will be written during the whole process, updating it with the relevant content of the scenarios developed in the chapters.2 Working with Relational DBs on Azure Relational DBs scenarios Technologies: VMs, Backup, Storage, SQL Server DR and GEO-DR, (Oracle, MySQL)We would like to cover the best practices to deploy standard RDBMSs while using Azure VMs and networking.3 Working with Azure SQL Database Azure DB scenarios Technologies: Azure SQL DB, Stretch DB , Database Pools, Sharding data, Migration from other RDBMSs to Azure SQL DBThis chapter is about the SQL Database PaaS, with some tricks for advanced usage. We cover the services and the connected services, how to scale with relational DBs and how to write multi-tenant applications.4 Working with NoSQL alternatives NoSQL scenarios Technologies: Storage, DocumentDB, Redis, Azure SearchThis chapter enforces the polyglot persistence idea, where different technologies and data sources address different needs. The NoSQL alternatives can fill the gap of modern applications in terms of performance and feature set.5 Orchestrate data with Azure Data Factory Integration scenarios Technologies: Azure Data FactoryIn this chapter we talk about integration of different data sources and advanced pipelines of data transformation. We explore some scenarios to lower the complexity of the Data Factory service and we see how to setup existing solutions to fit it.6 Advanced analysis with Azure Data Lake Analysis scenarios Technologies: Data Lake Store/Analytics, U-SQLThis is the first chapter about ingestion of big data. This is focused on ingestion of native data, to be prepared, enriched and evaluated/analyzed in a second step.7 Real-time Ingestion, Processing and Prediction Real-time scenarios Technologies: Machine Learning, Stream Analytics, Event HubThis is instead focused in ingestion of well-known and structured data with the aim to process it in real-time. In addition a step of prediction is added to react (in real time too) to certain events.8 Working with Big Data with Azure Batch and Map/Reduce Big data scenarios Technologies: HDInsight, Hadoop, Spark, R Server, Storm, Azure BatchThis is the last chapter about Big Data, exploring the industry standard to perform data operations, while executing those engines on Azure.9 APPENDIX (tbd yet, adding some of the topics below to one of the other chapter still has to be defined) Other Technologies: Azure Analysis Services (chapter 3?), Power BI (chapter 6?), Azure SQL DataWarehouse (chapter 6?), Azure Data Catalog (chapter 5?)Those technologies should fit the existing chapters, but we do not know where they best fit at the time being.