PASS Data Community Summit Courses

Back Up and Restore a SQL Server Database If You're Not a DBA

Learn essential database backup and restore techniques, including data files, recovery models, and automation, to safeguard your SQL Server data and prevent job-loss scenarios during disasters.

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

SQL Server Migration - The Last Mile

Explore post-migration steps for SQL Server upgrades, focusing on data accuracy, query performance, and leveraging new optimization features to minimize risks and improve workload efficiency.

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

AI for the DBA

Explore the AI ecosystem for DBAs, covering basics, support skills, and in-depth understanding to thrive in AI. Learn about architecture and operationalizing models using Azure ML Server.

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

Code Like a Snake Charmer - Introduction to Python

Learn Python basics, data manipulation, and integration with Microsoft tools for enhanced data analytics and machine learning capabilities.

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

Power BI Premium - Is it for Your Company and Worth It

Comprehensive overview of Power BI Premium features, benefits, and costs to help companies decide if it's the right investment for their data analytics needs.

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

dbatools - A PowerShell Toolkit for the DBA

Explore dbatools PowerShell module for efficient SQL Server management. Learn installation, automation of routine tasks, and advanced features to streamline database administration workflows.

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

Data Munging to Wrangling - 7 Steps to Mastering Data Preparation for Data Science

Discover essential techniques for data preparation in AI/ML projects. Learn to source, clean, and transform data effectively, enhancing the quality and predictive power of machine learning models.

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

Everything You Wanted to Know About Implementing Temporal Tables

Discover SQL Server's Temporal Tables: automate data history tracking, simplify time-based analysis, and explore new querying syntax for efficient data management and auditing.

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

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

Explore advanced T-SQL querying techniques for handling NULLs and data analysis, covering missing SQL Server features and effective workarounds for improved database performance and functionality.

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

Protect Your Data by Design - Creating a Data Masking Strategy

Learn to create a comprehensive data masking strategy to protect sensitive information, overcome implementation challenges, and ensure data security in pre-production environments.

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

Data Warehousing - Which of the Many Cloud Products is the Right One for You

Explore cloud-based data warehousing options, comparing Snowflake, Databricks, and Azure solutions. Learn to choose the best fit for your environment based on size, architecture, and unique features.

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

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

Master Data Services (MDS) empowers users to manage data quality and governance. Learn how MDS integrates with Excel, enforces data standards, and streamlines operational and analytical solutions.

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

Understanding Execution Plans

Explore SQL Server execution plans to optimize query performance. Learn to capture, read, and analyze plans, identifying potential issues and understanding key operations for efficient database queries.

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

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