Visual Studio Live! - Choose Azure SQL Database and Learn What Every Developer Should Know
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 - JSON, Graph, Geospatial
01:03:20 - Retry Logic - Microsoft.Data.SqlClient, Polly.NET, Tenacity
01:05:25 - Is Azure SQL database a good choice if I have 100 Billions rows to manage?
01:07:20 - Session Summary
01:08:02 - Additional resources and books
01:09:05 - Questions and Answers
Смотрите видео Visual Studio Live! - Choose Azure SQL Database and Learn What Every Developer Should Know онлайн без регистрации, длительностью 01 часов 15 минут 26 секунд в хорошем hd качестве. Это видео добавил пользователь Microsoft Developer 02 Сентябрь 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 1 тысяч раз и оно понравилось 3 людям.