1. SQL Query Performance Tuning2. Memory Performance Analysis3. Disk Performance Analysis4. CPU Performance Analysis5. Creating a Baseline6. Query Performance Metrics7. Analyzing Query Performance8. Index Architecture and Behavior9. Index Analysis10. Database Engine Tuning Advisor11. Query Store12. Key Lookups and Solutions13. Statistics, Data Distribution, and Cardinality14. Index Fragmentation15. Execution Plan Generation16. Execution Plan Cache Behavior17. Parameter Sniffing18. Query Recompilation19. Query Design Analysis20. Reduce Query Resource Use21. Blocking and Blocked Processes22. Causes and Solutions for Deadlocks23. Row-By-Row Processing24. Memory-Optimized OLTP Tables and Procedures25. Automated Tuning in Azure SQL Database and SQL Server26. Database Performance Testing27. Database Workload Optimization28. SQL Server Optimization Checklist
Grant Fritchey, Microsoft Data Platform MVP, has more than 20 years of experience in IT. That time was spent in technical support, development, and database administration. He currently works as Product Evangelist at Red Gate Software. Grant writes articles for publication at SQL Server Central and Simple-Talk. He has published books, including SQL Server Execution Plans and SQL Server 2012 Query Performance Tuning (Apress). He has written chapters for Beginning SQL Server 2012 Administration (Apress), SQL Server Team-based Development, SQL Server MVP Deep Dives Volume 2, Pro SQL Server 2012 Practices (Apress), and Expert Performance Indexing in SQL Server (Apress). Grant currently serves as President on the Board of Directors of the PASS organization, the leading source of educational content and training on the Microsoft Data Platform.