Pedro Lopes
Pedro Lopes is a Principal Architect in the Azure Data team and has been working with SQL Server for over 20 years. He is currently the tech lead for all database engine features that ship in SQL Server 2022 and Azure SQL, while keeping a special focus on the Query Processor.
He 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 (http://aka.ms/TigerToolbox) and SQL-Server-Samples GitHub (http://aka.ms/SQLServerSamples). Including AdaptiveIndexDefrag (http://aka.ms/AID) for index and stats maintenance and the BPCheck script for SQL Best Practices and Performance checks (http://aka.ms/BPCheck).
Pedro Lopes's Training Days
The SQL Server 2019 WorkshopSQLBits 2020
Spend a day with the Microsoft engineering team learning all aspects of SQL Server 2019 using a hands-on, interactive approach.
New SQL Server Upgrade and Migration: Project ChinookSQLBits 2016
Join the SQL Server product group for an all-day session to learn about the completely revamped and new upgrade and migration experience for SQL Server, codenamed Project “Chinook”.
Pedro Lopes's Sessions
Azure SQL and SQL Server 2022: Intelligent Database FuturesSQLBits 2022
Azure SQL DB and SQL Server introduced ground-breaking query performance enhancements under the Intelligent Query Processing family in the past few years. These make up the latest on Microsoft’s mission to make critical parallel workloads improve when running at scale, while remaining adaptive to the constantly changing world of data! Now join us to find about what's coming next in this new intelligent database world with SQL Serevr 2022 and Azure SQL!
AMA with the Microsoft Engineering team hosted by Bob WardSQLBits 2022
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.
Azure SQL and SQL Server: Path to an Intelligent DatabaseSQLBits 2020
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.
Query plans: a map to query performance analysisSQLBits 2020
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.
Storing strings in SQL Server and Azure SQL DBSQLBits 2020
in this session you will learn about what Unicode encoding you want to use for your scenario, what are the performance differences, and even debunk a few SQL Server myths along the way.
What's New - Query Performance InsightsSQLBits 2019
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 waySQLBits 2019
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.
0 to Hero: Troubleshooting SQL Server Performance Made EasySQLBits 2018
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.
Enhancements that will make your SQL engine roar #1SQLBits 2016
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 #2SQLBits 2016
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.
AMA with the Microsoft Engineering team hosted by Bob WardSQLBits 2022
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.
Azure SQL and SQL Server: Path to an Intelligent DatabaseSQLBits 2020
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.
Query plans: a map to query performance analysisSQLBits 2020
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.
Storing strings in SQL Server and Azure SQL DBSQLBits 2020
in this session you will learn about what Unicode encoding you want to use for your scenario, what are the performance differences, and even debunk a few SQL Server myths along the way.
Modernizing your SQL Server the right waySQLBits 2019
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.
0 to Hero: Troubleshooting SQL Server Performance Made EasySQLBits 2018
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.