PASS Data Community Summit Courses

The Function of Windowing Functions - DBA Fundamentals

1 review

Explore windowing functions in SQL for efficient data analysis, including row numbering, aggregation, lag/lead, and distribution functions. Learn practical applications and advanced techniques.

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

Data Governance for Beginners

1 review

Learn data governance basics for Microsoft Data Platform, including master data management and data stewardship. Discover practical steps for implementation and documentation to enhance organizational data value.

• YouTube
• 1 hour 1 minute
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• Conference Talk

Building a Security Dashboard for SQL Server

Learn to create a Power BI security dashboard for SQL Server, monitoring crucial security data and changes to ensure robust protection of your database systems.

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

Machine Learning, Artificial Intelligence, and Deep Learning Explained

Explore AI, ML, and DL with Buck Woody: learn key differences, use-cases, and implementation options, including SQL Server platform technologies.

• YouTube
• 1 hour 1 minute
• On-Demand
• Conference Talk

Common Data Service - Why Is It Not Common Yet?

Explore Common Data Service's strengths and weaknesses in the Power Platform. Learn to build, ingest, and extract data through demos, understanding its role in centralizing business logic across applications.

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

Dialogue with Your Data - Interactive AI with Cognitive Services

Explore Azure Cognitive Services for enhanced communication, language translation, and customer support analysis. Learn practical applications of Language and Speech APIs for immediate implementation.

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