Skip to content

One day training @ Microsoft Azure Cloud Workshop

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

Let’s work together

Ready to operate at
the next level?

Tell us about your challenge. We’ll bring the depth, the expertise, and the Swiss precision.

Stéphane Haby

Stéphane Haby

Stéphane Haby has more than 20 years of experience in Microsoft solutions, specializing in the installation, migration, best practices, and performance analysis of Microsoft SQL Server, as well as Microsoft Business Intelligence solutions (SharePoint, Office) and .NET development for the banking sector. A former Microsoft Most Valuable Professional (MVP) and early adopter of Microsoft Team System in France, he has authored several technical articles. He holds Microsoft Certified Solutions Associate (MCSA) and Expert (MCSE) for SQL Server, MCTS, MCITP for SQL Server 2008, and ITIL V3 Foundation certifications. His industry experience covers chemicals and pharma, banking, and financial services.View Author posts

182 posts since April 2011

Leave a Comment

Your email address will not be published. Required fields are marked *