In this session you will learn the best practices, tips and tricks on how to successfully use Azure SQL Database and SQL Managed Instance on production environments and how the DBA job changed versus administrating SQL Server. You will learn how to monitor and improve Azure SQL Database query performance. It will cover how to use Query Store, Extended Events, DMVs and Azure Monitor SQL Insights to help monitoring and improving query response times when running their databases in the Microsoft Azure cloud. These learnings are fruit of Microsoft CSS support cases, and customer field engagements. This session includes several demos.
José Manuel Jurado currently works as SQL Escalation Engineer and Subject Matter Expert in Azure SQL Database at Microsoft Spain. With over 15+ years of experience in SQL Server environments (administration and database development), he is a speaker for internal events at Microsoft and for public events as SQL Saturday, SQL Nexus, TechReady, DotNetConference and Azure BootCamp. In the past, he worked as Project Manager for large Global Retail Company for more than 10 years developing projects using different Microsoft Technologies.
My name is Alex and i'm a Support Escalation Engineer on Azure SQL DB team working from Microsoft for more than 2 years. Previously, i've worked as DBA and database developer for more than 8 years, most of them in the banking area.
We seek to provide a respectful, friendly, professional experience for everyone, regardless of gender, sexual orientation, physical appearance, disability, age, race or religion. We do not tolerate any behavior that is harassing or degrading to any individual, in any form. The Code of Conduct will be enforced.
All live stream organizers using the Global Azure brand and Global Azure speakers are responsible for knowing and abiding by these standards. Each speaker who wishes to submit through our Call for Presentations needs to read and accept the Code of Conduct. We encourage every organizer and attendee to assist in creating a welcoming and safe environment. Live stream organizers are required to inform and enforce the Code of Conduct if they accept community content to their stream.
If you are being harassed, notice that someone else is being harassed, or have any other concerns, report it. Please report any concerns, suspicious or disruptive activity or behavior directly to any of the live stream organizers, or directly to the Global Azure admins at email@example.com. All reports to the Global admin team will remain confidential.
We expect local organizers to set up and enforce a Code of Conduct for all Global Azure live stream.
A good template can be found at https://confcodeofconduct.com/, including internationalized versions at https://github.com/confcodeofconduct/confcodeofconduct.com. An excellent version of a Code of Conduct, not a template, is built by the DDD Europe conference at https://dddeurope.com/2020/coc/.