Today, with my colleague Christophe, we follow the Microsoft Azure Training Day: Data and Analytics @ Microsoft Zürich (Wallisellen to be exact).
After a presentation of SQL Server 2019, we begin with the First Lab about SQL Server 2019 and new features and we going through intelligent query processing, Data Discovery and Classification for personally identifiable information (PII) and General Data Protection Regulation (GDPR) and secure enclave.
The Second Lab is about Big Data with SQL Server 2019 Big Data Clusters
In this second lab, we work with Azure Data Studio and make some external table with csv file and an external Azure SQL Database.
I was curious to see the execution plan and the cost of these remote queries
Little pause with the lunch and go back to work with our labs!
We begin the afternoon with the database as a Service (DBaaS – PaaS) on Azure: Azure SQL Database (Single, Elastic Pool and Managed Instance) and Cosmos DB the globallly distributed, massively scalable, multi-model database Service.
After a little break, the last Lab is about the Modern Data Warehouse and all Azure “BI services” like Azure Data Factory, Azure Databricks, Azure SQL DW and Power BI. The goal of this lab is to learn how these tools can be use together
I discover also a new service in the “Azure Data World”: Azure Synapse
It is Azure SQL Data Warehouse evolved. You can find more information here
I will really thanks Microsoft and their Staff for the organization and this useful and interesting workshop day!
A learn a lot and can share with all my customers this experience now