PASS Data Community Summit Courses

Demystifying Query Store Plan Forcing

Explore Query Store's plan forcing feature through real-world examples, understanding its benefits, potential issues, and best practices for implementation in production environments.

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

Intro to Azure Data Catalog

Learn how Azure Data Catalog can help your organization efficiently discover, understand, and utilize vast amounts of data across various sources, improving data accessibility and decision-making.

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

Neutralize Troublesome SQL Server Indexes - Fun Stories & Demos

Explore SQL Server index optimization with real-world scenarios and demos. Learn to identify and resolve performance issues caused by problematic indexes for improved query efficiency.

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

Navigating Row Level Security

Explore fine-tuned data access with Row Level Security in SQL Server, covering implementation patterns, scaling solutions, and practical tips for sensitive information management.

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

Practical Guidance to Make Your Tier-1 SQL Server Roar

Optimize high-performance tier-1 SQL Server systems with expert guidance on configuration, tuning, and maintenance for modern hardware, covering platform, server, and infrastructure considerations.

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

Move Your Entire BI Platform to Azure and Power BI

Comprehensive guide to migrating BI platforms to Azure and Power BI, covering architecture, implementation, governance, and support. Includes real-world examples and demos for enterprise-level deployment.

• YouTube
• 2 hours 2 minutes
• Self-Paced
• Conference Talk

The Fundamentals of DAX Contexts

Explore DAX contexts and their resolution through practical demonstrations, enhancing your ability to create advanced measures and ensure accurate data analysis in Power BI.

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

Identifying, Understanding, and Combating Gender Bias & Inequality

Explore unconscious gender biases, their origins, and impacts. Learn strategies to identify and combat these biases in professional and personal settings, fostering positive solutions for equality.

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

Improving Analytics Performance With Columnstore Indexes

Explore columnstore indexes for efficient OLAP data storage and analytics in SQL Server. Learn architecture, optimization techniques, and best practices to enhance query performance on large datasets.

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

SQL Security for Everybody - Understanding Logins, Users, and Roles

Comprehensive guide to SQL Server security, covering instance-level controls, server and database principals, roles, and object-level permissions. Practical demos for developers and DBAs.

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

Think Like a Terminator - Internals of Classic SQL Server Indexes

Explore SQL Server index internals, including clustered and non-clustered types, space allocation, and optimization techniques. Learn to improve database performance through hands-on demonstrations and practical insights.

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

Code Like a Snake Charmer Version 2.0 - Introduction to Python

Comprehensive introduction to Python for data science, covering basics and machine learning using real-world datasets. Ideal for beginners looking to integrate Python into Microsoft tools.

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

Intelligent Query Processing

Explore SQL Server optimizer advancements that improve performance without code changes, including techniques for table variables, user-defined functions, and common anti-patterns in T-SQL development.

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

Understanding Numeric Calculations in DAX

Explore DAX's numeric calculations, learning to differentiate between filter and row contexts, and when to use calculated columns versus measures for optimal data analysis and visualization.

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

Troubleshooting Power BI Report Performance

Optimize Power BI report performance by identifying bottlenecks, addressing DAX measures, modeling issues, and visual overload. Learn techniques to enhance report responsiveness and user experience.

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