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).
Pedro Lopes has submitted 6 sessions for SQLBits 2020, although the agenda hasn't been chosen yet. See all
submitted sessions.
Pending Sessions
SQL Server 2019 introduces ground-breaking query performance enhancements under the Intelligent Query Processing family.
In order to get the most out of the latest hardware innovations, you need the latest software innovations as well. SQL Server 2019 introduces a suite of new and improved memory optimized technologies.
Azure SQL Database Edge offers the same SQL database engine which is optimized to run at the edge with a small resource footprint and with built-in capabilities like streaming support.
As businesses and applications reach global scale, you know that SQL Server and Azure SQL can support international applications. But there's much more than meets the eye.
What is a query plan is and what information does it hold? Dagnose and understand how the code you write is actually executed by the Database Engine.
Seasoned or new DBAs, you may be unsure of the latest and greatest recommendations for configuring and maintaining a high-performance tier-1 database system. This session is for you!