Sign in to confirm you’re not a bot
This helps protect our community. Learn more

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

Microsoft Developer
589K subscribers
<__slot-el>
<__slot-el>
1.4K views 2 years ago #VSLive2022
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 langua …...more
...more

Start

0:00

Agenda

0:57

Foundations - Azure SQL family, Azure SQL DB tiers, Azure SQL DB SKUs, programming languages support

3:47

Security - Building a secure application, going passwordless, avoiding SQL injection, getting proactive secuirity monitoring via Microsoft Defender

8:55

Scalability - Building a scalable application, smart SQL programming, scaling-out the database, connection strings best practices

24:36

Query processor, cost-based optimization, DAG and executing plans, Intelligent Query Processing

41:08

Indexes - Columnstore and Rowstore indexes, Clustered and Non-clustered index

54:21

Mult-Model support - JSON, Graph, Geospatial

57:42

Retry Logic - Microsoft.Data.SqlClient, Polly.NET, Tenacity

1:03:20

Is Azure SQL database a good choice if I have 100 Billions rows to manage?

1:05:25

Session Summary

1:07:20

Additional resources and books

1:08:02

Questions and Answers

1:09:05
Visual Studio Live! - Choose Azure SQL Database and Learn What Every Developer Should Know
32Likes
1,450Views
2022Sep 2
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 #VSLive2022

Follow along using the transcript.

Microsoft Developer

589K subscribers