PASS Data Community Summit Talks & Presentations

PASS Data Community Summit

The Function of Windowing Functions - DBA Fundamentals

1 review

Learn about windowing functions in SQL with Kevin Wilkie at PASS Data Community Summit. Master techniques like row numbering, aggregate functions, and more in 1-2 hours.

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

Optimizing OLTP and Data Warehousing with SQL Server 2014

161 ratings at Pluralsight

This course focuses on the database developers and architects engaged in the increasingly difficult task of achieving the best performance of database applications. SQL Server 2014 addresses these needs, optimizing for both OLTP and Data Warehousing work…

• Pluralsight
• 2 hours 19 minutes
• On-Demand
• Conference Talk

PASS Data Community Summit

Head to Head - SSIS Versus Azure Data Factory

Compare SSIS and Azure Data Factory in a head-to-head session by PASS Data Community Summit. Learn their features, benefits, challenges, and practical applications in 1-2 hours.

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

PASS Data Community Summit

Encrypting Data Within SQL Server

Learn to encrypt data within SQL Server, understand data privacy laws, and protect sensitive data with this 1-2 hour material from PASS Data Community Summit.

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

PASS Data Community Summit

SQL Containers in 5 Minutes and 5 Lines of Code

Learn to build SQL-on-Linux containers using Docker and PowerShell in less than an hour with the PASS Data Community Summit. Ideal for supporting QA and Dev environments.

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

PASS Data Community Summit

6 Months to 5 Minutes - DB & BI Deployments at the Speed of Light

Learn how a team at a major bank implemented Agile and Continuous Delivery in their Database, BI, and Document Management systems, overcoming organizational barriers. Offered by PASS Data Community Summit.

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

PASS Data Community Summit

Presenting Big Data Clusters for SQL Server 2019

Learn to leverage containers and Kubernetes to blend Apache Spark, Apache Hadoop, and SQL Server into a single package with this 1-2 hour material from PASS Data Community Summit.

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

PASS Data Community Summit

Modernize Your SQL Server the Right Way

Learn to modernize your SQL Server using Microsoft's free tools with PASS Data Community Summit's 1-2 hour material. Gain a solid methodology for successful migrations.

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

PASS Data Community Summit

Identifying Anti-Patterns in Analytical Queries

Improve your SQL-based job performance with Bert Wagner's guidance on restructuring analytical queries. Offered by PASS Data Community Summit, this 1-2 hour session is ideal for analysts and developers.

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

PASS Data Community Summit

Managing ETL Change Using BIMLScript

Learn to manage ETL changes using BIMLScript with Russel Loski in this 1-2 hour material from PASS Data Community Summit. Master metadata usage for efficient SSIS package generation.

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

PASS Data Community Summit

Using the Power Platform to Radically Change Your Business

Learn to transform your business with technology in this 1-2 hour session from PASS Data Community Summit, featuring Microsoft Flow, PowerApps, and Power BI.

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

PASS Data Community Summit

Virtual SQL Server Performance Deep Dive

Learn to optimize virtual SQL Servers with PASS Data Community Summit. Understand and manage virtualization-related bottlenecks, with live examples and practical tools. Duration: 1-2 hours.

• 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 data and ensure compliance with SQL Server TDE and Encryption using Azure Key Vault, covering complexities, pitfalls, and best practices in a 1-2 hour session by PASS Data Community Summit.

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

PASS Data Community Summit

Start off the Season with Azure Snowflake

Learn to manage cloud data warehousing with Azure Snowflake in this 1-2 hour material from PASS Data Community Summit. Gain insights on performance, simplicity, and affordability.

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

PASS Data Community Summit

JSON for the Data Mortals

Learn to understand, manipulate, and validate JSON in your database with this 1-2 hour material from PASS Data Community Summit. Gain practical skills with Microsoft's SQL Server additions.

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