Sessions at PASS Data Community Summit - JOYK Joy of Geek, Geek News, Link all geek

Filter

237 sessions

4 Useful DAX Solutions for Business Problems
James McGillivray
Director of Content Creation and Customer Delivery, Cobalt Analytics
```
You’ve built a perfect Star Schema, and your data models are performing amazingly… but now you’re starting to run into business questions that the model isn’t designed to answer. How… Show more 
```
Type: General Session (60-minutes)
Theme: Level Up
Track: Analytics
Level: 200 (Intermediate)

5 Fascinating principles to get things done

Pedro Reis

IT Team Leader

In this session, I'll show you 5 principles that might be holding you back from getting things done.

Warning: Just by knowing these you might be able to relate to previous… Show more

Type: Lightning Talk* (10-minutes)

Theme: Level Up

Track: Professional Development

Level: 100 (Foundational)

5 Things You Need to Know When Learning DAX

Markus Ehrenmüller-Jensen

BI Architect

When learning DAX you will soon discover, that it is both, “easy, but hard” (© Alberto Ferrari). On the one hand, the syntax of this language is very close to… Show more

Type: General Session (60-minutes)

Theme: Level Up

Track: Analytics

Level: 200 (Intermediate)

A Case Study - Data Movement and Transformation using Azure Data Factory
Alpa Buddhabhatti
Cluster Reply, London, UK
```
In this session , I will provide a basic introduction of Azure Data Factory, a scalable cloud-based data integration service. I will show a case study to move data from… Show more 
```
Type: General Session (60-minutes)
Theme: Reach for the Clouds
Track: Development
Level: 200 (Intermediate)

A Database DevOps Pipeline

Rob Richardson

@rob_rich

Are your automation practices accounting for the database? How do you verify database software quality? Most importantly, how do you care for customer data as the schema evolves? Let's dig… Show more

Type: General Session (60-minutes)

Theme: Level Up

Track: Database Management

Level: 100 (Foundational)

AI & Machine Learning in Power BI
Thomas LeBlanc
Data Warehouse Architect/MVP at Data on the Geaux
```
The new AI & Machine Learning in Power BI consists of clicks not code. Sounds to good to be true? The session will step thru the additional features added to… Show more 
```
Type: Half-day Session (2.5-hours)
Theme: Back to Basics
Track: Analytics
Level: 200 (Intermediate)
A Power BI Solution from Raw Crime Data to Insight in Ten Minutes
Ben Watt
Managing Director of Datalineo
```
In this session we will access Garda (Irish police) recorded crime data from the government data portal and build out a full solution from end-to-end. You will see many best… Show more 
```
Type: Lightning Talk* (10-minutes)
Theme: Level Up
Track: Analytics
Level: 200 (Intermediate)
A Quick Walkthrough of Azure Data Studio
Ananta Bulusu
WinWire Technologies - Module Lead- BI Stream
```
This talk provides a very high-level view of Azure Data Studio and its features. It will also focus on comparisons with SQL Server Management Studio, SMS.
```
Type: Lightning Talk* (10-minutes)
Theme: Back to Basics
Track: Database Management
Level: 100 (Foundational)

A Version Control Primer for Databases

Steve Jones

The Voice of the DBA

Why would a DBA or database developer need to learn Git? Version control systems (VCS) have typically not been a part of the database professional's daily work, but with DevOps… Show more

Type: General Session (60-minutes)

Theme: Level Up

Track: Development

Level: 100 (Foundational)

Learning Pathway: Database DevOps

Accelerate SQL Server Migration to the AWS Cloud: Approach & Methodology
Jeff Duncan
DBA Manager, SQL Server
```
In today’s marketplace, moving to the public Cloud is a familiar and consistent trend within the SQL Server community. But which cloud provider do you choose? After all there are… Show more 
```
Type: General Session (60-minutes)
Theme: Reach for the Clouds
Track: Database Management
Level: 200 (Intermediate)
Accessibility for hard of hearing & deaf people
Kay Sauter
Senior BI Consultant, OneDigit AG
Craig Porteous
Data Platform MVP | Principal Advanced Analytics Consultant
```
This session gives you an insight on what you can do in order to be more accessible to people that are hard of hearing or deaf. Accessibility does matter because… Show more 
```
Type: General Session (60-minutes)
Theme: Back to Basics
Track: DE&I
Level: 100 (Foundational)

A complete DevOps solution for databases

Hamish Watson

DevOps Alchemist

DevOps processes encompass both Continuous Integration and Continuous Delivery.

Continuous integration is based around automated builds and tests. Continuous Delivery allows both application developers, database developers and DBAs alike to deploy… Show more

Type: General Session (60-minutes)

Theme: Reach for the Clouds

Track: Development

Level: 300 (Advanced)

Learning Pathway: Database DevOps

Advanced SQL For Data Scientists

Jean Joseph

Data Engineer

I will begin with a brief overview of SQL. Then the five major topics a data scientist should understand when working with relational databases: basic statistics in SQL, data preparation… Show more

Type: General Session (60-minutes)

Theme: Level Up

Track: Development

Level: 300 (Advanced)

Advanced T-SQL Querying and Query Tuning

Itzik Ben-Gan

T-SQL Trainer, Lucient

This seminar covers advanced T-SQL querying and query tuning topics. It covers powerful querying tools like window functions, APPLY, OFFSET FETCH, and others; describing how they are optimized, and how… Show more

Type: Pre-conference Session (Full-day)

Pre-conference day: Tuesday

Theme: Level Up

Track: Development

Level: 300 (Advanced)

Analyze Billions of Rows of Data in Real-Time Using Azure Data Explorer
Niels Berglund
Software Architect at Derivco | Microsoft Data Platform MVP
```
In today's competitive world, it is of utmost importance that we analyze our data to get insights from it! However, batch style analytics - where we get results hours or… Show more 
```
Type: General Session (60-minutes)
Theme: Reach for the Clouds
Track: Analytics
Level: 200 (Intermediate)

Anchor Modelling - agile databases

Steph Locke

AI & Data Platform MVP and CEO of Locke Data and Nightingale HQ

Anchor Modelling is a fantastic database modelling paradigm that uses sixth normal form (6NF) to store data and provides third normal form (3NF) views for ease of use.

This session deep… Show more

Type: General Session (60-minutes)

Theme: Level Up

Track: Architecture

Level: 200 (Intermediate)

Applying a Security Mindset to Lock Down Azure SQL DB
Surbhi Pokharna
Charles River Development, Lead Database Reliability Engineer
```
Securing your database in cloud is not an act but a mindset. 
Securing a database is frustrating because how do you know when you are done? Meeting bare minimum of… Show more 
```
Type: General Session (60-minutes)
Theme: Reach for the Clouds
Track: Database Management
Level: 200 (Intermediate)
Learning Pathway: Data Security & Governance
Architecting SQL Server database on AWS
Yogi Barot
Senior Microsoft Specialist Solution Architect
```
Ways to Architect SQL Server database on AWS
```
Type: General Session (60-minutes)
Theme: Reach for the Clouds
Track: Architecture
Level: 200 (Intermediate)
Architecting a Modern Business Intelligence Cloud Data Platform
Warner Chaves
Pythian Principal Consultant - MS Data Platform MVP
```
The power of cloud storage and compute power has made data warehousing and big data possible for businesses of all sizes. What was once a large capital expenditure and multi-year… Show more 
```
Type: General Session (60-minutes)
Theme: Reach for the Clouds
Track: Architecture
Level: 100 (Foundational)
Architecting for High Availability in Azure SQL
Anthony Nocentino
Enterprise Architect, Centino Systems
```
This session will introduce you to the high availability architectures for Azure SQL deployment options, including Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines.… Show more 
```
Type: General Session (60-minutes)
Theme: Reach for the Clouds
Track: Architecture
Level: 200 (Intermediate)
Learning Pathway: Cloud Migrations
Auditing your data and data access
Kenneth Fisher
Data Platform MVP, Transamerica
```
When people think of security the first things that come to mind are "restricting access" and "least privilege". I.e. who has access to what and why. What most people don't… Show more 
```
Type: General Session (60-minutes)
Theme: Back to Basics
Track: Database Management
Level: 200 (Intermediate)
Learning Pathway: Data Security & Governance
AutoML features in Azure ML
Dinesh Asanka
Director - Technical , Datos (Pvt) Ltd.
```
In Machine learning, there are lot of selection and configurations to be done. With AutoML those selection and configurations are done automatically.
```
Type: Lightning Talk* (10-minutes)
Theme: Reach for the Clouds
Track: Analytics
Level: 200 (Intermediate)
Automate! Use GitHub Actions to Build and Test Database Projects
Liz Baron
Helping teams build confidence and deliver value with Data Platform DevOps
Sebastian Meine
Helping teams build confidence and deliver value with Data Platform DevOps
```
Unit Testing is a great way to make hunting down defects and implementing new features faster and easier. But it is an investment, and for that investment to pay off,… Show more 
```
Type: General Session (60-minutes)
Theme: Reach for the Clouds
Track: Development
Level: 300 (Advanced)
Azure AD for the Azure Data Services
Heini Ilmarinen
DevOps Consultant, Polar Squad
```
Working with Azure data services it is nearly impossible to ignore Azure AD; we can use it simply for logging in to specific services like Azure SQL or Azure Data… Show more 
```
Type: General Session (60-minutes)
Theme: Reach for the Clouds
Track: Architecture
Level: 200 (Intermediate)

Azure Arc for the Data Professional

Ben Weissman

Works with Computers

Over the last 2 years, Microsoft announced and released multiple services under their Azure Arc umbrella. 

But what's in it for the data professional?

Join Data Platform MVP Ben Weissman on… Show more

Type: General Session (60-minutes)

Theme: Reach for the Clouds

Track: Architecture

Level: 200 (Intermediate)

Learning Pathway: Cloud Migrations

Azure Data: A Guided Tour

Peter Shore

Data professional

As Azure has grown at a breakneck pace, the umbrella once known as SQL Server, including components like Integration Services, Analysis Services, and Reporting services has morphed into a full-fledged… Show more

Type: General Session (60-minutes)

Theme: Reach for the Clouds

Track: Architecture

Level: 100 (Foundational)

Azure Data Explorer for Near-Real-Time Data Analytics
Ferenc Csonka
Head of Development Services at Fizzcode | Trainer and Public Speaker
```
The Azure Data Explorer (a.k.a. ADX) is a Microsoft-managed near-real-time data analytics platform for a large volume of data coming from IoT devices, websites, applications (telemetry data), etc. This Azure… Show more 
```
Type: General Session (60-minutes)
Theme: Reach for the Clouds
Track: Analytics
Level: 200 (Intermediate)
Azure Data Factory: Utilizing Data Flows in a Modern Data Warehouse
Thimantha Vidanagamage
Associate Microsoft BI Consultant, Fortude (Pvt) Ltd.
```
Are you someone who is unsure about when and how to use which type of data flow in Azure Data Factory for a Modern Data Warehouse solution? There are two… Show more 
```
Type: General Session (60-minutes)
Theme: Level Up
Track: Analytics
Level: 200 (Intermediate)
Azure Data Factory for Beginners: Let's Make some Data
Leslie Andrews
Lead Data Architect @ 3Cloud: Be a catalyst for change!
```
Does Azure Data Factory really make data? Of course not, but what it does is allow you to make your data into something new and different! In this presentation you… Show more 
```
Type: General Session (60-minutes)
Theme: Back to Basics
Track: Development
Level: 100 (Foundational)
Azure Data Science solutions for the modern Enterprise
Anupama Natarajan
Data and AI Consultant, Pearl Innovations Limited
```
Data Science is a hot topic in the market and the foundation for Artificial Intelligence, Machine Learning, Deep Learning, and the Internet of Things (IoT). Modern enterprises want to be… Show more 
```
Type: General Session (60-minutes)
Theme: Reach for the Clouds
Track: Analytics
Level: 200 (Intermediate)
Azure Devops Dashboards EZ as pie-charts!
Angela Tidwell
Solutions Architect, SRE Team Lead, Jack Henry & Associates
```
Level up your metrics game by creating project dashboards in Azure DevOps!  Pictures are worth a thousand words, and creating dashboards is easy as pie(charts) in ADO.  I… Show more 
```
Type: Lightning Talk* (10-minutes)
Theme: Back to Basics
Track: Database Management
Level: 200 (Intermediate)
Azure Functions - a short introduction to serverless computing in Cloud-borne ETL processes
Benjamin Kettner
CTO ML!PA Consulting GmbH
```
As data warehouses move to the cloud we need to rethink ETL processes. For new sources like data streams, Web APIs and SaaS-Solutions, Azure functions can be utilized for reading… Show more 
```
Type: General Session (60-minutes)
Theme: Reach for the Clouds
Track: Development
Level: 300 (Advanced)
Azure Notebooks - Data Science fundamentals
Neil Hambly
Beacon Intelligence CEO, MCT and Presenter
```
Azure Notebooks is a hosted service for Jupyter Notebooks.
Getting started quickly on prototyping, data science or learning Python or R using Azure Notebooks.
```
Type: General Session (60-minutes)
Theme: Level Up
Track: Analytics
Level: 100 (Foundational)
Azure SQL Analytics - A Cloud Performance Monitoring Tool
Sarita Garg
IT Consultant
```
Azure SQL Analytics is in preview.  In this Lightning Talk we will talk about what is Azure SQL Analytics (ASA), why to use it, which options are available, how… Show more 
```
Type: Lightning Talk* (10-minutes)
Theme: Reach for the Clouds
Track: Analytics
Level: 100 (Foundational)
Azure SQL Fundamentals
Tracy Boggiano
Database Superhero at DocuSign
```
Organizations have been moving existing systems to the cloud and offloading some on-premises costs. The role of the data professional is changing, and you need to know what is changing… Show more 
```
Type: Pre-conference Session (Full-day)
Pre-conference day: Tuesday
Theme: Reach for the Clouds
Track: Database Management
Level: 100 (Foundational)
Azure SQL Journey: The daily routine of a Cloud DBA
Roberto Cavalcanti
Microsoft, Sr. Cloud Solution Architect - Microsoft Customer Success
```
In this session you will learn the best practices, tips, and tricks on how to successfully use Azure SQL Database and SQL Managed Instance on production environments and how the… Show more 
```
Type: Half-day Session (2.5-hours)
Theme: Reach for the Clouds
Track: Database Management
Level: 300 (Advanced)
Azure SQL & Our Toolbox To Manage It
Jess Pomfret
SQL Server DBA, from the South of England
```
Azure SQL is becoming more and more popular and there are many options available within that umbrella. In this session we’ll talk through our options when it comes to SQL… Show more 
```
Type: General Session (60-minutes)
Theme: Back to Basics
Track: Database Management
Level: 100 (Foundational)
Learning Pathway: Cloud Migrations

Azure Storage - The ins and outs

Martin Catherall

Doing data since day dot!

Storing data has come a long way over the past decade – from traditional hard disk drives to Solid State drives, cloud-based Infrastructure-as-a-Service (IaaS) solutions to (perceived) complex Platform-as-a-Service (PaaS)… Show more

Type: General Session (60-minutes)

Theme: Reach for the Clouds

Track: Architecture

Level: 200 (Intermediate)

Azure Synapse Analytics Pipelines: a 360-degree view

Carey Payette

Trillium Innovations

Learn how to leverage Azure Synapse Analytics pipelines in enterprise-scale data workloads. We will discuss components associated with running a pipeline, such as linked services, datasets, triggers, and integration runtime.… Show more

Type: General Session (60-minutes)

Theme: Reach for the Clouds

Track: Development

Level: 100 (Foundational)

Learning Pathway: Become an Azure Data Engineer

Azure Synapse Analytics SQL Pools Performance Tips and Tricks

David Alzamendi

Data Architect

In this session, I’ll share the recipe for 5 tips and tricks to help you optimize the state of your Azure Synapse Analytics SQL Pools and ensure that your platform… Show more

Type: Lightning Talk* (10-minutes)

Theme: Level Up

Track: Analytics

Level: 200 (Intermediate)

Azure all the things! End-to-end deployment pipelines for Azure SQL Database using Flyway and ADO
Christopher Unwin
Solutions Architect (Redgate) and Blogger at PlantBasedSQL.com
```
Flyway is a flexible, light weight and free deployment tool that supports 21 RDBMs'. Pair this with an Azure SQL Database and Azure DevOps deployment pipeline and you have yourself… Show more 
```
Type: General Session (60-minutes)
Theme: Reach for the Clouds
Track: Development
Level: 200 (Intermediate)

Azure machine learning for the absolute beginner

Alexander Arvidsson

Star Wars fan extraordinaire

Machine learning is one of the hottest trends on the market. According to the popular belief, machine learning will help you do everything from water your plants to running your… Show more

Type: General Session (60-minutes)

Theme: Back to Basics

Track: Analytics

Level: 100 (Foundational)

Backup Basics with Powershell and dbatools
Andy Levy
Database Administrator, dbatools fanatic, and transportation for @SqlHat
```
As DBAs, one of our top priorities is keeping the organization's data backed up and ready to be restored when needed. We also need to be prepared to answer questions… Show more 
```
Type: General Session (60-minutes)
Theme: Back to Basics
Track: Database Management
Level: 200 (Intermediate)
Become a Contributor to Microsoft Docs
William Assaf
Senior Content Developer, Microsoft
```
Meet the Microsoft SQL Docs Team for Q&A and the latest on Microsoft's open source Docs on Github. Learn about the content publishing engines behind Docs, and the best ways… Show more 
```
Type: General Session (60-minutes)
Theme: Level Up
Track: Professional Development
Level: 100 (Foundational)

Benefits of enabling IaaS Agent Extension on Azure SQL VM

Ameena Lalani

Together we learn more

SQL Server IaaS Agent Extension, formerly known as Resource Provider, enables additional management capabilities for self-installed SQL Server on Azure VMs. It provides PaaS-like capabilities to IaaS-based SQL for customers… Show more

Type: Lightning Talk* (10-minutes)

Theme: Reach for the Clouds

Track: Database Management

Level: 200 (Intermediate)

Best Practices for Delivering and Sharing Content in the Power BI Service
Melissa Coates
Data architect | Owner of Coates Data Strategies
```
The Power BI Service offers several ways to distribute and share content for internal colleagues and external users. We will discuss when using the sharing functionality is most appropriate, techniques… Show more 
```
Type: General Session (60-minutes)
Theme: Back to Basics
Track: Analytics
Level: 200 (Intermediate)
Learning Pathway: Power BI
Best friends? Let's talk about the Relationship of Power BI and Azure Synapse Analytics
Wolfgang Strasser
data juggler
```
Azure Synapse Analytics is the new star in the cloud data analytics field.
With the goal of combining enterprise data warehousing and Big Data analytics, this service provides an end-to-end solution… Show more 
```
Type: General Session (60-minutes)
Theme: Reach for the Clouds
Track: Analytics
Level: 100 (Foundational)
"Black Arts" Index Maintenance - LOBs - Defragmented by Default
Jeff Moden
Performance is in the code.
```
This is NOT your typical session on indexes.

When Microsoft introduced the MAX and XML data-types, they also made a mostly unknown change as to how the LOBs are handled. … Show more 
```
Type: General Session (60-minutes)
Theme: Level Up
Track: Database Management
Level: 300 (Advanced)
Breaking the fourth wall - connecting to audiences with your presentations
Rob Farley
Draws on the screen
```
Creating a presentation isn’t easy and neither is attending a presentation. Reading a thousand slides in dozens of presentations over a few days at a conference can make the most… Show more 
```
Type: General Session (60-minutes)
Theme: Level Up
Track: Professional Development
Level: 200 (Intermediate)
Breaking up your Monolithic Databases into Purpose-built Database
Kathleen Li
AWS -Data & Analytics specialist Solution Architect
```
Picking a database is a relatively long-term commitment for a modernization application. In order to make a wise decision, we need to understand various database types well. Specifically, we look… Show more 
```
Type: Lightning Talk* (10-minutes)
Theme: Level Up
Track: Architecture
Level: 200 (Intermediate)
Build Serverless, Full Stack Applications in Azure SQL (plus IoT!)
Anna Hoffman
Data & Applied Scientist
Davide Mauri
Senior Program Manager
Silvano Coriani
Principal Software Engineer
Sanjay Mishra
Principal Group PM Manager
```
In this workshop, join the Azure SQL Product Group to learn how developing apps with modern database capabilities, CI/CD and DevOps, backend API development, Iot, and more become easier, more… Show more 
```
Type: Pre-conference Session (Full-day)
Pre-conference day: Tuesday
Theme: Level Up
Track: Architecture
Level: 200 (Intermediate)
Build a Blog Worth Reading
Blythe Morrow
Blythe Morrow, Managing Director at Paper Sword B2B
```
Creating a blog worth reading is no easy task. It’s a fine balance between consistency, topic choice, readability, and SEO magic. Join marketing expert Blythe Morrow as we discuss how… Show more 
```
Type: General Session (60-minutes)
Theme: Reach for the Clouds
Track: Professional Development
Level: 100 (Foundational)
Building Your First Data Pipeline in Apache Spark
Kevin Feasel
CTO @ FareGame Inc
```
As a data engineer, the Apache Spark platform provides a great deal of functionality designed to solve common problems around data movement and processing, particularly in the cloud.  In… Show more 
```
Type: General Session (60-minutes)
Theme: Reach for the Clouds
Track: Analytics
Level: 100 (Foundational)
Learning Pathway: Become an Azure Data Engineer
Building an Azure Data Science Environment in Azure Synapse Analytics Workspaces
Bradley Ball
Microsoft - Sr. FastTrack Azure Engineer
```
In session we will build an end to end data platform workload. We will utilize the new Azure Synapse Analytics Workspaces environments to access Azure Data Factory and the Integrated… Show more 
```
Type: Half-day Session (2.5-hours)
Theme: Reach for the Clouds
Track: Analytics
Level: 200 (Intermediate)
CTEs vs Table Variables vs Temporary Tables
Dale Sullenberger
Sr. DBA / Manager of Database Administration, WelldyneRx
```
The temporary object you choose could have big impacts on performance. Each has its pros and cons, but understanding some of the basics of how the database engine uses them,… Show more 
```
Type: Lightning Talk* (10-minutes)
Theme: Level Up
Track: Development
Level: 200 (Intermediate)

Can SQL server run on Kubernetes?

Simon Cho

Director of DevOps @Nowcom. Prior Staff Database Engineer @VISA

Kubernetes is very popular platform that can orchestrate containers.
SQL server also support Kubernetes and it has benefit to use on Kubernetes as well.

This session covers that items in the below.

*… Show more

Type: General Session (60-minutes)

Theme: Level Up

Track: Database Management

Level: 200 (Intermediate)

Choosing the Right Tool for the Job

Deborah Melkin

SQL Developer

There’s a saying about using the right tool for the right job. After all, you don't want to use a hammer when you need a screwdriver. We have many tools… Show more

Type: General Session (60-minutes)

Theme: Back to Basics

Track: Database Management

Level: 100 (Foundational)

Clustering and Segmentation In Power BI

SANDEEP PAWAR

Simulation & Data Analytics Engineer

Power BI has native clustering capabilities that aren't used as much. In this session, I will show you can use the clustering technique to gain insights from the data and… Show more

Type: Lightning Talk* (10-minutes)

Theme: Level Up

Track: Analytics

Level: 200 (Intermediate)

Common SQL patterns to avoid for best performance
Bert Scalzo
Database Consultant, BS Consulting
```
When a database is slow, 90% of the time bad SQL is the culprit. The underlying issue can be either poor design or inefficient SQL coding. Knowing what common issues… Show more 
```
Type: General Session (60-minutes)
Theme: Back to Basics
Track: Development
Level: 100 (Foundational)
Compression, Dedupe, Encryption Conundrums in Cloud
Tejas Chopra
Senior Software Engineer, Netflix
```
Cloud storage footprint is in exabytes and exponentially growing and companies pay billions of dollars to store and retrieve data. In this talk, we will cover some of the space… Show more 
```
Type: General Session (60-minutes)
Theme: Reach for the Clouds
Track: Architecture
Level: 300 (Advanced)
Control your cloud data deployments - Deploy your Azure Data Solutions with Bicep and Azure DevOps
Rob Sewell
Be-Whiskered PowerShell Ninja
```
Lets migrate to the cloud.
 
You can go to the portal and click in the blades and manually create all of the resources that you need. Such as Azure SQL… Show more 
```
Type: General Session (60-minutes)
Theme: Reach for the Clouds
Track: Architecture
Level: 100 (Foundational)
Learning Pathway: Cloud Migrations
Control your cloud data deployments - Deploy your Azure Data Solutions with Bicep and Azure DevOps
Rob Sewell
Be-Whiskered PowerShell Ninja
```
You can go to the portal and click in the blades and manually create all of the resources that you need. Such as Azure SQL Databases, Azure SQL VMs, Azure… Show more 
```
Type: Pre-conference Session (Full-day)
Pre-conference day: Monday
Theme: Level Up
Track: Architecture
Level: 100 (Foundational)

Creating Something from Nothing

Matityahu Sarafzadeh

Senior Data Scientist at Soluto

Soluto's flagship product is called Anywhere experts, a platform for experts to support end user's technical issues. A notable feature, known as the Canned Messages feature, was created to help… Show more

Type: Lightning Talk* (10-minutes)

Theme: Back to Basics, Level Up

Track: Development

Level: 100 (Foundational)

Creating a Logical Data Warehouse using Azure Synapse Analytics Serverless SQL Pools
Andy Cutler
Independent Business Intelligence Consultant
```
In this session we'll be creating a Logical Data Warehouse using Serverless SQL Pools.  We'll go through what a Logical Data Warehouse is and how Serverless SQL Pools supports… Show more 
```
Type: General Session (60-minutes)
Theme: Reach for the Clouds
Track: Architecture
Level: 200 (Intermediate)
Custom SSIS Dataflow Script Components for Complex Import, Transform, and Export
luther atkinson
Business Intelligence Developer, Abbott Labs
```
SQL Server Integration Services (SSIS) is great at importing or exporting files with known format and number of columns. But what happens when the client leaves out a delimiter, or… Show more 
```
Type: General Session (60-minutes)
Theme: Back to Basics
Track: Development
Level: 200 (Intermediate)
DBA Basics: Getting Started with Performance Tuning
John Sterrett
Tuning mission critical workloads for over a decade.
```
Have you ever found yourself in need of making queries go faster but didn't know where to begin? In this session, you will learn multiple ways to find your top… Show more 
```
Type: General Session (60-minutes)
Theme: Back to Basics
Track: Database Management
Level: 100 (Foundational)
Learning Pathway: DBA Basics
DBA Red Team vs DEV Blue Team or "How to communicate with your Entity Framework developers."
Karim Ourtani
A passionate problem solver
```
Entity Framework (EF) has been around for some time, and what never seems to amaze me is the way in which developers and DBA's still don't seem to agree on… Show more 
```
Type: General Session (60-minutes)
Theme: Back to Basics
Track: Database Management
Level: 200 (Intermediate)

DBA in the Cloud

Deepthi Goguri

SQL Database Administrator

Are you a DBA and interested in learning about Azure SQL database but do not know where to start? Do you wonder if being on Azure environments will limit your… Show more

Type: General Session (60-minutes)

Theme: Reach for the Clouds

Track: Database Management

Level: 200 (Intermediate)

DIY Database Clones

Tonie Huizer

Solutions Architect, Writer and Speaker at Promicro

Summary:
---------------
Database DevOps techniques require an easy way to provision many copies of a database, even a large database, for development work and especially for testing work. Ideally, these databases should… Show more

Type: General Session (60-minutes)

Theme: Level Up

Track: Database Management

Level: 300 (Advanced)

Data Modeling for Analytics on Azure
Ike Ellis
General Manager - Data & AI, Solliance
```
There has been so much change in analytical data modeling in recent years.  Come to this session to learn:

* Why star schemas are still important
* What are star schemas
*… Show more 
```
Type: General Session (60-minutes)
Theme: Reach for the Clouds
Track: Analytics
Level: 200 (Intermediate)
Learning Pathway: Become an Azure Data Engineer
Data Modeling for the Beginner
Leslie Weed
The Data Factor
Jeff Renz
Principle Data and Analytics Architect
```
Organizing data into proper tables for both intent of storage and usage is important and can be a performance game changer.  Learn the basics of some different modeling techniques… Show more 
```
Type: General Session (60-minutes)
Theme: Back to Basics
Track: Architecture
Level: 100 (Foundational)
Data Modelling in Azure Cosmos DB
Will Velida
Azure Integration Consultant, Datacom | Microsoft Data Platform MVP
```
Modelling your data correctly is vital when building efficient applications that use Azure Cosmos DB. Proper data modelling allows us to easily scale our Cosmos DB resources as our applications… Show more 
```
Type: General Session (60-minutes)
Theme: Reach for the Clouds
Track: Architecture
Level: 300 (Advanced)
Data Pages, Allocation Units, IAM chains Oh My!…
Brandon Leach
Microsoft Data Platform MVP
```
Understanding how SQL Server organizes your data can seem like a daunting task.  But we will make it fun by telling humorous stories from my past as we go… Show more 
```
Type: General Session (60-minutes)
Theme: Level Up
Track: Database Management
Level: 200 (Intermediate)
Database Administration: The first 30 days.
Michael Walsh
CEO Straight Path IT Solutions
```
So you are a Database Administrator, congratulations! Where do you start, though? Well, naturally, at the beginning. . . In this session, we'll discuss what to start focusing on right… Show more 
```
Type: General Session (60-minutes)
Theme: Back to Basics
Track: Database Management
Level: 100 (Foundational)
Learning Pathway: DBA Basics
Database Administration for the Non Database Administrator
Denny Cherry
Owner and Principal Consultant, Denny Cherry & Associates Consulting
```
In this all day session on Microsoft SQL Server we will be learning about how Microsoft SQL Server works and what needs to be done to keep it up and… Show more 
```
Type: Pre-conference Session (Full-day)
Pre-conference day: Tuesday
Theme: Level Up
Track: Database Management
Level: 100 (Foundational)
Database Administration for the non-DBA
Denny Cherry
Owner and Principal Consultant, Denny Cherry & Associates Consulting
```
Are you a developer or a systems admin and you've just been handed a SQL Server database and you've got no idea what to do with it?  I've got… Show more 
```
Type: General Session (60-minutes)
Theme: Back to Basics
Track: Database Management
Level: 100 (Foundational)

Database Projects 101 in ADS

Warwick Rudd

SQL Masters Consulting, Principal Consultant, MVP, MCM

Database Projects are an important aspect in the Data Professional's skills and knowledge. Azure Data Studio provides a fantastic starting place for data professionals to learn and implement Database Projects… Show more

Type: General Session (60-minutes)

Theme: Back to Basics

Track: Database Management

Level: 100 (Foundational)

Database recovery in SQL 2019: what's new

Gilberto Zampatti

v-PFE at Microsoft

The session tries to explain  the Accelerated database recovery (ADR) feature. It improves database availability, especially in the presence of long running transactions, by redesigning the SQL database engine recovery… Show more

Type: General Session (60-minutes)

Theme: Back to Basics

Track: Database Management

Level: 200 (Intermediate)

Databricks for the SQL Developer
Gerhard Brueckl
Cloud Data Platform Architect
```
Big Data and SQL do not have a lot in common. However, over the last couple of years this changed, and more and more people want to integrate the data… Show more 
```
Type: General Session (60-minutes)
Theme: Reach for the Clouds
Track: Analytics
Level: 200 (Intermediate)

Demystifying AWS Identity (Auth...Auth...)

Amit Jha

Developer Adv./Architect - AWS

Cloud Journey starts with understanding security first. Authentication & Authorization is primary & fundamental ask from any enterprise moving a workload/application to the cloud.

Come to this session to understand
- AWS… Show more

Type: Lightning Talk* (10-minutes)

Theme: Reach for the Clouds

Track: Architecture

Level: 200 (Intermediate)

Demystifying Statistics in SQL Server
Erin Stellato
Principal Consultant at SQLskills
```
Troubleshooting performance issues and tuning queries can be easier with some level of understanding about statistics.  Something you may hear people talk about as part of query tuning are… Show more 
```
Type: General Session (60-minutes)
Theme: Level Up
Track: Database Management
Level: 200 (Intermediate)
Learning Pathway: Query Tuning

DevOps 101 for Data Folks

Alex Yates

I help orgs to not suck at delivering databases

DevOps has fundamentally changed the way we manage IT. Those practicing DevOps well aren't just outpacing their competitors, they are annihilating them.

DevOps brings a whole host of new practices, tools… Show more

Type: General Session (60-minutes)

Theme: Back to Basics

Track: Development

Level: 100 (Foundational)

Learning Pathway: Database DevOps

DevOps for Power BI
Jan Mulkens
Microsoft Data Platform & BI Consultant
```
Have you heard yet that everyone needs to be DevOpsing in a DevOps Team as a DevOps with DevOps tooling? If so, forget about it. If not, great!
This session leaves… Show more 
```
Type: General Session (60-minutes)
Theme: Back to Basics
Track: Analytics
Level: 100 (Foundational)
Learning Pathway: Database DevOps
Developing data solutions with Python and Apache Spark in Azure Synapse Analytics
Ginger Grant
Principal Data Geek at Desert Isle Group
```
There are a number of different features that you can perform with Python using Apache Spark as part of a data solution including Data Exploration, Delta Lake, ETL, Data Engineering,… Show more 
```
Type: Pre-conference Session (Full-day)
Pre-conference day: Tuesday
Theme: Reach for the Clouds
Track: Analytics
Level: 100 (Foundational)

Development Lifecycle Basics for DBAs

Eitan Blumin

The fastest DBA alive

What is source control? What is version history? What are unit tests? What do CI and CD even mean, and what the heck is an Artifact?? In this new era… Show more

Type: General Session (60-minutes)

Theme: Level Up

Track: Development

Level: 100 (Foundational)

Diagnosing Entity Framework Performance with SQL Monitor & Logging

Mitchel Sellers

Flying Code Ninja!

Entity Framework (EF) is amazing, however, with its great power can come great confusion when it comes to performance issues and diagnostics.  This session will take a deep dive… Show more

Type: General Session (60-minutes)

Theme: Level Up

Track: Architecture

Level: 200 (Intermediate)

Disaster Recovery Techniques for Azure SQL DB & Managed Instance
John Morehouse
Providing business solutions with SQL Server one problem at a time...
```
A database is often the heart and soul of any application. The data contained within it is the business so ensuring that it's protected is a great thing and is… Show more 
```
Type: General Session (60-minutes)
Theme: Reach for the Clouds
Track: Database Management
Level: 200 (Intermediate)
Drop it Like It's Hot! Safely Dropping (and Instantly Restoring) Database Objects
Pamela Mooney
Senior DBA, NISA Investment Advisors, LLC
```
How many times have you received a request to drop a stored procedure, view, function or (yikes) a table, only to hear the next day, "Oops!  I didn't think… Show more 
```
Type: General Session (60-minutes)
Theme: Back to Basics
Track: Database Management
Level: 200 (Intermediate)
Duet about which parts of Azure DevOps and GitHub to use together
Kevin Chant
Lead BI & Analytics Architect
Sander Stad
Data Masterminds, PowerShell Underdog
```
In this session we have a roleplay scenario where a Data Platform Development and Operations teams have merged together into one DevOps team. One heavily uses Azure DevOps and the… Show more 
```
Type: General Session (60-minutes)
Theme: Reach for the Clouds
Track: Development
Level: 200 (Intermediate)

Effective Public Speaking in Tech

Edward Pollack

Sr. Database Administrator, Datto Inc.

Public speaking is a critical life skill that benefits anyone in any field.  The ability to effectively communicate ideas in meetings, presentations, or interviews is necessary to make the… Show more

Type: General Session (60-minutes)

Theme: Level Up

Track: Professional Development

Level: 100 (Foundational)

Error and Transaction Handling in SQL Server

Erland Sommarskog

Erland Sommarskog SQL-Konsult AB

Most modern programming environments offers exception handling in some form, and SQL Server provides the popular TRY-CATCH concept. However, error handling in SQL Server is not as straightforward as one… Show more

Type: General Session (60-minutes)

Theme: Back to Basics

Track: Development

Level: 200 (Intermediate)

Every Millisecond Counts

Jared Poche

Database Engineer - ChannelAdvisor

Query optimization is relatively easy when you look at a plan and find table scans, hash match joins, and missing indexes. But how do you find opportunities when all the… Show more

Type: General Session (60-minutes)

Theme: Back to Basics

Track: Development

Level: 200 (Intermediate)

Everyone has a front-row seat: How to give an awesome virtual presentation
Erik Monchen
Team Lead Business Intelligence at DYMATRIX Consulting Group GmbH
```
As we see the light at the end of the pandemic-tunnel and start attending conferences again, times have changed and online conferences will most likely not disappear again. As some… Show more 
```
Type: General Session (60-minutes)
Theme: Level Up
Track: Professional Development
Level: 100 (Foundational)
Failover Clusters for the Modern Public Cloud
Tom Willwerth
Senior Consultant / DBA at Straight Path Solutions
```
SQL Server Failover Clusters can be a great option for achieving high availability in the cloud, often with less hassle and cost than other solutions, and are Standard Edition friendly.
In… Show more 
```
Type: General Session (60-minutes)
Theme: Reach for the Clouds
Track: Database Management
Level: 200 (Intermediate)
Fast Forward your Career by leveraging the Community
Koen Verbeeck
Senior Consultant @ AE - Data Platform MVP
```
Getting involved in the Data Platform community can be beneficial for your career, both short-term as long-term. Not everyone has the desire to jump on a stage and start speaking… Show more 
```
Type: General Session (60-minutes)
Theme: Level Up
Track: Professional Development
Level: 100 (Foundational)
Finding Problems and Stabilizing Performance with Query Store
Erin Stellato
Principal Consultant at SQLskills
```
As a data professional you often get pulled in to troubleshoot a drop in performance, and it can be stressful.  Then, when you figure out the issue, people want… Show more 
```
Type: Pre-conference Session (Full-day)
Pre-conference day: Tuesday
Theme: Back to Basics
Track: Database Management
Level: 200 (Intermediate)

Getting Started: Accelerated Database Recovery

John Deardurff

That Awesome Trainer

SQL Server 2019 redesigned the database engine recovery process to improves database availability. See how Accelerated Database Recovery (ADR) provides lightning-fast database recovery, instantaneous transaction rollback, and aggressive log truncation.

Type: General Session (60-minutes)

Theme: Back to Basics

Track: Database Management

Level: 100 (Foundational)

Getting Started with Amazon Aurora PostgreSQL

Shayon Sanyal

Sr Database Specialist Solutions Architect (AWS)

Amazon Aurora is a relational database service that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. The PostgreSQL-compatible edition of… Show more

Type: General Session (60-minutes)

Theme: Reach for the Clouds

Track: Database Management

Level: 200 (Intermediate)

Getting Started with Azure Databricks: Data Engineering
Douglas Leal
Director of Consulting (Data & Analytics) at CGI
```
Azure Databricks, based on Apache Spark, is a fast, easy-to-use, and scalable data platform. 
In this session, you will learn what is Azure Databricks and Apache Spark, why we need… Show more 
```
Type: General Session (60-minutes)
Theme: Back to Basics
Track: Development
Level: 100 (Foundational)
Getting and Nailing Azure Interviews
Paresh Motiwala
Data Platform Manager
```
Are you stuck in your existing job for years? Do you feel you need to get out, try either a new company or a new role; or even a new… Show more 
```
Type: General Session (60-minutes)
Theme: Reach for the Clouds
Track: Professional Development
Level: 100 (Foundational)
Getting started with Machine Learning in Azure Synapse Analytics and Azure ML
Ginger Grant
Principal Data Geek at Desert Isle Group
```
In this session we are going to look at algorithm selection for Machine Learning, and look at how we can use machine learning to pick the best algorithm with Azure… Show more 
```
Type: General Session (60-minutes)
Theme: Reach for the Clouds
Track: Analytics
Level: 200 (Intermediate)
Learning Pathway: AI & ML
Getting started with Python for Data professionals
Indira Bandari
Data Platform MVP | Senior Data and BI Consultant
```
Python is one of the valuable skills needed in these modern days if you want to become a data scientist.

In this session I will cover the basics libraries of Python… Show more 
```
Type: General Session (60-minutes)
Theme: Back to Basics
Track: Analytics
Level: 100 (Foundational)
Hacking SQL Server Another Day
André Melancia
Developer / DBA / Microsoft Certified Trainer (MCT)
```
This is a demo-driven session, suited for DBAs, developers and security consultants. Both exploits and security recommendations to avoid them will be covered.
Disclaimer: No actual crimes will be committed. Please… Show more 
```
Type: Half-day Session (2.5-hours)
Theme: Back to Basics
Track: Database Management
Level: 200 (Intermediate)
Learning Pathway: Data Security & Governance
Here’s the execution plan … now what?
Hugo Kornelis
I make SQL Server fast (.com)
```
You have learned the relevance of execution plans. You know where to find them, and you’ve been taught the basics of how to read them. You’ve looked at some of… Show more 
```
Type: General Session (60-minutes)
Theme: Back to Basics
Track: Development
Level: 200 (Intermediate)
Learning Pathway: Query Tuning
High Availability Basics for the DBA: What SQL Server Cannot Do For You
Edwin M Sarmiento
Managing Director; Microsoft Certified Master: SQL Server
```
With the different high availability features that SQL Server provides, it can be tempting to implement Always On Availability Groups because that's what most people recommend. However, just because you… Show more 
```
Type: General Session (60-minutes)
Theme: Back to Basics
Track: Database Management
Level: 100 (Foundational)
Learning Pathway: DBA Basics

High Availability/Disaster Recovery 101

Glenn Berry

Glenn Berry, Principal Consultant

How do you design a SQL Server 2019 infrastructure in order to meet specific Recovery Time Objective (RTO) and Recovery Point Objective (RPO) service levels? There are many aspects to… Show more

Type: General Session (60-minutes)

Theme: Back to Basics

Track: Database Management

Level: 100 (Foundational)

High Availability and Disaster Recovery with dbatools
Tracy Boggiano
Database Superhero at DocuSign
```
So, you need to provide high availability and disaster recovery for your environment?  SQL Server options several options that fall into either category.  We will learn about the… Show more 
```
Type: General Session (60-minutes)
Theme: Level Up
Track: Database Management
Level: 200 (Intermediate)
Hitting the Bricks with Azure Databricks
Andie Letourneau
Senior BI Consultant, 3 Cloud Solutions
```
Do you want to take the next step in your career as a Data Engineer? 
Attend this introductory session and learn how to create your first Azure Databricks cluster, use… Show more 
```
Type: General Session (60-minutes)
Theme: Reach for the Clouds
Track: Development
Level: 100 (Foundational)

How DBAs Can Launch a Data Governance Program

Kevin Kline

Head Geek

When organizations are small and simple, information technology is often thought of as just a means to support their their business. But as organizations grow in complexity and sophistication, they… Show more

Type: General Session (60-minutes)

Theme: Back to Basics

Track: Database Management

Level: 100 (Foundational)

Learning Pathway: Data Security & Governance

How To Tune A Multi-Terabyte Database For Optimum Performance
Jeff Taylor
Software & Data Architect
```
This session will cover how to tune a multi-terabyte database. We will look at infrastructure, data types, file groups, managing indexes, and moving large amounts of data.
```
Type: Half-day Session (2.5-hours)
Theme: Level Up
Track: Architecture
Level: 200 (Intermediate)
How secure is your Azure SQL DB?
Manish Kumar
Sr Cloud Solution Architect at Microsoft
```
How secure is your Azure SQL DB?
Data Security is one of the most important aspects that must be considered and well architected for cloud databases. Give your 10 mins to… Show more 
```
Type: Lightning Talk* (10-minutes)
Theme: Reach for the Clouds
Track: Database Management
Level: 200 (Intermediate)

How to Audit SQL Server for Free

Josephine Bush

DBA, MBA, Author

Are you tired of not knowing who's changing what on your SQL Servers?  Maybe your company can’t afford to buy third-party auditing tools, but there's no need to buy… Show more

Type: General Session (60-minutes)

Theme: Level Up

Track: Database Management

Level: 200 (Intermediate)

How to Deploy Highly Available AGs Across Containers in Azure

Connor Cox

Product Manager @ DH2i

The use of SQL Server containers is exploding as enterprises look for better ways to improve the performance, scalability and portability of their IT environments. Despite the promise of containers,… Show more

Type: General Session (60-minutes)

Theme: Reach for the Clouds

Track: Architecture

Level: 200 (Intermediate)

How to analyze stock data with Python

Danilo Dominici

Microsoft Data Platform enthusiast

A quick introduction to Python’s libraries to manage, analyze and show stock data: how to use pandas, numpy, matplotlib to do some calculations, create statistics indicators and show in a… Show more

Type: Lightning Talk* (10-minutes)

Theme: Level Up

Track: Analytics

Level: 200 (Intermediate)

How to reduce your SQL Database costs on Azure
Leonardo Fonseca
MCT | MCSE | DBA @ Localiza
Sulamita Dantas
Administradora de Banco de Dados & Analista BI
```
In this lightning talk we will show how to reduce your SQL Database costs on Azure!
```
Type: Lightning Talk* (10-minutes)
Theme: Reach for the Clouds
Track: Architecture
Level: 100 (Foundational)

How to solve common data security requirements

Pieter Vanhove

Microsoft, Domain Solution Architect - Data & AI

Cloud computing requires new security paradigms that are unfamiliar to many application users, database administrators, and programmers. As a result, some organizations are hesitant to implement a cloud infrastructure for… Show more

Type: General Session (60-minutes)

Theme: Reach for the Clouds

Track: Architecture

Level: 200 (Intermediate)

Identify Poorly Performing Queries - Three Tools You Already Own
Grant Fritchey
Redgate Software
```
One of the first challenges you’ll face when you decide to address poor query performance is identifying which query you should focus on. While you can simply wait for the… Show more 
```
Type: General Session (60-minutes)
Theme: Back to Basics
Track: Database Management
Level: 100 (Foundational)
Learning Pathway: Query Tuning

Identifying Bias

LaShana Lewis

L. M. Lewis Consulting, Chief Executive Officer

Think bias doesn't play a role in IT? Learn how to mitigate it, along with addressing and identifying microaggressions. We'll walk through some scenarios and teach you steps to take… Show more

Type: General Session (60-minutes)

Theme: Level Up

Track: DE&I

Level: 100 (Foundational)

I lost my job! Now what?!? A survival guide for the unemployed
Ray Kim
Technical Writer at Pluto TV
```
You’ve just been told by HR that you are no longer a part of their organization. You’ve been kicked to the curb. You are now living in the no-man’s land… Show more 
```
Type: General Session (60-minutes)
Theme: Back to Basics
Track: Professional Development
Level: 100 (Foundational)

Improve Database Scale for Strong Consistency without Code Changes

Roland Lee

Heimdall Data, VP of Products

Scaling out your SQL database involves separating the write-master from read replicas. However, there could be data inconsistency due to synchronization delays.

In this session, will discuss:
    … Show more

Type: Lightning Talk* (10-minutes)

Theme: Back to Basics

Track: Architecture

Level: 100 (Foundational)

Improve Database Write-Master Scale for Strong Consistency

Erik Brandsberg

CTO, Heimdall Data

Scaling out your SQL database involves separating the write-master from read replicas. However, it requires code changes and the risk of data inconsistency. 

In this session, will discuss:
  … Show more

Type: General Session (60-minutes)

Theme: Level Up

Track: Database Management

Level: 200 (Intermediate)

Indexing for Performance
Kimberly L. Tripp
Working at SQLskills and with SQL Server since 1990 and I still love it!
```
Indexes are one of the most important pieces in performance tuning - they can help queries seek to find a small number of records, efficiently scan for sets, use batch… Show more 
```
Type: General Session (60-minutes)
Theme: Level Up
Track: Database Management
Level: 200 (Intermediate)
Learning Pathway: Query Tuning
Introduction to GitHub for Data Professionals
Joshua Higginbotham
Microsoft Data Platform MVP, Data Services Manager, Army Vet
```
Getting started with GitHub can at times be overwhelming. Especially when you've been working with other source control and project management systems your whole career. In this session, we will… Show more 
```
Type: General Session (60-minutes)
Theme: Level Up
Track: Development
Level: 100 (Foundational)
Introduction to Machine Learning using Azure ML
Jamey Johnston
Senior Data Scientist/Engineer and Professor
```
Using Azure ML you will learn the basics of Machine Learning (ML) algorithms using real data. We will explore the different types of ML algorithms and how, why and when… Show more 
```
Type: General Session (60-minutes)
Theme: Back to Basics
Track: Analytics
Level: 100 (Foundational)
Learning Pathway: AI & ML
Introduction to SQL | Expanding on Select *
Mariano KOVO
MVP Data Platform - CEO Precision IT
```
SQL is a core part of working in modern data environments.  Once you feel comfortable with the data tools, you’ll want to know how to interact with data more… Show more 
```
Type: General Session (60-minutes)
Theme: Back to Basics
Track: Development
Level: 100 (Foundational)
Learning Pathway: Query Basics
Introduction to SQL | Getting Started
Amanda Halverson
Operations Manager, SQL Data Partners
Carlos Chacon
Compañero!
```
SQL is a core part of working in modern data environments and knowing the basics is a must. We all have to start somewhere, and this session is the first… Show more 
```
Type: General Session (60-minutes)
Theme: Back to Basics
Track: Development
Level: 100 (Foundational)
Learning Pathway: Query Basics
Introduction to SQL | How to change existing data
Brian Combs
Brian Combs - SQL Consultant
```
SQL is a core part of working in modern data environments.  Sometimes you will need to change data and this session will walk you through inserting and updating records… Show more 
```
Type: General Session (60-minutes)
Theme: Back to Basics
Track: Development
Level: 100 (Foundational)
Learning Pathway: Query Basics
Introduction to SQL | Level up with advanced features
Eugene Meidinger
Making BI approachable and accessible
```
SQL is a core part of working in modern data environments.  In the last session of the series, we’ll touch on advanced features like constraints, subqueries, formatting data and… Show more 
```
Type: General Session (60-minutes)
Theme: Back to Basics
Track: Development
Level: 100 (Foundational)
Learning Pathway: Query Basics
Introduction to SQL | More than just tables
Carlos Chacon
Compañero!
```
SQL is a core part of working in modern data environments.  As you feel comfortable searching and updating data, we can introduce you to how tables are created and… Show more 
```
Type: General Session (60-minutes)
Theme: Back to Basics
Track: Development
Level: 100 (Foundational)
Learning Pathway: Query Basics
Introduction to Unit Testing with tSQLt
Sebastian Meine
Helping teams build confidence and deliver value with Data Platform DevOps
```
Do you want to make it easier to find and fix issues with your SQL Server application? Do you sometimes feel anxious before a release, because you aren’t quite sure… Show more 
```
Type: General Session (60-minutes)
Theme: Back to Basics
Track: Development
Level: 100 (Foundational)
Learning Pathway: Database DevOps
Intro to Azure Data Factory for SSIS Developers
Brijeet Akula
Nordic Consulting - Cloud/Data Architect
```
Its 2021, and bit by bit, more things are starting to move to the cloud! You are an SSIS developer and have already tinkered around with some of the offerings… Show more 
```
Type: General Session (60-minutes)
Theme: Reach for the Clouds
Track: Development
Level: 100 (Foundational)

Intro to Dataverse inside of Power Automate

David Patrick

MCT, MCSD, MCSE, MVP

Microsoft Dataverse (formerly known as the Common Data Service) lets you securely store and manage data that's used by business applications. Data within Dataverse is stored within a set of… Show more

Type: Lightning Talk* (10-minutes)

Theme: Reach for the Clouds

Track: Development

Level: 200 (Intermediate)

Journey to the Cloud Lakehouse (Snowflake and Azure)
Puneet Srivastava
Citrix Systems, Senior Manager, Enterprise Data and Analytics (IT)
Hossein Fallahzadeh
SVP Data and Analytics
```
The intent of the session is to walk through our migration journey to snowflake and Azure Cloud
```
Type: Lightning Talk* (10-minutes)
Theme: Reach for the Clouds
Track: Architecture
Level: 200 (Intermediate)

Keeping it Classy: Designing a Great Classifier

Kevin Feasel

CTO @ FareGame Inc

Classification is one of the core workloads in machine learning and a natural starting point for budding data scientists.  Humans have a natural inclination to classify things--that cloud looks… Show more

Type: General Session (60-minutes)

Theme: Level Up

Track: Analytics

Level: 200 (Intermediate)

Learning Pathway: AI & ML

Keeping your Data Fresh in Power BI
Patrick LeBlanc
Principal Program Manager, MIcrosoft
Adam Saxton
Principal Program Manager, Microsoft
```
We all want our data refresh to happen quickly so the most current data is available for our reports. In this session we will walk you through options to configure… Show more 
```
Type: General Session (60-minutes)
Theme: Level Up
Track: Analytics
Level: 200 (Intermediate)
Learn Different Options to Calculate the Amount of Stock On-hand
Kelly Broekstra
General Manager and Solution Specialist at LobsterPot Solutions
```
There are many different ways to model your inventory data. In this session, we will talk about various modelling techniques and their pros and cons so that you can decide… Show more 
```
Type: Lightning Talk* (10-minutes)
Theme: Back to Basics
Track: Analytics
Level: 200 (Intermediate)

Learning PowerShell as a DBA

Ben Miller

DBAduck

There are a lot of people talking about PowerShell and they should be. Where are you in the PowerShell continuum? As one of the original PowerShell DBAs, I have been… Show more

Type: General Session (60-minutes)

Theme: Back to Basics

Track: Database Management

Level: 100 (Foundational)

Learning to present and becoming good at it
James Serra
Big Data/Data Warehouse Evangelist at Microsoft
```
Have you been thinking about presenting at a user group?  Are you being asked to present at your work?  Is learning to present one of the keys to… Show more 
```
Type: General Session (60-minutes)
Theme: Level Up
Track: Professional Development
Level: 100 (Foundational)

Lessons from spreadsheet data horror stories

Patrick O'Beirne

Excel/VBA consultant

There are many pitfalls in using Microsoft Excel to processing important data. I present published reports of horror stories and draw lessons from them. Firstly, how unskilled Excel users corrupted… Show more

Type: Lightning Talk* (10-minutes)

Theme: Back to Basics

Track: Analytics

Level: 200 (Intermediate)

Let's Learn DAX

Hasham Niaz

Data & Analytics , BlizTech

This session will walk you through DAX basics concepts, even though people writing DAX for many years just ignore these basics and only rely on hit & try method;
Learn DAX… Show more

Type: General Session (60-minutes)

Theme: Level Up

Track: Analytics

Level: 200 (Intermediate)

Lets review about AI and Analytics in Power BI

Leila Etaati

RADACAD

AI in Power bi exists for many years. However, many AI and ML feature inside Power BI help developers to achieve a more analytical report. In this session, some of… Show more

Type: General Session (60-minutes)

Theme: Level Up

Track: Analytics

Level: 300 (Advanced)

Learning Pathway: Power BI

Load Data In Near Real Time Using Azure Streaming Analytics
Jeremy Frye
Professional Services Sr. Manager - Data Analytics
```
Have you ever wondered how vehicle sensors send messages to apply brakes instantaneously to prevent an accident?   Maybe you are curious in how a social media post can… Show more 
```
Type: General Session (60-minutes)
Theme: Reach for the Clouds
Track: Analytics
Level: 100 (Foundational)

Lock Picking your SQL Engine

Shane Welgama

Data Engineer - i2iLogic

Locking is an essential need to uphold data integrity. Managing locking behaviour is also important when it comes to improving transaction concurrency. In this talk, we will dive into the… Show more

Type: General Session (60-minutes)

Theme: Back to Basics

Track: Database Management

Level: 100 (Foundational)

Log-Based CDC for SQL Server Always On Availability

Mark Van de Wiel

Chief Technology Officer at HVR

Businesses that run mission-critical applications on Microsoft SQL Server need a strategy for high availability and disaster recovery. A common solution to this requirement is SQL Server Always On availability… Show more

Type: General Session (60-minutes)

Theme: Back to Basics

Track: Architecture

Level: 100 (Foundational)

MERGE with confidence
Karel van der Walt
www.upaytechnology.com
```
Demonstrate a systematic approach to incrementally develop the MERGE-statement
for both a set-based and cursor-based MERGE application
```
Type: Lightning Talk* (10-minutes)
Theme: Level Up
Track: Development
Level: 200 (Intermediate)
Machine Learning: Prediction of Severe Car Crashes
Steve Schneider
SQL Insight ... Bringing light to the depths of data
```
Take a dip into Machine Learning!  Watch a fast-moving demonstration of a python-driven set of visuals leading to the prediction of whether a vehicle is likely to have a… Show more 
```
Type: General Session (60-minutes)
Theme: Level Up
Track: Analytics
Level: 200 (Intermediate)
Making the Leap from Reporting to Data Analysis
Stacia Varga
Consultant, educator, and author
```
You might be familiar with using queries to retrieve data from a data source to display in a report, but how do you go one step further to perform data… Show more 
```
Type: General Session (60-minutes)
Theme: Back to Basics
Track: Analytics
Level: 100 (Foundational)
Managing Your Data Services Spend with Azure Cost Management
Dustin Dorsey
Director of Data Management, Lifepoint Health
```
Cloud technologies provide us so many benefits to get us what we need very quickly with its extensive library of services, easy to deploy infrastructure, and flexibility to scale. However,… Show more 
```
Type: General Session (60-minutes)
Theme: Reach for the Clouds
Track: Architecture
Level: 100 (Foundational)
Master Communication and Influencing Skills
Blythe Morrow
Blythe Morrow, Managing Director at Paper Sword B2B
```
Master-level DBAs know how to communicate with clarity and pitch with confidence.

The honest truth is that you are negotiating and problem-solving all the time, often without knowing it. Your success… Show more 
```
Type: Pre-conference Session (Full-day)
Pre-conference day: Monday
Theme: Reach for the Clouds
Track: Professional Development
Level: 100 (Foundational)

Mastering TempDB

Monica Rathbun

Denny Cherry & Associates Consulting

Have you experienced performance problems caused by contention in TempDB? Have you ever wondered why your TempDB is suddenly 3 TB? In this session, you will learn about all the… Show more

Type: General Session (60-minutes)

Theme: Back to Basics

Track: Database Management

Level: 100 (Foundational)

Merging Power BI into Azure Devops

Hylke Peek

BI and Data Analytics Consultant, VX Company

From a development perspective Power BI gives you some challenges you can't overcome easily. When you and your team are continuously working on Power BI files, you need a central… Show more

Type: General Session (60-minutes)

Theme: Reach for the Clouds

Track: Analytics

Level: 200 (Intermediate)

Migrate Enterprise Data Integration to Azure

Andy Leonard

Microsoft MVP, BimlHero, Chief Data Engineer, and Data Philosopher

Many modern enterprises desire to leverage Azure functionality, but wonder, "Where do we begin?" 

In this presentation, Microsoft Data Platform MVP and author Andy Leonard describes and demonstrates lifting and… Show more

Type: General Session (60-minutes)

Theme: Reach for the Clouds

Track: Architecture

Level: 200 (Intermediate)

Migrate SQL Server to Azure
Bob Ward
Principal Architect
Ajay Jagannathan
Principal Group PM Manager, Microsoft
```
Many professionals and companies are looking to migrate their SQL Server environments to Azure. But many are not sure what are the right processes, tools, or decisions to ensure a… Show more 
```
Type: Pre-conference Session (Full-day)
Pre-conference day: Monday
Theme: Reach for the Clouds
Track: Architecture
Level: 200 (Intermediate)

Migrating from Azure Analysis Services to Premium Per User

Gilbert Quevauvilliers

Reporting made easy with FourMoo

I will walk through the different requirements to evaluable when migrating from Azure Analysis Services to Premium Per User with an overview of the details below

	• Query performance
	• Scalability
	• Data… Show more

Type: General Session (60-minutes)

Theme: Level Up

Track: Analytics

Level: 100 (Foundational)

Learning Pathway: Power BI

Migrating your Data Warehouse from SQL Server to Azure Synapse Analytics
Oscar Zamora
Azure Cloud & AI Architect, Microsoft
Gaiye Zhou
Passionate about migrating workloads into Azure Synapse! Created and published multiple tools/IPs (SQL Server to Synapse Migration, APS to Synapse Migration, Netezza to Synapse Migration, etc.)
```
Several organizations have created large footprint SQL Server instances that hosts Data Warehouse workloads. They have come to realize that SMP architectures at times gets taxed for multiyear scan demanding… Show more 
```
Type: General Session (60-minutes)
Theme: Reach for the Clouds
Track: Architecture
Level: 300 (Advanced)

Missing Indexes: Do's and Don'ts

Andy Yun

Principal Solutions Engineer

We've all written queries that have generated Missing Index Recommendations. Perhaps you've just implemented the recommendation and moved on with your day. Or maybe you've been told to not trust… Show more

Type: General Session (60-minutes)

Theme: Back to Basics

Track: Development

Level: 200 (Intermediate)

Module Signing: Use Certificates to Grant Higher-level Permissions Without Compromising Security
Solomon Rutzky
Head Honcho, Sql Quantum Lift
```
We often need to grant a higher-than-ideal level of permissions to a Login or Role so that someone can: start a SQL Agent job (but you don't want them to… Show more 
```
Type: General Session (60-minutes)
Theme: Back to Basics
Track: Architecture
Level: 200 (Intermediate)
Monitoring SQL Server security at scale
Ed Leighton-Dick
Microsoft MVP; Principal Architect, Kingfisher Technologies
```
Few tasks are more important to maintaining a secure SQL Server system than continuous monitoring, but the built-in logging and auditing tools can only monitor a single instance. Monitoring all… Show more 
```
Type: General Session (60-minutes)
Theme: Reach for the Clouds
Track: Database Management
Level: 200 (Intermediate)
Learning Pathway: Data Security & Governance
Monitoring and Troubleshooting SQL Server environments using Free community tools
Javier Villegas
Mediterranean Shipping Company, IT Director - Microsoft MVP Data Platform
```
In this session we will see how to monitor and troubleshoot different SQL Server environments using free tools developed by community experts
We will cover First Responder Kit , Diagnostics Queries,… Show more 
```
Type: General Session (60-minutes)
Theme: Back to Basics
Track: Database Management
Level: 200 (Intermediate)
Move your NoSql database to Azure by using Azure data Factory
Diponkar Paul
Data Engineer, Blogger, Speaker
```
NoSQL database have grown popularity in recent years due to the flexibility of data modeling and scaling up capabilities. NoSQL database also have been using in big data landscape. The… Show more 
```
Type: General Session (60-minutes)
Theme: Reach for the Clouds
Track: Development
Level: 100 (Foundational)
Neurodiversity and the Data Platform: A Greater Discussion
Chris Voss
A SQL Developer who is still figuring this out like everyone else
```
You may know someone who is a brilliant data wrangler and works hard, but may need special accommodations or struggles with emotional intelligence. It is quite possible that the person… Show more 
```
Type: General Session (60-minutes)
Theme: Level Up
Track: DE&I
Level: 100 (Foundational)

PostgreSQL for the SQL Server DBA: What to Know When You're Called In To Help!

Ryan Booz

Developer Advocate at Timescale

SQL Server is a leading enterprise database solution for good reason. However, it's not the only popular RDBMS used in an increasingly cloud-first, price conscious world.

PostgreSQL is arguably becoming one… Show more

Type: General Session (60-minutes)

Theme: Back to Basics

Track: Database Management

Level: 200 (Intermediate)

Power BI Adoption Framework

DENISHA MALONE

@ThePowerBIQueen

This session introduces the Power BI Adoption Framework and gives an overview of its start-to-finish approach to help attendees get the most value from Power BI in an organization. I… Show more

Type: General Session (60-minutes)

Theme: Back to Basics

Track: Analytics

Level: 200 (Intermediate)

Power BI Building first report
Heidi Hasting
Senior Business Intelligence Developer
```
You've heard about Power BI and now want to give it a go. In this session we will go through building our first report. 
We start off with a quick… Show more 
```
Type: General Session (60-minutes)
Theme: Back to Basics
Track: Analytics
Level: 100 (Foundational)
Learning Pathway: Power BI

Power BI Monitoring 101

Rui Romano

Head of BI @ DevScope | MVP - Data Platform

One of the pillars of a good Power BI Governance is monitoring and knowing exactly (without guessing) whats happening on your Power BI tenant.
In this session you will learn how… Show more

Type: Lightning Talk* (10-minutes)

Theme: Back to Basics

Track: Analytics

Level: 200 (Intermediate)

Power BI Paginated Reports: the New Old Operational Reporting Platform
Paul Turley
Principal Consultant, BI Solution Architect
```
Power BI Paginated Reports (aka SQL Server Reporting Services) was old but now it's new again. Available on-premises or in the Power BI service with flexible licensing, you have multiple… Show more 
```
Type: General Session (60-minutes)
Theme: Level Up
Track: Analytics
Level: 200 (Intermediate)

Power BI Performance - 7 Deadly Sins!

Nikola Ilic

BI Developer, Data Mozart

Congratulations! You've built your shiny fancy Power BI report and your charts look terrific. But, your data refresh takes forever...Or, your report is utterly slow when interacting with visuals...You switch… Show more

Type: General Session (60-minutes)

Theme: Reach for the Clouds

Track: Analytics

Level: 200 (Intermediate)

Power BI dataflows; Power Query everywhere, re-usable
Reza Rad
RADACAD, Consultant and Trainer
```
Power Query is the data transformation engine in Power BI. However, instead of doing it in each Power BI Desktop file as part of the dataset, there is a better… Show more 
```
Type: General Session (60-minutes)
Theme: Back to Basics
Track: Analytics
Level: 200 (Intermediate)
Learning Pathway: Power BI

Power BI release management with Deployment Pipelines

Asanka Padmakumara

Business Intelligence Consultant

Moving reports and models  between multiple environments has always been a cumbersome operation in Power BI until the introduction of Power BI deployment pipeline.   With deployment pipeline… Show more

Type: General Session (60-minutes)

Theme: Level Up

Track: Development

Level: 200 (Intermediate)

PowerShell for SQL Server DBAs

Rodrigo Crespi

CrespiDB - CTO

In this session you will fall in love for PowerShell!
Come to know how the PowerShell works, how to use the .NET Framework, WMI, several PowerShell modules and how to create… Show more

Type: General Session (60-minutes)

Theme: Back to Basics

Track: Database Management

Level: 200 (Intermediate)

Presentation Skills to Advance Your Career

Steve Gray

What's Your Story?

Good communication skills don’t just happen.  There’s no such thing as a “natural communicator.”  These skills are learned and perfected over time.  Rockford Gray has developed proven… Show more

Type: General Session (60-minutes)

Theme: Level Up

Track: Professional Development

Level: 200 (Intermediate)

Production down? How to keep calm and query on during an outage
Kris Gruttemeyer
Staff DBA @ Olo
```
It's 2am, you just got paged for a mission critical system being down, what do you do?  This talk will highlight both the technical and non-technical sides of handling… Show more 
```
Type: General Session (60-minutes)
Theme: Back to Basics
Track: Database Management
Level: 100 (Foundational)
Python in the Microsoft Data Platform
Chris Hyde
Owner and Principal Consultant, Hydrate Technologies LLC
```
You won't get very far along learning about AI, ML, and Data Science in the Microsoft Data Platform world before you run into Python.  Far from being a snake… Show more 
```
Type: General Session (60-minutes)
Theme: Back to Basics
Track: Analytics
Level: 100 (Foundational)
Learning Pathway: AI & ML

Query Store In-Depth

Ola Hallengren

Principal Database Architect, Saxo Bank

Query Store has become one of the most important tools for troubleshooting performance problems.

In this session I will share my experiences about how Query Store is working in different scenarios.… Show more

Type: General Session (60-minutes)

Theme: Back to Basics

Track: Database Management

Level: 200 (Intermediate)

Querying JSON When All You know is SQL
Edward Heraux
Founder, Chief Data Architect at The Lytic Group
```
We'll explore the magic of OPENROWSET, and how to use it to run SQL queries against unstructured data. See SQL demos against a JSON file, a CSV, and a Parquet… Show more 
```
Type: Lightning Talk* (10-minutes)
Theme: Back to Basics
Track: Analytics
Level: 200 (Intermediate)

Query tuning tips concerning table expressions

Itzik Ben-Gan

T-SQL Trainer, Lucient

T-SQL supports four kinds of named table expressions: derived tables, CTEs, views and inline table valued functions. From a query tuning perspective, SQL Server treats table expressions very differently compared… Show more

Type: General Session (60-minutes)

Theme: Level Up

Track: Development

Level: 300 (Advanced)

Learning Pathway: Query Tuning

Quick tips to help you pass the DA-100 exam: Analyzing Data with MSFT Power BI
Priscilla Camp
Business Intelligence and Analytics Specialist III
```
Need some tips to help you study for the DA-100 exam? I will talk to you about my experience, how I passed the exam, and then provide you with some… Show more 
```
Type: Lightning Talk* (10-minutes)
Theme: Level Up
Track: Analytics
Level: 200 (Intermediate)

Real-Time Streaming in Azure

Timothy Spann

Principal DataFlow Field Engineer

Today, data is being generated from devices and containers living at the edge of networks, clouds and data centers. We need to run business logic, analytics and deep learning at… Show more

Type: Lightning Talk* (10-minutes)

Theme: Reach for the Clouds

Track: Architecture

Level: 100 (Foundational)

Recovering With Minimal Impact: Advanced Database Restore Methods

Bob Pusateri

Microsoft Certified Master, Data Platform MVP

For mission-critical databases, backups are only half the battle – restores are what really matter when disaster strikes. Standard restores, while effective, may require additional downtime and thus further impact… Show more

Type: General Session (60-minutes)

Theme: Level Up

Track: Database Management

Level: 200 (Intermediate)

Redgate Presents: DevOps for the DBA
Grant Fritchey
Redgate Software
```
I love DevOps. I love DevOps the most because of its focus on automation. The key to understand DevOps is to grasp that it is your communication and environment that… Show more 
```
Type: Pre-conference Session (Full-day)
Pre-conference day: Tuesday
Theme: Level Up
Track: Database Management
Level: 200 (Intermediate)

Removing Technical Debt From Your Database

Kellyn Pot'Vin-Gorman

Azure Data Platform Architect

This session is database platform agnostic, but describes how to build a project to identify, address and modernize a database with technical debt built into it- no matter if it's… Show more

Type: General Session (60-minutes)

Theme: Level Up

Track: Database Management

Level: 200 (Intermediate)

SQL Graph Revealed

Mala Mahadevan

Passionate about community,loves to learn,enjoys dad jokes

‘Graph data’ is normally used to describe data that is highly interconnected. 
Transportation routes, social media friends or connections, organizational charts, genealogical charts, 
product and customer data, electrical grids and… Show more

Type: General Session (60-minutes)

Theme: Back to Basics

Track: Architecture

Level: 100 (Foundational)

SQL Server 2019 on containers and Kubernetes(k8s) from zero to an hero !

Yitzhak David

DBA BDA POWER BI NOSQL K8s

If containers are the new virtual machines, then Kubernetes are the new servers. Kubernetes is an important technology to the future of containerized applications, especially running enterprise workloads like SQL… Show more

Type: General Session (60-minutes)

Theme: Reach for the Clouds

Track: Architecture

Level: 200 (Intermediate)

SQL Server Backup Best Practices: RPO, RTO, and How to Not Jack Up your Log Chain

Scott Klein

SQL Server ROCKS!

Every organization needs a clearly defined disaster recovery plan with a rigorous backup strategy at its core. That strategy includes understanding and appropriately applying Recovery Time Objective (RTO) and Recovery… Show more

Type: General Session (60-minutes)

Theme: Back to Basics

Track: Database Management

Level: 100 (Foundational)

SQL Server Performance Tuning and Optimization - FULL DAY PRE CON
Monica Rathbun
Denny Cherry & Associates Consulting
```
Do your users complain about slow reports? Are your database servers overwhelmed during times of high usage? Every SQL Server environment can benefit from performance tuning whether your environment has… Show more 
```
Type: Pre-conference Session (Full-day)
Pre-conference day: Monday
Theme: Back to Basics
Track: Database Management
Level: 200 (Intermediate)

SQL Server Security Essentials

Ben DeBow

Founder and CEO

Systems and data are being compromised more frequently and with these compromises, comes new regulations and requirements from our companies to better protect the data. Depending on the industry you… Show more

Type: General Session (60-minutes)

Theme: Back to Basics

Track: Database Management

Level: 100 (Foundational)

Learning Pathway: DBA Basics, Data Security & Governance

SQL Server and PowerShell walk into a bar...
Mikey Bronowski
I select stars from the Space.
```
Managing SQL Server can be very exciting, but there are times when one needs to do a number of similar operations and it may become frustrating. 

In this session, you… Show more 
```
Type: General Session (60-minutes)
Theme: Back to Basics
Track: Database Management
Level: 100 (Foundational)

SQL Team Six - How to Build Effective Teams

Aaron Cutshall

Enterprise Data Architect

Teamwork is important in all areas, including development, QA or other teams that we interact with daily. Lessons learned from highly effective teams show that there are six major impacts… Show more

Type: General Session (60-minutes)

Theme: Level Up

Track: Professional Development

Level: 100 (Foundational)

Scale your SQL Pool dynamically in Azure Synapse
Erwin de Kreuk
Lead Data and AI | Public Speaker | InSpark | Innovate to Accelerate
```
How can you scale up or down your SQL Pool in Azure Synapse Analytics using an Synapse Pipeline. An easy way so save some cost in your Analytics Environment
```
Type: Lightning Talk* (10-minutes)
Theme: Reach for the Clouds
Track: Analytics
Level: 200 (Intermediate)

Secure This!

Ita Ryan

Security Enthusiast

Session overview:
- A discussion of database security 
- Implications of insecure databases
- A quick look at academic research on this
- Securing your on-prem databases; an overview and further resources
- Database… Show more

Type: General Session (60-minutes)

Theme: Back to Basics

Track: Database Management

Level: 100 (Foundational)

Learning Pathway: Data Security & Governance

Securing SQL Server on Linux

Louis Imershein

Principal Product Manager, Red Hat

Securing database workloads involves more than just configuring the database and a firewall, the operating system security is deeply involved. Linux has several security features that can be leveraged to… Show more

Type: General Session (60-minutes)

Theme: Level Up

Track: Architecture

Level: 200 (Intermediate)

Soft Skills for Geeks: Don’t Be a Flat Boxer
Randy Knight
Founder and Principal Consultant, SQL Solutions Group
```
If you like being the surly IT geek who lives in a dark office and gets fed pizza under the door (i.e. a flat boxer) this session is NOT for… Show more 
```
Type: General Session (60-minutes)
Theme: Level Up
Track: Professional Development
Level: 100 (Foundational)
Solving Query Performance Problems with Statistics
Kimberly L. Tripp
Working at SQLskills and with SQL Server since 1990 and I still love it!
```
Have you ever wondered why SQL Server did what it did to process your query? Have you wondered if it could have done better? Query estimates/statistics are at the core… Show more 
```
Type: Pre-conference Session (Full-day)
Pre-conference day: Monday
Theme: Level Up
Track: Database Management
Level: 200 (Intermediate)

Starting with Azure SQL Edge on Raspberry Pi

Hasan Savran

BI Manager

Azure SQL Edge is a containerized application that runs on either an ARM64 or an x64-based processor. SQL Database Edge is optimized specifically for IoT and edge workloads running on… Show more

Type: General Session (60-minutes)

Theme: Reach for the Clouds

Track: Architecture

Level: 100 (Foundational)

Stream Processing in Azure: A Data Engineer's Guide
Dustin Vannoy
Azure Data Engineer - Consultant and Trainer
Alicia Moniz
Microsoft AI MVP and #kafkaonAzure Evangelista
```
In data engineering we often default to processing in nightly or hourly batches, but that pattern is not enough anymore. Our customers know information is created all the time and… Show more 
```
Type: General Session (60-minutes)
Theme: Level Up
Track: Analytics
Level: 200 (Intermediate)
Learning Pathway: Become an Azure Data Engineer
Synapse Analytics: The Azure data engineer's ultimate toolbox
Joel Hulen
Senior Data Engineer | GM Solliance Training
```
There are many tools and services in Azure that data engineers use day-to-day. How you select the appropriate tools depends on many factors, including knowledge level, ease of use, features,… Show more 
```
Type: General Session (60-minutes)
Theme: Level Up
Track: Analytics
Level: 200 (Intermediate)
Learning Pathway: Become an Azure Data Engineer

Synapse Dedicated SQL Pool: Whats hidden behind the scene

Dennes Torres

DBA and BI Administrator, Betsson Group

Many DBA's mistakenly think a Synapse SQL Dedicated Pool is just a regular SQL Server Database
This mistake can lead to below optimal configurations, bad performance and loose of investment.

In this… Show more

Type: General Session (60-minutes)

Theme: Level Up

Track: Architecture

Level: 300 (Advanced)

System-versioned temporal tables and CI/CD

Josef Radl

Developer/DBA at COUNT IT Group

System-versioned temporal tables are an easy way to get access to data at any time in the past instead of only the currently existing entries.
But they come with some limitations,… Show more

Type: General Session (60-minutes)

Theme: Back to Basics

Track: Development

Level: 200 (Intermediate)

T-SQL - Beyond the Basics

Barney Lawrence

Senior BI Developer

This session is aimed at anyone with basic level T-SQL experience or above looking to improve their code; especially when writing long, complex queries. 
We will cover topics including getting… Show more

Type: General Session (60-minutes)

Theme: Back to Basics

Track: Development

Level: 100 (Foundational)

Tackling Monster Stored Procs

Allen White

President, DataPerf Professionals

What do you dread hearing from users? "The database is slow."

What might you dread even more?  Realizing the problem is related to stored procedures that are hundreds (thousands?!) of… Show more

Type: General Session (60-minutes)

Theme: Back to Basics

Track: Development

Level: 200 (Intermediate)

Learning Pathway: Query Tuning

Test Database Changes Against Your Workload With Distributed Replay

Mike Burek

Make your data work for you

When updating T-SQL code, database configurations, or table designs, you can test a few scenarios yourself with a few different queries. Many times, those changes can affect many more queries… Show more

Type: General Session (60-minutes)

Theme: Back to Basics

Track: Development

Level: 200 (Intermediate)

Test Driven Database Development
Magnus Ahlkvist
SQL Server specialist, Data Platform MVP, SQL Community organizer.
```
Test Driven Development, or TDD, means we start with unit tests, even before writing our code. When done properly, TDD leads to higher quality systems. It gives us good test… Show more 
```
Type: General Session (60-minutes)
Theme: Back to Basics
Track: Development
Level: 100 (Foundational)
Text Mining & Sentiment Analysis made easy
Sanil Mhatre
Lead Data Scientist @ World Wide Technology
```
Does your enterprise data include social media posts, product reviews, and survey results with free form text? Feel like you need a data scientist, equipped with tools like R, text… Show more 
```
Type: General Session (60-minutes)
Theme: Reach for the Clouds
Track: Analytics
Level: 100 (Foundational)

The 3 W’s of Allyship

Cecilia Judmann

Events Coordinator at Redgate Software

Allyship is an integral part of DE&I strategies, giving more privileged people the chance to make a difference. However, this concept can be confusing, so in this lightning talk, I’ll… Show more

Type: Lightning Talk* (10-minutes)

Theme: Level Up

Track: DE&I

Level: 100 (Foundational)

The Countless Benefits of Mentoring

Mark Runyon

Director of Consulting at Improving

Mentoring offers countless benefits to the mentee, mentor and the organization as a whole. In this session, we will map out the benefits to each participant as well as talk… Show more

Type: General Session (60-minutes)

Theme: Level Up

Track: Professional Development

Level: 100 (Foundational)

The Data Talks Back: Speech & Language AI for the Data Professional
Matt Gordon
Director of Data and Infrastructure at Rev.io
```
AI is, was, and will be a part of our world for a long time to come. The Speech and Language areas of Azure Cognitive Services provide powerful opportunities for… Show more 
```
Type: General Session (60-minutes)
Theme: Reach for the Clouds
Track: Analytics
Level: 100 (Foundational)
Learning Pathway: AI & ML
The Power BI Administrator and governance
Ásgeir Gunnarsson
Data Platform MVP
```
In this session we will put the spotlight on the Power BI Administrator and try to answer the following questions:
•	What is the role of the Power BI Administrator in the… Show more 
```
Type: General Session (60-minutes)
Theme: Back to Basics
Track: Analytics
Level: 100 (Foundational)
Learning Pathway: Power BI
The evolution of SQL Server as a Service - Azure SQL Database Managed Instance
Javier Villegas
Mediterranean Shipping Company, IT Director - Microsoft MVP Data Platform
```
We will look at the future of SQL Server as a Service. Azure SQL Managed Instance is a new PaaS service that allows us to have almost 100% compatibility with… Show more 
```
Type: General Session (60-minutes)
Theme: Reach for the Clouds
Track: Database Management
Level: 200 (Intermediate)
The latest data science workflow in Azure
Steph Locke
AI & Data Platform MVP and CEO of Locke Data and Nightingale HQ
```
Data science is a rapidly evolving skill set and keeping up to date with best practices for the workflow can be tough. In this one day course, we get hands-on… Show more 
```
Type: Pre-conference Session (Full-day)
Pre-conference day: Monday
Theme: Reach for the Clouds
Track: Analytics
Level: 200 (Intermediate)

Think like the Cardinality Estimator

Taiob Ali

Microsoft MVP - Data Platform

SQL Server uses a phase during query optimization, called cardinality estimation (CE). This process makes estimates based on the statistics as to how many rows flow from one query plan… Show more

Type: General Session (60-minutes)

Theme: Back to Basics

Track: Database Management

Level: 200 (Intermediate)

Time intelligence in a few clicks
Bernat Agulló
Senior BI developer and partner at Esbrina
```
How to leverage a publicly available script to create a time intelligence calculation group following the best practices of daxpatterns.com
```
Type: Lightning Talk* (10-minutes)
Theme: Back to Basics
Track: Analytics
Level: 100 (Foundational)
Tips and Tricks for Using SQL Server Management Studio Effectively
Jad Elahmad
IT Security & Infrastructure
```
Attend this session to hear from a former IT Business Analyst share his advice on foundational SQL Server tips. 

1) SQL Syntax Errors - Testing & Debugging
2) Query shortcuts can… Show more 
```
Type: Lightning Talk* (10-minutes)
Theme: Back to Basics
Track: Database Management
Level: 100 (Foundational)
To Hyperscale or not to Hyperscale, that's the question
Reitse Eskens
DBA-Consultant at Axians Business Analytics
```
In this short session I'll share my experiences with Hyperscale. The good things, the things to watch out for and the bug we found during development. This session should give… Show more 
```
Type: Lightning Talk* (10-minutes)
Theme: Reach for the Clouds
Track: Architecture
Level: 200 (Intermediate)

Transitioning your T-SQL skills to Spark SQL

John Miner

Insight Digital Innovations

This presentation is a crash course covering the basics of Spark SQL for the Microsoft T-SQL Server developer.

Azure Databricks is a managed service which provides the latest versions of Apache… Show more

Type: General Session (60-minutes)

Theme: Reach for the Clouds

Track: Development

Level: 200 (Intermediate)

Learning Pathway: AI & ML

Understanding Azure SQL
Tim Radney
SQLskills.com
```
Get a deep understanding of the differences between Azure SQL Database, Azure SQL Managed Instance, and on-premises SQL Server for solving your SQL Server workload needs. 
```
Type: General Session (60-minutes)
Theme: Reach for the Clouds
Track: Database Management
Level: 200 (Intermediate)
Learning Pathway: DBA Basics

Understanding DAX, It's All About the Context

Angela Henry

Data Platform MVP

How many times have you created a Power BI report and gotten an unexpected or inconsistent result, then spent an absurd amount of time trying to figure where the result… Show more

Type: General Session (60-minutes)

Theme: Back to Basics

Track: Analytics

Level: 100 (Foundational)

Understanding SQL Server Backup and Restore
Tim Radney
SQLskills.com
```
Everyone knows that it's critical to have backups but it's amazing how few people make sure those backups can be restored properly! Too many times to count, Tim has been… Show more 
```
Type: General Session (60-minutes)
Theme: Back to Basics
Track: Database Management
Level: 200 (Intermediate)
Learning Pathway: DBA Basics

User Definied Functions – From SQL 2000 – SQL 2019

Uwe Ricken

db Berater GmbH - Managing Director

User Definied Functions (UDF) came first with SQL Server 2000. While developers welcomed the introduction of these features, they became a DAB nightmare.
This session start with the very basics of… Show more

Type: General Session (60-minutes)

Theme: Level Up

Track: Development

Level: 300 (Advanced)

Using Kerberos to Authenticate Amazon RDS for SQL Server

Gene Mays

AWS Database Specialist SA

Kerberos has been the preferred authentication method for Microsoft since its introduction in Windows 2000. When spinning up an Amazon RDS for SQL Server instance, users want to make sure… Show more

Type: Lightning Talk* (10-minutes)

Theme: Level Up

Track: Architecture

Level: 300 (Advanced)

Using Power Apps in Power BI reports: Enabling writeback

Shabnam Watson

BI Architect

The Power Apps visual in Power BI is a powerful tool for adding writeback and other functionality from Power Apps applications to Power BI reports. Using the Power Apps visual,… Show more

Type: General Session (60-minutes)

Theme: Back to Basics

Track: Analytics

Level: 200 (Intermediate)

Using Power BI Datasets and Dataflows to Govern Corporate Data
Sharon Woloshin
Senior Power BI Consultant at 3 Cloud Solutions
```
If you have ever heard (or thought) the complaint that the same query is being created over and over again, this session is for you.  
We will discuss Power… Show more 
```
Type: General Session (60-minutes)
Theme: Level Up
Track: Analytics
Level: 200 (Intermediate)

Virtual SQL Server Performance for the DBA

David Klee

Founder & Chief Exorcist - Heraflux Technologies

Your business-critical SQL Servers should not suffer from infrastructure-related bottlenecks, no matter if it’s on-premises or in the cloud. When properly architected and managed, the principal bottleneck to performance of… Show more

Type: General Session (60-minutes)

Theme: Back to Basics

Track: Architecture

Level: 100 (Foundational)

Learning Pathway: DBA Basics

Weird Things I’ve Been Asked to Do with Power BI
Ed Watson
Senior Software Engineer
```
Over the last couple of years I’ve been asked to make Power BI Reports do things visually that it was not designed to do out of the box. Some of… Show more 
```
Type: General Session (60-minutes)
Theme: Level Up
Track: Analytics
Level: 100 (Foundational)

What Are You Worth?

Doug Lane

SQL Theater

Salary is a taboo subject in many countries, especially America. Getting a good idea of what you're worth is challenging. In this session, we'll talk about how to accurately estimate… Show more

Type: General Session (60-minutes)

Theme: Level Up

Track: Professional Development

Level: 100 (Foundational)

What I’ve learned about T-SQL since joining a SQL Server user group
Mike Chrestensen
Sr. IT Analyst, Duke Health, supporting eletronic health research
```
I joined TRIPASS in 2018 to double down on SQL knowledge and professional development. In this session, I’ll cover five basics that improved my query writing.
```
Type: Lightning Talk* (10-minutes)
Theme: Back to Basics
Track: Development
Level: 100 (Foundational)

What am I doing here? Imposter syndrome and you.

Daniel Kimberlin

WebMB Health Services - Senior DBA

Technology changes so fast it’s impossible to keep up with everything. Sometimes the overwhelm creeps in and you start asking “do I even belong?”. This feeling is known as imposter… Show more

Type: Lightning Talk* (10-minutes)

Theme: Level Up

Track: Professional Development

Level: 100 (Foundational)

What is an Azure Data Engineer?
Dustin Vannoy
Azure Data Engineer - Consultant and Trainer
Darek Easterly
Data Architect - HealthEquity
```
Data Engineer is an exciting and rewarding role. However, many are not sure what a data engineer does. This session kicks off the "Become an Azure Data Engineer" learning pathway… Show more 
```
Type: General Session (60-minutes)
Theme: Back to Basics
Track: Analytics
Level: 100 (Foundational)
Learning Pathway: Become an Azure Data Engineer

What's New in Azure SQL MI

Niko Neugebauer

Senior PM for Azure SQLMI

Let us review the latest and the greatest investment that Microsoft has made into the Azure SQL Managed Instance, the product that serve as the best target for the existing… Show more

Type: Half-day Session (2.5-hours)

Theme: Reach for the Clouds

Track: Architecture

Level: 200 (Intermediate)

What's new with Amazon RDS for SQL Server
Carlos Robles
AWS - Solutions Architect Database Specialist
```
Amazon RDS makes it easy to set up, operate, and scale a relational database in the cloud. With RDS, you can focus on your applications so you can give them… Show more 
```
Type: General Session (60-minutes)
Theme: Reach for the Clouds
Track: Architecture
Level: 200 (Intermediate)
Learning Pathway: Cloud Migrations
What to look out for when migrating your data to the cloud; is it REALLY the right choice?
Emanuele Meazzo
A DBA in a big company that's reaching for the sky
```
It has been “the year of the Cloud” for many years now, companies are slowly but surely moving to cloud services like Azure and AWS; businesses are expecting given cost… Show more 
```
Type: General Session (60-minutes)
Theme: Reach for the Clouds
Track: Architecture
Level: 100 (Foundational)
Why Azure SQL Managed Instance is the Best PaaS Option
Gonzalo Bissio
Customer Success Engineer Data & AI @Microsoft
```
If you are starting the cloud journey, one of the typical questions is... What service can I use for our database? In this 10 minute Lightning Talk I'll tell you… Show more 
```
Type: Lightning Talk* (10-minutes)
Theme: Reach for the Clouds
Track: Architecture
Level: 200 (Intermediate)

Why Open-Source Database Technologies are Making Headlines

Haider Raza

Senior Cloud Solution Architect

Open-source database technologies, traditionally, were used for less critical or internal applications. There were various reasons for that but for larger organisations it was more to do with the fact… Show more

Type: Lightning Talk* (10-minutes)

Theme: Back to Basics

Track: Architecture

Level: 200 (Intermediate)

Why a Diverse Team is Crucial to Startup Success

Melissa Jurkoic

Devoted to improving the human experience and empowering women in tech.

Team diversity refers to differences between members of startup team. Those differences can include demographic differences (like age, race, sex, ethnicity), personality (extrovert, introvert, and differing Myers-Briggs types) and functional… Show more

Type: General Session (60-minutes)

Theme: Level Up

Track: DE&I

Level: 100 (Foundational)

Working with Azure SQL for Azure DevOps

Carlos Lopez

Microsoft MVP Data Platform

Summary:

In this session we will work on Azure SQL as a data platform working interacting in collaboration with different teams in Azure Devops accelerating value of your workflow. Implementing … Show more

Type: General Session (60-minutes)

Theme: Reach for the Clouds

Track: Development

Level: 100 (Foundational)

Wrangle data in Power BI with Power Query Editor
Akshata Revankar
Data Architect at McKinsey & Company
```
If you are wondering, "I don't know Power Query M, but can I still wrangle my data?" , the answer is yes! Power Query Editor in Power BI Desktop has… Show more 
```
Type: General Session (60-minutes)
Theme: Back to Basics
Track: Analytics
Level: 100 (Foundational)
Zen and the Art of Virtual SQL Server Performance
David Klee
Founder & Chief Exorcist - Heraflux Technologies
```
Virtualization has been the norm in datacenters for years, and SQL Server in virtual machines in the cloud are nothing new. However, implemented incorrectly, your SQL Server performance can take… Show more 
```
Type: Pre-conference Session (Full-day)
Pre-conference day: Tuesday
Theme: Back to Basics
Track: Architecture
Level: 200 (Intermediate)
Zero To Dashboard
Angela Henry
Data Platform MVP
```
Your boss has heard all the buzz about Power BI and wants you to start using it to make the business users happy and reduce the demands on IT staff.… Show more 
```
Type: Pre-conference Session (Full-day)
Pre-conference day: Monday
Theme: Back to Basics
Track: Analytics
Level: 100 (Foundational)