PASS Data Community Summit Courses

One Bite at a Time

Efficient techniques for anonymizing PII data, archiving old data, and performing garbage collection in databases. Learn to create procedures for updating large datasets while maintaining performance and avoiding blocking operators.

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

Designing Azure Data Science and AI Projects

Aprenda a diseñar proyectos de ciencia de datos e IA en Azure, desde la comprensión del negocio hasta la implementación, utilizando un enfoque práctico basado en equipo y las últimas tecnologías disponibles.

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

Advanced Plan Explorer Usage for Tuning Execution Plans

Explore advanced techniques for optimizing SQL execution plans using Plan Explorer, focusing on practical T-SQL anti-patterns and in-depth analysis capabilities.

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

Inside Azure SQL Database Hyperscale

Explore Azure SQL Database Hyperscale's innovative architecture, including distributed components, multi-tiered caching, and read-scale replicas. Learn about built-in scalability, high availability, and unique diagnostics for performance insights.

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

Modern High Availability and Disaster Recovery Topologies

Explore innovative HA/DR solutions for SQL Server, including traditional and advanced technologies like availability groups, log shipping, VM replication, and container-based approaches for enhanced data protection.

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

Azure Synapse Analytics - A Data Lakehouse

Explore Azure Synapse Analytics, a unified service combining data warehousing and Big Data analytics. Learn about its features, scalability, and integration in modern data warehouses through demonstrations.

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

Learn Faster in a Container - A Docker Introduction

Discover Docker's power for DevOps, from basics to advanced uses. Learn to set up, modify images, and deploy databases. Accelerate your tech learning with practical examples and hands-on demos.

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

Building a Home Computer Lab

Explore options for creating an affordable home computer lab to learn data technologies, from laptops to servers. Covers key considerations, tips, and virtualization for an effective setup.

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

Aggregation and Composite Model - Power BI Fast and Furious

Optimize Power BI performance with Aggregations and Composite Models. Learn techniques for analyzing terabytes of data in seconds, with live demos and practical tips for handling huge datasets efficiently.

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

Designing Reports for Effective Storytelling

Learn effective digital storytelling techniques for creating impactful reports, focusing on color, contrast, layout, and design principles to convey information clearly and professionally.

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

The Curated Data Platform

Explore diverse data platform options, analysis tools, and processing technologies. Learn when to use Spark, R, Airflow, Power BI, and other solutions to optimize your data environment.

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

Building Your First Hybrid Lab

Extend your local SQL Server lab to Azure with a step-by-step guide on implementing a hybrid cloud Availability Group, network connectivity, and highly available Active Directory.

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

Deploying Availability Groups in Virtualized Architectures

Best practices for deploying SQL Server Always On Availability Groups in virtualized environments, covering on-premises, cloud, and hybrid architectures across VMware, Hyper-V, Azure, AWS, and GCP.

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

PowerApps & Power Automate - DB Best Practices

Explore best practices for efficient and secure data access in PowerApps and Power Automate. Learn design techniques and scenarios for sending and receiving data, enhancing rapid solution development.

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

Inside the VertiPaq Engine

Explore VertiPaq engine internals, database architecture, and optimization techniques for improved performance and compression in SQL Server Analysis Services Tabular, Power BI, and Power Pivot.

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