Pedro Lopes

  • Home
  • Sessions & Content

Pedro Lopes is a Senior Program Manager in the Database Systems Group, based in Redmond, WA, USA. He over 16 years of industry experience. He is currently responsible for Program Management of database engine features for SQL Server, with special focus on the Relational Engine (Query Processor, Query Performance, Programmability).

He also works closely with several Tier 1 SQL Server customers, as well as partners in the field, to understand and gather information about product usage and feedback to drive improvements into the product. Prior to this role, he was a Premier Field Engineer based in Europe for several years.

He has deep understanding and experience in various features of the product spanning several versions of SQL Server, starting with SQL Server 7 and up to and including SQL Server 2016.

He blogs about all things SQL at http://aka.ms/sqlserverteam and http://aka.ms/sqlinsights, authored AdaptiveIndexDefrag, and publishes the BPCheck script for SQL Best Practices and Performance checks.

Sessions

Enhancements that will make your SQL engine roar #1
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.
Enhancements that will make your SQL engine roar #2
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.
0 to Hero: Troubleshooting SQL Server Performance Made Easy
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.
What's New - Query Performance Insights
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.
Modernizing your SQL Server the right way
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.
Pedro_Lopes010728.jpg