Steve Verschaeve

This workshop is designed to get hands on experience with a Modern Data Solution. During this day, the participants will be wrangling data inside the Azure Data Platform, going from ingestion to consumption.

In this session we will look into the design and implementation of an intelligtent solution to track polar bear activity based on pictures taken on an island (simulated). Products used in this design are Azure Storage account, IoT hub, Node.js, Azure Stream Analytics, Azure Function, Cognitive Services, Power BI and Azure SQL database. We will discuss the role of each product during this demo heavy session.

When Microsoft Azure SQL Database was introduced, it had only a small subset of the features available in the SQL Server database engine. With the introduction of version V12 a few years ago, Azure SQL Database is now an enterprise-class platform-as-a-service (PaaS) offering. Of course, Microsoft continued to add new features and functionalities into Azure SQL Database. Join our pre-con to learn more about some cool new features that are available now in Azure SQL Database. The main topics we will discuss are: Administration o Hyperscale o Elastic Database Jobs o Backup Retention Periods Business Continuity o Geo-replication & Failover Groups o Virtual Network service endpoints o How to connect to Azure SQL Database and Managed Instance Security o TDE with Bring Your Own Key o Data Discovery and Classification o SQL Vulnerability Assessment Monitoring and performance tuning o Automatic Tuning o Intelligent Insights Managed Instance Migration o Data Migration Service o Azure Data Sync Important! We are not going to start from scratch, so prior knowledge on Azure SQL Database is required. Bring your laptop and your Azure subscription because we’re planning some exercises.