PASS Data Community Summit Courses

Batch Execution Mode on Rowstore Indexes

Explore SQL Server 2019's Batch Execution Mode for Rowstore Indexes, its benefits, challenges, and optimal usage scenarios to significantly enhance workload performance.

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

AI Cognitive Services - Vision 101

Introduction to Azure's Computer Vision and Custom Vision APIs, covering basics, model creation, training, and implementation using Python in Azure Notebooks.

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

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

Explore Microsoft's BI strategy and roadmap with Power BI leadership. See demos of latest enterprise features and learn how to leverage data for organizational success.

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

Different Types of Many-to-Many Relationships in Power BI

Explore various many-to-many relationships in Power BI, including classical, simple, and filter propagation. Learn when and how to use different types with practical examples and understand their impact on data modeling.

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

AI for the BI Professional

Explore AI integration in BI solutions for enhanced data insights. Learn to use pre-built AI tools, consume data scientist models, and leverage Power BI's AI features for intelligent reporting.

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

Successful ORM Design Strategies

Explore effective Object Relational Mapper design patterns for improved data access, schema management, and object structures. Learn strategies to ensure maintainable and flexible ORM implementations.

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

Failure Prediction for Manufacturing Industry with SQL Server & R

Explore predictive modeling for manufacturing failure using SQL Server and R. Learn regression, binary classification, and random forest techniques to forecast product failures and estimate lifespans.

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

ABCs of the Power BI REST API

Explore managing Power BI content using REST API, covering dashboards, datasets, reports, and groups. Learn to automate tasks, retrieve information, and enhance Power BI workflow efficiency.

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

Query Optimization Statistics - Driving Force Behind Performance

Explore SQL Server query optimization statistics, their impact on performance, and techniques to address common issues for improved query execution.

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

What's in a Name? Data Stories that Would Make the Bard Proud

Learn to transform U.S. Census Bureau data on children's names into captivating stories. Discover techniques for identifying key data points, creating effective visualizations, and crafting compelling narratives to engage any audience.

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

Power BI Report Server Enterprise Architecture, Tools to Publish

Explore enterprise-grade Power BI Report Server architecture, publishing tools, and best practices for improved performance, security, and scalability in large-scale implementations.

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

Turbocharge Your SQL Server with In-Memory Database

Discover how to leverage SQL Server 2019's memory-optimized technologies to enhance performance and scalability, taking advantage of modern hardware innovations for database applications.

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

How Do I Ensure My Azure Modern Data Warehouse Is Secure

Comprehensive guide to securing Azure-based data platforms, covering network security, client connections, firewalls, VNET rules, and Azure AD. Includes SQL security features and encryption options for robust data protection.

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

Introduction to Data Governance

Demystifying data governance: Learn its importance, core concepts, and practical implementation strategies for effective organizational data management.

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

Operationalize Data Science for Advanced Decision Support

Learn to develop and integrate predictive models using Azure Machine Learning, enhancing organizational decision-making through data science principles, best practices, and a real-world case study.

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