Infrastructure at your Service

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.

One of my favorites part of the lab was to play/configure a secure enclave because inever do it. 😎
A little tips: Don’t forget to enable parameterization for Always Encrypted in the Query Options

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.

Now, go to do the Third Lab with Cosmos DB

After somes errors due to my modifications on the alias name of my ressources, it’s finally working good

Little tips: You can choose now Switzerland North as Region

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

At the end,  I build my KPI under Power BI very easily…

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

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Stéphane Haby
Stéphane Haby

Delivery Manager and Senior Consultant