PASS Data Community Summit Talks & Presentations

PASS Data Community Summit

Animated Query Plans for the Visual Learner

Visualize SQL query execution with animated plans, demystifying concepts like Hash Match and Merge Join. Enhance your understanding of performance tuning through interactive, visual learning.

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

PASS Data Community Summit

Let Me Automate You - Take Power BI To The Next Level

Discover advanced Power BI automation techniques using CLI, PowerShell, and C#. Learn to streamline administration tasks, implement continuous integration, and create artifacts automatically.

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

PASS Data Community Summit

Choosing Database Hardware for SQL Server 2019

Optimize SQL Server 2019 hardware selection for performance and cost-efficiency. Learn to evaluate workloads, choose processors, and navigate licensing changes to maximize database server capabilities.

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

PASS Data Community Summit

Let's Automagically Stage 100 Tables - For SSIS or ADF - With Biml - Live

Explore how Business Intelligence Markup Language (Biml) can automate SSIS package creation and generate JSON for ADF pipelines, streamlining data transformation processes from on-premises to Azure.

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

PASS Data Community Summit

DataOps - Deploy SQL Server Databases Using Azure Pipelines

Learn to automate SQL Server database deployments using Azure Pipelines and Visual Studio Database Projects. Covers creating projects, manual deployments, and setting up automated pipelines with secure credential management.

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

PASS Data Community Summit

TDE, Encryption, and Compliance With Azure Key Vault - Zero To Hero

Learn to secure and comply with data regulations using SQL Server TDE, encryption, and Azure Key Vault. Covers basics to advanced topics, including AlwaysON and hybrid cloud scenarios.

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

PASS Data Community Summit

Complete CI - CD for C# and SQL

Practical demonstration on automating CI/CD for C# applications and SQL databases, covering source control, build processes, and deployment strategies for different environments.

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

PASS Data Community Summit

An Azure Data Engineer's ETL Toolkit

Explore Azure's data movement and transformation options, comparing SSIS with Data Factory, Databricks, and Logic Apps. Learn ETL patterns and Data Flow features for scalable cloud migration.

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

PASS Data Community Summit

Roles and Responsibilities of the Azure Data Engineer

Explore the role of Azure Data Engineer, including key responsibilities, required skills, and relevant Azure services. Learn how to align your career path with the Microsoft certification.

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

PASS Data Community Summit

Azure DevOps and the SSIS Development Lifecycle

Learn to manage SSIS projects through their lifecycle using Azure DevOps, from initial development to production release, with practical demonstrations and expert guidance.

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

PASS Data Community Summit

Tips and Tricks for Using SQL Server Management Studio Effectively

Discover essential tips and tricks to enhance your productivity with SQL Server Management Studio, covering features like object explorer, scripting, query plans, and multi-server management.

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

PASS Data Community Summit

Microsoft's Modern Data Warehouse Architecture

Explore Azure Synapse Analytics: Microsoft's comprehensive solution for traditional, big data, and real-time analytics, revolutionizing the approach to modern data warehousing.

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

PASS Data Community Summit

SQL Server Internals and Architecture

Explore SQL Server's internal workings and architecture, gaining insights into its core components, processes, and optimizations for enhanced database management and performance tuning.

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

PASS Data Community Summit

Big Data Architectures and The Data Lake - Cloud

Explore big data architectures, data lakes, and modern data warehousing. Learn about Hadoop, cloud benefits, and strategies to effectively manage and analyze large-scale data for business intelligence.

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

PASS Data Community Summit

SQL Server Security Basics - Security

Learn SQL Server database security essentials, including permissions, principals, and best practices. Gain practical knowledge to protect your company's valuable data and manage security effectively.

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