sqlsathistory

Nr: 842

Back to Main list

SQLSaturday #842 - Madison 2019

Start Time (24h) Speaker Track Title
09:30:00 Ross McNeely BI Platform Architecture, Development Administration Power BI in Healthcare
09:30:00 Ameena Lalani Database Administration Learn History from Temporal Tables
09:30:00 Dave Bland SQL 101 Data Types - What do I need to know about them
09:30:00 Andy Yun Professional Development Everyone Has a Story to Tell: Developing Your First Presentation
09:30:00 Andy Yun Application Database Development Practical SQL Server Internals for T-SQL Developers
09:30:00 Justin Mannhardt Analytics and Visualization Playing with (M)agic: an introduction to writing M code in Power BI
09:30:00 Joshuha Owen Cloud Application Development Deployment Azure Data Factory V2: The cloud SSIS we have been waiting for?
09:30:00 Jordan Anderson Cloud Application Development Deployment Real-Time IoT Analytics at the Edge (Double session length)
09:30:00 Ashley Day BI Platform Architecture, Development Administration Introduction to ETL with SQL Server Integration Services (SSIS)
09:30:00 Thomas Lane Database Administration Tracking Data Transformations Using Temporal Tables
09:30:00 Bryan Walsh Other #GetModern with Dell EMC
11:00:00 Sean Forgatch BI Platform Architecture, Development Administration Azure Data Factory Ingestion Framework
11:00:00 Jim Dorame Cloud Application Development Deployment COSMOS DB Develop Local Deploy Globally
11:00:00 Kevin Feasel Database Administration APPLY Yourself
11:00:00 Joe Obbish Application Database Development Improving Columnstore Load Scalability on Large Servers
11:00:00 Marcus Radue Application Database Development Hop Aboard the Git Train - Transitioning from TFVC
11:00:00 Riley Major Application Database Development Refactoring Monolith Database Stored Procedures
11:00:00 Arthur Daniels III Database Administration Performance tuning with SQL Server memory grants
11:00:00 Brijeet Akula Professional Development Women In Technology - Panel
13:15:00 Dave Bland Database Administration How to use Execution Plans to find Performance Issues
13: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
13:15:00 Ben Miller Database Administration Tips and Tricks for the PowerShell DBA (Double session length)
13:15:00 Brian Larson Analytics and Visualization Handling Role Playing Dimensions in Tabular Models
13:15:00 Pat Phelan Application Database Development How did you get in here, and who said you could do that???
13:15:00 Bob Charapata SQL 101 Visual Studio DB Projects for worry-free development
13:15:00 Allen White Application Database Development Get Near Realtime ETL with Service Broker
13:15:00 Erik Darling Database Administration Query Optimization Explained in 15 Demos
13:15:00 Ed Leighton-Dick Database Administration Always Encrypted - Now with Enclaves!
14:45:00 Farouq Abukhamireh BI Information Delivery Dashboard in an Hour using Power BI
14:45:00 Andy Yun Application Database Development Why Your Data Type Choices Matter
14:45:00 Jim Dorame Application Database Development JSON for the Data Mortals
14:45:00 Kevin Feasel Analytics and Visualization Eyes on the Prize: Simple and Effective Dashboard Visualization Techniques
14:45:00 Jake Manske Application Database Development Diagnosing and fixing deadlocks in SQL Server
14:45:00 Cassie Zirbel BI Platform Architecture, Development Administration Fundamentals of Building an Effective Data Warehouse
14:45:00 Phil Ekins Strategy and Architecture SQL Server in AWS - Where to begin
14:45:00 Ross McNeely BI Platform Architecture, Development Administration 0 to Snowflake in 60 Minutes on Azure
16:00:00 Dan Mallott Application Database Development New Frontiers: Platform Independent Full Stack Development
16:00:00 Daniel Woods Analytics and Visualization Machine Learning with Databricks
16:00:00 Jeremiah Robinson SQL 101 SubQueries and Common Table Expressions
16:00:00 Erin Dempster BI Platform Architecture, Development Administration Sneak Peek at SQL Server 2019
16:00:00 Pat Phelan Application Database Development Relational Data Architecture 101
16:00:00 Scott Hietpas Application Database Development Azure DevOps for automating DW deployments
16:00:00 Allen White Application Database Development Find and Fix those Troublesome Queries
16:00:00 John Eisbrener Professional Development Got the Consulting Itch? The Ins and Outs of being a Contractor for a Living
16:00:00 Ed Leighton-Dick Application Database Development Principle of Least Privilege: The Key to Strong Security

SessionID: 88230

Power BI in Healthcare

Back to calendar

Event Date: 06-04-2019 - Session time: 09:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Ross McNeely

Title: Power BI in Healthcare

Abstract:

Ross has implemented Power BI Premium for regional, national, and global clients. Join this healthcare focused presentation to hear the various licensing and data sourcing methods for PBI. Ross will discuss actual use cases to help illustrate the flexibility in rolling out the product to different teams within your organization. Implementation strategies for the IT department will also be discussed. Deployment topics to be covered include a PBI loaded model, PBI direct connect, PBI live connect, and PBI mix-model. On-premises data sourcing topics include SQL databases, Oracle databases, Analysis Services Tabular, and Excel files. Discussion will cover various healthcare reporting sources, such as an Operational Data Store and a Data Warehouse. Cloud data sourcing topics include Azure Data Lake, Azure Analysis Services, Dataflows, and Snowflake on Azure. Ross will start the session by introducing the basics of PBI, and work our way into complexities necessary to support an enterprise.

SessionID: 88247

Learn History from Temporal Tables

Back to calendar

Event Date: 06-04-2019 - Session time: 09:30:00 - Track: Database Administration

Speaker: Ameena Lalani

Title: Learn History from Temporal Tables

Abstract:

SQL Server 2016 came out with a bucket full of cool new features. One of them is Temporal Tables. SQL Server 2017 made some enhancements in this area. Temporal tables are basically history tables of the normal tables; that allows us to retrieve data from any point in time for every change such as updates and deletes. It does this all without any change to application code and without needing any triggers. In this session, we will see what the requirements of creating temporal tables are. We will see the demo on insert and update functionality and how to query historical information using new TSQL clause. We will touch upon retention of history as well. It has lots of demos and less theory.

SessionID: 88286

Data Types - What do I need to know about them

Back to calendar

Event Date: 06-04-2019 - Session time: 09:30:00 - Track: SQL 101

Speaker: Dave Bland

Title: Data Types - What do I need to know about them

Abstract:

This is a 100 level sessions intended for the folks that are just starting their career as a data professional working with SQL Server. In the session we will go over the common data types and limitations associated with each of them. We will review how to determine the most appropriate data type to use in common situations. This sessions will not only cover the basic of a number of data types, but also review data type precedence, auto type conversions and the performance implications of data types.

SessionID: 88392

Everyone Has a Story to Tell: Developing Your First Presentation

Back to calendar

Event Date: 06-04-2019 - Session time: 09: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?

Well I say you can and will show you how to get started! In this session, I will teach you how to develop your idea and create session content, and share tips tricks that I have learned along the way.

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

SessionID: 88396

Practical SQL Server Internals for T-SQL Developers

Back to calendar

Event Date: 06-04-2019 - Session time: 09:30:00 - Track: Application Database Development

Speaker: Andy Yun

Title: Practical SQL Server Internals for T-SQL Developers

Abstract:

Ever wonder how the SQL Server storage engine processes your T-SQL queries? Curious about what else you could be doing to improve query performance?

Having basic exposure to SQL Server Internals enables one to write more effective T-SQL. Join me as we peek into the black box of the storage engine. Topics will include an overview of the storage engine, indexing, and the query optimizer, accompanied by practical consequences and solutions.

When you leave, you will have a greater understanding of the storage engine and how to avoid T-SQL design patterns that negatively impact performance.

SessionID: 89055

Playing with (M)agic: an introduction to writing M code in Power BI

Back to calendar

Event Date: 06-04-2019 - Session time: 09:30:00 - Track: Analytics and Visualization

Speaker: Justin Mannhardt

Title: Playing with (M)agic: an introduction to writing M code in Power BI

Abstract:

Do you love Power Query? Are you ready to take your skills to the next level? Learning to write M code is easier than you think! Writing M code can reduce maintenance and create a more dynamic solution for you and your users.

In this session you will learn:

  1. Where you can write M code in PowerQuery.
  2. The different types of objects you can use as variables in your code.
  3. Different ways you can leverage variables to create a dynamic solution.

SessionID: 89302

Azure Data Factory V2: The cloud SSIS we have been waiting for?

Back to calendar

Event Date: 06-04-2019 - Session time: 09:30:00 - Track: Cloud Application Development Deployment

Speaker: Joshuha Owen

Title: Azure Data Factory V2: The cloud SSIS we have been waiting for?

Abstract:

Azure Data Factory V2 is relatively new in Azure and has a lot of great new SSIS-like features but is it good enough to replace SSIS? In this session we will go over some of the new control flow, branching, and scheduling features in Azure Data Factory and see how to make a fully cloud capable data orchestration engine. As a bonus we'll also show how you can run SSIS packages directly in Azure!

SessionID: 89390

Real-Time IoT Analytics at the Edge (Double session length)

Back to calendar

Event Date: 06-04-2019 - Session time: 09:30:00 - Track: Cloud Application Development Deployment

Speaker: Jordan Anderson

Title: Real-Time IoT Analytics at the Edge (Double session length)

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: 89499

Introduction to ETL with SQL Server Integration Services (SSIS)

Back to calendar

Event Date: 06-04-2019 - Session time: 09:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Ashley Day

Title: Introduction to ETL with SQL Server Integration Services (SSIS)

Abstract:

In this session, geared toward beginner level users, attendees will be introduced to SQL Server Integration Services (SSIS) as an ETL tool. We will review the SSIS workspace and toolbox to familiarize users with the various features offered and how to navigate between them, as well as discuss their functionality. We will then build an SSIS package to extract data from a flat file source and load it into a SQL Server Database. The session will conclude by reviewing best practices surrounding the documentation of SSIS solutions, and attendees will receive a copy of documentation describing the package we created.

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

SessionID: 90037

Tracking Data Transformations Using Temporal Tables

Back to calendar

Event Date: 06-04-2019 - Session time: 09:30:00 - Track: Database Administration

Speaker: Thomas Lane

Title: Tracking Data Transformations Using Temporal Tables

Abstract:

Along with change tracking and change data capture Microsoft has introduced a new method for tracking data changes within its databases called Temporal tables. Microsoft introduced temporal, or system-versioned, tables in SQL Server 2016 as a new database feature. A temporal table truly introduces two tables into the mix: one for current data and another for historical data. This talk will show how the feature is implemented and used along with a discussion on the common usage for temporal tables. Comparison to change tracking and change data capture will also be discussed. Scripts will be explored for the automation of the creation of temporal tables along with its use in data warehousing.

SessionID: 92830

#GetModern with Dell EMC

Back to calendar

Event Date: 06-04-2019 - Session time: 09:30:00 - Track: Other

Speaker: Bryan Walsh

Title: #GetModern with Dell EMC

Abstract:

Consistent and predictable performance is critical for any successful deployment of Microsoft SQL Server. All-Flash arrays have been available for years and sub-millisecond response times should be the expectation. Maximize the performance and agility of your environment and learn how to automate and leverage self-service for snapshots of your databases for protection and re-purposing. Test/dev infrastructures can be refreshed from production DBs in minutes rather than hours or days. Stop working harder and slower than you need to be, learn how you can leverage Dell EMC. Whether storage, servers, networking, data protection, converged or hyper-converged… we have you covered.

SessionID: 88207

Azure Data Factory Ingestion Framework

Back to calendar

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

Speaker: Sean Forgatch

Title: Azure Data Factory Ingestion Framework

Abstract:

In this session we will discuss Data Strategy around data lake ingestion and how that shapes the design of a framework to fuel Azure Data Factory. This session will take you through the development of a Metadata database designed using Data Vault modeling, the collection of the metadata, as well as building a fully automated Data Factory pipeline.

SessionID: 88402

COSMOS DB Develop Local Deploy Globally

Back to calendar

Event Date: 06-04-2019 - Session time: 11:00:00 - Track: Cloud Application Development Deployment

Speaker: Jim Dorame

Title: COSMOS DB Develop Local 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: 88450

APPLY Yourself

Back to calendar

Event Date: 06-04-2019 - Session time: 11:00:00 - Track: Database Administration

Speaker: Kevin Feasel

Title: APPLY Yourself

Abstract:

Microsoft introduced the APPLY operator in SQL Server 2005. This under-used, non-standard operator can help us solve a number of common (and not-so-common) problems with elegant code which performs well. We will look several problem spaces in which the APPLY operator shines, such as joining to table-valued functions, getting the top N child records for each parent record, string splitting, and word matching. With the use of these examples, we will gain a deeper understanding of when to use the APPLY operator.

SessionID: 88504

Improving Columnstore Load Scalability on Large Servers

Back to calendar

Event Date: 06-04-2019 - Session time: 11:00:00 - Track: Application Database Development

Speaker: Joe Obbish

Title: Improving Columnstore Load Scalability on Large Servers

Abstract:

Clustered Columnstore indexes can be a great solution for data warehousing workloads, but loading lots of data as quickly as possible is still an arcane art. We will walk through how to improve scalability of two common loading patterns using lessons learned from production workloads involving billions of rows. Come to this session to improve your Columnstore load times, to learn about scalability on large servers, or simply to be challenged.

SessionID: 89831

Hop Aboard the Git Train - Transitioning from TFVC

Back to calendar

Event Date: 06-04-2019 - Session time: 11:00:00 - Track: Application Database Development

Speaker: Marcus Radue

Title: Hop Aboard the Git Train - Transitioning from TFVC

Abstract:

Stay on track with your version control tool and learn the transition from TFVC to Git. We will demonstrate the migration process from TFVC to Git along with some things to consider before your migration. Stick around for some Git best practices that will get you off to a fast start with your new version control tool!

SessionID: 90600

Refactoring Monolith Database Stored Procedures

Back to calendar

Event Date: 06-04-2019 - Session time: 11:00:00 - Track: Application Database Development

Speaker: Riley Major

Title: Refactoring Monolith Database Stored Procedures

Abstract:

We get it. Move fast and break things. Just ship it! But what's left a giant stored procedure with cursors, temp tables, and mystery calculations. It's a big black box that nobody wants to touch. Let's fix that. We'll open the lid on an example monolith and do major surgery. What's left will perform better, be easier to understand, encourage code reuse, and be easier to test.

SessionID: 90601

Performance tuning with SQL Server memory grants

Back to calendar

Event Date: 06-04-2019 - Session time: 11:00:00 - Track: Database Administration

Speaker: Arthur Daniels III

Title: Performance tuning with SQL Server memory grants

Abstract:

When you're performance tuning queries with memory grants, you want to know where, how and why the memory is granted and used in your query.

In this session, we'll talk about analyzing requested and granted memory inside execution plans, the plan cache, and in currently running queries.

We'll also talk about troubleshooting your system when many queries have memory grants.

Prerequisites: General knowledge of execution plans and query writing

SessionID: 91124

Women In Technology - Panel

Back to calendar

Event Date: 06-04-2019 - Session time: 11:00:00 - Track: Professional Development

Speaker: Brijeet Akula

Title: Women In Technology - Panel

Abstract:

We are excited to host our Second Women In Technology Speaker Panel. This year we have 6 panelists joining us for discussion of issues pertinent to women working in technology.

Please join us as we welcome: • Virginia Logston – Retired - IT Pioneer • Jenny Herritz - Principal - SVA Consulting • Jesi Betley – VP of IT and Process Improvement – Mueller Sports Medicine • Molly Gallmeier – VP Business Development – Talavant • Sarah Terry-Rost - Director of Clinical Applications - UnityPoint Health • Tammy Passineau – BI Lead – Sub Zero

SessionID: 88288

How to use Execution Plans to find Performance Issues

Back to calendar

Event Date: 06-04-2019 - Session time: 13:15:00 - Track: Database Administration

Speaker: Dave Bland

Title: How to use Execution Plans to find Performance Issues

Abstract:

This is a introductory session on how a DBA and developers can use Execution plans to find performance bottlenecks. This will cover the fundamentals and cover some of the basic techniques that can be used to find hidden performance problems. We will also spend some time on how to properly read execution plans.

SessionID: 88361

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

Back to calendar

Event Date: 06-04-2019 - Session time: 13: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: 88471

Tips and Tricks for the PowerShell DBA (Double session length)

Back to calendar

Event Date: 06-04-2019 - Session time: 13:15:00 - Track: Database Administration

Speaker: Ben Miller

Title: Tips and Tricks for the PowerShell DBA (Double session length)

Abstract:

Do you have more than 1 server that you manage? More than 1 database? Then this session is for you. PowerShell interest is on the rise and it is one of the coolest tools you can learn as a DBA. Learn tips and tricks using PowerShell that will help you manage SQL Servers and get more done with less effort. From getting started in PowerShell to getting information about your servers/databases to making changes to your SQL Servers all using PowerShell. This is one tool you will want in your toolbelt to help sharpen your skills.

SessionID: 89624

Handling Role Playing Dimensions in Tabular Models

Back to calendar

Event Date: 06-04-2019 - Session time: 13:15:00 - Track: Analytics and Visualization

Speaker: Brian Larson

Title: Handling Role Playing Dimensions in Tabular Models

Abstract:

Most data models contain at least one situation requiring role playing dimensional behavior. For example, Order Date, Ship Date, and Invoice Date all linked to the Date table. The tabular model, available in Power BI, Power Pivot, and SQL Server Analysis Services, provides multiple methods for handling role playing dimensions. In this session, we will implement examples of each of these alternatives, including the DAX expressions required to fully exploit each one. We will explore the strengths and weaknesses of each approach as well as best practices when implementing each of these alternatives. Special emphasis will be given to model maintainability as well as the experience created for users exploring and analyzing the model.

SessionID: 90053

How did you get in here, and who said you could do that???

Back to calendar

Event Date: 06-04-2019 - Session time: 13:15:00 - Track: Application Database Development

Speaker: Pat Phelan

Title: How did you get in here, and who said you could do that???

Abstract:

This session covers the "101" issues of security within SQL Server. It covers authentication (AD, SQL Server, and Application Roles) and the basics of security declarations. This is targeted at entry and mid level database administrators and application designers that need an introduction or a refresher on how to grant access to the database engine and permissions at the SQL Server and database levels. NOTE: this presentation does NOT cover hacking, security work-arounds, etc.

SessionID: 90186

Visual Studio DB Projects for worry-free development

Back to calendar

Event Date: 06-04-2019 - Session time: 13:15:00 - Track: SQL 101

Speaker: Bob Charapata

Title: Visual Studio DB Projects for worry-free development

Abstract:

If you aren't using DB projects yet, you should! If you tried to start and failed, we'll discuss some of the common challenges and how to resolve them. We'll cover a typical project setup and best practices for effective schema management and deployment across environments.

SessionID: 90408

Get Near Realtime ETL with Service Broker

Back to calendar

Event Date: 06-04-2019 - Session time: 13:15:00 - Track: Application Database Development

Speaker: Allen White

Title: Get Near Realtime ETL with Service Broker

Abstract:

Most of the time you’ll see ETL being done with a tool such as SSIS, but what if you need near-realtime reporting? You need to get the updates in your OLTP database to the Data Warehouse quickly, but with minimal impact on your application. This session will demonstrate how to keep your data warehouse updated in near real-time using Service Broker messages from your OLTP database.

SessionID: 90565

Query Optimization Explained in 15 Demos

Back to calendar

Event Date: 06-04-2019 - Session time: 13:15:00 - Track: Database Administration

Speaker: Erik Darling

Title: Query Optimization Explained in 15 Demos

Abstract:

You've got the hang of writing queries and creating indexes, but once you hit F5 you have no idea what's going to happen.

In this session, we'll look a little deeper into query optimization, and why SQL Server makes the choices it does.

This will be fast-paced, demo-heavy and slide-light.

SessionID: 90596

Always Encrypted - Now with Enclaves!

Back to calendar

Event Date: 06-04-2019 - Session time: 13:15:00 - Track: Database Administration

Speaker: Ed Leighton-Dick

Title: Always Encrypted - Now with Enclaves!

Abstract:

Always Encrypted was introduced in SQL Server 2016, and it was a big step forward for encryption - but it had a very long list of exclusions which prevented it from being adopted by many organizations. Now, with SQL Server 2019, Always Encrypted is getting some much-needed improvements to its functionality. By utilizing the secure enclave capabilities of Windows 2019, SQL Server adds some impressive new abilities to work with data while it is encrypted. In this session, we’ll explore the secure enclave, and we'll see how you can leverage the new capabilities of Always Encrypted in your environment.

SessionID: 88237

Dashboard in an Hour using Power BI

Back to calendar

Event Date: 06-04-2019 - Session time: 14:45:00 - Track: BI Information Delivery

Speaker: Farouq Abukhamireh

Title: Dashboard in an Hour using Power BI

Abstract:

In this live demo I would like to show you how to create an effective and interactive dashboard using Power BI, I will also talk about and show some Power BI best Practices.

SessionID: 88395

Why Your Data Type Choices Matter

Back to calendar

Event Date: 06-04-2019 - Session time: 14:45:00 - Track: Application Database Development

Speaker: Andy Yun

Title: Why Your Data Type Choices Matter

Abstract:

Did you know that poor data type choices can be a real performance killer? Would you be surprised to learn that data type decisions can have a significant impact on your database design and performance?

Attend this session to learn how database records are stored within SQL Server and why all data types are not created equal. Armed with that knowledge, we will explore several performance scenarios that may be impacting your systems right now! When you leave, you will be able to explain to your colleagues why data type choices matter, assess your own systems, and implement some best practices to mitigate these performance killers.

SessionID: 88403

JSON for the Data Mortals

Back to calendar

Event Date: 06-04-2019 - Session time: 14:45: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: 88448

Eyes on the Prize: Simple and Effective Dashboard Visualization Techniques

Back to calendar

Event Date: 06-04-2019 - Session time: 14:45: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: 88814

Diagnosing and fixing deadlocks in SQL Server

Back to calendar

Event Date: 06-04-2019 - Session time: 14:45: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: 90027

Fundamentals of Building an Effective Data Warehouse

Back to calendar

Event Date: 06-04-2019 - Session time: 14:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Cassie Zirbel

Title: Fundamentals of Building an Effective Data Warehouse

Abstract:

Building a data warehouse that is effective and efficient is a constant challenge to designers and developers, and this session will highlight some of the fundamental guidelines to use during the life cycle of a data warehouse. With a broad range of topics, both business reporting users and developers architects will find this session informative. We will review the importance of each phase of the lifecycle, including analysis, design, development, testing and maintenance. We will discuss the expected outcomes for each phase, as well as the stakeholders who should be involved in the decision making process along the way. We will provide examples of documentation to help guide each step and discuss issues that commonly arise when building a Data Warehouse. At the conclusion of the session, attendees will receive a Data Warehouse checklist that provides a comprehensive overview of everything discussed and can serve as a resource beyond the session.

SessionID: 90289

SQL Server in AWS - Where to begin

Back to calendar

Event Date: 06-04-2019 - Session time: 14:45:00 - Track: Strategy and Architecture

Speaker: Phil Ekins

Title: SQL Server in AWS - Where to begin

Abstract:

This session will discuss your options for running SQL server in AWS, the easy way (and the hard way) to configure High Availability and how to ensure your Disaster Recovery needs are also met.

We will also look at strategies for moving your data into AWS. Done right there is rarely an "Easy" button for solid infrastructure choices but this session will get you well on the way!

SessionID: 92384

0 to Snowflake in 60 Minutes on Azure

Back to calendar

Event Date: 06-04-2019 - Session time: 14:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Ross McNeely

Title: 0 to Snowflake in 60 Minutes on Azure

Abstract:

Join this demo heavy session to get up and running on Snowflake in 60 minutes on Azure. You will learn how to quickly setup a data warehouse that can scale-up to support any data size, or scale-out to support any number of uses. Just as important is scaling-down to save on cost. We will first cover an overview of the Snowflake platform, and key enterprise capabilities. Demos will include loading data into Snowflake, exploring data, data time travel, and provisioning for various end users without eroding performance. Best practices will be discussed throughout the session, and we will conclude with a use case. Ross McNeely is a certified SnowPro.

SessionID: 88359

New Frontiers: Platform Independent Full Stack Development

Back to calendar

Event Date: 06-04-2019 - Session time: 16:00:00 - Track: Application Database Development

Speaker: Dan Mallott

Title: New Frontiers: Platform Independent Full Stack Development

Abstract:

For years, those of us who wanted to use non-Windows-based machines to do .NET or SQL Server development have been caught in a "worst of both worlds"-type of situation. We have had to use some sort of Windows VM or have had to go without a local copy of SQL Server. The good news is that thanks to Microsoft's efforts, we can now do full stack .NET development without ever touching a Windows VM or work arounds! In this talk, I'll live code a simple service with database back-end while introducing platform independent tools such as Visual Studio Code, SQL Operations Studio and SQL Server for Docker. Along the way, I'll discuss key differences and limitations between the Windows tools and their platform independent counterparts.

SessionID: 89389

Machine Learning with Databricks

Back to calendar

Event Date: 06-04-2019 - Session time: 16:00:00 - Track: Analytics and Visualization

Speaker: Daniel Woods

Title: Machine Learning with Databricks

Abstract:

Databricks holds enormous promise in providing organizations with large-scale analytics and machine learning at lightning speed. In this session, we will demonstrate a real business case where we utilize machine learning to improve customer retention.

The session begins with an overview of machine learning and its applications in business today; then, we dive into Databricks and its applications and advantages for data and analytics; finally, we implement our machine learning model in Databricks and build an analytics pipeline in Azure that delivers insights to decision makers.

SessionID: 89517

SubQueries and Common Table Expressions

Back to calendar

Event Date: 06-04-2019 - Session time: 16:00:00 - Track: SQL 101

Speaker: Jeremiah Robinson

Title: SubQueries and Common Table Expressions

Abstract:

This session will go over best practices for using subqueries and common table expressions (CTEs). We'll review basic concepts and then several examples. The focus will be on building efficient queries to solve complex problems while remaining understandable. Participants should feel welcome to bring their own complex query problems that we can work through together.

SessionID: 89800

Sneak Peek at SQL Server 2019

Back to calendar

Event Date: 06-04-2019 - Session time: 16:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Erin Dempster

Title: Sneak Peek at SQL Server 2019

Abstract:

SQL Server 2019 has a number of new and exciting features for the BI world, including the Big Data Cluster Edition with HDFS and Spark being added to Microsoft's offering. This session will give an overview of these features, as well as a few demos. Since SQL Server 2019 is still in CTP, features shown in this presentation are subject to change at RTM.

SessionID: 90054

Relational Data Architecture 101

Back to calendar

Event Date: 06-04-2019 - Session time: 16:00:00 - Track: Application Database Development

Speaker: Pat Phelan

Title: Relational Data Architecture 101

Abstract:

This presentation is a quick introduction for the DBA or developer who was just told that their boss promised a major new customer a scalable, well designed database. The customer will pay a lot of cash and years of ongoing business using this database… If you deliver it this week!

You’ll get a big bonus if you build this right, but you also remember what your co-workers did to the person who bungled the last database design… and wonder if that designer ever recovered! This session will introduce you to the fundamentals of Datatypes, Relational Algebra, and Normalization to help you avoid the major pitfalls and maybe get some sleep too!

This presentation is a survey of Data Architecture for the Intermediate DBA, it is not intended for experienced Data Modelers.

SessionID: 90185

Azure DevOps for automating DW deployments

Back to calendar

Event Date: 06-04-2019 - Session time: 16:00:00 - Track: Application Database Development

Speaker: Scott Hietpas

Title: Azure DevOps for automating DW deployments

Abstract:

Are you looking to incorporate CI/CD into your data warehouse solution? Azure DevOps provides tools to help automate deployment of DB and Analysis Services projects (and more). We'll demonstrate how to create a Build and Release pipeline to manage promotion across environments. We'll also discuss tips and tricks that provide greater control over deployment configurations with a little help from PowerShell.

SessionID: 90407

Find and Fix those Troublesome Queries

Back to calendar

Event Date: 06-04-2019 - Session time: 16:00:00 - Track: Application Database Development

Speaker: Allen White

Title: Find and 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: 90545

Got the Consulting Itch? The Ins and Outs of being a Contractor for a Living

Back to calendar

Event Date: 06-04-2019 - Session time: 16:00:00 - Track: Professional Development

Speaker: John Eisbrener

Title: Got the Consulting Itch? The Ins and Outs of being a Contractor for a Living

Abstract:

Have you ever thought about becoming a Consultant, but just didn't know if it was the right fit for you? In this session, I touch on various aspects of what being a consultant means, be it working for a consulting firm or independently for yourself. I'll cover some skills that are necessary to succeed in this field, touch on aspects of owning your own business, discuss ways to build up a network, and draw attention to some questions you should be asking yourself and others before you make the leap. By the end of the session, I hope you have enough information to know if becoming a consultant is the right choice for you or not.

SessionID: 90595

Principle of Least Privilege: The Key to Strong Security

Back to calendar

Event Date: 06-04-2019 - Session time: 16:00:00 - Track: Application Database Development

Speaker: Ed Leighton-Dick

Title: Principle of Least Privilege: The Key to Strong Security

Abstract:

A truly strong security model starts with no permissions and adds what is necessary to allow the user or application to do their assigned task - no more, no less. This is called the Principle of Least Privilege. It's a simple concept, but it can be quite difficult to implement in practice, especially if the prevailing practice has been much more permissive.

In this session, we'll talk about the Principle of Least Privilege in more detail, and we'll discuss ways to implement it for the three primary classes of users - general users, applications, and administrators. Each has their own set of needs that requires a separate approach to allowing the security to meet those needs. You'll leave with actionable ideas on ways that you can improve your company's security while minimizing the impact of the changes.