Главная
Study mode:
on
1
- Start
2
- Agenda
3
- Foundations - Azure SQL family, Azure SQL DB tiers, Azure SQL DB SKUs, programming languages support
4
- Security - Building a secure application, going passwordless, avoiding SQL injection, getting proactive secuirity monitoring via Microsoft Defender
5
- Scalability - Building a scalable application, smart SQL programming, scaling-out the database, connection strings best practices
6
- Query processor, cost-based optimization, DAG and executing plans, Intelligent Query Processing
7
- Indexes - Columnstore and Rowstore indexes, Clustered and Non-clustered index
8
- Mult-Model support - JSON, Graph, Geospatial
9
- Retry Logic - Microsoft.Data.SqlClient, Polly.NET, Tenacity
10
- Is Azure SQL database a good choice if I have 100 Billions rows to manage?
11
- Session Summary
12
- Additional resources and books
13
- Questions and Answers
Description:
Dive into a comprehensive conference talk from Visual Studio Live! that equips developers with essential knowledge for leveraging Azure SQL Database. Explore the foundations of Azure SQL, including family types, tiers, and SKUs, along with programming language support. Learn best practices for building secure applications, implementing passwordless connectivity, and preventing SQL injection attacks. Discover scalability techniques, smart SQL programming, and connection string optimization. Gain insights into query processing, cost-based optimization, and Intelligent Query Processing. Understand the differences between columnstore and rowstore indexes, as well as clustered and non-clustered indexes. Explore multi-model support for JSON, Graph, and Geospatial data. Master retry logic implementation using various tools and libraries. Address concerns about managing large-scale databases with billions of rows. Benefit from additional resources, book recommendations, and a Q&A session to enhance your Azure SQL Database expertise. Read more

Choose Azure SQL Database and Learn What Every Developer Should Know

Microsoft
Add to list
0:00 / 0:00