PASS Data Community Summit Courses

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

Elevation to the Cloud – How Our Customers Are Using Azure SQL

Explore real-world scenarios of Azure SQL adoption, innovative design patterns, and lessons learned from customers achieving cost efficiency, scalability, and elasticity in their database usage.

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

Azure SQL - Path to an Intelligent Database

Explore groundbreaking query performance enhancements in Azure SQL DB and SQL Server 2019, focusing on Intelligent Query Processing for improved parallel workloads at scale.

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

Next Gen - Intelligent Infrastructure

Explore how Intelligent Infrastructure and AIOps can revolutionize SQL Server database management, simplifying tasks and enabling DBAs to focus on high-value activities with less resources.

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

Understanding Machine Learning Algorithms Through Examples

Explore common machine learning algorithms and practices through industry examples, learn to choose the right algorithm, and discover Azure ML solutions for automating tasks without coding.

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