PASS Data Community Summit Courses

Statistics Techniques Can Fix Tough Performance Issues

Explore advanced statistics techniques to optimize query performance, including filtered statistics, computed columns, sample size adjustments, and solutions for stale statistics and correlated columns.

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

How to Put DevOps Into Action for Your Databases

Learn to implement DevOps practices for database deployments, covering source control, automated testing, and continuous integration/delivery through live demonstrations and practical insights.

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

Giving Feedback - How to Effectively Communicate to Your Employees

Learn essential soft skills for effective feedback and communication as a manager. Discover best practices for coaching conversations, handling tough dialogues, and addressing performance issues tactfully.

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

Modernize Your SQL Applications Recently Enhanced Version Azure SQL Managed Instance

Explore Azure SQL Managed Instance's latest enhancements for modernizing SQL applications, including improved migration, security, and manageability features for optimal cloud transformation.

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

Moving Data with Azure Data Factory

Learn to build native ADF pipelines, lift and shift SSIS to Azure, and use design patterns for execution and monitoring in this comprehensive overview of Azure Data Factory's cloud data engineering capabilities.

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

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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• Conference Talk