PASS Data Community Summit Courses

Getting Started with PowerShell as a DBA

Learn PowerShell fundamentals for DBAs: syntax, TSQL translation, and practical applications. Discover how this powerful tool can enhance your database administration skills and workflow efficiency.

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

Performance Tuning - Getting the Biggest Bang for Your Buck

Discover essential SQL Server performance tuning techniques, from memory optimization to configuration changes, with real-world scenarios and practical solutions for immediate improvements.

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

Modernizing Your Data Platform

Structured approach to modernizing data platforms, focusing on Microsoft technologies. Covers migration tools, techniques, and steps for improved performance, security, and cost-efficiency.

• YouTube
• 58 minutes
• On-Demand
• Conference Talk

Mental Health in IT - Safeguarding Our Most Precious Resource

Explore mental health challenges in tech, their impact on work, and strategies for creating supportive environments. Learn to recognize signs, avoid burnout, and foster positive workplace attitudes.

• YouTube
• 48 minutes
• On-Demand
• Conference Talk

Deep Dive on Embedded Analytics with Power BI

Explore best practices for integrating Power BI reports into applications, comparing versions and tiers to optimize embedded analytics implementation in business solutions.

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

Increase Deployment Flexibility with Feature Flags

Learn to use feature flags for flexible database deployments, enabling dark deployments and reducing production impact. Includes T-SQL code examples and demonstrations of implementation in deployment processes.

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

Implementing Data-Driven Storytelling Techniques in Power BI

Learn four data-driven storytelling techniques and their implementation in Power BI to create engaging, easy-to-consume reports with coherent structures that effectively communicate insights.

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

Machine Learning in C# - Introduction to ML.NET

Discover ML.NET: Build machine learning applications using C# and .NET. Learn data preparation, model evaluation, and deployment techniques for integrating ML capabilities into your .NET projects.

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

Think Like the Cardinality Estimator

Explore SQL Server's cardinality estimation process to optimize query performance. Learn how to influence physical operations, handle multiple predicates, and tackle complex query plans.

• YouTube
• 58 minutes
• On-Demand
• Conference Talk

Continuous Integration with Local Agents and Azure DevOps

Explore Azure DevOps for database CI, using local agents for automated testing and validation. Learn to improve teamwork and code quality in database development.

• YouTube
• 54 minutes
• On-Demand
• Conference Talk

Accelerating the Migration of Legacy SSIS with Azure Data Factory

Explore new features for migrating legacy SSIS to Azure Data Factory, including Azure-SSIS Integration Runtime, Azure Files integration, and batch assessments using Data Migration Assistant.

• YouTube
• 47 minutes
• On-Demand
• Conference Talk

Budgeting with Power BI

Learn advanced budgeting techniques in Power BI, including previous year allocation, multi-step budgeting, and handling new product forecasts. Master DAX code for precise budget modeling and forecasting.

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

Understanding Modern Data Encryption Offerings for SQL Server

Explore SQL Server's native encryption methods, Azure Key Vault, and Always Encrypted to safeguard your data. Learn implementation techniques and potential issues for modern data security.

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

Revenge - The SQL

Discover humorous and creative SQL techniques to enforce best practices, prevent errors, and maintain control over your database environment. Learn unconventional methods to address common DBA challenges.

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

SQL Migration to Azure - Best Practices, Accelerators, and Production Case Studies

Explore SQL workload migration to Azure, covering best practices, tools, and real-world case studies. Learn end-to-end migration lifecycle and determine the best approach for your organization.

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