PASS Data Community Summit Courses

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

SQL Server and Azure Data - What to Use When

Explore SQL Server deployment options across on-premises, cloud, and hybrid environments. Learn decision-making strategies for modernizing your data platform and choosing the right solution for your needs.

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

Entity Framework Debugging Using SQL Server - A Detective Story

Aprenda a depurar consultas LINQ de Entity Framework investigando SQL Server. Técnicas para otimizar el rendimiento mediante configuración, perfilado y planes de ejecución.

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

Columnstore Indexes in 2017-2019

Explore recent enhancements to Columnstore Indexes in SQL Server 2017-2019, focusing on performance improvements for Data Warehouses and BI solutions. Learn about new features and fixes for high-scale environments.

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

How I Would Attack SQL Server

Explore SQL Server vulnerabilities and attack strategies from an adversary's perspective, learning detection, prevention, and response techniques for enhanced database security.

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

Data Privacy, Security, Ethics and Compliance in a Data-Driven World

Explore ethical challenges in data-driven technologies, focusing on privacy, security, and compliance. Learn tools and strategies to mitigate risks and maintain integrity in the evolving landscape of AI and big data.

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