PASS Data Community Summit Courses

Lift and Shift Your SQL Servers to Azure SQL Virtual Machines

Learn best practices for migrating SQL Servers to Azure, including assessment, sizing, and data transfer. Discover cost-saving strategies, hybrid deployments, and tools for efficient Azure migration of existing SQL infrastructure.

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

Guiding User Experiences With Advanced Reporting Features

Explore advanced Power BI features to enhance user experience: bookmark capture, button configurations, report tooltips, and measure-based formatting for improved report design and interactivity.

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

DevOps - SSDT Makes Deployment Consistent

Learn to deploy database code consistently and accurately using Azure DevOps pipeline. Explore techniques for setting up database objects, including security and reports, for successful and repeatable deployments across different environments.

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

The Battle of Cloud Data Warehouses - Snowflake, Synapse, and More

Explore cloud data warehousing solutions, comparing Snowflake, Synapse, Redshift, and BigQuery. Learn key principles, features, and how these platforms revolutionize data management and analysis.

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

Machine Learning with SQL Server - From the Edge to the Cloud

Explore machine learning options in SQL Server ecosystem, from edge devices to cloud, covering training, testing, and operationalization for various workloads and design patterns.

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

The ABCs of BDCs - Big Data Clusters for Beginners

Explore SQL Server 2019's Big Data Clusters: architecture, deployment, and capabilities for combining relational and non-relational data, enhancing your big data skills and career prospects.

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

So, You Want to Be an Azure Data Engineer When You Grow Up?

Explore Azure Data Engineer role: certifications, skills, and duties. Learn about storage, security, DevOps, and automation. Gain insights for certification exams and career advancement in cloud data engineering.

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

Checking in with Power Apps, Flow, and Power BI

Create a Power App for location check-ins, integrate with Flow to update Power BI data, and build a report displaying user locations on a map using Microsoft's Power Platform tools.

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

Maximize Performance for Less Cost Using Azure SQL Database Serverless

Learn to optimize Azure SQL Database serverless for intermittent workloads, automatically scaling resources and improving cost-efficiency while simplifying performance management.

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

DAX Studio

Explore DAX Studio with its creator, learning to profile and diagnose query and model performance issues through live demos of core features and practical applications.

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

Migrating SQL Servers to AWS

Learn to migrate SQL Servers to AWS efficiently, exploring deployment options, migration strategies, and best practices for system sizing, security, and automation. Discover how to modernize workloads using cloud-native AWS databases.

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

Standardize Your Environments Leveraging Infrastructure As Code

Explore methodologies for standardizing SQL Server deployments, identify gaps, and learn how Infrastructure as Code tools like Terraform can enhance and streamline your environment setup.

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

What's Your Bacon Number - An Introduction to Graph Databases

Explore graph databases using IMDB data to calculate Bacon Numbers. Learn graph theory, database types, and practical applications with Azure Cosmos DB and Gremlin API.

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

Localizing Reports in Power BI

Learn to localize Power BI reports, including content translation, currency conversion, and language settings for global audiences. Explore options for multi-language support and automated translation using Azure Cognitive Services.

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

A Self-Tuning Fill Factor Technique for SQL Server

Discover a technique for optimizing SQL Server index fill factors, reducing fragmentation and bad page splits, leading to significant performance improvements in OLTP databases.

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