Pedro Lopes is a Principal Program Manager in the Azure Data SQL Server team, based in Redmond, WA, USA.

He over 19 years of industry experience and has been with Microsoft for almost 10 years, where he is currently responsible for Program Management of database engine features for SQL Server and Azure SQL, with special focus on the Relational Engine (Query Processor, Programmability, Performance).

He is a regular speaker at conferences and user groups events (such as TechReady, Ignite, Build, PASS Summit, SQLIntersection, SQLBits, 24H of PASS), blogs about all things SQL at http://aka.ms/sqlserverteam, authored the book “Learn T-SQL Querying” (https://aka.ms/LearnTSQLQuerying), and  several tools in the TigerToolbox on GitHub: AdaptiveIndexDefrag (http://aka.ms/AID), the BPCheck script for SQL Best Practices and Performance checks (http://aka.ms/BPCheck), or usp_WhatsUp to get an instant view of performance affecting issues in your workload (https://aka.ms/uspwhatsup).

Sessions

Do you have an application running with an in-market version of SQL Server, such as 2012 or 2014? Then this session is for you! We will see more in-depth what enhancements are in the latest SPs and 2016, and why you should install them.
Do you have an application running with an in-market version of SQL Server, such as 2012 or 2014? Then this session is for you! We will see more in-depth what enhancements are in the latest SPs and 2016, and why you should install them.
Take charge of any performance issue coming your way. "SQL Server is hurting!" Turn feelings to symptoms, and become the hero that saved the day.
This session will showcase several improvements in SQL Server, focusing on the latest and upcoming query performance diagnostics and query processing enhancements that address some of the most common customer pain points. Ranging from new xEvents and Showplan improvements, to Intelligent Query Processing innovations, learn how you can leverage these features and streamline the process of troubleshooting query performance with faster insights.
Upgrades should be approached with the same rigor and processes as a full software or hardware project – a solid methodology is required for success. Microsoft provides you with all the tools you need to achieve a seamless, reliable upgrade experience. In this session we demonstrate some of the free tools that Microsoft provides in order to ensure your SQL Server upgrade is a success.
Come join us in the intelligent database world that started with SQL Server 2017 and takes a leap forward with the upcoming SQL Server 2019 and Azure SQL DB.
This session is designed to guide you through what a query plan is and what information it holds to help you diagnose and understand how the code you write is actually executed by the Database Engine.
Pedro_Lopes010728.jpg