sqlsathistory

Nr: 913

Back to Main list

SQLSaturday #913 - Minnesota 2019

Start Time (24h)	Speaker	Track	Title
09:00:00	Monica Rathbun	Enterprise Database Administration Deployment	SQL Server Performance Tuning and Optimization for the DBA
09:00:00	Leila Etaati	Analytics and Visualization	AI with Power Platform: The realm of Impossible
09:00:00	Matt Stenzel	BI Platform Architecture, Development Administration	Modern Data Warehouse
09:00:00	Reza Rad	BI Platform Architecture, Development Administration	Power BI from Rookie to Rock Star - All About DATA
09:45:00	Paul Stanton	Application Database Development	SQL DevOps Simplified with Production Databases
09:45:00	Leila Etaati	Analytics and Visualization	Microsoft AutoML the Next Generation of Machine Learning
09:45:00	Monica Rathbun	Enterprise Database Administration Deployment	I'm It - Survival Techniques for the Lone DBA
09:45:00	Reza Rad	BI Platform Architecture, Development Administration	Architecture Blueprints for Power BI Implementation
09:45:00	George Bryant	BI Platform Architecture, Development Administration	Give me an "M"! Give me another "M"! Give me a... Ok you get the point.
09:45:00	Ross McNeely	Cloud Application Development Deployment	Azure Security, Cost, and Capabilities
09:45:00	Doug Bernhardt	Enterprise Database Administration Deployment	Deploying SQL Server 2019 Big Data Clusters on VMware
09:45:00	Peter Kral	Application Database Development	MongoDB and SQL Server 2019: The Odd Couple
09:45:00	Riley Major	Application Database Development	Pseudo-Constants in SQL
09:45:00	Joshuha Owen	Professional Development	Building Your Brand in the Local Data Community
11:00:00	Jim Dorame	Application Database Development	JSON for the Data Mortals
11:00:00	Adam Anderson	Application Database Development	Environment Setup using automation tools like Docker, Powershell and Chocolatey
11:00:00	Jared Zagelbaum	Cloud Application Development Deployment	Azure Databricks in action
11:00:00	Andy Yun	Enterprise Database Administration Deployment	A Beginner's Guide to Seven Practices that Kill Performance
11:00:00	Eric Zierdt	Application Database Development	I deleted 1 billion records, what happened next will shock you!
11:00:00	David Klee	Enterprise Database Administration Deployment	Zen and the Art of Baselines
11:00:00	Brian Larson	Analytics and Visualization	DAX: Functions and Context - That's What It's All About!
11:00:00	Steve Hughes	BI Platform Architecture, Development Administration	Power BI Dataflows - What do you mean it's about storing data?
11:00:00	Tim Plas	Enterprise Database Administration Deployment	Azure SQL Database Managed Instance - Almost But Not Quite the Same
11:00:00	Kathi Kellenberger	Professional Development	WIT Panel: Celebrating Women Computing Pioneers
13:30:00	Jordan Anderson	Cloud Application Development Deployment	Real-Time IoT Analytics at the Edge
13:30:00	Marcus Hopfinger	Enterprise Database Administration Deployment	Decoder ring not needed
13:30:00	Craig Johnson	Analytics and Visualization	Creating a Marketing Dashboard with Power BI and Dax
13:30:00	Andy Yun	Professional Development	Everyone Has a Story to Tell: Developing Your First Presentation
13:30:00	Matt Stenzel	Cloud Application Development Deployment	SQL Server Serverless Overview
13:30:00	Bill Preachuk	Application Database Development	File Formats - A Deep Dive
13:30:00	Kevin Krenz	Enterprise Database Administration Deployment	An Introduction to Partitioning
13:30:00	Andrew Brobston	Application Database Development	Hands-On Query Tuning Workshop
13:30:00	Greg Beaumont	BI Platform Architecture, Development Administration	Control PHI and Sensitive Data Risk for Self-Service BI using Power BI DataFlows and Azure Data Lake
13:30:00	Doug Bernhardt	Enterprise Database Administration Deployment	SQL Server 2019 and Big Data Clusters on Dell EMC Storage
15:00:00	Kurt Hagedorn	Cloud Application Development Deployment	Introduction to PowerApps and Flow
15:00:00	James Phillips	Professional Development	Leadership 101: Guiding principals to success
15:00:00	Kathi Kellenberger	Enterprise Database Administration Deployment	What is DevOps and Why Should DBAs Care?
15:00:00	Frank Matteson	BI Platform Architecture, Development Administration	Modern Data Integration Analytics in the Cloud – From Azure to Snowflake
15:00:00	Chris Kramer	Enterprise Database Administration Deployment	SQL Server 2019 on Docker Kubernetes
15:00:00	Gina Meronek	Analytics and Visualization	Power BI for the Data Systems Administrator
15:00:00	Drew Skwiers-Koballa	Application Database Development	Azure Data Studio Extension Development
15:00:00	Ed Leighton-Dick	Enterprise Database Administration Deployment	Dammit Jim! Dr McCoy’s Field Guide to system_health (and the default trace)
15:00:00	Huy Ly	Application Database Development	Azure SQL DB Hyperscale for OLTP HTAP
15:00:00	David Klee	Enterprise Database Administration Deployment	Maximum SQL Server on VMware Performance
16:15:00	Jake Manske	Application Database Development	Diagnosing and fixing deadlocks in SQL Server
16:15:00	Ashley Day	Analytics and Visualization	Getting Started with SQL Server Reporting Services (SSRS)
16:15:00	Jim Dorame	Application Database Development	Cosmos DB Develop Locally Deploy Globally
16:15:00	Dan Mallott	Cloud Application Development Deployment	SSDT, Docker, and (Azure) DevOps: How to Make Your Database Builds a First Class CI/CD Citizen
16:15:00	Ganesh Lohani	Professional Development	Building your Microsoft Business Intelligence (MSBI) Career
16:15:00	Elizabeth Noble	Enterprise Database Administration Deployment	Get your Git on with Source Control
16:15:00	JD Braun	Application Database Development	Bottling Up Your Data Lake with Delta Lake Tables
16:15:00	Russel Loski	BI Platform Architecture, Development Administration	Managing ETL Change Using BIMLScript
16:15:00	Ameena Lalani	Enterprise Database Administration Deployment	SQL Server 2019 - New Features and Enhancements
16:15:00	Dave Bland	Enterprise Database Administration Deployment	Extended Events: What are they and How do I use them

SessionID: 95146

SQL Server Performance Tuning and Optimization for the DBA

Back to calendar

Event Date: 12-10-2019 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Monica Rathbun

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.

SessionID: 95338

AI with Power Platform: The realm of Impossible

Back to calendar

Event Date: 12-10-2019 - Session time: 09:00:00 - Track: Analytics and Visualization

Speaker: Leila Etaati

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.

SessionID: 95527

Modern Data Warehouse

Back to calendar

Event Date: 12-10-2019 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Matt Stenzel

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!

SessionID: 95538

Power BI from Rookie to Rock Star - All About DATA

Back to calendar

Event Date: 12-10-2019 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Reza Rad

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.

SessionID: 94721

SQL DevOps Simplified with Production Databases

Back to calendar

Event Date: 12-10-2019 - Session time: 09:45:00 - Track: Application Database Development

Speaker: Paul Stanton

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.

SessionID: 95337

Microsoft AutoML the Next Generation of Machine Learning

Back to calendar

Event Date: 12-10-2019 - Session time: 09:45:00 - Track: Analytics and Visualization

Speaker: Leila Etaati

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.

SessionID: 95390

I'm It - Survival Techniques for the Lone DBA

Back to calendar

Event Date: 12-10-2019 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Monica Rathbun

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.

SessionID: 95540

Architecture Blueprints for Power BI Implementation

Back to calendar

Event Date: 12-10-2019 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Reza Rad

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.

SessionID: 95712

Give me an "M"! Give me another "M"! Give me a... Ok you get the point.

Back to calendar

Event Date: 12-10-2019 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: George Bryant

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.

SessionID: 95747

Azure Security, Cost, and Capabilities

Back to calendar

Event Date: 12-10-2019 - Session time: 09:45:00 - Track: Cloud Application Development Deployment

Speaker: Ross McNeely

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.

SessionID: 96379

Deploying SQL Server 2019 Big Data Clusters on VMware

Back to calendar

Event Date: 12-10-2019 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Doug Bernhardt

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.

SessionID: 96591

MongoDB and SQL Server 2019: The Odd Couple

Back to calendar

Event Date: 12-10-2019 - Session time: 09:45:00 - Track: Application Database Development

Speaker: Peter Kral

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?

SessionID: 96622

Pseudo-Constants in SQL

Back to calendar

Event Date: 12-10-2019 - Session time: 09:45:00 - Track: Application Database Development

Speaker: Riley Major

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.

SessionID: 98161

Building Your Brand in the Local Data Community

Back to calendar

Event Date: 12-10-2019 - Session time: 09:45:00 - Track: Professional Development

Speaker: Joshuha Owen

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

SessionID: 94432

JSON for the Data Mortals

Back to calendar

Event Date: 12-10-2019 - Session time: 11:00:00 - Track: Application Database Development

Speaker: Jim Dorame

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.

SessionID: 95324

Environment Setup using automation tools like Docker, Powershell and Chocolatey

Back to calendar

Event Date: 12-10-2019 - Session time: 11:00:00 - Track: Application Database Development

Speaker: Adam Anderson

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.

SessionID: 95443

Azure Databricks in action

Back to calendar

Event Date: 12-10-2019 - Session time: 11:00:00 - Track: Cloud Application Development Deployment

Speaker: Jared Zagelbaum

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.

SessionID: 95502

A Beginner's Guide to Seven Practices that Kill Performance

Back to calendar

Event Date: 12-10-2019 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Andy Yun

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.

SessionID: 96012

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

Back to calendar

Event Date: 12-10-2019 - Session time: 11:00:00 - Track: Application Database Development

Speaker: Eric Zierdt

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

SessionID: 96048

Zen and the Art of Baselines

Back to calendar

Event Date: 12-10-2019 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: David Klee

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.

SessionID: 96618

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

Back to calendar

Event Date: 12-10-2019 - Session time: 11:00:00 - Track: Analytics and Visualization

Speaker: Brian Larson

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.

SessionID: 96666

Power BI Dataflows - What do you mean it's about storing data?

Back to calendar

Event Date: 12-10-2019 - Session time: 11:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Steve Hughes

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.

SessionID: 96681

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

Back to calendar

Event Date: 12-10-2019 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Tim Plas

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?

SessionID: 96908

WIT Panel: Celebrating Women Computing Pioneers

Back to calendar

Event Date: 12-10-2019 - Session time: 11:00:00 - Track: Professional Development

Speaker: Kathi Kellenberger

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

SessionID: 94884

Real-Time IoT Analytics at the Edge

Back to calendar

Event Date: 12-10-2019 - Session time: 13:30:00 - Track: Cloud Application Development Deployment

Speaker: Jordan Anderson

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.

SessionID: 95139

Decoder ring not needed

Back to calendar

Event Date: 12-10-2019 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Marcus Hopfinger

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.

SessionID: 95377

Creating a Marketing Dashboard with Power BI and Dax

Back to calendar

Event Date: 12-10-2019 - Session time: 13:30:00 - Track: Analytics and Visualization

Speaker: Craig Johnson

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.

SessionID: 95504

Everyone Has a Story to Tell: Developing Your First Presentation

Back to calendar

Event Date: 12-10-2019 - Session time: 13:30:00 - Track: Professional Development

Speaker: Andy Yun

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.

SessionID: 95525

SQL Server Serverless Overview

Back to calendar

Event Date: 12-10-2019 - Session time: 13:30:00 - Track: Cloud Application Development Deployment

Speaker: Matt Stenzel

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!

SessionID: 95796

File Formats - A Deep Dive

Back to calendar

Event Date: 12-10-2019 - Session time: 13:30:00 - Track: Application Database Development

Speaker: Bill Preachuk

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.

SessionID: 96208

An Introduction to Partitioning

Back to calendar

Event Date: 12-10-2019 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Kevin Krenz

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.

SessionID: 96424

Hands-On Query Tuning Workshop

Back to calendar

Event Date: 12-10-2019 - Session time: 13:30:00 - Track: Application Database Development

Speaker: Andrew Brobston

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.

SessionID: 96501

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

Back to calendar

Event Date: 12-10-2019 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Greg Beaumont

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.

SessionID: 99070

SQL Server 2019 and Big Data Clusters on Dell EMC Storage

Back to calendar

Event Date: 12-10-2019 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Doug Bernhardt

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.

SessionID: 94973

Introduction to PowerApps and Flow

Back to calendar

Event Date: 12-10-2019 - Session time: 15:00:00 - Track: Cloud Application Development Deployment

Speaker: Kurt Hagedorn

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.

SessionID: 95271

Leadership 101: Guiding principals to success

Back to calendar

Event Date: 12-10-2019 - Session time: 15:00:00 - Track: Professional Development

Speaker: James Phillips

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.

SessionID: 95373

What is DevOps and Why Should DBAs Care?

Back to calendar

Event Date: 12-10-2019 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Kathi Kellenberger

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.

SessionID: 95649

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

Back to calendar

Event Date: 12-10-2019 - Session time: 15:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Frank Matteson

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.

SessionID: 95653

SQL Server 2019 on Docker Kubernetes

Back to calendar

Event Date: 12-10-2019 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Chris Kramer

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.

SessionID: 96252

Power BI for the Data Systems Administrator

Back to calendar

Event Date: 12-10-2019 - Session time: 15:00:00 - Track: Analytics and Visualization

Speaker: Gina Meronek

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.

SessionID: 96430

Azure Data Studio Extension Development

Back to calendar

Event Date: 12-10-2019 - Session time: 15:00:00 - Track: Application Database Development

Speaker: Drew Skwiers-Koballa

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.

SessionID: 96663

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

Back to calendar

Event Date: 12-10-2019 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Ed Leighton-Dick

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.

SessionID: 96678

Azure SQL DB Hyperscale for OLTP HTAP

Back to calendar

Event Date: 12-10-2019 - Session time: 15:00:00 - Track: Application Database Development

Speaker: Huy Ly

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.

SessionID: 98831

Maximum SQL Server on VMware Performance

Back to calendar

Event Date: 12-10-2019 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment

Speaker: David Klee

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.

SessionID: 94364

Diagnosing and fixing deadlocks in SQL Server

Back to calendar

Event Date: 12-10-2019 - Session time: 16:15:00 - Track: Application Database Development

Speaker: Jake Manske

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.

SessionID: 94417

Getting Started with SQL Server Reporting Services (SSRS)

Back to calendar

Event Date: 12-10-2019 - Session time: 16:15:00 - Track: Analytics and Visualization

Speaker: Ashley Day

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.

SessionID: 94431

Cosmos DB Develop Locally Deploy Globally

Back to calendar

Event Date: 12-10-2019 - Session time: 16:15:00 - Track: Application Database Development

Speaker: Jim Dorame

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.

SessionID: 94716

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

Back to calendar

Event Date: 12-10-2019 - Session time: 16:15:00 - Track: Cloud Application Development Deployment

Speaker: Dan Mallott

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.

SessionID: 94902

Building your Microsoft Business Intelligence (MSBI) Career

Back to calendar

Event Date: 12-10-2019 - Session time: 16:15:00 - Track: Professional Development

Speaker: Ganesh Lohani

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.

SessionID: 95095

Get your Git on with Source Control

Back to calendar

Event Date: 12-10-2019 - Session time: 16:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Elizabeth Noble

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.

SessionID: 96484

Bottling Up Your Data Lake with Delta Lake Tables

Back to calendar

Event Date: 12-10-2019 - Session time: 16:15:00 - Track: Application Database Development

Speaker: JD Braun

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!

SessionID: 96648

Managing ETL Change Using BIMLScript

Back to calendar

Event Date: 12-10-2019 - Session time: 16:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Russel Loski

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.

SessionID: 96916

SQL Server 2019 - New Features and Enhancements

Back to calendar

Event Date: 12-10-2019 - Session time: 16:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Ameena Lalani

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.

SessionID: 98125

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

Back to calendar

Event Date: 12-10-2019 - Session time: 16:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Dave Bland

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.

This site is open source. Improve this page.