Visual Studio Live! - Choose Azure SQL Database and Learn What Every Developer Should Know

From the creator

Speakers: Bob Ward & Davide Mauri You’ve been tasked to build a backend API and store everything in a database. Should you choose Azure SQL Database? In this session we will provide you the information you need to make the right choices for Azure SQL Database. Come learn the best coding techniques to secure, scale, and ensure your application is highly available based on the best practices from Microsoft. We will show you things like passwordless connectivity, scaling access to data, avoiding security attacks, and built-in retry logic. We will also show and demonstrate how to easily choose indexes and take advantage of the power of SQL to process all your data like JSON. You won’t want to miss this session as the Microsoft team will always bring you the latest innovations from the cloud for Azure SQL Database. 00:00:00 - Start 00:00:57 - Agenda 00:03:47 - Foundations - Azure SQL family, Azure SQL DB tiers, Azure SQL DB SKUs, programming languages support 00:08:55 - Security - Building a secure application, going passwordless, avoiding SQL injection, getting proactive secuirity monitoring via Microsoft Defender 00:24:36 - Scalability - Building a scalable application, smart SQL programming, scaling-out the database, connection strings best practices 00:41:08 - Query processor, cost-based optimization, DAG and executing plans, Intelligent Query Processing 00:54:21 - Indexes - Columnstore and Rowstore indexes, Clustered and Non-clustered index 00:57:42 - Mult-Model support - J

Published 2022-09-02 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.