Extended Events Courses and Certifications

SQLBits

An Introduction to Extended Events

Learn to set up and utilize Extended Events for SQL Server performance monitoring and troubleshooting.

• YouTube
• 51 minutes
• On-Demand
• Free Video

PASS Data Community Summit

Extending Your Use of Extended Events

Explore advanced Extended Events techniques for SQL Server troubleshooting. Learn to leverage targets, actions, and predicates for innovative problem-solving beyond traditional Trace capabilities.

• YouTube
• 1 hour 29 minutes
• On-Demand
• Conference Talk

SQL Server Administration Part 2

3500 ratings at Udemy

Learn how to optimize, improve performance, review and analysis statistics, use monitoring tools, and create indexes

• Udemy
• 10 hours 13 minutes
• On-Demand
• Paid Course

SQL Server Performance Tuning Part 2

2642 ratings at Udemy

Advanced techniques for optimizing SQL Server performance, including index tuning, tempdb management, and stored procedure optimization using various diagnostic tools.

• Udemy
• 7 hours 36 minutes
• On-Demand
• Paid Course

Monitor and optimize operational resources in Azure SQL

Configure hardware and server resources for optimum performance after establishing a baseline. Identify sources of performance problems. Troubleshoot using Azure SQL Intelligent Insights.

• Microsoft Learn
• 2 hours 49 minutes
• On-Demand
• Free Online Course

PASS Data Community Summit

Extended Events - Receitas de Sucesso para Troubleshooting

Aprenda técnicas avançadas de troubleshooting usando Extended Events no SQL Server, com receitas práticas para otimizar o desempenho e resolver problemas complexos de banco de dados.

• YouTube
• 59 minutes
• On-Demand
• Conference Talk

PASS Data Community Summit

Improving Columnstore Load Scalability on Large Servers

Optimize columnstore index load times from 260 to 6 minutes using advanced techniques for SQL Server. Learn scalability improvements for large servers and data warehouse workloads.

• YouTube
• 1 hour 13 minutes
• On-Demand
• Conference Talk

PASS Data Community Summit

Performance Tuning Azure SQL Databases

Optimize Azure SQL Database performance using Automatic Tuning, Intelligent Insights, and Extended Events. Learn to leverage these features for time and cost savings while maximizing database efficiency.

• YouTube
• 1 hour 18 minutes
• On-Demand
• Conference Talk

PASS Data Community Summit

Deadlocking for Mere Mortals

Explore common SQL Server deadlocks, their causes, and troubleshooting methods using various tools like Trace Flags, SQL Trace, Event Notifications, and Extended Events.

• YouTube
• 1 hour 29 minutes
• On-Demand
• Conference Talk

PASS Data Community Summit

Cross-Platform SQL Server Management - Taming Infrastructure and Application Usage

Learn to monitor SQL Server instances using extended events, capturing data for CPU utilization, resource usage, and performance analysis. Gain insights into best practices and practical implementation techniques.

• YouTube
• 59 minutes
• On-Demand
• Conference Talk

PASS Data Community Summit

What's New in SQL Server 2016 Analysis Services

Explore new features in SQL Server 2016 Analysis Services, including Extended Events, Tabular Mode enhancements, DAX functions, and Direct Query improvements for more powerful data analysis.

• YouTube
• 1 hour 1 minute
• On-Demand
• Conference Talk

PASS Data Community Summit

Azure SQL Database - Lessons Learned from the Trenches

Discover best practices, tips, and monitoring techniques for optimizing Azure SQL Database performance in production environments, based on real-world Microsoft CSS support cases and customer engagements.

• YouTube
• 1 hour 14 minutes
• On-Demand
• Conference Talk