PASS Data Community Summit Courses

Deadlocks - Understanding and Troubleshooting

Explore complex deadlock scenarios in databases, learn to identify root causes, and discover effective solutions for this challenging aspect of concurrent query management.

• YouTube
• 1 hour
• Self-Paced
• Conference Talk

Inside Waits, Latches, and Spinlocks Returns

Dive deep into SQL Server internals, exploring waits, latches, and spinlocks. Learn monitoring techniques, troubleshoot common wait types, and gain insights into Azure SQL-specific waits through demos and Windows Debugger analysis.

• YouTube
• 1 hour 16 minutes
• Self-Paced
• Conference Talk

SQL Server Containers in Action

Explore SQL Server containers: use cases, recent improvements, and future roadmap. Hands-on demo showcases practical applications and benefits for database management and deployment.

• YouTube
• 1 hour 10 minutes
• Self-Paced
• Conference Talk

Query Store Best Practices

Optimize Query Store implementation with best practices, workload considerations, and performance insights for Azure SQL and SQL Server 2016+. Learn to address challenges and maximize benefits.

• YouTube
• 1 hour 23 minutes
• Self-Paced
• Conference Talk

Azure SQL - What to Use, When, and What's New

Explore Azure SQL deployment options, latest capabilities, and updates. Learn to choose between VM, Managed Instance, and Database for optimal performance and scalability.

• YouTube
• 1 hour
• Self-Paced
• Conference Talk

Migrating Hundreds of SQL Server Instances to Azure at Scale

Learn strategies for migrating large numbers of SQL Server instances to Azure efficiently, including services, components, and automation techniques for minimal downtime and maximum scalability.

• YouTube
• 1 hour 1 minute
• Self-Paced
• Conference Talk

Get Your Optimizer to Give Up All Its Secrets

Uncover SQL Server's query optimization process, from parsing to rule application. Learn to analyze parse trees and memos for more efficient T-SQL writing and improved query performance.

• YouTube
• 1 hour
• Self-Paced
• Conference Talk

Securing Network Access to Your SQL Servers

Learn effective strategies to secure SQL Servers from network attacks, including network segmentation, lateral movement prevention, and Azure IaaS VM options. Gain insights on protecting against ransomware and common vulnerabilities.

• YouTube
• 1 hour 2 minutes
• Self-Paced
• Conference Talk

Getting the Most Out of the SQL Server Maintenance Solution

Explore advanced features of SQL Server Maintenance Solution for efficient database management, including availability groups, smart backups, parallel processing, and Azure integration.

• YouTube
• 48 minutes
• Self-Paced
• Conference Talk

SQL Security Principals 101

Comprehensive introduction to SQL Server permissions, covering basics to advanced topics like stored procedures, views, and application roles, with practical demos for on-premise and Azure-based SQL platforms.

• YouTube
• 1 hour 5 minutes
• Self-Paced
• Conference Talk

Make a Real SQL Cloud Transformation, Not Just a Migration

Explore cloud-native SQL transformation strategies, focusing on DevOps, scalability, and long-term outcomes beyond simple migration for optimal data management in the cloud era.

• YouTube
• 57 minutes
• Self-Paced
• Conference Talk

Modern Storage Technologies for Data Professionals

Explore cutting-edge storage technologies like Persistent Memory and NVMe, and learn how they enhance database performance. Understand storage-based data services and architectures for Big Data Clusters.

• YouTube
• 1 hour 18 minutes
• Self-Paced
• Conference Talk

Animated Query Plans for the Visual Learner

Visualize SQL query execution with animated plans, demystifying concepts like Hash Match and Merge Join. Enhance your understanding of performance tuning through interactive, visual learning.

• YouTube
• 55 minutes
• Self-Paced
• Conference Talk

Data Virtualization - Data Lake Power Using SQL Big Data Cluster

Explore data virtualization with SQL Server 2019 Big Data Cluster, enabling seamless integration of diverse data sources for efficient processing and analysis of structured and unstructured data across cloud and on-premises environments.

• YouTube
• 1 hour 20 minutes
• Self-Paced
• Conference Talk

Securing SQL Server in Containers

Learn strategies for securing SQL Server in containers, including pre-implementation considerations and methods to enhance container security in modern infrastructures.

• YouTube
• 1 hour 3 minutes
• Self-Paced
• Conference Talk