PASS Data Community Summit Courses

SQL Server Machine Learning Services in Production

Discover best practices for deploying and maintaining SQL Server Machine Learning Services, including R package management, code deployment, and troubleshooting techniques for seamless integration.

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

How to Build an Impactful KPI Scorecard in Power BI

Learn to create professional KPI scorecards in Power BI using DAX, custom visuals, and design best practices. Master matrix tables, conditional formatting, and sparklines for impactful data visualization.

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

Deep Dive into Blocking and Deadlocks Troubleshooting

Comprehensive exploration of SQL Server Concurrency Model, focusing on blocking issues and deadlocks. Learn to troubleshoot using standard tools and a specialized Blocking Monitoring Framework.

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

Introducing Azure Synapse Analytics - The End-to-End Analytics Platform

Explore Azure Synapse Analytics, a comprehensive platform integrating relational and big data systems for efficient data ingestion, preparation, modeling, and serving in a unified workspace.

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

ETL in Azure Made Easy with Data Factory Mapping Data Flows

Explore Azure Data Factory's Mapping Data Flows for efficient, scalable ETL without coding. Learn to transform data using Databricks integration and graphical tools.

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

Linux Fundamentals for SQL Server DBAs

Explore SQL Server on Linux: installation, configuration, and management. Learn essential Linux commands and file systems for DBAs transitioning to this open platform.

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

Power Query, M and Dataflow - The Lightsaber for the Data Jedi

Discover Power Query's transformation capabilities, M language benefits, and Dataflows' role in Power BI. Learn advanced features through demos to enhance your data preparation skills.

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

HA - DR - Too Many Choices

Explore various high availability and disaster recovery options for SQL Server, weighing pros and cons to find the best fit for your company's needs and requirements.

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

Scaling Clustered Column Store Indexes

Learn to effectively plan, configure, and operate Clustered Columstore indexes for handling trillions of rows, using real-world examples and best practices for partitioning, data type selection, and data insertion.

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

Using PowerShell on Linux

Learn to install and use PowerShell on Linux, interact with Azure and SQL Server, and discover its potential for Linux administrators. Explore use cases and resources for further learning.

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

Reporting for Developers

Explore Power BI and SQL Server Reporting Services for developers. Compare features, development environments, and integration capabilities to choose the best platform for your reporting needs.

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

Azure DevOps Pipelines for BI

Learn to implement DevOps practices for SQL databases, Analysis cubes, and SSIS packages using Azure DevOps Pipelines. Discover techniques for code tracking, compile-time checking, and efficient deployments.

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

Azure Data Studio Extension Development

Learn to develop extensions for Azure Data Studio using Typescript, exploring APIs, GitHub hosting, and marketplace sharing. Gain practical skills through a live demonstration of building a functional extension.

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

Handling Role Playing Dimensions in Tabular Models

Explore various methods for implementing role-playing dimensions in tabular models, including DAX expressions, with a focus on model maintainability and user experience in data analysis.

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

An Introduction to Data Visualizations and Design Best Practices

Learn effective data visualization techniques, including chart selection, color theory, and design principles to enhance your data storytelling skills and create impactful Power BI reports.

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