SQLBits 2020
Azure SQL Hyperscale Deep Dive
We will deep dive into the architecture of Hyperscale and its various components. We will dive into scaling aspects and the new application patterns it enables and also diagnostics that enable bottleneck identification.
The Azure SQL Database Hyperscale tier is SQL architected for the cloud and allows applications that encountered limits of prior tiers to be unshackled. Will deep dive into the architecture of Hyperscale and discuss the components of hyperscale and iteraction between each component and the internals of each component. We will cover scaling aspects and the new application patterns it enables. Last but not the least best practices during migration as well as new diagnostics introduced in Hyperscale that help in performance troubleshooting and bottleneck identification.
Speakers
Denzil Ribeiro's previous sessions
Build & scale applications with Azure SQL Hyperscale
Learn how hyperscale can accommodate applications to scale from the very small applications to large scaled out ones with options from provisioned to serverless. This cloud native multi-modal database can meet all modern application needs in the cloud whether security, resiliency, availability or performance.
Building SaaS solutions on Azure SQL Database
Azure SQL Database is powering some of the largest SaaS solutions on the planet sporting millions of tenants. It does that through a combination of multiple multi-tenancy models that support different requirements and use cases. from few users to millions. In this session, we'll dig deeper into some examples of real-world architectures implemented by 1st party and 3rd party solution providers like Microsoft Dynamics 365 and others, and see how these can be applied to your own scenarios.
AMA with the Microsoft Engineering team hosted by Bob Ward
Come get your questions answered live on stage by members of the Microsoft engineering team. This will be a fun and interactive session hosted by Bob Ward. We will take questions live from the audience plus those who are connected virtually.
Mitigate performance problems using Query Store hints
Query store hints enables changing query plan shapes without modifying application code. We will look at a few poor performance scenarios and use query store hints to improve performance of the application. Become an instant hero having query store hints in your toolkit.
Azure SQL Hyperscale Deep Dive
We will deep dive into the architecture of Hyperscale and its various components. We will dive into scaling aspects and the new application patterns it enables and also diagnostics that enable bottleneck identification.
Optimizing your Azure SQL Database workloads
In this session we will demonstrate a few workload patterns on Azure SQL Database and discuss how to identify and remove bottlenecks in order to scale those applications.