PASS Data Community Summit Courses

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

Securing Your Data in Azure - Tips and Tricks

Comprehensive guide to Azure security features, covering SQL Database, Key Vault, blob storage, CosmosDB, and Power BI. Learn to protect data, manage access, and implement best practices for secure data handling in Azure.

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

Embracing Database DevOps through CI/CD

Learn to implement Database DevOps using SQL Server containers, Flyway, Kubernetes, and Azure DevOps. Explore strategies for efficient database migrations and build your first CI/CD pipeline for database deployment.

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

One Bite at a Time

Efficient techniques for anonymizing PII data, archiving old data, and performing garbage collection in databases. Learn to create procedures for updating large datasets while maintaining performance and avoiding blocking operators.

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

Designing Azure Data Science and AI Projects

Aprenda a diseñar proyectos de ciencia de datos e IA en Azure, desde la comprensión del negocio hasta la implementación, utilizando un enfoque práctico basado en equipo y las últimas tecnologías disponibles.

• YouTube
• 2 hours 5 minutes
• On-Demand
• Conference Talk

Advanced Plan Explorer Usage for Tuning Execution Plans

Explore advanced techniques for optimizing SQL execution plans using Plan Explorer, focusing on practical T-SQL anti-patterns and in-depth analysis capabilities.

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

Inside Azure SQL Database Hyperscale

Explore Azure SQL Database Hyperscale's innovative architecture, including distributed components, multi-tiered caching, and read-scale replicas. Learn about built-in scalability, high availability, and unique diagnostics for performance insights.

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

Modern High Availability and Disaster Recovery Topologies

Explore innovative HA/DR solutions for SQL Server, including traditional and advanced technologies like availability groups, log shipping, VM replication, and container-based approaches for enhanced data protection.

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

Azure Synapse Analytics - A Data Lakehouse

Explore Azure Synapse Analytics, a unified service combining data warehousing and Big Data analytics. Learn about its features, scalability, and integration in modern data warehouses through demonstrations.

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

Learn Faster in a Container - A Docker Introduction

Discover Docker's power for DevOps, from basics to advanced uses. Learn to set up, modify images, and deploy databases. Accelerate your tech learning with practical examples and hands-on demos.

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