SQLSaturday #913 - Minnesota 2019

Event Date: 10/12/2019 00:00:00

Event Location:

Saint Paul College
235 Marshall Avenue
Saint Paul, Minnesota

This event has completed. All data shown below is from the historical XML public data available.

Sessions
Speakers
Sponsors

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).

Sessions

This is a list of sessions from the event, based on the schedule in the XML files.

Title: SSDT, Docker, and (Azure) DevOps: How to Make Your Database Builds a First Class CI/CD Citizen

Abstract: Your application developers benefit from Continuous Integration and Continuous Deployment practices to accelerate feature deployment and catch regression issues up front, but your database deployments are still stuck in the proverbial dark ages. The build scripts might be in source control or even an SSDT project already, but deploying is still an exercise in creating the perfect script, and don’t even think about making a data (or data type) change!

SSDT and Azure DevOps can solve some of these problems, and even give us a window into the world of automated testing. In this talk, we will explore how to automate your database builds and deployments using SSDT and Azure DevOps, and we will explore automated testing using tSQLt and Docker. Lastly, we will check up on some tasks that you cannot (or should not) automate and talk about how to make sure your application developers are not left behind.

Speaker(s):

Dan Mallott

Track and Room: Cloud Application Development Deployment - 2200

Title: Get your Git on with Source Control

Abstract: Have you tried implementing source control? How has your continuous integration (CI) process gone?

This session is for developers, database administrators, database engineers, and data architects that want to automate their database deployments. Particularly for those individuals that have hit roadblocks along that way. We will discuss the differences between migration and stated-based deployment methods. We will also discuss options with branching and merging.

At the end of the session, attendees will know how to select the best deployment method for their environment. In addition, attendees will be familiar with branching and merging strategies that can be used as part of their continuous integration strategy.

Attendees should be familiar with general concepts about source control and be comfortable with Visual Studio or VS Code.

Speaker(s):

Elizabeth Noble

Track and Room: Enterprise Database Administration Deployment - 3190

Title: Azure Security, Cost, and Capabilities

Abstract: Security, cost, and capabilities are the key questions for any Azure project. Nothing should be implemented today without a tested security surface. Creating a strong and flexible identity perimeter will allow for secure access. Platform security will create a secured perimeter for all of your cloud resources from Virtual Machines and Networks to resource locks and permissions. Manage customized security alerts, and configure a playbook for specific threats. Configure security for data infrastructure, and data encryption at rest. Implement security for applications such as certs, monitoring, and security baselines. Data and applications will not last long if costs are not managed from the beginning. You will need to monitor and analyze the cost of your Azure resources as soon as development begins. Azure Cost Management allows you to create a budget. The biggest factor in security, and cost management is implementing the right capabilities to support your business requirements.

Speaker(s):

Ross McNeely

Track and Room: Cloud Application Development Deployment - 2200

Title: SQL Server Performance Tuning and Optimization for the DBA

Abstract: 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 one server or thousands. In this full-day session you will learn about how identify problems using a wide variety of tools and scripts and how to implement best practices across your environment. Additionally, you will learn how to begin reading execution plans and how to tune queries to improve your performance within SQL Server. You will walk away with a list of items to evaluate in your environments and ways to resolve common issues. This session will guide you through real-life performance problems which can be solved by best practices and practical skills. Taught on a level anyone can understand, this session will focus on Microsoft SQL Server 2016 and forward.

Speaker(s):

Monica Rathbun

Track and Room: Enterprise Database Administration Deployment - 1512

Title: Zen and the Art of Baselines

Abstract: If your boss asked you for the list of the five most CPU-hungry databases in your environment six months from now for an upcoming licensing review, do you have an answer? Performance data can be overwhelming, but this session can help you make sense of the mess. Twisting your brain and looking at the data in different ways can help you identify resource bottlenecks that are limiting your SQL Server performance today. Trending this data over time will help you project how much resource consumption you will have months away. Come learn how to extract meaning from your performance trends and how to use it to proactively manage the resource consumption from your SQL Servers.

Speaker(s):

David Klee

Track and Room: Enterprise Database Administration Deployment - 3275

Title: Microsoft AutoML the Next Generation of Machine Learning

Abstract: Automated machine learning simplifies the traditional machine learning process () by creating models with applying hyperparameter settings, and different algorithms. Also, choosing the best models among them based on the performance of each algorithm. Moreover, it provides more detail about the experiment and how much time has been spent to run each iteration and so forth. In this one hour session, an overview of what is Automated Azure ML will be provided, the latest updates of this products will be shown and the audience will learn how to set up the environment and how to use the mode in Power BI services and SQL Server.

Speaker(s):

Leila Etaati

Track and Room: Analytics and Visualization - 2215

Title: AI with Power Platform: The realm of Impossible

Abstract: There is a huge need to use AI and ML in Power Platform to get more insight from data, create smart applications and so forth. In a one day workshop, the process of using AI and ML in Power BI desktop and Power BI Service using Cognitive services, Azure ML Studio, AutoML will be discussed. Next, AUdience will learn how to use AI and ML inside Power Apps and Microsoft Flow to access more insight from the data they have and to create smart applications. In general, new features and tools in Microsoft Machine learning in Power BI, Microsoft Power Apps, and Flow will be shown. Some parts of this workshop are hands-on.

Speaker(s):

Leila Etaati

Track and Room: Analytics and Visualization - 1518

Title: Modern Data Warehouse

Abstract: With the smorgasbord of Azure service available, how do you approach building a modern enterprise data warehouse?

In this pre-con we will be covering both architecture patterns from Microsoft and actual implementations in the industry on how to move to Azure for your data warehousing needs. We’ll cover the various offerings of Azure including storage, data ingestion and orchestration, databases , NoSQL, and streaming.

We’ll also cover how to analyze all of this data with tools and services like Power BI and Databricks. Finally, we’ll cover strategies on how you get there; Lift-and-shift, hybrid, or brand new implementations will all be discussed.

By the end of this pre-con you should have a thorough understanding of architecting a modern enterprise data warehouse in Azure including getting those services to work together and how to use that data effectively!

Speaker(s):

Matt Stenzel

Track and Room: BI Platform Architecture, Development Administration - 1506

Title: Environment Setup using automation tools like Docker, Powershell and Chocolatey

Abstract: Environment setup in some organizations can take days and even then it is not consistent and has components missing or configured incorrectly. These problems can be solved and this session will cover several techniques for doing just that. In this session we will use Docker to create 3 SQL environments. The first is a production like environment for UAT. In the second environment will redact the confidential data and in the third environment reduce the dataset by 90%.

This three tiered environment setup can work with or without Docker. In this session we will also cover using Chocolatey NuGet’s, which sounds tasty, but it is also a very powerful method of installing software on Windows.

Speaker(s):

Adam Anderson

Track and Room: Application Database Development - 2220

Title: An Introduction to Partitioning

Abstract: Large tables in SQL Server present challenges on several fronts. For query performance, avoiding accessing data unnecessarily becomes more important. For ETL, loading and modifying data while utilizing compute resource and avoiding lock contention becomes more difficult. For maintenance, making efficient use of resources and time presents challenges.

In this session, we will introduce the core concepts of partitioning in SQL Server – partitioning columns, partition schemes, and partition functions. We will configure heaps, rowstores, and columnstores as partitioned tables, and execute queries to compare how they access data. Finally, we will work with the requirements for switching partitions in and out of tables.

After this session, you will be able to configure partitioned tables, explain how partitioning affects query execution, and switch partitions in and out of tables.

Speaker(s):

Kevin Krenz

Track and Room: Enterprise Database Administration Deployment - 3275

Title: What is DevOps and Why Should DBAs Care?

Abstract: You may have heard the term “DevOps” a lot lately, but is this just one of those buzzwords that gets thrown around and means something different depending on who’s talking? While traditional software methodologies pit developers and operations folks like DBAs against each other, DevOps requires that they work together for a common goal. And, ultimately, shouldn’t the software project’s success be everyone’s goal? Attend this session to learn how DevOps is changing the DBAs world for the better.

Speaker(s):

Kathi Kellenberger

Track and Room: Enterprise Database Administration Deployment - Theater

Title: Power BI from Rookie to Rock Star - All About DATA

Abstract: In this one day workshop, you will learn Power BI modeling and data preparation from beginner to advance. You will learn how to use Power BI for simple data analysis situations as well as complex business intelligence scenarios. You will learn about using Power Query and the formula language (M) for data preparation and transformation. You will also learn about relationships, and modeling in Power BI, and DAX which is the calculation engine for Power BI.

This course is full of live demos of real-world challenges of data modeling and how to solve it using Power BI. Modules include, but not limited to:

Module 1: Data preparation using Power Query Module 2: Advanced Data transformations Module 3: M: Power Query formula language Module 4: Data Modelling in Power BI, Everything you need to know about Relationships Module 5: DAX and Calculations in Power BI This is a data modeling module of the world-famous Power BI training from Rookie to Rock Star by the book author; Reza Rad.

Speaker(s):

Reza Rad

Track and Room: BI Platform Architecture, Development Administration - 1514

Title: Power BI for the Data Systems Administrator

Abstract: Data systems administrators pride themselves on their ability to dig deep into the weeds of their systems and get to the root of problems. However, when it comes time to explain a complex or intermittent issue, we find that others don’t enjoy those weeds. Ever wish you could draw a better picture of what’s going on? Enter Power BI! This tool is beloved by many analysts and developers but it can transform more than just OLTP data. Attend this session to learn how you can use quick models in Power BI against administrative data such as the SSRS execution log, SQL Server Extended Events, XML JSON files, query performance data, and even those random Excel files you get from vendors. You’ll leave this session with the skills you need to survey your domain from a new angle and communicate what you learn to your organization.

Speaker(s):

Gina Meronek

Track and Room: Analytics and Visualization - 2215

Title: Creating a Marketing Dashboard with Power BI and Dax

Abstract: Are you new to Power BI? Are you looking to extract insights from your Google Analytics and Google Ad Words data? I will walk you through the underlying architecture of Power BI and basic Dax all the while in building a Power BI marketing report for your Ad Words and website data. The attendee will leave the class ready to start using Power BI for their Marketing Dashboards.

Speaker(s):

Craig Johnson

Track and Room: Analytics and Visualization - 2215

Title: Architecture Blueprints for Power BI Implementation

Abstract: Implementing a Power BI solution is not just about the report development, dashboard design and DAX queries. Designing the right architecture is an essential part of a Power BI implementation.

There are many areas to consider when you are designing a Power BI architecture. From sharing reports and security to the type of connection and usage of other components such as Dataflow.

Come to this session to learn about important things you need to know about the architecture of a Power BI solution. You will learn some blueprints of what are key things to consider and how to design the architecture for your solution.

Speaker(s):

Reza Rad

Track and Room: BI Platform Architecture, Development Administration - Theater

Title: Getting Started with SQL Server Reporting Services (SSRS)

Abstract: In this session, geared toward beginner level users, attendees will be introduced to SQL Server Reporting Services (SSRS) as a tool for customized reporting. We will first review the SSRS workspace in Visual Studio 2017 to familiarize users with the various components that can be used when building reports. We will then look at a few examples of reports to see some of those components in action, focusing on the usage of parameters and expressions to provide flexibility, before finally building a sample report together. We will conclude by walking through the deployment process and discussing both basic and data-driven subscription options for automated report delivery.

This session is designed for users with little to no familiarity with SSRS who are looking for a baseline understanding of the tool, who want to begin working more with SSRS development, or who need to support SSRS in their current role but do not know where to begin.

Speaker(s):

Ashley Day

Track and Room: Analytics and Visualization - 2215

Title: SQL DevOps Simplified with Production Databases

Abstract: DevOps is based on building an application binary (immutable artifact) that supports a highly reliable, repeatable engineering process. In the case of SQL Server, however, a database is already in production, and isn’t simply replaced (as an app binary), but is upgraded. Current SQL Server DevOps methods use source control to build a “development” database, with schema and objects and static data needed for functional testing. “Near production data” is used in Staging, and finally production is upgraded. This approach involves complexity, and breaks the principle of working with immutable artifacts throughout the process. Our session introduces a new approach to SQL Server DevOps, with production databases used in all stages. Production database clones are delivered more quickly than “built” databases, are more easily integrated with source control, and produces higher fidelity outcomes. Learn how leading enterprises are simplifying SQL DevOps.

Speaker(s):

Paul Stanton

Track and Room: Application Database Development - 2225

Title: SQL Server Serverless Overview

Abstract: The Serverless compute tier is a new feature of Azure SQL DB. I will cover the new features that Serverless includes and go over the concepts it is built upon. There will be several demos and interactive sessions. Come excited to learn!

Speaker(s):

Matt Stenzel

Track and Room: Cloud Application Development Deployment - Theater

Title: Azure Data Studio Extension Development

Abstract: Cross-platform and approachably extensible, Azure Data Studio is a new application for database development and management. Azure Data Studio extensions can create efficiencies by automating a workflow or integrating with an external system.

This session will take the audience through the fundamentals of extension development for Azure Data Studio with Typescript and other open source tools. Our discussion will include available internal APIs, hosting your extension on GitHub, and sharing your work through the extension marketplace. By demonstrating each concept through building an extension in the session, we will end with a working extension utilizing functionality released recently in Azure Data Studio.

Speaker(s):

Drew Skwiers-Koballa

Track and Room: Application Database Development - 2220

Title: Hands-On Query Tuning Workshop

Abstract: You know query plans can help you fix T-SQL performance issues, but maybe you aren’t sure of all the ways query plans can help. Maybe you use index suggestions, but you wonder if you could do better. Maybe you’ve never used a query plan at all. Come to this workshop and learn!

Let’s roll up our sleeves and dig into some T-SQL performance work. We’ll work together to examine query plans and enhance query performance. Feel encouraged to take part in the conversation, no matter your experience level. We’re all here to learn!

You’ll get even more out of the session if you bring a device that can use OpenVPN (if you have SQL Server Management Studio or another client) or remote desktop (if you don’t). You can then experiment on your own to discover suggestions for the group and see improvements for yourself.

When you leave the session, you’ll have more practical ways to fix slow T-SQL the next time you run into a real-world performance problem.

Speaker(s):

Andrew Brobston

Track and Room: Application Database Development - 2220

Title: Pseudo-Constants in SQL

Abstract: You know you’ve done it. Maybe it was the lucky number 7. Maybe it was an enigmatic X. Maybe you smooshed some words together in ALLCAPS. That should be easier to spot, right? Because some day you might need to change it—in every stored procedure, function, and view.

Magic numbers, codes, identifiers, constants, enumerations. Whatever you call them, all applications have them. Sure it’s quick and easy to sprinkle the values throughout your code, but that breeds mistakes, rigidity, and obfuscation. There has to be a better way!

Other languages give us real constants and enums—with IntelliSense and compilation-level enforcement. Well guess what– SQL Server does too, sort of. Join us and learn to write clearer, easier to maintain code without sacrificing performance.

Speaker(s):

Riley Major

Track and Room: Application Database Development - 2220

Title: Dammit Jim! Dr McCoy’s Field Guide to system_health (and the default trace)

Abstract: As DBAs, we are asked all sorts of impossible questions. Who dropped that important table last month? Why was everything slow last week? Who made that user a sysadmin? You’d have to be a mind reader to know the answers to some of those, right? Not necessarily! SQL Server can help you find information about these and other common problems with its default trace and system_health Extended Events session, but you have to know how to collect and interpret the data they provide. In this session, we’ll explore what system_health and the default trace are, what information they contain, and how to use them to find the answers you’re searching for.

Speaker(s):

Ed Leighton-Dick

Track and Room: Enterprise Database Administration Deployment - 3190

Title: SQL Server 2019 - New Features and Enhancements

Abstract: SQL Server 2019 is in Public preview for almost 1 year. Microsoft promises that it is going to be released for consumption this year. Like previous versions, SQL Server 2019 comes with a plethora of new features as well as with enhancements to the existing features. In this session, I will discuss new features such as Accelerated Database Recovery, PMEM (persistent memory device), Hybrid Buffer pool, In-memory Optimized Tempdb, etc. This is an introductory session to introduce you to these new features. There will not be enough time to do any meaningful demo but there will be plenty of time to ask questions. You will leave this session with a solid understanding of some of the best new features of SQL Server 2019 which will help you and your company make decisions such as when and why to upgrade your database platform.

Speaker(s):

Ameena Lalani

Track and Room: Enterprise Database Administration Deployment - Theater

Title: MongoDB and SQL Server 2019: The Odd Couple

Abstract: Microsoft is pulling out all the stops when it comes to SQL Server 2019 integration with “Big Data” solutions. With the expansion of PolyBase to handle external data in MongoDB, moving data from “unstructured” documents into relational tables in SQL Server is theoretically simple. However, MongoDB is designed to allow for spontaneous schema changes. Our fussy SQL Server won’t like such sloppiness! In this session, we will explore SQL Server 2019 features, such as PolyBase, SQL Server Integration Services (SSIS), and T-SQL features such as JSON support, that facilitate integration with MongoDB. The demonstration will include moving data between our Odd Couple of database paradigms, and building in safeguards to keep the two systems from having issues. Can two incompatible databases share data without driving each other crazy?

Speaker(s):

Peter Kral

Track and Room: Application Database Development - R3

Title: Control PHI and Sensitive Data Risk for Self-Service BI using Power BI DataFlows and Azure Data Lake

Abstract: Protected Health Information (PHI) and other forms of sensitive data are an area of concern in all industries. Highly regulated industries such as Healthcare and Financial Services have a great deal of person-specific information in their systems, and often restrict the use of self-service Business Intelligence (BI) to prevent the wrong people from seeing the wrong data. This presentation will review new ways to safely enable self-service BI for an enterprise without introducing additional risk of PHI or sensitive data violations. I’ll review strategies and architectures that include Power BI DataFlows with Azure Data Lake to eliminate sensitive data from a self-service BI environment. An infrastructure leveraging these tools can still have highly controlled and governed enterprise Power BI reports that carefully distribute PHI and sensitive data to targeted users, while also enabling self-service BI without an increased risk of sensitive data violations.

Speaker(s):

Greg Beaumont

Track and Room: BI Platform Architecture, Development Administration - 2230

Title: Managing ETL Change Using BIMLScript

Abstract: Change is constant, especially with source files. Health care claims data files change at least yearly. You develop an SSIS package to load the source file. You meticulously identify each of the columns and map them to the targets. Your package runs fine for months. Then the file format changes. Again, you tediously select each column, etc. Wouldn’t it be nice to simply document the structure of the file, the file’s metadata, and generate the SSIS from that metadata? Your users demand the documentation anyway. If the file changes, you simply change the metadata.

To demonstrate such an approach, I import some US census data. I create the SSIS package using BIMLScript and metadata. When the format changes, I change the metadata and generate a whole new package. And if your whole ETL approach changes to say Azure Data Factory? I will demonstrate how to generate an Azure Data Factory pipeline from the same metadata.

Speaker(s):

Russel Loski

Track and Room: BI Platform Architecture, Development Administration - 2230

Title: Azure SQL DB Hyperscale for OLTP HTAP

Abstract: SQL DB Hyperscale is a cost effective VLDB, fully managed SQL PaaS option. It shares the same Azure SQL Server engine, retaining compatibility for application, the storage is fundamentally redesigned from the ground up to be cloud-born with cache-miss reads of under 2ms. The Hyperscale architecture supports separation of compute and storage, allows for dynamic scaling of CPU, memory, and compute nodes in constant time, regardless of database size. Database backup and restore also in constant time, regardless of database size (RPO 0 minutes, RTO less than 10 minutes). High availability supports one primary read/write, up to four read-only replicas, which also serve as hot-standy in case of automatic failover. Come find out more about this exciting, optimized for OLTP and HTAP database option.

Speaker(s):

Huy Ly

Track and Room: Application Database Development - 2225

Title: I’m It - Survival Techniques for the Lone DBA

Abstract: Are you the only database person at your company? Are you both the DBA and the Developer? Being the only data professional in an environment can seem overwhelming, daunting, and darn near impossible sometimes. However, it can also be extremely rewarding and empowering. This session will cover how you can keep your sanity, get stuff done, and still love your job. We’ll cover how I have survived and thrived being a Lone DBA for 15 years and how you can too. When you finish this session, you’ll know what you can do to make your job easier, where to find help, and how to still be able to advance and enrich your career.

Speaker(s):

Monica Rathbun

Track and Room: Enterprise Database Administration Deployment - 3275

Title: Maximum SQL Server on VMware Performance

Abstract: Virtualizing your business-critical SQL Servers should not imply that they will run slower than if they were physical. When properly architected and managed, virtual SQL Servers should be equally as fast as their physical counterparts, if not faster. However, if not properly constructed and managed, silent and seemingly random performance killers can strike and significantly hurt your database performance.

This session is packed with many tips and tricks gained from years of experience for getting the most performance from your VMware-based SQL Servers. The major roadblocks to performance will be discussed and the knowledge gained will help you work with your infrastructure engineers so you can optimize the system stack for performance. Tools, techniques, and processes will be demonstrated to help you measure and validate the system performance of the key components underneath your data.

Speaker(s):

David Klee

Track and Room: Enterprise Database Administration Deployment - 3275

Title: Real-Time IoT Analytics at the Edge

Abstract: As the velocity of device data increases, the promise of the Cloud is often limited by the latency of the office Internet connection. Leveraging the power of Azure, we will deploy real-time analytics at the edge and illustrate how performing high-frequency analysis is possible.

In this session, we will cover the basics of Azure Internet-of-Things (IoT) and Stream Analytics, then we will deploy Stream Analytics at the edge using a Raspberry Pi device connected to the Azure IoT ecosystem.

No prior Azure IoT or Azure Stream Analytics knowledge is required to benefit from this session.

Speaker(s):

Jordan Anderson

Track and Room: Cloud Application Development Deployment - 2200

Title: Building Your Brand in the Local Data Community

Abstract: In this session we will go over and talk about what it means to build your own brand and cover the following topics listed below. We plan for this to be a highly interactive discussion.

Discussing value of community events Meetups
Importance of an active social profile
Investing in professional development training
Give back to the local data community

Speaker(s):

Joshuha Owen

Track and Room: Professional Development - 2115

Title: WIT Panel: Celebrating Women Computing Pioneers

Abstract: Most people do not realize that we can thank women for many of the technical innovations we enjoy today. In fact, Ida Lovelace wrote computer code 100 years before the first computer existed! From space travel to encryption, women’s contributions have made a big difference in our lives. Those who have gone before us are also responsible for the opportunities we have today.

In today’s WIT session, you’ll hear how our panel of successful technical women have been inspired by computing pioneers and their own mentors. You’ll also have a chance to win a copy of Melinda Gates’ new book!

Panel will include: Gina Meronek, Theresa Heroff, Monica Rathbun, Ashley Day

Speaker(s):

Kathi Kellenberger

Track and Room: Professional Development - 2115

Title: Cosmos DB Develop Locally Deploy Globally

Abstract: CosmosDB is Microsoft’s globally distributed, massively scalable, cloud based database that is hosted in AZURE. Who cares? You should if you need to support thousands of transactions a second, global distribution and redundancy, and different consistencies.

Do you need to support JSON, Graph, et al? Done. Join me and see how easy it is to get started. We will set up a local instance of CosmosDB, load JSON data and build a PowerBI visualization. Along the way I’ll point out a couple of things to watch out for. At the end of the session you will then learn how, with a couple of commands, to switch your visualization to the cloud.

Speaker(s):

Jim Dorame

Track and Room: Application Database Development - 3150

Title: File Formats - A Deep Dive

Abstract: Text/CSV. JSON. AVRO. XML. Parquet. ORC.

In this “Sounds-boring-but-should-be-extra-practical” session we will do a deep dive into these 6 different file formats. We will discuss:

Design and Layout
Differences between formats
Pros and Cons
Performance Characteristics
Applicability to Azure/SQL Server
Optimizing for Cloud Object Storage
Common Use Cases in the Real World

In the end, you will understand How, When, Where, and Why to optimally use each particular file format in your Enterprise Data Architecture.

Speaker(s):

Bill Preachuk

Track and Room: Application Database Development - 2225

Title: Leadership 101: Guiding principals to success

Abstract: Let me share with you the some of the secrets to successful Leadership. We will cover Team Building, Employee Retention, Motivation, How to discover toxic situations and Success for the short and long term. Each one of these topics is derived from my own experiences in leading teams and organizations. Hint: I didn’t get it all right the first time so stop on by for some horror stories too.

Speaker(s):

James Phillips

Track and Room: Professional Development - 2115

Title: Power BI Dataflows - What do you mean it’s about storing data?

Abstract: Power BI Dataflows are an emerging technology from Microsoft in the Power BI space (not to be confused with Azure Data Factory Dataflows, of course). Power BI Dataflows are emerging as some features are still in preview. The part that is not clear in the name is that this is not purely and ETL function. Power BI dataflows allow you to store data in Azure Data Lake. Depending on how you configure your solution, you can use the Common Data Model as well. Let’s dig in an create a dataflow using native Power BI functionality then we will look at using an existing ADLS as well.

Speaker(s):

Steve Hughes

Track and Room: BI Platform Architecture, Development Administration - 2230

Title: Diagnosing and fixing deadlocks in SQL Server

Abstract: You know how locking works in SQL Server, but now you are tasked with diagnosing and fixing deadlocks. How do you take the knowledge you have and apply it to address deadlocks in your production database?

In this session, we will discuss how you can use free tools to detect and analyze deadlocks in your system. We will do a deep dive on deadlock XML with an eye toward interpreting the information automatically collected by SQL Server when the free tools fall short.

Attendees will leave with the understanding they need to develop solutions to deadlocks in their systems.

Speaker(s):

Jake Manske

Track and Room: Application Database Development - 2220

Title: Give me an “M”! Give me another “M”! Give me a… Ok you get the point.

Abstract: The language commonly known as “M” (or Power Query to some) has grown in prevalence over the last 5 years to where it has evolved into a fully integrated language in various tools from far in the front end to way in the back end. Power BI uses it heavily. Cubes can call directly to it.

Come along and learn how the language works and some proposed best practices. With a focus on Power BI optimization but watch as I delve into Data Lake ingestion to Azure Analysis Services and so forth.

Speaker(s):

George Bryant

Track and Room: BI Platform Architecture, Development Administration - 2230

Title: SQL Server 2019 and Big Data Clusters on Dell EMC Storage

Abstract: Dell EMC Storage and SQL Server 2019 are changing the game for big data and data analytics. In this session come learn how Dell EMC Storage is enabling SQL Server 2019 Big Data Clusters. We’ll also discuss some architecture options for deploying Big Data Clusters and talk about the latest integrations from Dell EMC Storage for SQL Server 2019. Finally, I’ll leave some dedicated time for QA to answer your SQL Server storage related questions.

Speaker(s):

Doug Bernhardt

Track and Room: Enterprise Database Administration Deployment - 3150

Title: Introduction to PowerApps and Flow

Abstract: This session will provide an introduction to Microsoft PowerApps and Flow.
PowerApps and Flow are both useful tools for enabling end users with the ability to rapidly create and deploy low-code solutions to add value to their organizations by enabling rapid application development with PowerApps and workflow process automation with Flow.

Speaker(s):

Kurt Hagedorn

Track and Room: Cloud Application Development Deployment - 2200

Title: Azure Databricks in action

Abstract: Databricks is the tool of choice for performing data transformation in Azure. This session gives an overview of Apache Spark and Databricks. We will also perform a non trivial data transformation, publish the resulting data frame to the HIVE metastore, and query it directly from Power BI. Come see what is possible in the Modern Data Platform.

Speaker(s):

Jared Zagelbaum

Track and Room: Cloud Application Development Deployment - 2200

Title: Deploying SQL Server 2019 Big Data Clusters on VMware

Abstract: SQL Server 2019 Big Data Clusters introduce Kubernetes as whole new deployment platform. For those coming from prior versions of SQL Server on Windows, this can be daunting. This session will walk through how to do the deployment step-by-step so you can understand how it’s done, the components involved, and what you might need to learn more about as you take the journey to SQL Server 2019 and Big Data Clusters.

Speaker(s):

Doug Bernhardt

Track and Room: Enterprise Database Administration Deployment - 3190

Title: A Beginner’s Guide to Seven Practices that Kill Performance

Abstract: Are you a relative newcomer to SQL Server and want to get into performance tuning? Or maybe you just want to expand your knowledge of hidden performance killers?

Then join me for a survey of seven worst practices that kill performance in SQL Server. In this demo-filled session, we will cover a mix of administrative and T-SQL development practices, making this session suitable for DBAs and developers alike! Topics include server configuration mistakes, T-SQL parallelism, and TempDB headaches.

When you leave, you’ll be armed with knowledge and tools to tackle your current workloads and hit the ground running.

Speaker(s):

Andy Yun

Track and Room: Enterprise Database Administration Deployment - Theater

Title: Modern Data Integration Analytics in the Cloud – From Azure to Snowflake

Abstract: In this session we’ll discuss modern data integration and analytics in the cloud. We’ll walk through how to create an Azure Data Lake by using Azure Data Factory as our ELT tool. We’ll then use Databricks to load our data into Snowflake for better analysis. Finally, we’ll connect Power BI to our data. No prior experience will be needed for this session.

Speaker(s):

Frank Matteson

Track and Room: BI Platform Architecture, Development Administration - 2230

Title: Bottling Up Your Data Lake with Delta Lake Tables

Abstract: Data engineering architectures in recent years have been centralized around large cloud Data Lakes like Azure Data Lake, Azure Blob, S3, and HDFS. These Data Lakes have provided organizations with cheap and easy to use storage of critical and sometimes… very inconsistent data.

Using Delta Lake, in tandem with Azure Databricks, we’ll walkthrough bottling your Azure Data Lake data into clean, validated, and consumable tables for personas from Business Analysts to Data Scientists. All without changing where you keep your data!

Speaker(s):

JD Braun

Track and Room: Application Database Development - 2225

Title: Azure SQL Database Managed Instance - Almost But Not Quite the Same

Abstract: Let’s talk about Managed Instance, the newest member of the Azure SQL Database family. It’s a WHOLE lot closer to out-of-the-box SQL Server than other flavors of Azure SQL DB. But it’s still got some differences. Do those matter for you? What exactly is it? What is it good for (or not)? How much does it cost? Just how compatible is it with existing systems? How can I move data in and out of it? How is my data protected, for HA, DR, and backups? What else do I need to know about it?

Bottom line: Does Managed Instance make sense for me?

Speaker(s):

Tim Plas

Track and Room: Enterprise Database Administration Deployment - 3190

Title: I deleted 1 billion records, what happened next will shock you!

Abstract: In this session we will give an overview of what Table Partitioning is, how can it be used to move large amounts of data quickly and how can it be used with a data archiving strategy to quickly and easily drop archived data from a table. We will discuss the practical applications of table partitioning using scripts to generate new table partitions, move a partition to another table and discussion on how this can benefit you. In this demo heavy session, attendees will be provided with scripts to get setup quickly so they can begin using the strategies to take control of rapid data archival

Speaker(s):

Eric Zierdt

Track and Room: Application Database Development - 3150

Title: Building your Microsoft Business Intelligence (MSBI) Career

Abstract: Are you excited to know about the MSBI tools and work as a Business Intelligence Professional, a dynamic and rewarding career in Information Technology? If yes, this is the right time and place for you. In this session, I will give you the overview of the MSBI tools (SSIS, SSRS, SSAS, Power BI, Azure Analytics). I will also provide you some insights to build the MSBI career and to leverage the learning curve in Microsoft Data Platform, based on my knowledge and experience, the proven strategies and techniques.

Speaker(s):

Ganesh Lohani

Track and Room: Professional Development - R8

Title: DAX: Functions and Context - That’s What It’s All About!

Abstract: To get the most from our SSAS Tabular and Power BI models, we must be able to create robust DAX expressions. This requires the right interplay of filtering, context and the myriad of DAX functions. This session will provide a solid working understanding of all three, giving you a firm foundation for fulfilling those demanding user requirements. This session will include examples using some of the most recent additions to the ever-expanding DAX language.

Speaker(s):

Brian Larson

Track and Room: Analytics and Visualization - 2215

Title: Extended Events: What are they and How do I use them

Abstract: Extended Events are an essential part of properly monitoring and every DBA should know what they are and how to use them. This session will cover the basics of Extended events as well as an introduction to the system_health session. This session will focus on how to use Extended Events as part of your performance troubleshooting process.

Speaker(s):

Dave Bland

Track and Room: Enterprise Database Administration Deployment - 3275

Title: SQL Server 2019 on Docker Kubernetes

Abstract: Docker and Kubernetes are revolutionizing the way software is being developed and deployed. Faster deployments, easier setup and consistency benefits are now reaching us with SQL Server running in Docker containers on Kubernetes. Come and find out what’s new with SQL Server 2019 running in Docker/Kubernetes. We’ll go over Docker/Kubernetes basics as well as some demos of SQL Server 2019 running on containers.

Speaker(s):

Chris Kramer

Track and Room: Enterprise Database Administration Deployment - 3150

Title: Decoder ring not needed

Abstract: Data privacy has never been more relevant than the last few years. Are you doing all you can to protect your data? In this session we will look at different methods to encrypt data and what those methods protect against as well as what they do not protect. I will also demonstrate enabling Transparent Data Encryption (TDE), column level encryption and the new Always Encrypted along with how to encrypt and decrypt your data….no decoder ring needed.

Speaker(s):

Marcus Hopfinger

Track and Room: Enterprise Database Administration Deployment - 3190

Title: JSON for the Data Mortals

Abstract: Do you see curly brackets stored in your database and wonder what that is? Are you a DBA, with developers storing JSON in your database? As a database administrator or developer, it’s important to understand JSON today. This session will explain what JSON is, where it came from, and why it is showing up all over the place. When you leave this session you will understand how to investigate, manipulate, and validate JSON in your database. You will walk away with example code of how to use Microsoft’s additions to SQL Server to use this data.

Speaker(s):

Jim Dorame

Track and Room: Application Database Development - 2225

Title: Everyone Has a Story to Tell: Developing Your First Presentation

Abstract: Ever considered giving a presentation of your own? Pondered how your favorite speakers got their start? Contemplated whether you could ever do that too, but were not sure where to begin?

In this session I will show you how to get started. We will go over how to develop your idea, create session content, and share my favorite tips tricks.

You will leave armed with a wealth of resources (and hopefully some inspiration) to venture forth and develop your first presentation.

Speaker(s):

Andy Yun

Track and Room: Professional Development - 2115

Speakers

This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Greg Beaumont

Twitter: - https://www.twitter.com/grbeaumont

LinkedIn: Greg Beaumont

As a Technology Solutions Professional at Microsoft I am constantly working to both inspire and create Digital Transformation using Analytics. Architecting solutions, training technologists, and never passing up an opportunity to design something new using Microsoft tools such as Power BI, Azure, SQL Server, Streaming Data and Azure Machine Learning.

Tim Plas

Twitter: - tjplas

LinkedIn: Tim Plas

Tim is a Principal Consultant at Virteva, in Mpls MN. His current focus areas are cloud architecture / engineering / migration, operational-DBA services (esp. HA/DR), server migrations, server virtualization, and storage. His experience over the past 25+ years has been primarily with server / data-center infrastructure, including being CTO / co-founder of a successful hosting company. Tim has held a variety of MS certifications since 1994.

Frank Matteson

LinkedIn: Frank Matteson

I am a Solution Architect for Tail Wind with over a decade of experience in Business Intelligence and Data Analytics with a current focus on Cloud Technologies. I current hold certifications in both Microsoft and Snowflake and have worked in many different industries from manufacturing, medical, retail, and more.

George Bryant

Twitter: - Azure_George0

LinkedIn: George Bryant

George has over a decade of experience in the Business Intelligence industry and is an active member of the BI community across the Midwest. His knowledge spans multiple industries including, retail, manufacturing, finance, and medical, however recent years has seen him focus on the analytics in sports.

George specializes in BI architecture and end to end development in order to deliver advanced analytics and metrics to multiple organizations across the country. In recent years George has focused on and worked primarily in the Azure cloud, utilizing both established and recent offerings.

Brian Larson

Twitter: - @Brian_Larson

LinkedIn: Brian Larson

Contact: http://sqlmag.com/author/brian-larson

Brian Larson is Chief Creative Officer/Partner at Superior Consulting Services and has presented at SQL Server Connections, PASS Summit, and the Microsoft BI Conference. As a consultant to Microsoft, Brian contributed to the original code base of Reporting Services. Brian is the author of “Microsoft SQL Server 2016 Reporting Services: 5th Edition” and “Delivering Business Intelligence with SQL Server 2016: 4th Edition”, as well as the forthcoming “Data Analysis with Microsoft Power BI.”

James Phillips

Twitter: - @JPhillips_Data

James Phillips is the VP Technology for Mizuho Americas and has over 20 years of experience with SQL technologies with the last 10 years focused on Business Intelligence. He is a past Leader of the Northern NJ SQL Server User group and current Leader for SQLSaturday NYC. He has worked in a wide array of industries including finance and insurance. Regularly speaks about Database Performance Tuning, SSIS and Power BI topics. Also an avid softball player and father to 5 beautiful children.

Peter Kral

Twitter: - https://twitter.com/pkral

LinkedIn: Peter Kral

Peter Kral is a Premier Field Engineer (Data AI) at Microsoft. He holds SQL Server MCSA 2012/2014/2016 and Data Platform MCSE certifications, and was the winner of the Speaker Idol Award at PASS Summit 2016. Peter lives in the San Diego area where he is an active member of the local PASS chapter. He has spoken at many SQLSaturdays, SoCal Code Camps, and at PASS Summit 2017 and 2018.

Chris Kramer

Twitter: - @Kramer_SQL

LinkedIn: Chris Kramer

Chris Kramer is a Senior Database Administrator at Digi-Key Electronics in Thief River Falls, MN. He started working with SQL Server in 2009 dealing with SQL 2000 and up dealing with clustering, architecture, backups, and virtualization. He mainly focuses on performance and architecture but also deals with other technology stacks including Hadoop, MongoDB and MemSQL. He graduated from North Dakota State University with a BS in Computer Science. In his free time, he enjoys golf, video games, watching football, and riding motorcycles.

Ameena Lalani

Twitter: - SQLHands

LinkedIn: Ameena Lalani

Ameena Lalani is a SQL Server veteran and started her journey with SQL Server 2000. She is a Microsoft Certified Solution Associate on SQL Server 2016 and also hold Azure Administrator Associate certification. Ameena works at Microsoft as a Premier Field engineer. She has implemented numerous High Availability and Disaster Recovery solutions at various companies. Ameena loves to share her technical knowledge and speaks at local user groups and SQLSaturday events throughout the United States.

Kathi Kellenberger

Twitter: - auntkathi

LinkedIn: Kathi Kellenberger

Contact: http://auntkathisql.com

Kathi Kellenberger is the editor of Simple Talk at Redgate and a Data Platform MVP. She has worked with SQL Server for over 20 years and has authored, co-authored, or tech edited over a dozen technical books. Kathi is the co-leader of the PASS Women in Technology Virtual Group and a volunteer at LaunchCode. When Kathi isn’t working, she enjoys spending time with family and friends, cycling, singing, and climbing the stairs of tall buildings. Be sure to check out her courses on Pluralsight.

Marcus Hopfinger

Twitter: - DakotaDataWrang

LinkedIn: Marcus Hopfinger

Contact: http://dakotadatawrangler.blogspot.com/

Marcus has been with Daktronics, Inc. since 2001 where he started doing ColdFusion development and some SQL Server 7 database administration. In late 2003 he was activated and deployed in early 2004 to Iraq with the South Dakota Army National Guard. During this time, he served as a Battalion Communications Officer where he was responsible for redundant voice and data networks including satellite internet and secure internet routing protocol networks. Upon returning to Daktronics in 2005 he moved in into a fulltime database administration position where he gets to work on SQL Server instances on three continents. He is also a Sci-Fi Fan, History buff, Amateur Radio Operator (call sign KA0SQL), but most importantly husband and father.

Ross McNeely

Twitter: - Ross_McNeely

LinkedIn: Ross McNeely

Contact: https://rossmcneely.com

Ross McNeely is a Tail Wind Principal Consultant in Data Management, and the Practice Manager of Business Intelligence. He works with external vendors, customers, and partners to integrate disperse data sources. Throughout most of his 15 year career he has been specializing in Information Management, and implementing solutions for Information Strategy, Information Asset Management, Enterprise Data Management, and Business Intelligence.

Riley Major

Twitter: - RileyMajor

LinkedIn: Riley Major

Contact: http://www.Scribnasium.com/

Riley Major is an Enterprise Architect based in the Twin Cities, MN metro area who enjoys collaborating with business leaders to design technical solutions and working with technology professionals to build them. He’s been programming and designing databases since he was a kid and doing so professionally for 20 years. He has a special place in his heart for T-SQL in SQL Server and loves to share that enthusiasm.

Dave Bland

Twitter: - @SQLDave29

LinkedIn: Dave Bland

Contact: https://www.davebland.com

Over 20 years of SQL Server experience that includes being a DBA, BI development and Application development using VB.NET. Dave currently is the Manager of the DBA team at Stericycle. Dave is a Friend of Red-Gate for 2019. He is a frequent presenter at SQLSaturday events and user groups around the country. Has been teaching SQL Server since version 2000 and is the SQL Server instructor at Harper College in Palatine, IL. Current certifications include: • Microsoft Certified Trainer • MCTS: SQL Server 2008, Implementation and Maintenance • MCTS: SQL Server 2008, BI Development and Maintenance • MCSA: SQL Server 2008 • MCSA: SQL Server 2016 • MCSE: SQL Server 2016 - BI • MCDBA: SQL Server 2000 • MCSD • MCSE: Data Management and Analytics

Monica Rathbun

Twitter: - SQLEspresso

LinkedIn: Monica Rathbun

Contact: http://www.sqlespresso.com

Monica Rathbun lives in Virginia, is a Microsoft MVP for Data Platform and Microsoft Certified Solutions Expert. She has nearly two decades of experience working with a wide variety of database platforms with a focus on SQL Server and the Microsoft Data Platform. She is a frequent speaker at IT industry conferences on topics including performance tuning and configuration management. She is the Leader of the Hampton Roads SQL Server User Group and a Mid‐Atlantic PASS Regional Mentor. She is passionate about SQL Server and the SQL Server community, doing anything she can to give back. Monica can always be found on Twitter (@sqlespresso) handing out helpful tips. You can find Monica blogging at sqlespresso.com

Andy Yun

Twitter: - SQLBek

LinkedIn: Andy Yun

Contact: http://sqlbek.wordpress.com

Andy Yun is a SentryOne Principal Solutions Engineer and a former Microsoft MVP. He has been working with SQL Server for nearly 20 years as both a Database Developer and Administrator. Leveraging knowledge of SQL Server Internals and extensive experience in highly transactional environments, he strives to make T-SQL leaner and meaner. Andy is extremely passionate about passing knowledge onto others, regularly speaking at User Groups, SQLSaturdays, and PASS Summit. Andy is a co-founder of the Chicago SQL Association, co-Chapter Leader of the Chicago Suburban User Group, and part of the Chicago SQLSaturday Organizing Committee.

Dan Mallott

Twitter: - https://twitter.com/DanielMallott

LinkedIn: Dan Mallott

Contact: https://www.danielmallott.com

Dan Mallott is a Chicago-based consultant for West Monroe Partners in their Technology Practice. His passion is for service-layer development, particularly database technologies, including Microsoft SQL Server and Apache Cassandra.

Recent projects have included designing a new integration architecture for a mid-sized health insurer, designing a full technical architecture for a large health insurer, building a new member portal for a healthcare-related association, and developing threat hunting software for use by West Monroe.

In his spare time, Dan can be found writing his own libraries instead of using package solutions, or on the ice as a hockey player and referee.

Steve Hughes

Twitter: - dataonwheels

LinkedIn: Steve Hughes

Contact: http://www.dataonwheels.com

Steve Hughes is the Director of Consulting at Pragmatic Works. In his current role, Steve manages the consultant team at Pragmatic Works and directs implementation of our cloud practices for customers. He focuses on team development and company growth with this role. In his previous role as a Principal Consultant Lead, he focused designing solutions for customers on Microsoft technologies including SQL Server, Power BI, and Azure. He has been working with technology for over 20 years with much of that time spent on creating business intelligence solutions and helping customers implement leading BI and cloud solutions. He is passionate about using data effectively and helping customers understand that data is valuable and profitable.

Leila Etaati

Twitter: - @leila_etaati

LinkedIn: Leila Etaati

Contact: http://blog.radacad.com

Leila Etaati is the First Microsoft AI MVP in New Zealand and Australia, as well as a Data Platform MVP. She has a Ph.D. from the University of Auckland and is the co-director and data scientist in RADACAD company with many clients around the world. Additionally, she is the co-organizer of Microsoft Business Intelligence and Power BI Use group in Auckland with more than 1300 members. Leila has also co-organized 3 main conferences in Auckland: SQLSaturday Auckland (from 2015), Difinity (from 2017) and Global AI Bootcamp. She is a data scientist, BI consultant, trainer, and speaker. She is a well-known International speaker to many conferences such as MS Ignite, SQL PASS, Data Platform Summit, SQLSaturday, Power BI World Tour and in Europe, USA, Asia, Australia, and NZ. She has over 10 years’ experience with databases and software systems. Leila is an active Technical Microsoft AI blogger in RADACAD.

Matt Stenzel

Twitter: - sqlstenz

LinkedIn: Matt Stenzel

Matt Stenzel is a Data Platform Technical Specialist at Microsoft. He has been using Microsoft tools for over 10 years. He is a Microsoft Certified Solutions Associate and has held positions as a Developer, DBA and Architect with several Fortune 500 companies before joining Microsoft. He now works with customers across the North Central District to implement data platform solutions that will provide business value.

Matt is passionate about helping businesses turn data into insights and realizing the value of their data. He has helped numerous customers realize value from on-prem and cloud solutions dealing with structured and unstructured data using the Microsoft Data Platform and Azure.

Ed Leighton-Dick

Twitter: - eleightondick

LinkedIn: Ed Leighton-Dick

Contact: http://www.edleightondick.com

Ed Leighton-Dick is a Microsoft MVP, SQL Server performance and architecture specialist, and Founder/Principal Consultant of Kingfisher Technologies. He is a frequent volunteer with PASS, including current roles as a Regional Mentor, co-leader of I-380 PASS local group, and co-leader of the HA/DR virtual group. He can often be found teaching sessions at local, regional, and national events, including user groups, SQLSaturday, and PASS Summit.

Jordan Anderson

Twitter: - https://twitter.com/flightsoft

LinkedIn: Jordan Anderson

Contact: http://blogs.talavant.com/

Jordan has over 10 years of experience as a consultant, analyst, and developer of business intelligence and analytics solutions. He has a proven background in business process analysis, planning, and strategic alignment across numerous business functional areas in a wide range of industries. Jordan is proficient in cross-functional team facilitation, organization, leadership, and cultivating cooperative relationships with project sponsors and stakeholders.

Jordan brings an extensive track record of delivering successful technology solutions that align with the business, engage people, and produce value. Jordan drives teams with a focus on creativity, relevance, quality, and high performance.

Paul Stanton

Twitter: - https://twitter.com/Paul_E_Stanton

LinkedIn: Paul Stanton

Contact: https://www.windocks.com/blog-2

Co-founder of Windocks, Paul is a former Microsoft engineer who is focused on delivering solutions for SQL Server development and test, including SQL Server containers and database cloning.

Huy Ly

Huy is a solution architect at Microsoft, he claims expertise in data AI, 50% of the time, he is right every time.

Kurt Hagedorn

LinkedIn: Kurt Hagedorn

Kurt is an experienced BI professional who has executed multiple projects delivering Business Intelligence capabilities to clients with the Microsoft data and BI stack. In addition to on-premises solutions, he is also experienced with Azure cloud-based solutions.

He has a passionate interest in enabling organizations to operate more effectively through tools to better understand and visualize their data.

Elizabeth Noble

Twitter: - SQLZelda

LinkedIn: Elizabeth Noble

Elizabeth Noble is a Director of Database Development in the metro Atlanta area. When she was introduced to her first database over 10 years ago, it was love at first sight. Her passion is to help others improve the quality and speed of deploying database changes through automation. When she is not trying to automate all of the things, she can be found spending time with her dogs, playing disc golf, or taking a walk at the gym.

Russel Loski

Twitter: - sqlmovers

LinkedIn: Russel Loski

Contact: http://www.sqlmovers.com

Russ Loski is a SQL Server BI Developer based in Dallas-Fort Worth. He current works as a Data Analytics Engineer for Navisite, a remote managed IT services company. Twenty years ago, he began working with SQL Server 6.5. He has since continued to develop applications connected to all of the versions of SQL Server. He has worked with clients in industries from insurance to healthcare, from movie theaters to American football. Russ is a regular speaker at SQLSaturday events, as well as the SQL Server Users Groups in the North Texas region. Russ likes working with data in various shapes.

Joshuha Owen

Twitter: - SQLJosh

LinkedIn: Joshuha Owen

A Data and AI Premier Field Engineer by day and tech geek at all times. I enjoy working with data technologies as well as dabbling in other areas such as VR programming.

Jake Manske

Twitter: - @jmanske

Contact: https://concurrencyexchange.com

Jake has been a T-SQL developer since 2013, starting after he jumped ship from an academic life as a mathematics professor to the software industry. He focuses on solving difficult concurrency problems, large scale data warehouse ETL processes, data conversions, and understanding SQL Server optimizer behavior.

David Klee

Twitter: - kleegeek

LinkedIn: David Klee

Contact: http://davidklee.net

David Klee is a Microsoft Data Platform MVP and VMware vExpert with a lifelong passion for technology. David spends his days focusing on the convergence of data and infrastructure as the Founder of Heraflux Technologies. His areas of expertise include cloud, virtualization, performance, and business continuity. David speaks at a number of national and regional technology related events, including PASS Summit, VMware VMworld, SQLBits, SQLSaturday events, and many SQL Server User Groups.

Kathi Kellenberger

Twitter: - auntkathi

LinkedIn: Kathi Kellenberger

Contact: http://auntkathisql.com

Reza Rad

Twitter: - Rad_Reza

LinkedIn: Reza Rad

Contact: http://radacad.com/blog

Reza Rad is a Microsoft Regional Director, MVP, author, trainer, speaker and consultant. He is a Microsoft Data Platform MVP for nine years from 2011. Reza wrote many books on Power BI subjects including the Power BI from Rookie to Rock Star, and Pro Power BI Architecture. Reza is the invited speaker at the world’s well-known conferences such as Microsoft Ignite, Microsoft Business Applications Summit, Ignite Tour, PASS Summit, and many other conferences. Reza is an active blogger and writes regularly about Power BI at https://radacad.com.

Ganesh Lohani

LinkedIn: Ganesh Lohani

Ganesh Lohani has 10 years of experience working with Business Intelligence platform and Data Analytics, with over 8 years of experience with MS BI tools and Business Intelligence processes. He is currently working for Stericycle as a senior Business Intelligence Developer. He also enjoy his evening and weekend time in providing online training, coaching and mentoring individuals who want to learn MSBI (T – SQL, SSIS, SSRS, SSAS, and Power BI ) products. He holds MSIS degree from University of Texas at Arlington.

Kevin Krenz

LinkedIn: Kevin Krenz

Kevin started working with SQL Server in 2015 as a technical services engineer for a large healthcare software vendor. During that time, he has worked on the data warehouse product, helped with server and database performance investigations, and led internal training for SQL Server. He enjoys working on issues that improve his understanding of the entire system, spanning hardware, hypervisor, OS, database, and application.

In his spare time, Kevin enjoys spending time with his wife and son in Madison, playing watching soccer, brewing an occasional batch of beer, and looking up at the stars.

Craig Johnson

LinkedIn: Craig Johnson

Data-Driven Marketing Professional. Using Power BI to measure marketing and business outcomes.

Gina Meronek

Twitter: - @equerystrian

LinkedIn: Gina Meronek

Contact: http://ginameronek.com

Gina Meronek is a Business Intelligence, Application Architecture, and IT Management professional with 18 years of experience applying the right people and tools to produce genuinely useful technology. She is dedicated to transforming data into information that solves problems via the right system architecture and interactive data visualizations. Gina has been active in the SQL PASS Community for a number of years and is passionate about sharing knowledge with other data geeks in her community. When not glorying in all that Power BI can do, she loves reading, riding her horse, or attending theater with her husband.

Monica Rathbun

Twitter: - SQLEspresso

LinkedIn: Monica Rathbun

Contact: http://www.sqlespresso.com

Adam Anderson

Twitter: - sqlpioneer

LinkedIn: Adam Anderson

Contact: https://sqlpioneer.wordpress.com/

Adam Anderson is a Microsoft Certified Solutions Associate in Database Development, and an ICAgile Certified Agile and DevOps professional with over 2 decades of experience in IT processes. Currently, he works at American AgCredit in Santa Rosa California on their software integrations team.

Andy Yun

Twitter: - SQLBek

LinkedIn: Andy Yun

Contact: http://sqlbek.wordpress.com

Eric Zierdt

Twitter: - @EricZierdt

LinkedIn: Eric Zierdt

Contact: http://ericemployed.blogspot.com

Eric is a level 70 Data Slayer, who has worked with SQL Server since 2000. Eric has worked with benefit systems, real estate data, marketing, game data, and medical device data. Eric enjoys performance tuning, T-SQL programming, and SQL Server Administration.

David Klee

Twitter: - kleegeek

LinkedIn: David Klee

Contact: http://davidklee.net

Ashley Day

LinkedIn: Ashley Day

Ashley found the world of data analytics and business intelligence after a supervisor saw her potential and introduced her to SQL and report writing. Her analytical mindset and thirst for knowledge quickly turned that opportunity into a career, and she has spent the past five years working within the sphere of data management and business intelligence. She has experience working with data from a number of industries, including manufacturing, distribution, benefits administration, and the financial sector.

Ashley is very passionate about working with data and helping others gain access to the clean and reliable data they need to make informed business decisions.

Doug Bernhardt

Twitter: - @DougBern

LinkedIn: Doug Bernhardt

SQL Server professional since 1995. Over the course of my career I’ve worked in various roles including reporting, dev, DBA, architect, troubleshooter, etc. Currently I work at Dell EMC where I develop and test storage solutions for SQL Server in terms of white papers, best practices, and reference architectures for running SQL Server on Dell EMC storage. In my spare time I like to unplug and play with muscle cars, do some cycling, or throw weights around at the gym.

Jared Zagelbaum

Twitter: - @JaredZagelbaum

LinkedIn: Jared Zagelbaum

Contact: https://jaredzagelbaum.wordpress.com

With over 10 years of experience using the Microsoft Data Platform suite, Jared’s main areas of focus include data lake architecture, machine learning, and application embedded analytics. Jared regularly speaks at user groups and events across the Midwest, as well as blogs and provides technical review for SQL Server publications.

Drew Skwiers-Koballa

Twitter: - SysAdminDrew

LinkedIn: Drew Skwiers-Koballa

Contact: https://www.drewsk.tech/

Drew Skwiers-Koballa is a program manager for SQL tools at Microsoft and an open source advocate. He spent nearly a decade as a database administrator and developer, building several extensions for Azure Data Studio prior to joining Microsoft. He is currently working on experiences for DBAs and database developers.

Leila Etaati

Twitter: - @leila_etaati

LinkedIn: Leila Etaati

Contact: http://blog.radacad.com

Matt Stenzel

Twitter: - sqlstenz

LinkedIn: Matt Stenzel

Reza Rad

Twitter: - Rad_Reza

LinkedIn: Reza Rad

Contact: http://radacad.com/blog

Doug Bernhardt

Twitter: - @DougBern

LinkedIn: Doug Bernhardt

Andrew Brobston

Twitter: - AndrewBrobston

LinkedIn: Andrew Brobston

Contact: https://brobston.com/

Andrew Brobston is a senior full-stack software developer at SJV Associates, an Atlanta-area company specializing in background checks. Previously, he was a full-stack developer with Stack Overflow. His Microsoft SQL Server experience started with SQL Server 2000, and he has worked with every version since then.

Jim Dorame

Twitter: - @DBAJD

LinkedIn: Jim Dorame

Contact: http://www.jamesdorame.com/

Jim Dorame has been working with SQL Server for over 20 years. Over those years he has learned a great deal from the SQL community. He has also given back to the community in the hopes that he may help someone in their career. He is always looking for something to learn and luckily Microsoft keeps adding to SQL Server.

Jim Dorame

Twitter: - @DBAJD

LinkedIn: Jim Dorame

Contact: http://www.jamesdorame.com/

Bill Preachuk

Twitter: - billpreachuk

LinkedIn: Bill Preachuk

Bill is a Data Architect with almost 3 decades of experience doing all forms of large-scale Data Architecture and Data Design work – EDW, Hadoop, SQL Server Development DBA, Performance Tuning, and Technical Architecture planning.

Bill has presented at the PASS Summit, many SQLSaturdays, and PASS/Hadoop/Analytics user group meetings in the Twin Cities, Wisconsin, Iowa, Winnipeg, and Ukraine. He also served 2 years on the Board of PASSMN - The Minnesota SQL Server User Group.

JD Braun

LinkedIn: JD Braun

JD is a data engineering consultant at Slalom where he helps organizations design and implement modern data architectures to deliver value to their internal external customers.

He holds certifications such as; Databricks Certified Developer, AWS Solutions Architect - Associate, and Microsoft Certified Solutions Expert (MCSE) - Data Management Analytics.

SQLSaturday #913 - Minnesota 2019

Sessions

Title: SSDT, Docker, and (Azure) DevOps: How to Make Your Database Builds a First Class CI/CD Citizen

Title: Get your Git on with Source Control

Title: Azure Security, Cost, and Capabilities

Title: SQL Server Performance Tuning and Optimization for the DBA

Title: Zen and the Art of Baselines

Title: Microsoft AutoML the Next Generation of Machine Learning

Title: AI with Power Platform: The realm of Impossible

Title: Modern Data Warehouse

Title: Environment Setup using automation tools like Docker, Powershell and Chocolatey

Title: An Introduction to Partitioning

Title: What is DevOps and Why Should DBAs Care?

Title: Power BI from Rookie to Rock Star - All About DATA

Title: Power BI for the Data Systems Administrator

Title: Creating a Marketing Dashboard with Power BI and Dax

Title: Architecture Blueprints for Power BI Implementation

Title: Getting Started with SQL Server Reporting Services (SSRS)

Title: SQL DevOps Simplified with Production Databases

Title: SQL Server Serverless Overview

Title: Azure Data Studio Extension Development

Title: Hands-On Query Tuning Workshop

Title: Pseudo-Constants in SQL

Title: Dammit Jim! Dr McCoy’s Field Guide to system_health (and the default trace)

Title: SQL Server 2019 - New Features and Enhancements

Title: MongoDB and SQL Server 2019: The Odd Couple

Title: Control PHI and Sensitive Data Risk for Self-Service BI using Power BI DataFlows and Azure Data Lake

Title: Managing ETL Change Using BIMLScript

Title: Azure SQL DB Hyperscale for OLTP HTAP

Title: I’m It - Survival Techniques for the Lone DBA

Title: Maximum SQL Server on VMware Performance

Title: Real-Time IoT Analytics at the Edge

Title: Building Your Brand in the Local Data Community

Title: WIT Panel: Celebrating Women Computing Pioneers

Title: Cosmos DB Develop Locally Deploy Globally

Title: File Formats - A Deep Dive

Title: Leadership 101: Guiding principals to success

Title: Power BI Dataflows - What do you mean it’s about storing data?

Title: Diagnosing and fixing deadlocks in SQL Server

Title: Give me an “M”! Give me another “M”! Give me a… Ok you get the point.

Title: SQL Server 2019 and Big Data Clusters on Dell EMC Storage

Title: Introduction to PowerApps and Flow

Title: Azure Databricks in action

Title: Deploying SQL Server 2019 Big Data Clusters on VMware

Title: A Beginner’s Guide to Seven Practices that Kill Performance

Title: Modern Data Integration Analytics in the Cloud – From Azure to Snowflake

Title: Bottling Up Your Data Lake with Delta Lake Tables

Title: Azure SQL Database Managed Instance - Almost But Not Quite the Same

Title: I deleted 1 billion records, what happened next will shock you!

Title: Building your Microsoft Business Intelligence (MSBI) Career

Title: DAX: Functions and Context - That’s What It’s All About!

Title: Extended Events: What are they and How do I use them

Title: SQL Server 2019 on Docker Kubernetes

Title: Decoder ring not needed

Title: JSON for the Data Mortals

Title: Everyone Has a Story to Tell: Developing Your First Presentation

Speakers

Sponsors