PASS Data Community Summit Courses

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

Architecture Blueprints for Power BI Implementation

Learn essential architecture design principles for Power BI solutions, covering sharing, security, connections, and components like dataflow. Gain insights into key considerations and blueprint designs for effective implementation.

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

Data Quality Round-trip in the MS Dataplatform

Explore comprehensive data quality solutions using Microsoft's Data Platform, including Machine Learning, Azure Data Factory, and SQL Server 2019, to address and resolve data quality challenges.

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

Azure Data Studio - The Challenger

Explore Azure Data Studio's features, benefits, and comparison to SQL Server Management Studio. Learn about its cross-platform capabilities, monitoring tools, and use cases.

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

Removing the SELECT * - Helping Your App Developers and Yourself

Optimize database performance by understanding ORM frameworks, LINQ, and application impact. Learn to improve queries, enhance developer collaboration, and boost your value as a data professional.

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

Hidden Differences Between Azure ML Products Revealed

Explore Azure ML products, their differences, and use cases. Learn to create end-to-end ML workflows, integrate with SQL Server, and manage models in production using various Azure tools.

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

AI for Developers

Explore Azure AI platform's tools, infrastructure, and services for integrating AI into existing applications. Learn skills needed to become an AI developer and create intelligent solutions.

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

Best, Better, Hyperscale! The Last Database You Will Ever Need in the Cloud

Explore Azure Hyperscale: a cloud-native, scalable database solution offering SQL Server features for innovation and future-proofing. Learn deployment patterns, best practices, and its underlying architecture.

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

Hidden Gems of SQL Server 2019

Discover lesser-known features and improvements in SQL Server 2019 beyond the main highlights, exploring hidden capabilities that can enhance database management and performance.

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

Infrastructure for the DBA - An Introduction

Comprehensive overview of infrastructure layers for DBAs, covering hardware, network, storage, virtualization, and operating systems to enhance problem-solving and proactive management skills.

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

Reporting Services - A Smart Migration Strategy

Discover strategies for migrating to Power BI Report Server, utilizing ReportServer database metadata to determine which reports and data sources to migrate, and learn PowerShell techniques for efficient extraction and migration.

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