sqlsathistory

Nr: 745

SQLSaturday #745 - Indianapolis 2018

Start Time (24h)	Speaker	Track	Title
08:00:00	Dave Bland	Enterprise Database Administration Deployment	Extended Events: What are they and How do I use them
08:00:00	Jay Robinson	Application Database Development	SQL Operations Studio: A Test Drive
08:00:00	Warren Sifre	Strategy and Architecture	Hadoop Shmadoop... What the heck is the all the Hadoop about it?
08:00:00	Arthur Daniels III	Enterprise Database Administration Deployment	Plan Cache performance tuning
08:00:00	Allen White	Enterprise Database Administration Deployment	Emergency! Are You Ready for Disaster to Strike?
08:00:00	Aaron Cutshall	Application Database Development	Discover the Hidden Mysteries of Common Table Expressions
08:00:00	Michael Huffer	Analytics and Visualization	Integrating Azure ML with Power BI
08:00:00	Dave Leininger	Professional Development	What To Learn Next
08:00:00	Peter Shore	SQLStarter	SQLStarter - Intro to Database Administration
09:15:00	Drew Furgiuele	Other	Building the HASSP: Putting SQL Server In Space
09:15:00	Sean Werick	Strategy and Architecture	Choosing the Right Microsoft Data Science Platform
09:15:00	David Maxwell	Enterprise Database Administration Deployment	Transaction Log Internals and Performance
09:15:00	Kathi Kellenberger	Application Database Development	Introduction to T-SQL Windowing Functions
09:15:00	Ameena Lalani	Enterprise Database Administration Deployment	Learn History from Temporal Tables
09:15:00	Ben Miller	Application Database Development	Inside the SQLServer PowerShell Module
09:15:00	Andrew Loree	Analytics and Visualization	Getting started with Machine Learning
09:15:00	Trayce Jordan	Enterprise Database Administration Deployment	Finding root cause for unexplained Availability Group failover
09:15:00	Jessica Jolly	Professional Development	Relax! It's just DAX.
09:15:00	Grant Fritchey	SQLStarter	SQLStarter - Intro to Database Development
09:15:00	Jonathan Stewart	Application Database Development	Relationship Goals: The SQL Server Graph Database
10:30:00	Dave Mattingly	Cloud Application Development Deployment	Alexa, Talk to Me
10:30:00	Kellyn Pot'Vin-Gorman	Enterprise Database Administration Deployment	Essential Linux for the SQL Server DBA
10:30:00	Hasan Savran	Strategy and Architecture	Introduction to Spatial Data with the help of SQL Server 2016/17
10:30:00	Ben Miller	Enterprise Database Administration Deployment	SQL Server Encryption
10:30:00	Bradley Nielsen	Application Database Development	Introduction to SQL Server Machine Learning Services
10:30:00	Chris Hyde	Analytics and Visualization	Python in SQL Server 2017
10:30:00	David Mellinger	BI Platform Architecture, Development Administration	Lift Off to the Cloud: Lift Shift Azure options for the SQL Server BI Stack
10:30:00	Wendy Pastrick	Professional Development	Moving Past Imposter Syndrome
10:30:00	Warren Sifre	SQLStarter	SQLStarter - Intro to Big Data
11:45:00	Chris Lumnah	Other	Simplifying SQL Data Protection (Sponsored by Rubrik)
11:45:00	Richard Waymire	Other	Using RDS SQL Server on Amazon Web Services
13:00:00	Andy Wickman	Enterprise Database Administration Deployment	Simple DR Setup
13:00:00	Ben Davis	Enterprise Database Administration Deployment	Linked Servers – Purpose, Pitfalls and Performance Implications
13:00:00	Grant Fritchey	Application Database Development	Data Protection Privacy in the World of Database DevOps
13:00:00	Andy Yun	Professional Development	Everyone Has a Story to Tell: Developing Your First Presentation
13:00:00	Britton Gray	Analytics and Visualization	Data Science in Reverse: Creating Credible Fake Data Sets
13:00:00	Matt Gordon	Cloud Application Development Deployment	Where Should My Data Live (and Why)?
13:00:00	Amy Herold	Enterprise Database Administration Deployment	The Case for Change: Identifying and Remedying Bad Code
13:00:00	Tamera Clark	BI Platform Architecture, Development Administration	SSRS; Not everything is a dashboard
13:00:00	Sean Werick	SQLStarter	SQLStarter - Intro to Data Science
14:15:00	Kevin Feasel	Analytics and Visualization	R For the SQL Server Developer
14:15:00	Hilary Wilkie	Professional Development	5 Lessons from Black Panther for any IT Professional
14:15:00	Rob Volk	Enterprise Database Administration Deployment	Revenge: The SQL!
14:15:00	Peter Shore	Cloud Application Development Deployment	Hello My Friends, Welcome to CosmosDB
14:15:00	Brian Hansen	Enterprise Database Administration Deployment	Get Your Optimizer to Give up All Its Secrets
14:15:00	Louis Davidson	Application Database Development	Database Design Fundamentals
14:15:00	Kerry Tyler	Enterprise Database Administration Deployment	Tuning Like CSS: With These Tools There's No Need Call Support
14:15:00	Brian Beswick	BI Platform Architecture, Development Administration	Managing Enterprise Data Quality with Data Quality Services 2016
14:15:00	CJ Knapp	SQLStarter	SQLStarter - Intro to Business Intelligence
15:30:00	Kevin Wilkie	Professional Development	IT and the Evil Empire (Business) : Friends or Enemies?
15:30:00	Rob Collie	BI Platform Architecture, Development Administration	Ten Things Power BI Can Do for Your Business
15:30:00	Ben Kimmel	Analytics and Visualization	Empowering Power BI with PowerApps
15:30:00	Chris Koester	BI Information Delivery	Real-Time Streaming in Power BI
15:30:00	Chris Lumnah	Enterprise Database Administration Deployment	Taking the pain out of database migrations
15:30:00	Pat Phelan	Enterprise Database Administration Deployment	How did you get in here, and who said you could do that???
15:30:00	Aaron King	Application Database Development	Grudge Match: XML vs JSON
15:30:00	Robert Verell	Enterprise Database Administration Deployment	Migration Basics
15:30:00	Hope Foley	SQLStarter	SQLStarter - Discussion/Networking Session

SessionID: 72617

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

Back to calendar

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

Speaker: Dave Bland

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

Abstract:

Extended Events are an essential part of properly monitoring and every DBA should know what they are and how to use them. This session will cover the basics of Extended events as well as an introduction to the system_health session. This session will give someone who has never used Extended events before the skills to start using them!

SessionID: 73900

SQL Operations Studio: A Test Drive

Back to calendar

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

Speaker: Jay Robinson

Title: SQL Operations Studio: A Test Drive

Abstract:

Unveiled at PASS Summit 2017, SQL Operations Studio is Microsoft's new open-source cross-platform database development and operations tool. In this session, we'll examine the new Operations Studio and see what's great about it, what's not so great, and how it ranks up against other apps like SSMS and SSDT. By the end, you'll know how best to incorporate Microsoft's newest database tool into your arsenal.

SessionID: 78975

Hadoop Shmadoop... What the heck is the all the Hadoop about it?

Back to calendar

Event Date: 11-08-2018 - Session time: 08:00:00 - Track: Strategy and Architecture

Speaker: Warren Sifre

Title: Hadoop Shmadoop... What the heck is the all the Hadoop about it?

Abstract:

SessionID: 80629

Plan Cache performance tuning

Back to calendar

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

Speaker: Arthur Daniels III

Title: Plan Cache performance tuning

Abstract:

In this session, we'll discuss ways to manage execution plans inside the plan cache of busy and unpredictable SQL Servers. The plan cache keeps SQL Server healthy, but all it takes is one bad execution plan to decrease server performance.

Just like gardening, keeping a database healthy requires pruning. Techniques to manage, remove, and improve performance in the Plan Cache will be shown. The Query Store gives us power tools for this work, but it's not the entire solution.

SessionID: 80677

Emergency! Are You Ready for Disaster to Strike?

Back to calendar

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

Speaker: Allen White

Title: Emergency! Are You Ready for Disaster to Strike?

Abstract:

Just like pilots who are prepared for disaster recovery through regular practice, we as Database Administrators need to actually spend time practicing recovering with those backups. Ransomware has made it critical to prepare to rebuild your datacenter at any moment. This session will focus on the kinds of situations that can dramatically affect a data center, and how to practice recovery processes to assure business continuity.

SessionID: 83316

Discover the Hidden Mysteries of Common Table Expressions

Back to calendar

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

Speaker: Aaron Cutshall

Title: Discover the Hidden Mysteries of Common Table Expressions

Abstract:

Although they have been around since SQL Server 2005, Common Table Expressions (CTEs) have been a complete mystery to many. As a result, there are many misunderstood myths and assumptions surrounding them. This session will explore deep into CTEs, what they are, what they are not, and how they work. We'll look at situations where they can really help improve not only code clarity but also performance especially when compared side-by-side to usual methods. We'll also identify situations where CTEs can be used incorrectly causing hidden performance problems.

SessionID: 83651

Integrating Azure ML with Power BI

Back to calendar

Event Date: 11-08-2018 - Session time: 08:00:00 - Track: Analytics and Visualization

Speaker: Michael Huffer

Title: Integrating Azure ML with Power BI

Abstract:

Power BI is a robust tool for building data visualizations that help businesses derive insights from their data. Azure ML is a flexible tool that allows iterative development and deployment of predictive models across an enterprise.

It can be difficult, however, to productionize a machine learning model and present the findings to a business user in a manner that is easily-consumed and reliable. Combining Power BI and Azure ML businesses can easily leverage predictive models and present the results in a user-friendly way.

This talk will cover the basics of Power BI and of Azure ML, how to build and deploy a model using Azure ML Studio, alternative options to Azure ML and Power BI, and demonstrate how to easily score data from an existing SQL Server DB using Power BI.

SessionID: 83653

What To Learn Next

Back to calendar

Event Date: 11-08-2018 - Session time: 08:00:00 - Track: Professional Development

Speaker: Dave Leininger

Title: What To Learn Next

Abstract:

As technologists, we continually adapt to changing market needs and the maturity of concepts and tools. What To Learn Next explores four topics, each having important considerations for your opportunities in the next three to five years.

High Demand/Low Supply explores the effect on data technologists from social media, biztech media, and the modern focus on employee experience. So Many Technologies looks into the layers of technologies, from core to the edge, that define our world of data. Too Many Products gives a view of the hundreds of products in category upon category. Only the liar could know them all. This session concludes with a look at How To Learn, including the pros and cons of online, meetups, classroom, conference, and video - even books!

What To Learn Next will be most valuable to intermediate and advanced SQL Server professionals who seek to augment their current skills with modern, strategic data technologies.

SessionID: 83738

SQLStarter - Intro to Database Administration

Back to calendar

Event Date: 11-08-2018 - Session time: 08:00:00 - Track: SQLStarter

Speaker: Peter Shore

Title: SQLStarter - Intro to Database Administration

Abstract:

Session in the SQLStarter beginner track to introduce the database administrator career. Will discuss aspects of what this job entails and what day to day could look like in this career path. We'll go over important skills and where to find training information.

SessionID: 72611

Building the HASSP: Putting SQL Server In Space

Back to calendar

Event Date: 11-08-2018 - Session time: 09:15:00 - Track: Other

Speaker: Drew Furgiuele

Title: Building the HASSP: Putting SQL Server In Space

Abstract:

In today's world, technology is a pervasive part of our lives. We have "smart" appliances everywhere: from cars, thermostats, and even refrigerators contain built-in systems to collect, store, and transmit data. Small embedded devices can also be used for scientific purposes as well, offering new and exciting ways to collect data for studies or projects at home.

The High-Altitude SQL Server Project, or HASSP, is one such project.

The HASSP team has created a high-altitude balloon that uses sensors to collect various data points and store the results in an embedded version of SQL Server!

In this session, you'll hear about how this is possible: we'll discuss the hardware used, the custom device that we built, and the software used to make it all work together. Best of all, you'll see how to recreate (and hopefully improve!) the project on your own.

SessionID: 72736

Choosing the Right Microsoft Data Science Platform

Back to calendar

Event Date: 11-08-2018 - Session time: 09:15:00 - Track: Strategy and Architecture

Speaker: Sean Werick

Title: Choosing the Right Microsoft Data Science Platform

Abstract:

So you've done traditional BI for some time, but now you and your company know it's time to dig into advanced analytics. The big question is, with so many data science platform options available, which one is the right one for us?

In this session we dive into the available platforms listed below and provide a brief summary, strengths and weaknesses, scale capabilities, and last but not least, pricing/licensing. • Microsoft R Open • Microsoft R Server • R and Python Services for SQL Server 2017 • Azure Machine Learning Workbench • HDInsight (with Spark) • Microsoft Data Science VM

If you're looking to maximize and optimize your data science platform of choice, be sure to attend.

SessionID: 80164

Transaction Log Internals and Performance

Back to calendar

Event Date: 11-08-2018 - Session time: 09:15:00 - Track: Enterprise Database Administration Deployment

Speaker: David Maxwell

Title: Transaction Log Internals and Performance

Abstract:

The transaction log is one of the most critical, yet often misunderstood, components of SQL Server. From out of control log growth to very long start-up times, problems with the transaction log can cause a lot of pain. In this session, we'll look at how the transaction log works and what information is actually stored in the log. You'll learn how to optimize the log's performance, determining the right settings for log growth, and what to do when things get out of control.

SessionID: 80764

Introduction to T-SQL Windowing Functions

Back to calendar

Event Date: 11-08-2018 - Session time: 09:15:00 - Track: Application Database Development

Speaker: Kathi Kellenberger

Title: Introduction to T-SQL Windowing Functions

Abstract:

T-SQL windowing functions can simplify many complex queries. They are the best thing that has happened to the T-SQL language in years, but many database professionals and developers haven’t heard about them.

They were initially introduced with SQL Server 2005. In 2012, Microsoft added several new functions that let you do things like pull values from different rows without a performance penalty. Attend this session to learn how T-SQL windowing functions apply to many real world examples.

SessionID: 80777

Learn History from Temporal Tables

Back to calendar

Event Date: 11-08-2018 - Session time: 09:15:00 - Track: Enterprise Database Administration Deployment

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. 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: 82140

Inside the SQLServer PowerShell Module

Back to calendar

Event Date: 11-08-2018 - Session time: 09:15:00 - Track: Application Database Development

Speaker: Ben Miller

Title: Inside the SQLServer PowerShell Module

Abstract:

SQLPS has been evolving since 2012 and the SQL Provider/cmdlets have been around since 2008. Have you taken advantage of the PowerShell infrastructure that is on your servers? This session takes you behind the scenes of the SQLPS and the new SqlServer module that is installed with the tools. We will cover how to get it without the tools, how to use it once you have it and why you will want to use it for simple tasks or complex ones. When you learn how to navigate SQL Server and all its services using Paths, you won't go back. Join me for a fun filled hour and learn how to keep SQLPS from becoming frustrating and a black box. You will be glad you did. Let's continue the journey to becoming a PowerShell DBA.

SessionID: 82214

Getting started with Machine Learning

Back to calendar

Event Date: 11-08-2018 - Session time: 09:15:00 - Track: Analytics and Visualization

Speaker: Andrew Loree

Title: Getting started with Machine Learning

Abstract:

Do you have large amounts of data which you want to leverage to predict the answers to difficult questions? The seemingly new field of Machine Learning (ML) has been around for almost 60 years, with this exact goal in mind.

In this session, you will be introduced to the fundamentals of ML, to get you started without requiring a mathematics background. We will look at how to “frame” your data questions, as well as understanding the type of outputs ML can provide in responding with predictions. Focus will be placed on the high-level overview of the ML process, and spend time on the simple steps of determining the “right” algorithm to use. Tools used include Weka and Azure ML Studio, but the focus of the session is on fundamentals and the ML process, not specific toolsets.

SessionID: 82790

Finding root cause for unexplained Availability Group failover

Back to calendar

Event Date: 11-08-2018 - Session time: 09:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Trayce Jordan

Title: Finding root cause for unexplained Availability Group failover

Abstract:

In this session, we will walk you step by step showing how we determine root cause analysis of an unexplained failure in an Availability Group. Whether the databases simply became unavailable, synchronization stopped, or there was an unexplained failover. We will show you specifically what we look for in the OS Cluster logs, SQL error logs, Extended Events and other sources of information.

SessionID: 83105

Relax! It's just DAX.

Back to calendar

Event Date: 11-08-2018 - Session time: 09:15:00 - Track: Professional Development

Speaker: Jessica Jolly

Title: Relax! It's just DAX.

Abstract:

DAX is the language you use when working in Power BI or Power Query to create calculations using your data.

At first, it may seem intimidating, but the truth is that if you have been using functions in Excel, you have the basic knowledge to help you get started in DAX. The first half of this session will introduce basic DAX terminology and concepts. In the second half, participants can use their own laptop and work on a demo data set, creating some beginner DAX statements. The experts in DAX say that DAX is an easy language to learn, and a hard language to master. DAX may be easy to learn (although that hasn't been this speaker's experience!), but it is definitely hard to carve out a chunk of time to try out a new skill. This is your chance! At the end of the session, I will also share a list of resources, including books, videos, and blogs for you to continue your journey into DAX.

SessionID: 83739

SQLStarter - Intro to Database Development

Back to calendar

Event Date: 11-08-2018 - Session time: 09:15:00 - Track: SQLStarter

Speaker: Grant Fritchey

Title: SQLStarter - Intro to Database Development

Abstract:

Session in the SQLStarter beginner track to introduce the database development career. Will discuss aspects of what this job entails and what day to day could look like in this career path. We'll go over important skills and where to find training information.

SessionID: 85072

Relationship Goals: The SQL Server Graph Database

Back to calendar

Event Date: 11-08-2018 - Session time: 09:15:00 - Track: Application Database Development

Speaker: Jonathan Stewart

Title: Relationship Goals: The SQL Server Graph Database

Abstract:

Relational databases have their strengths. Ironically data relationships are not one of them. Graph databases excel in this department using nodes and edges. They are optimized to find and view relationships using graph theory.

One of the best new features of SQL Server 2017 is the Graph Database! It brings us the best of both worlds in one easy platform! Come learn about the history of graph databases, how they work and why you should be using it!

SessionID: 73126

Alexa, Talk to Me

Back to calendar

Event Date: 11-08-2018 - Session time: 10:30:00 - Track: Cloud Application Development Deployment

Speaker: Dave Mattingly

Title: Alexa, Talk to Me

Abstract:

Learn how to create your own skill (app) for Amazon's Echo / Dot service known as Alexa.

In this session, we'll create a simple skill from scratch, and show how to get into some of the more advanced options.

SessionID: 76876

Essential Linux for the SQL Server DBA

Back to calendar

Event Date: 11-08-2018 - Session time: 10:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Kellyn Pot'Vin-Gorman

Title: Essential Linux for the SQL Server DBA

Abstract:

Linux has come to Microsoft! Do you want to gain the knowledge that Oracle DBAs have been using for years to manage their databases on this valuable OS?

This session is taught by a multi-platform DBA who specializes in Oracle and SQL Server with almost two decades on Unix/Linux experience. The goal is to give you the most valuable fundamentals and commands that are important to the DBA when managing a database in a Non-Windows environment. We’ll learn:

Linux history and concepts.
Important differences between systems
Crucial commands to get around a. Navigating, searching and managing b. Monitoring, tracing and updating c. Editing and scripting

You’ll leave feeling more at ease with Linux and have plenty of content and links to continue the learning after the session!

SessionID: 78598

Introduction to Spatial Data with the help of SQL Server 2016/17

Back to calendar

Event Date: 11-08-2018 - Session time: 10:30:00 - Track: Strategy and Architecture

Speaker: Hasan Savran

Title: Introduction to Spatial Data with the help of SQL Server 2016/17

Abstract:

If you would like to learn about Spatial Data but don’t know where to start, this session is for you. We will begin by focusing on what Spatial Data is through examples and interactive demo’s. The goal is to show how Spatial Data can improve your professional experience and serve as an asset to your business.

I will introduce you to Spatial Data in the SQL server and show how to import data into SQL Server. We will focus on demonstrations of the SQL Server 2016 and JSON functions used to create geoJSON objects from Spatial Data. Next we will cache these objects by using In-Memory tables with the help of SQL Server 2017.

SessionID: 82141

SQL Server Encryption

Back to calendar

Event Date: 11-08-2018 - Session time: 10:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Ben Miller

Title: SQL Server Encryption

Abstract:

Have you ever wanted to know how Transparent Database Encryption (TDE) works or how you set it up? What about encrypting your backups? This session will go over all the steps and caveats that go with this technology. TDE allows you to have your database encrypted on disk and the same Encryption Hierarchy allows you to back up your database and have it encrypt the contents in the backup file. We will discuss the Encryption Hierarchy which is used for encryption in SQL Server and take you through keeping your secrets safe. We will also go over how Always Encrypted works as well. Master the concepts of SQL Server Encryption when you are done with this session.

SessionID: 82889

Introduction to SQL Server Machine Learning Services

Back to calendar

Event Date: 11-08-2018 - Session time: 10:30:00 - Track: Application Database Development

Speaker: Bradley Nielsen

Title: Introduction to SQL Server Machine Learning Services

Abstract:

Machine Learning Services is a powerful new product in the SQL Server family. It unlocks advanced analytics and machine learning functionality without leaving the SQL Server you know and love. I’ll demonstrate how you can build an end to end ML pipeline within a simple T-SQL procedure. Machine Learning Services makes it so that you don’t need a PhD to successfully implement predictive analytics in your organization.

SessionID: 83402

Python in SQL Server 2017

Back to calendar

Event Date: 11-08-2018 - Session time: 10:30:00 - Track: Analytics and Visualization

Speaker: Chris Hyde

Title: Python in SQL Server 2017

Abstract:

SQL Server 2017 has finally arrived, bringing with it a host of exciting new features. Of particular interest to BI practitioners and data scientists is the integration of the Python programming language into the SQL ecosystem. This integration opens up a number of possibilities for in-database analytics and intelligent database applications, so let's get started!

In this introductory session we'll briefly introduce the Python language and then look at how to install and administer Machine Learning Services. We'll start to demonstrate the power of Python by showing you how to create and run simple scripts from within T-SQL. We'll then discuss some of the powerful open source packages that are available to aid your data analyses. Finally, we'll go through some examples of how to use Python to integrate data analytical methods in real-world situations, and wow your customers with the power of analytics!

SessionID: 83465

Lift Off to the Cloud: Lift Shift Azure options for the SQL Server BI Stack

Back to calendar

Event Date: 11-08-2018 - Session time: 10:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: David Mellinger

Title: Lift Off to the Cloud: Lift Shift Azure options for the SQL Server BI Stack

Abstract:

The SQL Server Analytics\BI stack is widely used and mature. Azure PaaS offerings have matured greatly well beyond just Azure SQL DB the last couple of years. This session is designed for SQL Server professionals who want to expand their knowledge set to Azure or those interested in learning more about Azure data solution options. The focus will be on SQL Server on-premise (or on Azure VM\IaaS) to Azure equivalences, complementary tools, and hybrid approaches and possible challenges. Azure SQL DB, Azure SQL DW, Azure Data Factory, Azure Analysis Services, Power BI and more will be covered.

SessionID: 83527

Moving Past Imposter Syndrome

Back to calendar

Event Date: 11-08-2018 - Session time: 10:30:00 - Track: Professional Development

Speaker: Wendy Pastrick

Title: Moving Past Imposter Syndrome

Abstract:

We have heard a lot on recognizing Imposter Syndrome and how to address it. However, what if it’s not Imposter Syndrome after all? We will discuss working scenarios and how you approach or deal with them to determine “is it you or is it me?”

SessionID: 83737

SQLStarter - Intro to Big Data

Back to calendar

Event Date: 11-08-2018 - Session time: 10:30:00 - Track: SQLStarter

Speaker: Warren Sifre

Title: SQLStarter - Intro to Big Data

Abstract:

Session in the SQLStarter beginner track to introduce big data careers. Will discuss aspects of what this job entails and what day to day could look like in this career path. We'll go over important skills and where to find training information.

SessionID: 84773

Simplifying SQL Data Protection (Sponsored by Rubrik)

Back to calendar

Event Date: 11-08-2018 - Session time: 11:45:00 - Track: Other

Speaker: Chris Lumnah

Title: Simplifying SQL Data Protection (Sponsored by Rubrik)

Abstract:

When you think about backups in your environment, how many servers scripts do you have to manage? Or have you ever needed to get a table back from a large database and didn't want to argue with the storage admins about space for the restore? With Rubrik, we empower you to backup and restore your databases quickly and with ease. Come and see how you can quickly protect hundreds of databases with just a few clicks or bring back a database in minutes to satisfy your most demanding executives. With Rubrik, it's not about backing up, it's about going forward!

SessionID: 85052

Using RDS SQL Server on Amazon Web Services

Back to calendar

Event Date: 11-08-2018 - Session time: 11:45:00 - Track: Other

Speaker: Richard Waymire

Title: Using RDS SQL Server on Amazon Web Services

Abstract:

This session will examine how RDS SQL Server is used to host SQL Server as a managed service offering on Amazon Web Services. We will discuss the capabilities of the service offering, considerations for migration and how to manage SQL Server databases hosted in the AWS cloud.

SessionID: 77403

Simple DR Setup

Back to calendar

Event Date: 11-08-2018 - Session time: 13:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Andy Wickman

Title: Simple DR Setup

Abstract:

Setting up a DR plan can be tedious. Luckily there is a WIZARD for most of it. However, when databases get larger, the wizards don't work as well. Lucky for us, we have POWERSHELL!! This presentation will show you a simple way to set up your DR plan, and if you do a lot of log shipping, say goodbye to having to manage 5 separate SQL Jobs to get one database configured. This presentation includes usage of the community powershell tools project (dbatools.io).

SessionID: 77495

Linked Servers – Purpose, Pitfalls and Performance Implications

Back to calendar

Event Date: 11-08-2018 - Session time: 13:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Ben Davis

Title: Linked Servers – Purpose, Pitfalls and Performance Implications

Abstract:

Using linked servers allows for queries across instances. While connected to Server A, you can query resources on Server B. Developers often love them. DBAs often hate them. Regardless of what side of the fence you are on, they are an important tool in the DBA toolbelt and you need to know how they can help and hurt you. Attend this session and learn linked servers' purpose, pitfalls, and performance implications.

SessionID: 77957

Data Protection Privacy in the World of Database DevOps

Back to calendar

Event Date: 11-08-2018 - Session time: 13:00:00 - Track: Application Database Development

Speaker: Grant Fritchey

Title: Data Protection Privacy in the World of Database DevOps

Abstract:

SessionID: 77982

Everyone Has a Story to Tell: Developing Your First Presentation

Back to calendar

Event Date: 11-08-2018 - Session time: 13:00: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: 80771

Data Science in Reverse: Creating Credible Fake Data Sets

Back to calendar

Event Date: 11-08-2018 - Session time: 13:00:00 - Track: Analytics and Visualization

Speaker: Britton Gray

Title: Data Science in Reverse: Creating Credible Fake Data Sets

Abstract:

Sometimes a data professional will find themselves in need of a large demonstration data set. However, non-proprietary options are few and usually lacking. This session will educate attendees in how to get around these obstacles by creating their own data. We'll talk about the process of using real-world variability, creating inconsistency that leads to insight using some basic statistical concepts, the process of putting everything together, and getting the data set into SQL Server.

SessionID: 80799

Where Should My Data Live (and Why)?

Back to calendar

Event Date: 11-08-2018 - Session time: 13:00:00 - Track: Cloud Application Development Deployment

Speaker: Matt Gordon

Title: Where Should My Data Live (and Why)?

Abstract:

Long gone are the days where the only architecture decision you had to make when scaling an environment was deciding which part of the datacenter would store your new server. There is a dizzying array of options available in the SQL Server and Azure ecosystems and those are evolving by the day. Is “the cloud” a fad? Are private datacenters a thing of the past? Could both questions have a kernel of truth in them? In this session I will go over real world scenarios and walk you through real world solutions that utilize your datacenter, cloud providers, and everything in between to keep your data highly available and your customers happy.

SessionID: 83493

The Case for Change: Identifying and Remedying Bad Code

Back to calendar

Event Date: 11-08-2018 - Session time: 13:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Amy Herold

Title: The Case for Change: Identifying and Remedying Bad Code

Abstract:

There is no organization that is immune from performance issues with their SQL Server queries. Sometimes all it takes is one "perfect storm" that kills your server performance and lands you in the hot seat with everyone asking you what happened. While many performance issues can be addressed with an index or configuration change, what about when the root of the problem is the code itself? Whether it's a stored procedure or dynamic T-SQL generated by an ORM, the burden of proof lies with the DBA to demonstrate how the code is negatively impacting performance.

How do you capture those bad queries? When you have this data what do you look at besides the query itself? How do you make the case to the business that a code change is necessary? In this session we will explore capturing and identifying those problem queries, the analysis of the performance data, and how to effectively communicate your findings to the business to get your proposed code change approved and implemented.

SessionID: 83567

SSRS; Not everything is a dashboard

Back to calendar

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

Speaker: Tamera Clark

Title: SSRS; Not everything is a dashboard

Abstract:

OH “SSRS is so 2005, why are we even talking about it?” Join me and find out why we should be talking about it, even in 2018. We’ll explore the differences between MS Business Intelligence offerings and help you see why SSRS is still relevant. We’ll review example scenarios and help you see what SSRS can do for you.

SessionID: 83740

SQLStarter - Intro to Data Science

Back to calendar

Event Date: 11-08-2018 - Session time: 13:00:00 - Track: SQLStarter

Speaker: Sean Werick

Title: SQLStarter - Intro to Data Science

Abstract:

Session in the SQLStarter beginner track to introduce data science careers. Will discuss aspects of what this job entails and what day to day could look like in this career path. We'll go over important skills and where to find training information.

SessionID: 72687

R For the SQL Server Developer

Back to calendar

Event Date: 11-08-2018 - Session time: 14:15:00 - Track: Analytics and Visualization

Speaker: Kevin Feasel

Title: R For the SQL Server Developer

Abstract:

R is the premiere language for data analysis. If the world of data science sounds fun and exciting, now is the time to get into R. We will walk through the core constructs of R, learn how to retrieve data from flat files and databases, and get a peek at the power behind R. This session will also give resources on where to go in order to become more familiar with statistics, R the language, and the R package ecosystem.

SessionID: 77058

5 Lessons from Black Panther for any IT Professional

Back to calendar

Event Date: 11-08-2018 - Session time: 14:15:00 - Track: Professional Development

Speaker: Hilary Wilkie

Title: 5 Lessons from Black Panther for any IT Professional

Abstract:

"Just because something works doesn’t mean it can’t be improved." Shuri, T’Challa’s sister and a technological wizard, has this foundational quote in the movie that ties the cinematic marvel to the technology industry in a fun and challenging way. This session breaks down what we can take away and some ideas on how to apply these principles to lead our teams, products, and industry into the next chapter.

SessionID: 78346

Revenge: The SQL!

Back to calendar

Event Date: 11-08-2018 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Rob Volk

Title: Revenge: The SQL!

Abstract:

Pop quiz DBA: are your developers all using cursors? SELECT *? Running dynamic SQL using sysadmin privileges? And all in production despite your warnings? WHAT DO YOU DO? Answer: You attend Revenge: The SQL! This session will show you how to "correct" all those bad practices without actually killing them. You'll see demonstrations of little-used features in unconventional ways. You'll also see methods to prevent common mistakes that even you might make, like dropped a table, or database, or WHERE clause accidentally. We'll also demonstrate the dangers of too many permissions and how to convince everyone to never use the sa login again! Revenge: The SQL! is fun and educational and may even have some practical use, but you’ll want to attend simply to indulge your Dark Side. Revenge: The SQL! assumes no liability and is not available in all 50 states. Do not taunt Revenge: The SQL! or Happy Fun Ball.

SessionID: 80790

Hello My Friends, Welcome to CosmosDB

Back to calendar

Event Date: 11-08-2018 - Session time: 14:15:00 - Track: Cloud Application Development Deployment

Speaker: Peter Shore

Title: Hello My Friends, Welcome to CosmosDB

Abstract:

Microsoft says Azure Cosmos DB is a globally distributed, multi-model database. Your reaction might be something like, “what the heck is it”, “why would I use it”, or “how do I use it”. The fundamental purpose of this session is to answer those very questions. After briefly discussing what CosmosDB is, we’ll take some time to discuss why you might use CosmosDB instead of SQL Server or another platform, and finally touch on some basics to get you started with CosmosDB. Upon completion of this session you will be better equipped to discuss the value of CosmosDB to your organization.

SessionID: 83393

Get Your Optimizer to Give up All Its Secrets

Back to calendar

Event Date: 11-08-2018 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Brian Hansen

Title: Get Your Optimizer to Give up All Its Secrets

Abstract:

You know that execution plans can provide you with vital information to tune a query, but just how does that plan get generated? In this session, we will examine details the query optimization process that are not very well known. We will discuss how SQL Server parses a T-SQL statement then and begins applying rules to make it more efficient. Did you know that SQL Server can be coaxed into outputting hidden structures such as parse trees and memos? We'll do just that, and then take it a step further with a unique visualization tool that I have created. With a better understanding of how SQL Server optimizes T-SQL (and sometimes doesn't do it as well as might be hoped), you can write more efficient SQL statements.

SessionID: 83445

Database Design Fundamentals

Back to calendar

Event Date: 11-08-2018 - Session time: 14:15:00 - Track: Application Database Development

Speaker: Louis Davidson

Title: Database Design Fundamentals

Abstract:

Data should be easy to work with in SQL Server if the database has been organized as close as possible to the standards of normalization that have been proven for many years, but are often thought of as old-fashioned. Many common T-SQL programming "difficulties" are the result of struggling against these standards and can be avoided by understanding the requirements, applying normalization, as well as a healthy dose of simple common sense. In this session I will give an overview of how to design a relational database, allowing you to work with the data structures instead of against them. This will let you use SQL naturally, enabling the query engine internals to optimize your output needs without you needing to spend a lot of time thinking about it. This will mean less time trying to figure out why SUBSTRING(column,3,1) = 'A' is killing your performance, and more time for solving the next customer problem.

SessionID: 83484

Tuning Like CSS: With These Tools There's No Need Call Support

Back to calendar

Event Date: 11-08-2018 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Kerry Tyler

Title: Tuning Like CSS: With These Tools There's No Need Call Support

Abstract:

But what if you could bypass support and do all of this analysis yourself? In this session, you'll learn how to use battle tested tools to analyze your workload and error logs. Armed with this information, you'll understand the root cause of the problem and propose solutions to performance and stability problems.

SessionID: 83682

Managing Enterprise Data Quality with Data Quality Services 2016

Back to calendar

Event Date: 11-08-2018 - Session time: 14:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Brian Beswick

Title: Managing Enterprise Data Quality with Data Quality Services 2016

Abstract:

Regardless of your role or the system you work with, data quality is always critical to ensuring the accuracy of data. In this session we'll discuss overall architecture and strategies for managing enterprise data quality, explore a variety of case studies, and demo an end to end data quality solution using Data Quality Services 2016.

SessionID: 83713

SQLStarter - Intro to Business Intelligence

Back to calendar

Event Date: 11-08-2018 - Session time: 14:15:00 - Track: SQLStarter

Speaker: CJ Knapp

Title: SQLStarter - Intro to Business Intelligence

Abstract:

Session in the SQLStarter beginner track to introduce the business intelligence career. Will discuss aspects of what this job entails and what day to day could look like in this career path. We'll go over important skills and where to find training information.

SessionID: 77175

IT and the Evil Empire (Business) : Friends or Enemies?

Back to calendar

Event Date: 11-08-2018 - Session time: 15:30:00 - Track: Professional Development

Speaker: Kevin Wilkie

Title: IT and the Evil Empire (Business) : Friends or Enemies?

Abstract:

Tensions between the business and IT can be high. The business sees IT as alien and IT sees the business as cavemen. The difference between a great IT professional and a mediocre one is that a great one can work well with the business. This session will give you 6 practical ways you can implement immediately to make a bigger, better impact on the business.

SessionID: 80097

Ten Things Power BI Can Do for Your Business

Back to calendar

Event Date: 11-08-2018 - Session time: 15:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Rob Collie

Title: Ten Things Power BI Can Do for Your Business

Abstract:

Spoiler alert: many of the obvious valuable things were prohibitively difficult to execute using previous tools – so much so that we’ve forgotten what we should be doing! The speaker (Rob Collie) has seen it all in the process of helping literally hundreds of organizations revolutionize their relationships with data, and in this thought-provoking and non-technical talk, he will share 10 recurring and valuable patterns observed within the past 2-3 years.

SessionID: 80504

Empowering Power BI with PowerApps

Back to calendar

Event Date: 11-08-2018 - Session time: 15:30:00 - Track: Analytics and Visualization

Speaker: Ben Kimmel

Title: Empowering Power BI with PowerApps

Abstract:

The 'recently' introduced PowerApps visual for Power BI allows us to greatly extend the capabilities of our reports. In this talk we will cover the basics of PowerApps, from pricing to capabilities. We’ll also cover some potential use cases for adding PowerApps to your Power BI reports, and see some of those use cases demonstrated. Finally, we’ll walk through the whole process of building and deploying a PowerApp to a Power BI report.

SessionID: 80928

Real-Time Streaming in Power BI

Back to calendar

Event Date: 11-08-2018 - Session time: 15:30:00 - Track: BI Information Delivery

Speaker: Chris Koester

Title: Real-Time Streaming in Power BI

Abstract:

Power BI offers compelling streaming features that allow you to view your data in real time in a web browser and on mobile devices. In this session we'll examine how to setup streaming datasets and dashboards for real-time viewing. For a demonstration we'll look at how to stream performance counter data from Windows into Power BI using C#, giving us a real-time view of system information that is accessible from anywhere.

SessionID: 82052

Taking the pain out of database migrations

Back to calendar

Event Date: 11-08-2018 - Session time: 15:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Chris Lumnah

Title: Taking the pain out of database migrations

Abstract:

Database migrations are scary. The migration of a database has many moving pieces and things to think about. Some of those things have nothing to do with the DBA and are outside of their control. However, if these items are not taken into account, it is the DBA that management will hold responsible for the failure.

This session will discuss what you need to take into account to ensure a successful pain free database migration. These steps can be used for a single database, multiple databases, or an entire server. By the end of the session, you will have a checklist of the items you need to consider for a database migration.

SessionID: 83642

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

Back to calendar

Event Date: 11-08-2018 - Session time: 15:30:00 - Track: Enterprise Database Administration Deployment

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

Grudge Match: XML vs JSON

Back to calendar

Event Date: 11-08-2018 - Session time: 15:30:00 - Track: Application Database Development

Speaker: Aaron King

Title: Grudge Match: XML vs JSON

Abstract:

Starting in SQL 2016, two rivals entered the ring in a professional fight for format supremacy. XML seems too fat to compete with the newcomer JSON but a fight has begun. JSON doesn't seem experienced enough to have real punching power but does it have the speed to win? Who is the pound for pound format champion? Come watch this action-packed bout between two titans of SQL.

SessionID: 83904

Migration Basics

Back to calendar

Event Date: 11-08-2018 - Session time: 15:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Robert Verell

Title: Migration Basics

Abstract:

So you've got SQL Server instances that need to be moved off of old hardware or need a version upgrade for functionality and support purposes. Where do we begin? What pieces do we need to consider and how are we going to get them moved? What kind of window do we need to move everything?

We'll cover all of these things and more, as well as querying the attendees on what to do next during certain steps to ensure you have your mind in the right place. Migrations can be tedious, but if planned properly, they can be easy and expand your knowledge for SQL Server.

This session does not cover dbaas migrations

SessionID: 83914

SQLStarter - Discussion/Networking Session

Back to calendar

Event Date: 11-08-2018 - Session time: 15:30:00 - Track: SQLStarter

Speaker: Hope Foley

Title: SQLStarter - Discussion/Networking Session

Abstract:

Ending the day of SQLStarter sessions with a mix of QA and networking.

This site is open source. Improve this page.