PASS Data Community Summit Courses

The Power Platform Game Changer

Comprehensive guide to building and deploying business apps using Microsoft Power Platform, covering PowerApps, Flow, SQL Server, Power BI, and Cortana with focus on security and enterprise governance.

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

SQL Server 2019 - Your Next Modern Data Platform

Comprehensive overview of SQL Server 2019's features, including improved performance, data integration capabilities, and advanced security, highlighting its evolution as a modern data platform.

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

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