PASS Data Community Summit Courses

Providing High Availability to SQL Server on Linux

Explore configuring Linux Pacemaker for SQL Server high availability, comparing it to Windows Server Failover Cluster and learning proper architecture for robust database systems on Linux.

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

Consuming API Data Using Built in SSIS Components

Learn to consume API data using SSIS components, focusing on building requests, parsing JSON, and outputting data in a standard pipeline without additional tools. Practical example using NOAA Weather API.

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

Leading Virtual Teams with Trust

Discover strategies to enhance virtual team leadership through trust-building techniques, improving remote work effectiveness and productivity in the post-pandemic era.

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

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