sqlsathistory

Nr: 930

Back to Main list

SQLSaturday #930 - Cleveland 2020

Start Time (24h) Speaker Track Title
08:00:00 Paul Popovich Jr Admin Registration
08:25:00 Paul Popovich Jr Admin Opening
08:30:00 Matt Slocum Database Performance Hardware Hints For The SQL DBA - Don't Let Your IT Department Hand You A Big Bag Of Hurt
08:30:00 Leslie Andrews SQL Development The Power of Data: The Complete Beginners Data Warehouse Kit
08:30:00 Taiob Ali Cloud If you use Azure, you must learn Kusto Query Language?
08:30:00 John Deardurff Database Performance Inside the Database Engine
08:30:00 Kevin Feasel Analytics and Visualization Eyes on the Prize: Simple and Effective Dashboard Visualization Techniques
08:30:00 Dave Bland Database Monitoring, Maintenance, and Tools How to do a Complete SQL Server Assessment
08:30:00 Hilary Cotter Database Architecture and Design Replication Technologies
09:30:00 Paul Popovich Jr Admin Break
09:45:00 Frank Gill Database Performance Performance Improvements in SQL Server 2019
09:45:00 Jes Schultz SQL Development Source Control for Databases: Why You Need It and How To Get Started
09:45:00 Matt Gordon Analytics and Visualization Make Your Company Conversational using Azure Cognitive Services
09:45:00 Peter Shore Database Monitoring, Maintenance, and Tools Wait Wait Do Tell Me
09:45:00 Joseph Fleming Database Performance Going Beyond the Basics with Query Store
09:45:00 Dan de Sousa Cloud Azure Data Factory as easy as 1..2...3
11:00:00 Allen White Database Monitoring, Maintenance, and Tools Find (So You can Fix) those Troublesome Queries
11:00:00 Sarah Dutkiewicz SQL Development Using Azure DevOps to Automate Database Deployments
11:00:00 Angela Henry Database Architecture and Design Data Types Do Matter
11:00:00 Matthew Groves Analytics and Visualization Introduction to SQL++ for Big Data: Same Language, More Power
11:00:00 Jim Donahoe Cloud Mario..Take My Data To The Cloud!
11:00:00 Jeff Iannucci Database Performance It's Not Your Fault, It's the SQL Server Default
12:00:00 Paul Popovich Jr Admin Lunch
13:30:00 Anthony Nocentino Cloud Practical Container Scenarios in Azure
13:30:00 Andy Mallon SQL Development Shortcuts from an Impatient DBA
13:30:00 Ed Wagner Database Monitoring, Maintenance, and Tools DBA - What's Most Important
13:30:00 Rayis Imayev Database Architecture and Design Loading your Data Vault with Azure Data Factory Mapping Data Flows
13:30:00 Joshua Higginbotham Analytics and Visualization Tapping into the Power of Data Flows in Power BI
13:30:00 David Maxwell Database Performance SQL Server Indexing - Practical Solutions
15:00:00 Jeff Moden SQL Development Automating "Excel Hell" with T-SQL
15:00:00 Marsha Pierce Database Architecture and Design How To Talk To Your Storage Admin
15:00:00 Andy Levy SQL Development Keys to a Healthy Relationship with SQL Server
15:00:00 Michael J Swart Database Performance What Developers Need to Know About The Transaction Log
15:00:00 Eugene Meidinger Analytics and Visualization Introduction to M (a.k.a Power Query)
15:00:00 Sean Forgatch Cloud Data Hub Automation with Databricks Delta
16:15:00 Slava Murygin Analytics and Visualization Power BI: From Zero to 101
16:15:00 Andy Yun Database Performance Let's Dive Into SQL Server I/O To Improve T-SQL Performance
16:15:00 Josh Handler Database Monitoring, Maintenance, and Tools Real World Use Cases Utilizing DbaTools.IO
16:15:00 Hasan Savran Cloud CosmosDB is the missing piece to your Data puzzle!
16:15:00 Rob Volk Database Architecture and Design Tame Your Unruly Data With Constraints
17:15:00 Paul Popovich Jr Admin Closing

SessionID: 101242

Registration

Back to calendar

Event Date: 01-02-2020 - Session time: 08:00:00 - Track: Admin

Speaker: Paul Popovich Jr

Title: Registration

Abstract:

Reg

SessionID: 101236

Opening

Back to calendar

Event Date: 01-02-2020 - Session time: 08:25:00 - Track: Admin

Speaker: Paul Popovich Jr

Title: Opening

Abstract:

Open

SessionID: 100412

Hardware Hints For The SQL DBA - Don't Let Your IT Department Hand You A Big Bag Of Hurt

Back to calendar

Event Date: 01-02-2020 - Session time: 08:30:00 - Track: Database Performance

Speaker: Matt Slocum

Title: Hardware Hints For The SQL DBA - Don't Let Your IT Department Hand You A Big Bag Of Hurt

Abstract:

Most IT departments are stretched thin and do not usually have the opportunity to fully investigate the true needs of the database infrastructure. In this session, we will cover a number of aspects that will help the SQL DBA have informed conversations with IT in order to ensure that better decisions are made when it comes to compute and storage hardware in order to deliver improved performance and reduced licensing cost.

This session will also cover some options that the DBA can investigate if they have been handed hardware that is not quite up to par.

SessionID: 100435

The Power of Data: The Complete Beginners Data Warehouse Kit

Back to calendar

Event Date: 01-02-2020 - Session time: 08:30:00 - Track: SQL Development

Speaker: Leslie Andrews

Title: The Power of Data: The Complete Beginners Data Warehouse Kit

Abstract:

For many of us data is scattered in many different systems. We almost all have data that someone wants to compare or track but can't without a lot of manual manipulation. So, how do you tie disparate systems together? With a Data Warehouse! In this presentation you will get the skills you need to start building your own. We will discuss the basics of what a Data Warehouse is, the tools needed to create, deploy and manage the Data Warehouse process, and the benefits of using the data you collect to manage operational processes and create data visualizations. After attending this session you will be able to return to your job and amaze people with your ability to show them the power of the data!

SessionID: 100485

If you use Azure, you must learn Kusto Query Language?

Back to calendar

Event Date: 01-02-2020 - Session time: 08:30:00 - Track: Cloud

Speaker: Taiob Ali

Title: If you use Azure, you must learn Kusto Query Language?

Abstract:

Kusto is a service for storing and running interactive analytics over Big Data, easy to query using Kusto Query Language (KQL). As we make progress in our migration to cloud, we are learning new ways to monitor and alert on resources and services. Microsoft has consolidated many services under the umbrella of ‘Azure Monitor’. Whether you are ‘detecting and diagnose issues across applications’, ‘correlate infrastructure issues for VMs’, ‘drill into your SQL database monitoring data with Log Analytics’ you will be using ‘Azure Monitor’. Azure Monitor uses a version of the KQL that is suitable for simple log queries but also includes advanced functionality such as aggregations, joins, and smart analytics. Going forward, KQL must be your primary resource for querying the Azure Monitor log.

In this 95% demo session, I will show you some ‘getting started’ tips and a few sophisticated queries using KQL. Come learn about the future of monitoring and investigations of Azure services.

SessionID: 99370

Inside the Database Engine

Back to calendar

Event Date: 01-02-2020 - Session time: 08:30:00 - Track: Database Performance

Speaker: John Deardurff

Title: Inside the Database Engine

Abstract:

This session is for the absolute beginner to learn the basic components of the Database Engine (Relational Engine, Storage Engine, and SQLOS) and what is the purpose of each of these three components in the execution of a simple query. The relational engine to process a query, the storage engine to access data and the SQLOS to manage resource access. The session is led by an expert Microsoft Certified Trainer (MCT) and former Microsoft MVP who regularly teaches SQL Server certification courses.

SessionID: 99468

Eyes on the Prize: Simple and Effective Dashboard Visualization Techniques

Back to calendar

Event Date: 01-02-2020 - Session time: 08:30:00 - Track: Analytics and Visualization

Speaker: Kevin Feasel

Title: Eyes on the Prize: Simple and Effective Dashboard Visualization Techniques

Abstract:

When done right, data visualization informs users quickly and efficiently with a minimum of distraction. When done wrong, we end up with spinning 3D pie charts. In this talk, we will look at techniques for effective dashboard design, minimizing noise and clutter (like spinning 3D pie charts) while providing relevant information to the intended audience. We will see how different types of charts work, build out rules of thumb around which charts to use, and integrate visuals to create a coherent dashboard image. When it comes to dashboards, we will compare and contrast dashboards based on their intended uses, such as interactive dashboards versus TV dashboards. Finally, we will take an awful dashboard and turn it into something which end users will appreciate.

SessionID: 99498

How to do a Complete SQL Server Assessment

Back to calendar

Event Date: 01-02-2020 - Session time: 08:30:00 - Track: Database Monitoring, Maintenance, and Tools

Speaker: Dave Bland

Title: How to do a Complete SQL Server Assessment

Abstract:

Completing a full assessment on a SQL Server is essential to learning about not only the current state of the server, but also any area that may be impacting performance or security. If you have more than one DBA, it is also important to have all the DBA team members review the same areas when completing an assessment. During this session we will discuss when assessments are useful, what should be included in the assessment as well as how to interpret the results. We will use a SQL script that will capture all the data needed. This script will more than 88 data points, including fragmentation of indexes, performance counter values, server and database security information, queries that consume the most CPU time including execution plans as well as many other data points. This session will also cover how to document your findings and recommendations.

SessionID: 99991

Replication Technologies

Back to calendar

Event Date: 01-02-2020 - Session time: 08:30:00 - Track: Database Architecture and Design

Speaker: Hilary Cotter

Title: Replication Technologies

Abstract:

Replication is a native SQL Server component which is used for copying, distribution and aggregating data between databases and servers. In this presentation Hilary Cotter discusses the different replication types and technologies and their sweet points. He also shows common use cases, gotcha's, and performance tuning and troubleshooting techniques.

SessionID: 101234

Break

Back to calendar

Event Date: 01-02-2020 - Session time: 09:30:00 - Track: Admin

Speaker: Paul Popovich Jr

Title: Break

Abstract:

Break

SessionID: 100426

Performance Improvements in SQL Server 2019

Back to calendar

Event Date: 01-02-2020 - Session time: 09:45:00 - Track: Database Performance

Speaker: Frank Gill

Title: Performance Improvements in SQL Server 2019

Abstract:

Microsoft released SQL Server 2019 in November. The latest version contains several improvements and new features that improve reliability and performance. First, Accelerated Database Recovery (ADR) completely redesigns the SQL Server database engine recovery process. This allows the time spent recovering from a crash or rolling back a transaction to be greatly reduced. ADR also prevents the transaction log from growing during a long-running transaction. Second, metadata for temporary tables can be stored in in-memory tables. For tempdb-heavy workloads, this removes a bottleneck and provides an improvement to performance. Finally, SQL Server 2019 supports the use of persistent-memory (PMEM) devices. PMEM can be used to persist the transaction log buffer, effectively removing LOGWRITE waits. Join me for this session to learn about these new features in SQL Server 2019 and how they can make your workload run faster.

SessionID: 100536

Source Control for Databases: Why You Need It and How To Get Started

Back to calendar

Event Date: 01-02-2020 - Session time: 09:45:00 - Track: SQL Development

Speaker: Jes Schultz

Title: Source Control for Databases: Why You Need It and How To Get Started

Abstract:

Database administrators and developers should attend this working demo session to see how to deploy a database to a development system, how to deploy changes from development back to the production database, and how multiple users can interact simultaneously. You'll leave with an understanding of the concepts of source control, sample code to work with, and a cheat sheet of commands to get you through your first day working with source control.

SessionID: 99362

Make Your Company Conversational using Azure Cognitive Services

Back to calendar

Event Date: 01-02-2020 - Session time: 09:45:00 - Track: Analytics and Visualization

Speaker: Matt Gordon

Title: Make Your Company Conversational using Azure Cognitive Services

Abstract:

Customers and users increasingly demand more personal and prompt communication from companies and brands with which they interact. How can data professionals help fill that need? The incredible power and instant accessibility of the Azure Cognitive Services Language and Speech APIs, combined with other Azure services, put the power in our hands. From translating between languages to make communication more efficient to analyzing support communications to ensure customers are happy, Azure Cognitive Services allows data professionals to enhance a brand's interaction with and impression in the customer community. This demo-heavy sessions walks through practical applications of these APIs that you can apply at home or at work immediately after the session.

SessionID: 99518

Wait Wait Do Tell Me

Back to calendar

Event Date: 01-02-2020 - Session time: 09:45:00 - Track: Database Monitoring, Maintenance, and Tools

Speaker: Peter Shore

Title: Wait Wait Do Tell Me

Abstract:

Hurry up and wait, it happens to all of us, even SQL Server. Why is SQL Server waiting? What can we do about it? These questions will be addressed as we define what a wait really is in SQL Server and some approaches to reduce the waiting. This session, targeted at data professionals, managers, developers, and sysadmins, will also explore a few of the common SQL waits and specifically what we can do about them.

SessionID: 99601

Going Beyond the Basics with Query Store

Back to calendar

Event Date: 01-02-2020 - Session time: 09:45:00 - Track: Database Performance

Speaker: Joseph Fleming

Title: Going Beyond the Basics with Query Store

Abstract:

The query store, introduced with SQL 2016, has proven to be a valuable tool for gaining insight into performance issues and applying some basic first aid to troublesome queries. With SQL 2017, the ability to do automatic regression correction was introduced. Still, there are some limitations on what the query store can handle. In this session we'll review some query store basics, talk about limitations, and explore a way to work around some of those limitations by using data stored in the query store.

SessionID: 99900

Azure Data Factory as easy as 1..2...3

Back to calendar

Event Date: 01-02-2020 - Session time: 09:45:00 - Track: Cloud

Speaker: Dan de Sousa

Title: Azure Data Factory as easy as 1..2...3

Abstract:

In this session I will introduce Azure Data Factory and will demonstrate how easy it is to start using the service and how to get your ETL going forward in a matter of minutes. I will go through the best practices and, based on my experience, will expose some scenarios when I had to rethink the way ti should work because of some of the limitations of the service. I will explore the limitations and some ideas on how to overcome them.

There will be some live demos and by the end of the session we may have a working ETL solution that will move data from a SQL database as well as from a Blob Storage into an Azure SQL Datawarehouse (or a PaaS) instance.

SessionID: 100199

Find (So You can Fix) those Troublesome Queries

Back to calendar

Event Date: 01-02-2020 - Session time: 11:00:00 - Track: Database Monitoring, Maintenance, and Tools

Speaker: Allen White

Title: Find (So You can Fix) those Troublesome Queries

Abstract:

Every expert has their own set of tools they use to find and fix the problem areas of queries, but SQL Server provides the necessary information to both diagnose and troubleshoot where those problems actually are, and help you fix those issues, right in the box. In this session we will examine a variety of tools to analyze and solve query performance problems.

SessionID: 100480

Using Azure DevOps to Automate Database Deployments

Back to calendar

Event Date: 01-02-2020 - Session time: 11:00:00 - Track: SQL Development

Speaker: Sarah Dutkiewicz

Title: Using Azure DevOps to Automate Database Deployments

Abstract:

Whether you are dealing with SQL Server deployments or Azure SQL deployments, Azure DevOps helps us easily automate changing our databases - from scripted SQL objects to pre-deployment and post-deployment scripts, working with DACPACs, there are a variety of ways that Azure DevOps can alleviate deployment woes for data professionals. In this session, we will look at Azure DevOps and how to deploy changes to SQL Server and to Azure SQL.

SessionID: 99348

Data Types Do Matter

Back to calendar

Event Date: 01-02-2020 - Session time: 11:00:00 - Track: Database Architecture and Design

Speaker: Angela Henry

Title: Data Types Do Matter

Abstract:

They're just numbers, right? A date's a date. It's just string data, who cares? I can't tell you how many times I've heard these phrases. This session will help you understand why choosing the correct data type for your data is so important. It affects data quality, storage and performance. It can even produce incorrect query results.

SessionID: 99367

Introduction to SQL++ for Big Data: Same Language, More Power

Back to calendar

Event Date: 01-02-2020 - Session time: 11:00:00 - Track: Analytics and Visualization

Speaker: Matthew Groves

Title: Introduction to SQL++ for Big Data: Same Language, More Power

Abstract:

SessionID: 99662

Mario..Take My Data To The Cloud!

Back to calendar

Event Date: 01-02-2020 - Session time: 11:00:00 - Track: Cloud

Speaker: Jim Donahoe

Title: Mario..Take My Data To The Cloud!

Abstract:

Moving your databases to any data platform in Azure can be a daunting task. This session is designed to show you different methods to accomplish the task while having some fun in the process. Join Mario from Nintendo, Sonic from Sega as they make their journey from on-premise to the Cloud utilizing the methods supported by Microsoft. You will see Transactional Replication, the use of the Database Migration Assistant, and a simple deploy from SSMS!

SessionID: 99968

It's Not Your Fault, It's the SQL Server Default

Back to calendar

Event Date: 01-02-2020 - Session time: 11:00:00 - Track: Database Performance

Speaker: Jeff Iannucci

Title: It's Not Your Fault, It's the SQL Server Default

Abstract:

When you see those little green checkmarks, then you know your new SQL Server instance is ready to go, right? Not exactly. Your fresh installation has some questionable default settings that could cause headaches and heartburn in the future. In this session, we identify several instance and database defaults that could lead to disaster, and discuss how you can modify them to improve performance and avoid unnecessary problems.

SessionID: 101235

Lunch

Back to calendar

Event Date: 01-02-2020 - Session time: 12:00:00 - Track: Admin

Speaker: Paul Popovich Jr

Title: Lunch

Abstract:

Lunch

SessionID: 100196

Practical Container Scenarios in Azure

Back to calendar

Event Date: 01-02-2020 - Session time: 13:30:00 - Track: Cloud

Speaker: Anthony Nocentino

Title: Practical Container Scenarios in Azure

Abstract:

You’ve heard the buzz about containers and Kubernetes, now let’s start your journey towards rapidly deploying and scaling your container-based applications in Azure. In this session, we will introduce containers and the container orchestrator Kubernetes. Then we’ll dive into how to build a container image, push it into our Azure Container Registry and deploy it our Azure Kubernetes Services cluster. Once deployed, we’ll learn how to keep our applications available and how to scale them using Kubernetes.

SessionID: 100423

Shortcuts from an Impatient DBA

Back to calendar

Event Date: 01-02-2020 - Session time: 13:30:00 - Track: SQL Development

Speaker: Andy Mallon

Title: Shortcuts from an Impatient DBA

Abstract:

This session is about performance tuning your day.

We spend a lot of time thinking about how to write efficient code, but we don't spend a lot of time thinking about how to be efficient with how we use our tools. In this session I will show you some lesser known keyboard shortcuts, tips, tricks, and hacks that will make your day easier. These are the tricks I've picked up over the years that help me get my work done quicker and easier.

Even the most seasoned Database Professionals will learn a new trick that makes SSMS even easier to use.

Slides and handouts available on GitHub: http://am2.co/shortcuts-ppt

SessionID: 100493

DBA - What's Most Important

Back to calendar

Event Date: 01-02-2020 - Session time: 13:30:00 - Track: Database Monitoring, Maintenance, and Tools

Speaker: Ed Wagner

Title: DBA - What's Most Important

Abstract:

There are so many topics for a DBA to focus on that it can be overwhelming, especially for a new or accidental DBA. Without knowing what's most important, you can find yourself spending lots of time trying to figure out what's important. This session focuses on the five topics that matter most to a DBA, whether you're an aspiring DBA, a new DBA or a seasoned professional.

SessionID: 99383

Loading your Data Vault with Azure Data Factory Mapping Data Flows

Back to calendar

Event Date: 01-02-2020 - Session time: 13:30:00 - Track: Database Architecture and Design

Speaker: Rayis Imayev

Title: Loading your Data Vault with Azure Data Factory Mapping Data Flows

Abstract:

Mapping Data Flows feature of Azure Data Factory is now generally available since October 2019.

There are many different use-case scenarios that can be covered by Data Flows, considering that Data Flows in SQL Integration Service (SSIS) projects are still playing a big role in fulfilling Extracting-Loading-Transforming (ETL) patterns for your data.

In this session, I will share my experience of populating a Data Vault repository with the help of Mapping Data Flows in Azure Data Factory.

SessionID: 99713

Tapping into the Power of Data Flows in Power BI

Back to calendar

Event Date: 01-02-2020 - Session time: 13:30:00 - Track: Analytics and Visualization

Speaker: Joshua Higginbotham

Title: Tapping into the Power of Data Flows in Power BI

Abstract:

Power BI has changed the landscape when it comes to Analytics and Reporting. With the introduction of Power BI Data Flows, we've opened up the capabilities of doing light weight ETL work, internal to Power BI allowing for your Report writers and analysts to reuse the work done by others to make your development process more productive. In this session, we will cover the internals of Data Flows and work through demos on how to setup your first Data Flow to generate a usable model for your reporting needs.

SessionID: 99735

SQL Server Indexing - Practical Solutions

Back to calendar

Event Date: 01-02-2020 - Session time: 13:30:00 - Track: Database Performance

Speaker: David Maxwell

Title: SQL Server Indexing - Practical Solutions

Abstract:

Have you ever created an index on your database to improve performance, and nothing changed? Have you created indexes suggested by the Missing Index DMV or Database Tuning Advisor, and query performance actually got worse? Are you constantly rebuilding your indexes or updating statistics, just for minor, temporary gains in performance? If so, then this session is for you.

In this session, we’ll discuss how SQL Server selects and uses indexes to improve query performance. We’ll look at how SQL Server chooses a Scan vs. a Seek, why the Missing Index DMVs don’t always give good advice, and how to tell when your databases are over-indexed. We’ll review DMVs and stored procedures that will quickly show how your indexes are being used, and where they can be improved. After this session, you’ll have the knowledge and tools to properly optimize your indexing strategy and create significant performance gains for your important queries.

SessionID: 100404

Automating "Excel Hell" with T-SQL

Back to calendar

Event Date: 01-02-2020 - Session time: 15:00:00 - Track: SQL Development

Speaker: Jeff Moden

Title: Automating "Excel Hell" with T-SQL

Abstract:

Truly automate complex monthly SPREADSHEET IMPORTS without monthly code changes!

Right or wrong, spreadsheets still constitute a source of data that many of us have to import every week or month. The trouble is that most spreadsheets aren’t setup to look like an SQL table. Rather, they are setup as multiple dimensions to aid in user readability and that makes column mapping and importing seriously automation resistant.

This “Black Arts” session provides an introduction to a relatively simple method to quickly, easily, and automatically import such spreadsheets and the code to do so frequently requires no changes to be used across multiple disparate spreadsheets. Creation of the necessary staging table and the related mapping is all done automatically and the monthly addition of columns is automatically handled, as well. Some of the pitfalls of more traditional import methods will also be examined.

Don’t let the “Advanced” rating of this session scare you away. We make it simple!

SessionID: 100840

How To Talk To Your Storage Admin

Back to calendar

Event Date: 01-02-2020 - Session time: 15:00:00 - Track: Database Architecture and Design

Speaker: Marsha Pierce

Title: How To Talk To Your Storage Admin

Abstract:

A general discussion about storage and how it affects DBA's. We will discuss how to monitor for performance as well. We will also discuss what DBA's need to consider when talking to their storage administrators.

SessionID: 99331

Keys to a Healthy Relationship with SQL Server

Back to calendar

Event Date: 01-02-2020 - Session time: 15:00:00 - Track: SQL Development

Speaker: Andy Levy

Title: Keys to a Healthy Relationship with SQL Server

Abstract:

Developers and DBAs have had a long, sometimes strained relationship. Some developers see DBAs as roadblocks standing in the way of getting their work shipped; some DBAs see developers as agents of chaos bent on ruining their perfect database environments.

In this talk designed for application and database developers, we’ll talk about why SQL Server behaves the way it does, common database and query design pain points, and how we look for them. With real-world examples and tales of troublesome T-SQL, past and present, you’ll start to get a picture of what to do and not to do in your applications. Along the way, you’ll learn how to build a better relationship with both SQL Server and the DBAs responsible for it.

SessionID: 99439

What Developers Need to Know About The Transaction Log

Back to calendar

Event Date: 01-02-2020 - Session time: 15:00:00 - Track: Database Performance

Speaker: Michael J Swart

Title: What Developers Need to Know About The Transaction Log

Abstract:

Every database change is tracked in the transaction log. It's an essential component to keeping database transactions atomic and durable.

As workloads increase, the performance and throughput to the transaction log matters. In fact the throughput of the transaction log can become the biggest category of database waits. We're going to take a close look at the function of the transaction log, the challenges that developers can face because of it and we'll discuss what developers can do to about it.

SessionID: 99572

Introduction to M (a.k.a Power Query)

Back to calendar

Event Date: 01-02-2020 - Session time: 15:00:00 - Track: Analytics and Visualization

Speaker: Eugene Meidinger

Title: Introduction to M (a.k.a Power Query)

Abstract:

When it comes to getting your data into Excel or Power BI, M is your best choice. The M Language (A.K.A Power Query) is a powerful tool for self-service data preparation. However, it's not clear where it fits compared to tools like SSIS or TSQL. It's also not clear what it's limitations are. This session will cover the basics of M and when to use it.

In this session, we'll demonstrate how M is a linear series of transformations, just like a set of steps from a recipe. We'll show how 80% of what you will ever need to do can be done from the GUI. We'll also talk about how to write custom code for that other 20%. By the end of this presentation, you'll be able to take any manual cleanup you do today and turn it into a repeatable process with M.

SessionID: 99921

Data Hub Automation with Databricks Delta

Back to calendar

Event Date: 01-02-2020 - Session time: 15:00:00 - Track: Cloud

Speaker: Sean Forgatch

Title: Data Hub Automation with Databricks Delta

Abstract:

Databricks Delta is the new standard for building a data lake as a part to your data warehouse. In this sessions we will learn how we can automate the development and ETL of a Data Hub\PSE in Databricks Delta that can process 1000's of tables with minimal code.

Agenda:

SessionID: 100259

Power BI: From Zero to 101

Back to calendar

Event Date: 01-02-2020 - Session time: 16:15:00 - Track: Analytics and Visualization

Speaker: Slava Murygin

Title: Power BI: From Zero to 101

Abstract:

Power BI is already proven technology and everyone should know at least basics of it.

That is elementary startup session at which you will learn:

After this session you will be really able to work with Power BI on your own.

SessionID: 100526

Let's Dive Into SQL Server I/O To Improve T-SQL Performance

Back to calendar

Event Date: 01-02-2020 - Session time: 16:15:00 - Track: Database Performance

Speaker: Andy Yun

Title: Let's Dive Into SQL Server I/O To Improve T-SQL Performance

Abstract:

Do you understand how SQL Server handles I/O? If not, you should. Understanding I/O is more important than ever with increasing cloud adoption, due to cloud costing models. But even on-premises, I/O has a direct impact on T-SQL performance.

Join me for a deep dive into the storage engine to understand how SQL Server handles I/O. Concepts will be paired with T-SQL examples to illustrate the practical impacts.

When you leave, you'll be able to optimize your T-SQL reduce I/O and improve performance across the board.

SessionID: 100612

Real World Use Cases Utilizing DbaTools.IO

Back to calendar

Event Date: 01-02-2020 - Session time: 16:15:00 - Track: Database Monitoring, Maintenance, and Tools

Speaker: Josh Handler

Title: Real World Use Cases Utilizing DbaTools.IO

Abstract:

If you have been anywhere near the SQL community in the past year, you have heard of this cool new toolset call DBAtools. DBAtools is set of PowerShell commands that will help make every DBA's (including the accidental DBA's) life easier. With just a few piece of information, you can manage and report on your SQL instances, from one to many, with ease. This session is a quick overview of what DBAtools is, some of the things you can do with it, and then some real world examples that are taken from our daily uses. Our objective is that when you leave this session, you will be comfortable reporting on your instances, and be prepared to take the next steps, AUTOMATION!!

SessionID: 99642

CosmosDB is the missing piece to your Data puzzle!

Back to calendar

Event Date: 01-02-2020 - Session time: 16:15:00 - Track: Cloud

Speaker: Hasan Savran

Title: CosmosDB is the missing piece to your Data puzzle!

Abstract:

You have been hearing about Azure CosmosDB but you haven't had a chance to explore it. In this session, you will learn the key concepts of Azure Cosmos DB. I will use many analogies to explain advantages and limitations of Azure CosmosDB. By the end of this session, you will be able to setup CosmosDB and know its available tools.

I will cover the following topics in this session Why do we need another database system? How to setup Azure CosmosDB How to create database and containers. How much does it cost? Multi-Model Apis CosmosDB vs SQL Server How to Import Data into CosmosDB How to use Cosmos DB Emulator CosmosDB Limitations

SessionID: 99844

Tame Your Unruly Data With Constraints

Back to calendar

Event Date: 01-02-2020 - Session time: 16:15:00 - Track: Database Architecture and Design

Speaker: Rob Volk

Title: Tame Your Unruly Data With Constraints

Abstract:

Bad data comes in many forms: duplicate rows, wrong data type, invalid values, and orphaned or missing foreign keys. Time is wasted cleansing, reviewing and correcting data, not to mention the potential hazards bad data can cause. This introductory presentation will explain the data types and constraints available in SQL Server, and how they can replace or augment business rules that would otherwise be written in application or procedure code. Performance benefits provided by constraints will be demonstrated. We will examine the various system views and procedures that describe constraints and how to use them to document your databases. You will be able to apply this knowledge to your database environments and see significant improvements in data quality, performance, and reliability.

SessionID: 101237

Closing

Back to calendar

Event Date: 01-02-2020 - Session time: 17:15:00 - Track: Admin

Speaker: Paul Popovich Jr

Title: Closing

Abstract:

Closing