PASS Data Community Summit Courses

Building Data Lakes in Azure

Learn to build and leverage data lakes in Azure using Databricks and Synapse Analytics. Explore key services, implementation strategies, and querying techniques for modern data environments.

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

Charticulator - Create Custom Visual with No Code in Power BI

Learn to create custom Power BI visuals using Charticulator without coding. Explore the tool's environment, chart creation process, and importing custom visuals into Power BI desktop.

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

The Good, Bad, and Ugly of Migrating SQL Server to Public Clouds

Explore the challenges and best practices for migrating SQL Server to public clouds like Azure, AWS, and GCP. Learn from real-world experiences to ensure a successful transition from on-premises to cloud environments.

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

What's New in the SQL Server Tools?

Explore upcoming SQL Server tools and user experiences, featuring demos on Jupyter notebooks and SQL database projects, presented by the SQL Server product team.

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

Deployment, High Availability & Performance Guidance for SQL Server Linux Azure IaaS Ecosystem

Explore deploying SQL Server on Linux in Azure, covering high availability, AD authentication, and performance optimization for production environments.

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

Azure SQL Is the Best Choice for Building Back-End REST API - Discuss

Explore Azure SQL's capabilities for building high-performance, scalable REST APIs with JSON support, CI/CD integration, and robust security features for modern agile development.

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

Microsoft Power BI - Business Intelligence Strategy, Vision, and Roadmap Update

Explore Microsoft Power BI's latest features and future roadmap for driving data-driven decision-making across organizations, presented by BI leadership at PASS Data Community Summit.

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

Migrating Oracle Workloads to Azure

Learn strategies for migrating Oracle databases to Azure, including architecture design, deployment automation, and success factors for moving to IaaS while leveraging both Oracle and Azure products.

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

Polybase - It's What's for Dinner!

Explore Polybase, Microsoft's linked server replacement, for connecting to diverse data sources. Learn setup best practices, scale-out groups, AlwaysOn integration, and performance optimization techniques.

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

The Cases of The Unexplained Memory Problems

Explore advanced SQL Server memory usage troubleshooting through real-world cases, addressing complex issues and providing solutions for optimizing database performance.

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

Inclusive Presentation Design

Learn techniques for creating accessible presentations that maximize learning for audiences with diverse abilities, enhancing content delivery and impact for all viewers.

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

Microsoft SQL Server Machine Learning Workloads on Red Hat Enterprise Linux and Red Hat OpenShift

Accelerate machine learning pipelines using SQL Server on Red Hat Enterprise Linux and OpenShift. Learn in-database ML techniques and containerization for efficient model production and deployment.

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

From Docker to Big Data Cluster - A New Era for SQL Server

Explore SQL Server's evolution from Docker support to Big Data Clusters, covering containerization, Kubernetes deployment, and integration with Python for modernized database management and analytics.

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

Developer Best Practices in SQL Server

Learn optimized T-SQL coding techniques for SQL Server, including Sarg-ability, performance improvement, SQL injection prevention, parameterization, and dynamic SQL best practices through real-world examples.

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

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
• Self-Paced
• Conference Talk