sqlsathistory

Nr: 662

SQLSaturday #662 - Sioux Falls 2017

Start Time (24h)	Speaker	Track	Title
08:15:00	Jim Dorame	Application Database Development	JSON for the Data Mortals
08:15:00	Brian Hansen	Application Database Development	Set Me Up: How to Think in Sets
08:15:00	Joshua Warne	Professional Development	Building Stronger Relationships Between Us... "Data People" and T
08:15:00	Jasmine Miller	BI Platform Architecture, Development Administration	Business Intelligence with R and Python
09:40:00	Marcus Hopfinger	Enterprise Database Administration Deployment	HELP! HELP! My System Databases Are Gone!
09:40:00	Janis Griffin	Enterprise Database Administration Deployment	Does Your Performance Tuning Need a 12-step Program?
09:40:00	Susantha Bathige	Enterprise Database Administration Deployment	Statistics and New Cardinality Estimator Model
09:40:00	Julia Renz	BI Platform Architecture, Development Administration	Even I Can Power BI!
11:00:00	Andy Tabisz	Application Database Development	Intro to PowerApps Flow - Creating mobile business apps without writing code
11:00:00	Don St. Cyr	BI Platform Architecture, Development Administration	Remote SQL Server Troubleshooting and Monitoring Using SSIS
11:00:00	Rick Bielawski	Application Database Development	Difficult Queries
11:00:00	Brian Hansen	Enterprise Database Administration Deployment	Visualize Your Transaction Log
13:25:00	Adam Koehler	Enterprise Database Administration Deployment	Isolation Levels – Understanding Transaction Temper Tantrums
13:25:00	Stacia Varga	BI Platform Architecture, Development Administration	Where Does R Fit Into Your SQL Server Stack?
13:25:00	Christopher Wolff	Cloud Application Development Deployment	Amazon Web Services RDS with SQL Server
13:25:00	Eric Zierdt	Professional Development	SQL Server DBA Quiz Show
14:45:00	Janis Griffin	Enterprise Database Administration Deployment	Welcome To the 2016 Query Store!
14:45:00	Stacia Varga	BI Platform Architecture, Development Administration	Reduce, Reuse, Recycle: Automating Your BI Framework
14:45:00	Brian Hansen	Enterprise Database Administration Deployment	Remember Back When? Temporal Tables in SQL Server 2016
14:45:00	Susantha Bathige	Enterprise Database Administration Deployment	How to Fix Cardinality Estimation Anomalies
16:05:00	Stacia Varga	BI Platform Architecture, Development Administration	Getting Your Story Straight with Data Visualizations
16:05:00	Nem Schlecht	Application Database Development	Maximizing SQL Server Management Studio for Developers and DBAs
16:05:00	Rick Bielawski	Application Database Development	Mastering queries into XML data.
16:05:00	George Bryant	BI Platform Architecture, Development Administration	Navigating Modern BI Infrastructure – Power BI Report Server (On-

SessionID: 64933

JSON for the Data Mortals

Back to calendar

Event Date: 19-08-2017 - Session time: 08:15:00 - Track: Application Database Development

Speaker: Jim Dorame

Title: JSON for the Data Mortals

Abstract:

In SQL Server 2016 Microsoft has include native handling of JSON. What does that mean? What is JSON? Why do I care? Will there be knives and hockey masks? Come to this session and you will learn what JSON is, where and how it is used and why as a data professional you need to know this.

SessionID: 66816

Set Me Up: How to Think in Sets

Back to calendar

Event Date: 19-08-2017 - Session time: 08:15:00 - Track: Application Database Development

Speaker: Brian Hansen

Title: Set Me Up: How to Think in Sets

Abstract:

SQL Server is optimized to work in sets, but this is certainly a paradigm shift for someone accustomed to row-by-row operations.

We will look at T-SQL features that can break set-based processing -- generally meaning poor performance -- and gather empirical evidence to support that assertion. We'll also look at some constructs to overcome these issues and make your T-SQL scripts run faster and use fewer resources.

SessionID: 68793

Building Stronger Relationships Between Us... "Data People" and T

Back to calendar

Event Date: 19-08-2017 - Session time: 08:15:00 - Track: Professional Development

Speaker: Joshua Warne

Title: Building Stronger Relationships Between Us... "Data People" and T

Abstract:

The role of data and IT professionals is evolving from simply responding to requests about business to one of helping shape the business strategy. The integration of these professionals into the strategy process is a transformation that presents communication challenges and requires more visibility by people typically known to be introverts. In this session we will discuss some of the barriers causing relationship pains as well as some techniques and strategies to begin building stronger relationships with the managers and end users so data can thrive and customer satisfaction can proliferate.

SessionID: 68848

Business Intelligence with R and Python

Back to calendar

Event Date: 19-08-2017 - Session time: 08:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jasmine Miller

Title: Business Intelligence with R and Python

Abstract:

With the integration of R into SQL Server 2016, and now Python into SQL Server 2017, this presentation will dive into the differences between the two languages, what they are best suited for, and highlight key features and packages within both for descriptive and predictive analytics. Application of SQL statements will be demonstrated within RStudio/Jupyter notebooks, as opposed to within SQL Server, in order to demonstrate its multi-purpose use across all platforms (Oracle, PostgreSQL, MySQL, etc.).

SessionID: 64556

HELP! HELP! My System Databases Are Gone!

Back to calendar

Event Date: 19-08-2017 - Session time: 09:40:00 - Track: Enterprise Database Administration Deployment

Speaker: Marcus Hopfinger

Title: HELP! HELP! My System Databases Are Gone!

Abstract:

Your worst nightmare has happened. You had a server crash and lost your system databases. Now what? Watch me break a Hyper-V virtual machine and then fix it again. This presentation will walk through regenerating and restoring your system databases to get back up and running. I will also discuss several situations I have faced and scenarios prepped for and strategies for preparing for the worst case DR situations.

SessionID: 65045

Does Your Performance Tuning Need a 12-step Program?

Back to calendar

Event Date: 19-08-2017 - Session time: 09:40:00 - Track: Enterprise Database Administration Deployment

Speaker: Janis Griffin

Title: Does Your Performance Tuning Need a 12-step Program?

Abstract:

Performance tuning can be complex.It's often hard to know which knob to turn or button to press to get the biggest performance boost. In this presentation, Janis Griffin, Database Performance Evangelist, SolarWinds, will detail 12 steps to quickly identify performance issues and resolve them. Attendees at this session will learn how to:

Quickly fine tune a SQL statement
Identify performance inhibitors to help avoid future performance issues
Recognize and understand how new SQL Server features can help improve query
performance

SessionID: 65096

Statistics and New Cardinality Estimator Model

Back to calendar

Event Date: 19-08-2017 - Session time: 09:40:00 - Track: Enterprise Database Administration Deployment

Speaker: Susantha Bathige

Title: Statistics and New Cardinality Estimator Model

Abstract:

Statistics in SQL Server plays a major role creating execution plan which essentially decides server performance. If you get a good execution plan the server performance is good otherwise it will impact negatively on the server performance. SQL Server 2014 introduced new Cardinality Estimation (CE) model to improve the quality of the execution plans via quality estimates of row counts. The new CE model is a major redesign to the Query Optimizer since SQL Server 7.0. In this session, I'm going to talk about how statistics is used to generate the execution plan, how execution plan changes with new CE model with demos.

SessionID: 66941

Even I Can Power BI!

Back to calendar

Event Date: 19-08-2017 - Session time: 09:40:00 - Track: BI Platform Architecture, Development Administration

Speaker: Julia Renz

Title: Even I Can Power BI!

Abstract:

Power BI Desktop is so intuitive when it comes to creating reports that even a 13 year old can do it. In fact I'm 13 and I can do it! Don't believe me? Come to my session as I demonstrate how to import data, create dashboards, and publish them to the Power BI service.

SessionID: 64564

Intro to PowerApps Flow - Creating mobile business apps without writing code

Back to calendar

Event Date: 19-08-2017 - Session time: 11:00:00 - Track: Application Database Development

Speaker: Andy Tabisz

Title: Intro to PowerApps Flow - Creating mobile business apps without writing code

Abstract:

PowerApps allows you to extend your SQL SharePoint business data along with data from over 100 other software packages to iPhone, Android phone and other mobile devices. Flow extends that capability by automating your workflow. This introduction will discuss Microsoft's strategy and demonstrate how you can create your own business apps.

SessionID: 65107

Remote SQL Server Troubleshooting and Monitoring Using SSIS

Back to calendar

Event Date: 19-08-2017 - Session time: 11:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Don St. Cyr

Title: Remote SQL Server Troubleshooting and Monitoring Using SSIS

Abstract:

We have over 3500 remote installations of SQL Server and only 3 DBAs to find and resolve issues. While some installations need daily examination others operate for months without any attention at all.

We needed a system to keep a light, revolving set of data that we could quickly pull back and analyze when issues were escalated to us. This system also had to be modular so we could add or remove queries, as needed, while always keeping the data fresh. In this session I'll use Glenn Berry's diagnostic queries and SSIS to show how we collect and store data on our remote systems. When problems arise we download the data and use Powershell to digest it into a simple report.

SessionID: 66431

Difficult Queries

Back to calendar

Event Date: 19-08-2017 - Session time: 11:00:00 - Track: Application Database Development

Speaker: Rick Bielawski

Title: Difficult Queries

Abstract:

Take your T-SQL skills to the next level. Regardless of your current level there will be something here you'll be glad you didn't miss. Basics like avoiding cursors in iterative tasks and multi-database executions is the tip of the iceberg. If queries are basic arithmetic then this is basic algebra. First we see how coding style affects maintainability then dive into several types of encapsulation, parameterization and more.

SessionID: 66814

Visualize Your Transaction Log

Back to calendar

Event Date: 19-08-2017 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Brian Hansen

Title: Visualize Your Transaction Log

Abstract:

SessionID: 64565

Isolation Levels – Understanding Transaction Temper Tantrums

Back to calendar

Event Date: 19-08-2017 - Session time: 13:25:00 - Track: Enterprise Database Administration Deployment

Speaker: Adam Koehler

Title: Isolation Levels – Understanding Transaction Temper Tantrums

Abstract:

In this session we will review Isolation levels and how they affect applications that run on SQL Server. We will explore what happens when multiple applications accessing the same data use different isolation levels, and how that effects the server as a whole. We will also explore different ways to relieve these tantrums, and make your applications play nice together.

SessionID: 65196

Where Does R Fit Into Your SQL Server Stack?

Back to calendar

Event Date: 19-08-2017 - Session time: 13:25:00 - Track: BI Platform Architecture, Development Administration

Speaker: Stacia Varga

Title: Where Does R Fit Into Your SQL Server Stack?

Abstract:

Now that SQL Server 2016 includes support for R in the database, how does this change your BI implementation options?

In this session, we start with a brief introduction to R and explain why it’s increasingly popular, the typical development workflow, which tools you can use, common use cases, and where it fits into the latest Microsoft stack at a high level.

Then we’ll review how to implement R Services so that you can use R with SQL Server data, including how to install R packages on SQL Server, how to use rx functions, and how to operationalize R in SQL Server.

Then we explore options for using R to prepare data for analytics using SSIS or Power BI and how to report and visualize data using SSRS or Power BI.

SessionID: 65312

Amazon Web Services RDS with SQL Server

Back to calendar

Event Date: 19-08-2017 - Session time: 13:25:00 - Track: Cloud Application Development Deployment

Speaker: Christopher Wolff

Title: Amazon Web Services RDS with SQL Server

Abstract:

Are you wanting to make more SQL Servers but don't want to invest in more hardware? Then Relational Database Service (RDS) in Amazon Web Services (AWS) maybe the right choice for you. We will begin with creating a server using the Amazon Web Console, explore how to automate installation through Cloud Formation, show how to administrate the service, and walk through advanced features. Whether you are familiar with AWS or are brand new to it, this presentation should at least give you a good overview to decide if RDS is the right service for you.

SessionID: 66974

SQL Server DBA Quiz Show

Back to calendar

Event Date: 19-08-2017 - Session time: 13:25:00 - Track: Professional Development

Speaker: Eric Zierdt

Title: SQL Server DBA Quiz Show

Abstract:

You are invited to be a participant on the SQL Server DBA Quiz Show; this fun and interactive session will test your knowledge of SQL Server. We will be using an online tool to allow you to submit your answers to questions in real time via a mobile device or laptop. If you have ever played trivia in a bar or restaurant you'll be familiar with the setup for this.

This session promises to be fast paced and fun and hopefully you will even learn something.

SessionID: 65044

Welcome To the 2016 Query Store!

Back to calendar

Event Date: 19-08-2017 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Janis Griffin

Title: Welcome To the 2016 Query Store!

Abstract:

One of my favorite new features in SQL Server 2016 is the Query Store. The Query Store houses valuable information on performance of your queries as well as gives you great insights into your query workload. This presentation will take a look at the Query Store, how it works and the type of information it holds. You will learn how to use the Query Store to quickly find plan changes and analyze performance issues caused by them. New DMVs will be introduced and the performance impact of enabling the Query Store will be discussed. Both DBAs and developers can increase their performance tuning skills by attending this session.

SessionID: 65199

Reduce, Reuse, Recycle: Automating Your BI Framework

Back to calendar

Event Date: 19-08-2017 - Session time: 14:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Stacia Varga

Title: Reduce, Reuse, Recycle: Automating Your BI Framework

Abstract:

Quite frankly, some aspects of building out a business intelligence solution are tedious. As you cycle through iterations of your star schema, you’ll find that even a simple data type change in the data warehouse requires you to make corresponding changes to staging tables, and SSIS packages that take a considerable amount of time to implement. But there’s a better, faster way!In this session, we’ll explore lessons from a project that required implementation of a framework to easily generate BI objects based on reusable patterns. We’ll walk through the decision points in the framework design, review the implementation steps, and see demonstrations of how easily you can make iterative changes to your BI solution’s design by using reusable design patterns. Whether you simply want to accelerate change management or reproduce objects in bulk on demand, this session will give you practical tips for automating these processes.

SessionID: 66815

Remember Back When? Temporal Tables in SQL Server 2016

Back to calendar

Event Date: 19-08-2017 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Brian Hansen

Title: Remember Back When? Temporal Tables in SQL Server 2016

Abstract:

SQL Server 2016 comes with its own version of a Wayback Machine: temporal tables. With this new feature, it is easy to store and query the history of changes to data. We will discuss the fundamentals and creating, storing data in, querying from, and maintaining these tables. We will also take a quick look under the hood to see how they work. And yes, this is a version 1 product, so we'll also consider the current limitations that are in place. Find out how temporal tables can benefit your system!

SessionID: 66848

How to Fix Cardinality Estimation Anomalies

Back to calendar

Event Date: 19-08-2017 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Susantha Bathige

Title: How to Fix Cardinality Estimation Anomalies

Abstract:

Statistics in SQL Server plays a major role deciding the shape of the Execution Plan. Execution plan, ultimately responsible for the query performance. Filtered statistics is a type of statistics in SQL Server which you can influence the query optimizer by providing more information to it so that query optimizer could produce quality execution plans. Filtered statistics was introduced in SQL Server 2008 but in my opinion, it has not got the attention it needed yet.

In this presentation, I will demo the use of filtered statistics to fix some cardinality estimation anomalies.

SessionID: 65197

Getting Your Story Straight with Data Visualizations

Back to calendar

Event Date: 19-08-2017 - Session time: 16:05:00 - Track: BI Platform Architecture, Development Administration

Speaker: Stacia Varga

Title: Getting Your Story Straight with Data Visualizations

Abstract:

Having multiple data visualizations doesn't make it easier to choose the right one to reveal the story. Choosing the wrong visualization can obscure the story - or worse yet, distort it! In this session, learn the vocabulary of data visualization and how to apply grammar (visualization design principles) to your data. Along the way, you will also learn how to evaluate the goal of your data story and how to choose the correct visualizations that communicate this story accurately and effectively.

SessionID: 66302

Maximizing SQL Server Management Studio for Developers and DBAs

Back to calendar

Event Date: 19-08-2017 - Session time: 16:05:00 - Track: Application Database Development

Speaker: Nem Schlecht

Title: Maximizing SQL Server Management Studio for Developers and DBAs

Abstract:

Whether you're a developer or a DBA, you likely use SSMS (SQL Server Management Studio) a lot. However, are you using all the features and extensions available to maximize your efficiency? This talk will show some of the most useful, yet overlooked, features of SSMS and some of the best (and free) extensions to make life easier for you and your teams. I'll also include some of my most useful code snippets that I've found or written over the years. Save yourself some time and headaches!

SessionID: 66430

Mastering queries into XML data.

Back to calendar

Event Date: 19-08-2017 - Session time: 16:05:00 - Track: Application Database Development

Speaker: Rick Bielawski

Title: Mastering queries into XML data.

Abstract:

If you've never queried an XML column you definitely want to attend. While targeted to beginners this isn't a "Just do this" session where you are walked down a chocolate path, then back on the job scratch your head to apply it in real life. After this session I'd like you to truly understand even subtle nuances of basic query syntax. Seasoned veterans stand a fair chance of learning something new.

SessionID: 68323

Navigating Modern BI Infrastructure – Power BI Report Server (On-

Back to calendar

Event Date: 19-08-2017 - Session time: 16:05:00 - Track: BI Platform Architecture, Development Administration

Speaker: George Bryant

Title: Navigating Modern BI Infrastructure – Power BI Report Server (On-

Abstract:

Business Intelligence has sat pretty comfortably on the same laurels for well over a decade however that landscape has been disrupted by the surfacing new Azure tools, Power BI, and now Power BI on premise. With so many new tools and features things can get pretty intimidating, especially for those with additional considerations and regulations. It can however open new doors to organizations who were previously unable to fully utilize BI.

Through presentation, demo, and open discussion we attempt to navigate classic BI Architecture and the available options there in, as well as touch upon the future of BI and modern architecture.

This site is open source. Improve this page.