Pedro Lopes

Pedro Lopes

Pedro Lopes is a Senior Program Manager in the Data Platform group, with special focus on the Relational Engine for all in-market versions of SQL Server.

He also connects closely with several high profile SQL Server customers and partners in the field, to understand more about product usage and gather feedback that drives improvements back into the product.

He has extensive background in performance tuning and optimization, and has co-developed several of Microsoft’s WorkshopPLUS courses in these topics.

He blogs about all things SQL at and, home of AdaptiveIndexDefrag, where he also shares T-SQL scripts in the SQL Swiss Army Knife series for everyday troubleshooting and performance analysis.

He regularly delivers technical presentations at conferences and user groups, including SQL Saturday, 24H of PASS, PASS Summit, SQL Bits, local User Groups, and internal Microsoft events such as Safe Passage, C+E Bootcamp or TechReady.

TigerToolbox-SQL Best Practices and Performance checks

Sala A

BPCheck came to be back in 2011, as a way to empower Microsoft support engineers onsite with customers to gain insight on best practices not being followed, and evolved to include performance based checks. But this previously internal BPCheck script was released to Microsoft SQL Server GitHub recently and is now free to use. In […]

300 Admin EN

Enhancements that will make your SQL Server roar-SP1 Ed.


Are you a: Production DBA that wants to know which new xEvents and DMVs/DMFs are available to get further insights into SQL Server operations? Production DBA that needs to troubleshoot a performance issue, and needs to collect performance data for others to analyze? Developer that needs to analyze query performance and already has basic knowledge […]

400 Admin EN