PASS Data Community Summit Courses

Deployment, High Availability & Performance Guidance for SQL Server Linux Azure IaaS Ecosystem

Explore deploying SQL Server on Linux in Azure, covering high availability, AD authentication, and performance optimization for production environments.

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

Azure SQL Is the Best Choice for Building Back-End REST API - Discuss

Explore Azure SQL's capabilities for building high-performance, scalable REST APIs with JSON support, CI/CD integration, and robust security features for modern agile development.

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

Microsoft Power BI - Business Intelligence Strategy, Vision, and Roadmap Update

Explore Microsoft Power BI's latest features and future roadmap for driving data-driven decision-making across organizations, presented by BI leadership at PASS Data Community Summit.

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

Migrating Oracle Workloads to Azure

Learn strategies for migrating Oracle databases to Azure, including architecture design, deployment automation, and success factors for moving to IaaS while leveraging both Oracle and Azure products.

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

Polybase - It's What's for Dinner!

Explore Polybase, Microsoft's linked server replacement, for connecting to diverse data sources. Learn setup best practices, scale-out groups, AlwaysOn integration, and performance optimization techniques.

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

The Cases of The Unexplained Memory Problems

Explore advanced SQL Server memory usage troubleshooting through real-world cases, addressing complex issues and providing solutions for optimizing database performance.

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

Inclusive Presentation Design

Learn techniques for creating accessible presentations that maximize learning for audiences with diverse abilities, enhancing content delivery and impact for all viewers.

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

Microsoft SQL Server Machine Learning Workloads on Red Hat Enterprise Linux and Red Hat OpenShift

Accelerate machine learning pipelines using SQL Server on Red Hat Enterprise Linux and OpenShift. Learn in-database ML techniques and containerization for efficient model production and deployment.

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

From Docker to Big Data Cluster - A New Era for SQL Server

Explore SQL Server's evolution from Docker support to Big Data Clusters, covering containerization, Kubernetes deployment, and integration with Python for modernized database management and analytics.

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

Developer Best Practices in SQL Server

Learn optimized T-SQL coding techniques for SQL Server, including Sarg-ability, performance improvement, SQL injection prevention, parameterization, and dynamic SQL best practices through real-world examples.

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

Statistics Techniques Can Fix Tough Performance Issues

Explore advanced statistics techniques to optimize query performance, including filtered statistics, computed columns, sample size adjustments, and solutions for stale statistics and correlated columns.

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

How to Put DevOps Into Action for Your Databases

Learn to implement DevOps practices for database deployments, covering source control, automated testing, and continuous integration/delivery through live demonstrations and practical insights.

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

Giving Feedback - How to Effectively Communicate to Your Employees

Learn essential soft skills for effective feedback and communication as a manager. Discover best practices for coaching conversations, handling tough dialogues, and addressing performance issues tactfully.

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

Modernize Your SQL Applications Recently Enhanced Version Azure SQL Managed Instance

Explore Azure SQL Managed Instance's latest enhancements for modernizing SQL applications, including improved migration, security, and manageability features for optimal cloud transformation.

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

Moving Data with Azure Data Factory

Learn to build native ADF pipelines, lift and shift SSIS to Azure, and use design patterns for execution and monitoring in this comprehensive overview of Azure Data Factory's cloud data engineering capabilities.

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