PASS Data Community Summit Courses

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

Best Practices for Deployment of SQL Server on Azure Virtual Machines

Optimize SQL Server deployment on Azure VMs: right-sizing, high availability, performance, migration, disaster recovery, and licensing for Windows and Linux environments.

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

Data Analysis with Spark and Databricks in Azure Synapse

Comparing Spark and Databricks in Azure Synapse: use cases, costs, data types, processing volumes, and implementation demos. Learn when to choose Spark-based tools vs. alternatives like SQL on-demand or ELT.

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

Data Modeling and Partitioning Patterns in Azure Cosmos DB

Explore key strategies for effective data modeling and partitioning in Cosmos DB, using real-world examples to optimize performance and scalability in NoSQL database design.

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

Navigate Your Big Data Journey with AWS Big Data Services

Comprehensive guide to AWS big data services, covering data ingestion, warehousing, analysis, and visualization using tools like Jupyter notebooks and Amazon Redshift for effective data lifecycle management.

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

Surprising Setbacks for Data Modernization and Azure Migration

Explore common setbacks in data modernization and Azure migration, covering strategies, planning, cost forecasting, performance monitoring, and team composition for successful projects.

• YouTube
• 57 minutes
• On-Demand
• Conference Talk

Deploying SQL Server Big Data Clusters

Learn to deploy SQL Server Big Data Clusters, demystify Kubernetes, and compare on-prem vs cloud deployments. Gain practical tools and scripts for immediate implementation.

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