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.
Choose Azure SQL Database and Learn What Every Developer Should Know
Overview
Syllabus
- Start.
- Agenda.
- Foundations - Azure SQL family, Azure SQL DB tiers, Azure SQL DB SKUs, programming languages support.
- Security - Building a secure application, going passwordless, avoiding SQL injection, getting proactive secuirity monitoring via Microsoft Defender.
- Scalability - Building a scalable application, smart SQL programming, scaling-out the database, connection strings best practices.
- Query processor, cost-based optimization, DAG and executing plans, Intelligent Query Processing.
- Indexes - Columnstore and Rowstore indexes, Clustered and Non-clustered index.
- Mult-Model support - JSON, Graph, Geospatial.
- Retry Logic - Microsoft.Data.SqlClient, Polly.NET, Tenacity.
- Is Azure SQL database a good choice if I have 100 Billions rows to manage?.
- Session Summary.
- Additional resources and books.
- Questions and Answers.
Taught by
Microsoft Developer
