Conference Talks

Flutter Europe

Forms with Flutter

Build Flutter forms with validation, focus behavior, and custom widgets, including multi-step flows.

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

GOTO Conferences

When Customers Don't Share A Language

A domain-driven design case study follows how a claims platform’s model changed as successive customers brought different rules and terminology.

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

PASS Data Community Summit

Aggregation and Composite Model - Power BI Fast and Furious

Learn how aggregation tables and composite models help Power BI analyze large DirectQuery datasets faster, with live demos of setup and common patterns.

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

PASS Data Community Summit

Inside the VertiPaq Engine

Explore how VertiPaq stores and compresses tabular data, and how its processing and query behavior affect model performance.

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

PASS Data Community Summit

Understanding Modern Data Encryption Offerings for SQL Server

Explore SQL Server’s native encryption methods alongside Azure Key Vault and Always Encrypted, including implementation considerations and potential issues.

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

PASS Data Community Summit

dbatools - A PowerShell Toolkit for the DBA

Use the dbatools PowerShell module to automate SQL Server administration, from migrating logins and jobs to setting up log shipping and availability groups.

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

PASS Data Community Summit

Missing T-SQL Querying Features for Handling NULLs and for Data Analysis

Explore missing SQL-standard querying features in T-SQL, with workarounds for NULL handling and analytical tasks such as window functions and row pattern recognition.

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

PASS Data Community Summit

MDS from the Ground Up - Let Your Users Maintain Their Data

Learn how Master Data Services lets business users maintain governed, quality-controlled data in Excel and integrate it into operational and analytical solutions.

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

PASS Data Community Summit

Understanding Execution Plans

Learn to read SQL Server execution plans to identify accessed objects, operators, and potential causes of slow queries.

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

PASS Data Community Summit

How to Build an Impactful KPI Scorecard in Power BI

Build a Power BI scorecard using DAX calculations, native and custom visuals, and design practices for client-ready reporting.

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

PASS Data Community Summit

Using PowerShell on Linux

See how PowerShell can serve Linux users, from installation and learning resources to use cases involving Azure and SQL Server.

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

PASS Data Community Summit

Improve Your Power BI Reports with DAX

Use DAX to refine Power BI reports with conditional formatting, visible-row totals, an “Others” row after the top ten, and readable slicer selections.

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

PASS Data Community Summit

Different Types of Many-to-Many Relationships in Power BI

Distinguish Power BI’s many-to-many cardinality from canonical many-to-many relationships and learn when each relationship pattern applies.

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

PASS Data Community Summit

Columnstore Indexes in 2017-2019

Explore columnstore index improvements introduced in SQL Server 2017 and 2019, including changes relevant to large-scale data warehouses and BI solutions.

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

PASS Data Community Summit

Deep Dive with Data Migration Tools and Azure Database Migration Service - DMS

See how discovery, assessment, target sizing, and migration tools support near-zero-downtime moves of SQL Server instances to Azure.

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