PASS Data Community Summit Courses

A Deep Dive into Execution Plans & How to Use Them

Explore SQL Server Query Optimizer's execution plans, learn to read and fine-tune them for better performance, and master troubleshooting techniques to enhance database efficiency.

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

Do You Feel the Need the Need for Speed in SQL Server Database?

Discover efficient SQL Server query tuning techniques using Quest Foglight and SQL Optimizer. Learn to identify bottlenecks, analyze execution plans, and optimize database performance systematically.

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

Notebooks, PowerShell, and Excel Automation

Automate Excel tasks using PowerShell and Jupyter Notebooks. Learn to create self-service solutions for users to generate custom Excel workbooks efficiently and effectively.

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

SQL Professional to Cosmic Superstar in 75 Minutes

Transition SQL Server skills to CosmosDB: Learn NoSQL concepts, JSON, multi-models, and key differences in monitoring and data structure. Prepare for a new approach to database management and optimization.

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

Real-World Challenges to Implementing Database DevOps

Explore practical strategies for implementing database DevOps, addressing challenges in data management, and optimizing deployment processes for both on-premises and cloud-based environments.

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

Understanding Accelerated Database Recovery

Explore SQL Server 2019's Accelerated Database Recovery feature, its mechanics, benefits, and implementation in on-premises and Azure environments for rapid recovery and instant transaction rollback.

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

The Art of Data Classification and Protection

Learn to classify, report, and audit data using SQL Server tools to enhance data protection, comply with regulations, and prevent breaches. Gain practical skills for effective data management and security.

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

Unlocking The Data Lake With Azure Synapse SQL Serverless

Explore and transform massive data in Azure data lakes using SQL Serverless for Synapse. Learn to leverage T-SQL for analytics, BI, and ML at petabyte scale.

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

Scaling a DWH Beyond the Petabyte

Learn strategies for planning, architecting, and scaling data warehouse infrastructure from terabytes to petabytes using real-world examples for on-premises and cloud solutions.

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

Unlock Business Value From Your SQL Server Backups as You Head to the Cloud

Discover how to seamlessly migrate SQL Server to the cloud while ensuring robust data protection. Learn about platform-independent backup solutions that enable data mobility and instant retrieval, unlocking business value from your backups.

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

Design Your Data Vault and Load It With Azure Data Factory

Explore Data Vault methodology for data warehouse design and learn how to populate it using Azure Data Factory's Mapping Data Flows, with insights on ETL patterns and practical implementation.

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

Advanced Development Pipelines

Explore multi-threaded builds, database dependencies, container-based agents, and environment automation for advanced development pipelines in this comprehensive session.

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

App Modernization and Migration from End to End

Comprehensive guide to app modernization and data migration using Microsoft tools, focusing on SSIS to ADF and SQL Server to Azure SQL MI transitions with practical demonstrations.

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

Deploying and Managing SQL Server with dbatools

Automate SQL Server deployment and management using dbatools PowerShell module. Learn installation, configuration, and operations techniques for efficient multi-system administration.

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

Pay Less, Get More - A Guide to SQL Server Licensing

Optimize SQL Server licensing costs with expert guidance on editions, models, and scenarios for virtual environments, high availability, and non-production setups.

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