SQLSaturday #629 - Indianapolis 2017

Event Date: 08/12/2017 00:00:00

Event Location:

Ivy Tech Noblesville
300 N 17th St
Noblesville, Indiana

This event has completed. All data shown below is from the historical XML public data available.

Sessions
Speakers
Sponsors

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).

Sessions

This is a list of sessions from the event, based on the schedule in the XML files.

Title: Find out why SQL Server 2016 Service Pack 1 is an Industry Game changer

Abstract: Come to this session to find out why SQL Server 2016 SP1 revolutionized SQL Server allowing a consistent feature and functionality surface area for developers and organizations across all SQL Server 2016 editions, a first in the industry. This will enable developers, ISVs and customers to build advanced applications that scale across editions and cloud as you grow. SQL Server 2016 SP1 Standard Edition sets the bar for rich programming capabilities, security innovations, and fast performance for mid-tier applications and data marts. Then easily upgrade to Enterprise Edition for mission critical capabilities as your workload scales, without having to re-write your application.

Key Learning: Learn the new features made available with SQL Server 2016 SP1 Standard Edition Develop more powerful application that were not possible before with Standard Edition Learn how to upgrade to SQL Server 2016 Service Pack 1

Speaker(s):

Ross LoForte

Track and Room: Enterprise Database Administration Deployment - 141

Title: Increase Your Coding Speed in SQL Server Management Studio

Abstract: Every developer wants to be productive and get more things accomplished during their day to day work. Given a choice between working harder and working smarter, you will most likely choose the latter. But the big question is – How do you boost your productivity? How do you reduce your development time? How do you increase your coding speed?

Be it a T-SQL developer or DBA, we spend most of our time working in SQL Server Management Studio. In this session, we will learn a number of tips and tricks to increase productivity and efficiency in SSMS IDE. We will also look at the new and improved features of SSMS 2016. We will learn how adding few free third party tools to the SSMS IDE will enhance your coding speed. This will be a content rich session with plenty of live demonstrations.

By the end of this session, you will learn some useful techniques to take back with you and apply in your day to day work.

Speaker(s):

Samir Behara

Track and Room: Application Database Development - 145

Title: SELECT Provider FROM Cloud

Abstract: Are you starting to think that this cloud thing may actually take off? Perhaps it has become your responsibility to look for a cloud provider to meet the data needs of your employer/client or you want to be ready in case someone asks. In this session, we will spend a few moments defining Infrastructure as a Service (IaaS), Platform as a Service (PaaS) and Software as a Service (SaaS) before moving on to a brief discussion regarding cloud objections and misconceptions. Finally, we reach our destination, a conversation based in the classic high school essay test question “Compare and Contrast” concerning data centric services in AWS and Azure. The focus of this session is available features not necessarily how to use them.

Speaker(s):

Peter Shore

Track and Room: Cloud Application Development Deployment - 109

Title: Data Visualization: How to truly tell a great story!

Abstract: We have more information available to us today than ever before. So much so that we run the risk of not being able to tell concise stories. There’s a lot more to creating that story than just getting the correct information. Come learn not just the do’s and don’ts, but the whys…

Speaker(s):

Jonathan Stewart

Track and Room: Analytics and Visualization - 136

Title: Query Store Primer

Abstract: This session will take a look at the new Query Store feature in SQL Server 2016. Query Store tracks changes in execution plans, allowing you to easily view performance differences and revert to older plans with a few clicks of the mouse. We will take a hands on look at how to use Query Store to troubleshoot problems as well as some of the new DMVs you can use to find issues as they arise.

Speaker(s):

Tracy Boggiano

Track and Room: Enterprise Database Administration Deployment - 143

Title: Using SQL as the Key to Robust Automation

Abstract: Kelverion Best Practices; Using a Persistent Data Store

It is Kelverion’s recommendation that in nearly every case runbook automations be implemented utilizing a small backend SQL database table or set of tables. This document explains why we make this recommendation.

Persistence

The ORCHESTRATOR data bus is extremely powerful but it is not persistent. This means that if the ORCHESTRATOR runbook server were to reboot or the services were to crash all data about executing runbooks would be lost. So a complicated multistep workflow that is counting on the data bus for its current state would need to be restarted manually by an administrator. That administrator would potentially need to take significant time to understand what parts of the workflow had run successfully and what parts were still needed. If a persistent data store is used at the backend, the last successful step in the process has been recorded in the database with all necessary information to continue the next step.

Speaker(s):

Amber Goins

Track and Room: Professional Development - 109

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.

Speaker(s):

Stacia Varga

Track and Room: Analytics and Visualization - 136

Title: Stop Ignoring the SQL Server Resource Governor

Abstract: SQL Professionals are looking for ways to increase density without increasing resource contention between workloads. The SQL Server Resource Governor is a valuable tool which is often overlooked by Developers and Database Administrators. Resource Governor feature enhancements have made it an indispensable tool for developers and architects. This session will utilize case-studies and demos to illustrate why the Resource Governor should be part of your deployment strategy.

Speaker(s):

Denis McDowell

Track and Room: Application Database Development - 145

Title: Managing Availability Groups with PowerShell

Abstract: SQL Server Always On Availability Groups are all the craze. When you have a need to failover or modify a configuration there are some things that you can only do with PowerShell. Aside from these items, PowerShell can completely manage an AG. Join me for a demo filled session where we will create an Always On Availability Group from scratch to management with PowerShell, including the Windows Server Failover Cluster. From changing parameters to failover, we will have a blast using PowerShell with ease of use to make your life better. Let’s work smarter and not harder when managing this great feature of SQL Server.

Speaker(s):

Ben Miller

Track and Room: Enterprise Database Administration Deployment - 145

Title: Handling Temporal Data in SQL Server 2016

Abstract: In many industries, it is necessary for data professionals to be able to show what a data set looked like at a previous point in time. Whether it’s calculating tax or insurance rates based on a contract date, quickly comparing data changes over time for trend analysis or just recovering from an accidental data change, it’s useful to be able to look back in time through our data. Solutions like Change Data Capture or trigger-based audit tables can be slow, or require a lot of extra code to be effective. Fortunately, SQL Server 2016 introduces system-versioned tables, also known as Temporal Tables, which track data through time with far less overhead than other solutions. In this session, you’ll learn how to create temporal tables, how SQL Server manages data within those tables, and how to query data at a specific point in time using several real-world examples.

Speaker(s):

David Maxwell

Track and Room: Application Database Development - 145

Title: Tame Your Unruly Data With Constraints

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

Speaker(s):

Rob Volk

Track and Room: Application Database Development - 145

Title: Securing SQL Server

Abstract: A default SQL Server installation is reasonably secure, but quot;reasonably securequot; doesn#39;t cut it in an era in which one bad line of code, one weak password, or one open port can result in your customer database ending up on Pastebin. In this talk, we will look at different methods of securing a SQL Server instance, from venerable (principle of least privilege, Transparent Data Encryption) to novel (Always Encrypted, row-level security). These tools and techniques will show us ways for developers, database administrators, and network specialists to work together to secure SQL Server instances.

Speaker(s):

Kevin Feasel

Track and Room: Enterprise Database Administration Deployment - 141

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.

Speaker(s):

Ben Miller

Track and Room: Enterprise Database Administration Deployment - 143

Title: Introduction to SQL Server Integration Services

Abstract: Take an introductory journey into the world of SSIS through the eyes of a SQL Server DBA as he navigates the Business Intelligence waters. This is an introductory course for beginners or users without any SSIS experience. Come learn how to SSIS with me!

Speaker(s):

Ed Watson

Track and Room: BI Platform Architecture, Development Administration - 229

Title: Read Dirty to Me - Isolation Levels/User Impact

Abstract: Issue a “SELECT {data} FROM {myTable}” statement and users need to trust the data returned is accurate. What happens when multiple processes access the same data? What happens further if one of those process is an UPDATE or even a DELETE statement? How about if both processes will be updating that data? Understanding Isolation in SQL Server is paramount in ensuring data integrity in your system. We will cover the different levels of isolation and how they impact what a user views when accessing the data at a given point-in-time.

Speaker(s):

Wendy Pastrick

Track and Room: Application Database Development - 145

Title: SQL Server and PowerShell: Let’s Get Serious

Abstract: Whether you’ve dabbled in PowerShell or wondered what all the fuss is about, make no mistake: PowerShell is something worth learning to make your life as a SQL Server professional easier. Whether you’re a DBA, a SSIS developer, or security professional, In this session you’ll see practical, real world examples of how you can blend SQL Server and PowerShell together, and not just a bunch of regular T-SQL tasks that have been made more complicated.

Speaker(s):

Drew Furgiuele

Track and Room: Application Database Development - 145

Title: From SQL to DAX – another way of extract data

Abstract: Summary: This presentation is to provide BI consultants and SQL developers with different DAX and tabular modeling solutions which can be replacements of SQL querying and high resource consuming ETL processes. Abstract: Many of us are coming from knowing SQL before they have been introduced with DAX or many of us know how to use tabular model through reporting tool but do not know they can use DAX as query language against a tabular model. Thus, I am glad to provide this presentation focusing on three areas:

How to use DAX as a query language to select columns (columns from multiple tables and from value); Group Data; Filter Data; Join Tables; Build customized calculations/measures
How to use tracing tools to monitor the performance difference between SQL solution and DAX solution;
Use a real life example to demonstrate how to DAX and tabular modeling (Row Contexts vs. Filter Contexts+Bridge Table+Inactive relationship+extended table) to replace high resource ETL Processes

Speaker(s):

Dan (Annie) Xu

Track and Room: BI Information Delivery - 144

Title: MS SSAS Business Value: Should I choose Tabular or Multidimensional?

Abstract: Determine which model presents the right business value for your company’s analytical needs. In this session we’ll discuss the difference between SSAS Tabular and SSAS Multidimensional modes, feature differences as well as the benefits and cons to utilizing both modes in MS SQL Server 2016.

Speaker(s):

Wylie Blanchard

Track and Room: BI Information Delivery - 136

Title: Installing SQL Server on Linux in AWS

Abstract: This session will discussion the strategies, pitfalls, and configuration items needed to successfully install SQL Server 2016 on Ubuntu Linux in AWS.

The session will end with a demonstration of an install of SQL Server 2016 on Linux and the tools for SQL Server.

Speaker(s):

Stacy Hein

Track and Room: Strategy and Architecture - 144

Title: Reduce your DBA ( DEV) task list by using Microsoft BI tools

Abstract: Are you a DBA or DBA Dev with access to the Microsoft BI Stack? Why not utilize some of these amazing tools to make your life a little easier?

Are you working without fancy monitoring and reporting tools? Do you dream of having time to pull data into Excel ans show you management staff what is going on? Do you run queries to answer questions for projects or at the department’s request on a regular basis? Wanna know what is going on with your report server?

Come to this “BI for the Engine Guy” session and let me help you make visualizations for all your engine’s health care needs and your user’s (customer) data demands.

Speaker(s):

Tamera Clark

Track and Room: Enterprise Database Administration Deployment - 141

Title: Introduction to Relational Database Design Patterns

Abstract: The use of design patterns has been quite popular in object-oriented development to help identify best practices for various situations. Unfortunately, this practice has not really reached the world of relational database architecture where they are just as applicable. In this session, we’ll discuss some techniques and best practices that help make database design more effective and efficient not only in operation but also in design and administration. With the use of some example scenarios, you’ll walk away with a better understanding of design patterns that you can apply right away!

Speaker(s):

Aaron Cutshall

Track and Room: Strategy and Architecture - 144

Title: SQL into R: an Absolute Beginners’ Guide to R for the SQL User

Abstract: SQL data can be exported to any number of data manipulation, visualization, and reporting packages, including R. But what, exactly, is R and why would anyone consider it when there are already so many other choices available? We will answer those questions by considering: (1) what is R? (2) how does it work? (3) why is it so popular (4) what is so special about it? We will do this using side-by-side examples of R and SQL code, and by using the “pipe” operator in R to connect several operations to analyze a publicly-available data set. By the end of this session, the attendees will have the previous questions answered and be able to decide whether to consider R, or to stay with their current solution.

Speaker(s):

Stan Siranovich

Track and Room: Analytics and Visualization - 136

Title: SQL Server ColumnStore Indexes

Abstract: Come and learn how the SQL Server 2012 feature, ColumnStore Indexes, can parallelize your Data Warehouse aggregations. I will be doing a deep dive into the inner workings of ColumnStore indexes; how they work, key characteristics, dos and don’ts, restrictions, and more. I will have some insight into how CSI’s have been updated in SQL Server 2014 2016, as well. If you are a production DBA who needs to find out more about some of the additional hot features that have been included with CSI’s, like batch mode processing and data segments, then this session is for you. If you are a BI DBA or developer who needs to find out how CSI’s can increase the performance of your aggregations and star-joins by up to 40 times, then this session is also for you.

Speaker(s):

Gareth Swanepoel

Track and Room: BI Platform Architecture, Development Administration - 140

Title: SSMS Tips and Tricks

Abstract: As DBA’s, your primary tool to connect to SQL is likely SQL Server Management Studio. We will be covering some cool stuff from the options menu, a few formatting/query tips, and why you should use the latest SSMS client. Hopefully you’ll learn at least one trick to make your life easier.

Speaker(s):

Brandon Lukes

Track and Room: Enterprise Database Administration Deployment - 143

Title: How to Keep Your Databases Secure in Just Minutes a Day

Abstract: You’re busy. You don’t have time to check the security of your systems all the time, right? It’s not like anyone has added a user that you don’t know about. And no one would create a database and add all logins to the db_owner role. And of course, no one would ever think of setting the TRUSTWORTHY property on a database… right?

Things like that happen on a daily basis, poking holes in even the most well-secured database. Those holes are just waiting for someone to find them. That someone could be you, or it could be an attacker probing for a way to get data from your company.

In this session, we will explore how to create reports that are quick to review so you can find the holes before someone else does - without interfering with the rest of your day. Along the way, you’ll also learn where to find security-related information in SQL Server’s metadata and logs to allow you to customize and extend the reports to meet your company’s unique needs.

Speaker(s):

Ed Leighton-Dick

Track and Room: Enterprise Database Administration Deployment - 143

Title: 45 Minutes to Your First SSAS Tabular Model

Abstract: Have you been watching SSAS Tabular develop? What about the new Azure Analysis Services product? Or you’ve looked at these and like what they can add in Power BI or classic BI scenarios, but haven’t had a chance to dive in and figure all of this out? Now is the time! SSAS Tabular is a new-ish form of business intelligence model released with SQL Server 2012, intended as an alternative to more traditional Multidimensional cubes. In this session, we will talk briefly about what Tabular is and what it does, in addition to the various options for deployment, before exploring the development process of creating a tabular model ready for ad-hoc querying through Excel or Power BI.

Speaker(s):

Kerry Tyler

Track and Room: BI Platform Architecture, Development Administration - 229

Title: Anatomy of a Transaction

Abstract: In SQL Server, the transaction log is the most important file in any database. All changes to the data and schema are tracked in the transaction log. Join me to learn how to read the transaction log, how to follow a transaction as is processes, and how SQL Server handles a transaction rollback. You will also learn how to identify the resources and objects SQL Server accesses during the course of the transaction. Finally, you will see how SQL Server processes transactions for In-Memory tables.

Speaker(s):

Frank Gill

Track and Room: Strategy and Architecture - 144

Title: The Data-Professional’s Junk Drawer

Abstract: There is at least one in your home right now, a box, a basket, a bucket, perhaps even actually drawer; hastily organized at best but full of tools, gadgets, widgets and whatchamacallits designed for one or two specific purposes. Realistically, we all want to use the more generic, multipurposed item found in our “well organized place for storing things”, yet deep down we know that tool/gadget/widget etc. is really what we need. As data-professionals, we are all familiar with the largest “junk drawer” ever created, the Internet. In this session, we will discuss some tools which are not data specific, the jobs they do well, and where to find them. Join as us as explore Robocopy, parts of the SysInterals Suite, a connection manager or two, portables apps aplenty and more so that you can move that file more efficiently, troubleshoot that problem through a different lens, or simply know what the heck someone else is talking about.

Speaker(s):

Peter Shore

Track and Room: Enterprise Database Administration Deployment - 141

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

Abstract: Since Extended Events are replacing Profiler, 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!

Speaker(s):

Dave Bland

Track and Room: Enterprise Database Administration Deployment - 143

Title: SQL Election: Which Tech is Faster?

Abstract: Ever wondered what’s faster between a bulk insert and BCP? What about index seek vs index scan? This session will review multiple topics of SQL Server that include development, ETL, and administration. In the spirit of our recent election, this session will feature having the ability to debate and vote on which of each technology you think we will be best, and if your “candidate” wins, your votes will be entered into a drawing; so the more votes you win the more chances you get!

Speaker(s):

Robert Verell

Track and Room: Application Database Development - 140

Title: SQL Server 2017 (Linux and Beyond)

Abstract: Microsoft has leveled the RDBMS playing field, with SQL Server vNext (aka SQL Server 2017), allowing you to deploy and run SQL Server on a variety of operating systems and container solutions.

In this session, we will look at the background of SQL Server’s move to non-Windows platforms, cover how to install using package deployment on Linux and image-containers with Docker. Focus will cover administration and tools that you can leverage while running SQL Server on non-Windows platforms, including migration and current feature function limitations.

Speaker(s):

Andrew Loree

Track and Room: Enterprise Database Administration Deployment - 141

Title: Introduction to Data Science

Abstract: This presentation is part of the SQL Starter Track an will give an Introduction to Data Science.

Speaker(s):

Stan Siranovich

Track and Room: SQL Starter Track - Auditorium

Title: Ethics, Morals, and Laws for the DBA 101

Abstract: Ethics, Morals, and Laws each govern one aspect of our behavior as people and DBAs. They govern which actions we take and which actions we avoid.

Understanding the basics of these guides and how they coordinate (and sometimes conflict) with each other helps you to make choices you can live with from both a personal and professional perspective.

This session presents basic definitions, ideas, and discussion points. It is intended to be an interactive presentation where the audience contributes to the discussion, so no two presentations are exactly the same!

Speaker(s):

Pat Phelan

Track and Room: Professional Development - 140

Title: Working with JSON in SQL Server 2016

Abstract: One of the many exciting new features in SQL Server 2016 is the suite of JSON functions, which allow for querying JSON text and generating JSON text from tabular data. This session will explore these new capabilities from a BI perspective. You’ll learn how to load JSON text into SQL Server with SSIS, and how the new JSON functions facilitate the ELT (Extract, Load, Transform) or schema on read pattern.

Speaker(s):

Chris Koester

Track and Room: BI Platform Architecture, Development Administration - 229

Title: Leveraging SQL Server R Services to Perform Advanced Analytics

Abstract: SQL Server 2016 is packed with many great features. One of those features is the integration of R in SQL Server via SQL Server R Services. This integration gives us the ability to perform very sophisticated analytics against data inside the database and data warehoused in big data environments such as Spark Hadoop.

In this session I will demonstrate how to productionize models developed by your data scientist via SQL Server R Services. I will demonstrate how to manage the whole process using an IDE that many of us have grown to love, Visual Studio.

Speaker(s):

Ryan Wade

Track and Room: Advanced Analysis Techniques - 109

Title: Architecting for Performance

Abstract: Successful reporting and transactional systems start with proper architectural principles and considerations. Learn how to design new database systems for optimal performance and how to discover, document and prove when performance issues are caused by the system configuration.

Speaker(s):

Matt Henderson

Track and Room: Other - 109

Title: Introduction to Business Intelligence

Abstract: This session is part of the SQL Starter Track and will present and Introduction to Business Intelligence.

Speaker(s):

Kerry Tyler

Track and Room: SQL Starter Track - Auditorium

Title: SQL Server Tricks for Storage and I/O Performance in the cloud

Abstract: SQL Performance strategies for on premises deployment don’t translate straight through to the cloud. SQL Server 2016 brought much more integration and performance options for cloud database deployment. In this session we will see through multiple demos how to benefit from the storage options in Azure storage and make SQL Server break the sound speed!

Speaker(s):

Armando Lacerda

Track and Room: Enterprise Database Administration Deployment - 141

Title: Getting Started with R and R Services

Abstract: R is a statistics and graphical software. Now that it is available in SQL Server 2016 how do you integrate it into your work process? R is its own piece of software and communication between R and SQL Server can seem daunting at first. Learn a bit about R, how to get data into and out of it, integrating it into stored procedures, and some useful tools and tips.

Speaker(s):

Alan Dykes

Track and Room: Analytics and Visualization - 136

Title: Introduction to Database Administration

Abstract: This session is part of the SQL Starter track and will present and Introduction to Database Administration.

Speaker(s):

David Maxwell

Track and Room: SQL Starter Track - Auditorium

Title: MPP – Master Parallel Productivity in Azure SQL DW

Abstract: We will discuss and demonstrate the MPP (massively parallel processing) architecture of Azure SQL DW and how to make best use of this exciting technology, including: • Getting up and running • Loading and migrating data • Dynamically scaling performance • Designing tables and optimizing queries to extract maximum performance • Integrating with big data

Speaker(s):

Britton Gray

Track and Room: BI Platform Architecture, Development Administration - 229

Title: Introduction to Database Development

Abstract: This session is part of the SQL Starter track and will present an Introduction to Database Development.

Speaker(s):

Aaron King

Track and Room: SQL Starter Track - Auditorium

Title: An Adventure Works IoT Demo: moving beyond sales data

Abstract: This session will cover a potential IoT use case demonstration. I describe how to simulate IoT data and then utilize that simulated data to tell business use stories. I use the classic Adventure Works SQL database as the launch point that is then enriched with the simulated IoT data.

Speaker(s):

Martin Madsen

Track and Room: Analytics and Visualization - 136

Title: Partitioned Tables and Query Performance

Abstract: Partitioned tables are an ideal solution for improving write performance in certain situations. But they present unique challenges for the developer who simply needs to query the data. In this session, you will learn how the optimizer takes partitioned tables into account when producing query plans, recognize common query plan issues, and learn tactics for improving performance when querying partitioned data.

Speaker(s):

Jay Robinson

Track and Room: Application Database Development - 140

Title: Never Lose Data! Digging Out From Corruption

Abstract: A “Disaster” doesn’t need to be on a massive scale to cause widespread destruction in your enterprise. Simple things like failing hardware, strange storage bugs, a forgotten WHERE clause, or an angry employee can either cause devastation or be just a nuisance to the properly-prepared DBA. This session is a survey of recovery techniques that should be in every DBA’s toolbox.

Speaker(s):

Eddie Wuerch

Track and Room: Enterprise Database Administration Deployment - 145

Title: Advanced Biml Concepts

Abstract: After you get started with Biml you quickly find yourself getting more and more complex with your solutions. In this session, we walk through the end game of Biml. What would it take to get to full automation in your BI solutions? At the end of this session, you’ll have a game plan to get to that point.

At the end we discuss the implications of automating your solutions: what do we do when we no longer need a SSIS developer?

Speaker(s):

Shannon Lowder

Track and Room: BI Platform Architecture, Development Administration - 229

Title: Right-Size Your Data Files

Abstract: Best practices for SQL Server indicate that when configuring tempdb, we should create multiple files for better performance. So why is it this is often ignored for user databases, where our data is actually stored?

In this session we’ll look into why having multiple files for databases and filegroups is important, even on solid state drives. Then we’ll look into some scripts and tools that will assist us in transforming our databases to be right-sized for performance considerations.

Speaker(s):

Robert Verell

Track and Room: Strategy and Architecture - 140

Title: Unleashing Stretched Databases

Abstract: This is a deep dive session full of demos about SQL 2016 stretched databases feature. It will go from pre-reqs and blocking factor through deployment and disaster recovery. Everything you need to know and when to use this new cloud-based exciting capability.

Speaker(s):

Armando Lacerda

Track and Room: Enterprise Database Administration Deployment - 141

Title: Availablity Groups in SQL 2016 and beyond: Faster, Higher, Stronger

Abstract: Always On Availability Groups have become the preferred HA/DR solution within SQL Server. Starting with SQL Server 2016, a number of enhancements have been made to make AGs faster, have better up time, and be more resilient. We will cover all the recent changes in Availability Groups (direct seeding, multiple automatic failover replicas, distributed AGs, load balanced secondaries, etc) and look at how they can be leveraged to create more robust HA/DR solutions.

Speaker(s):

Joe McTaggart

Track and Room: Strategy and Architecture - 144

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.

Speaker(s):

Dave Mattingly

Track and Room: Cloud Application Development Deployment - 109

Title: Introduction to Big Data

Abstract: This session is part of the SQL Starter track that will present an Introduction to Big Data.

Speaker(s):

Warren Sifre

Track and Room: SQL Starter Track - Auditorium

Title: SQL Server 2016: Data Masking and Encryption

Abstract: Learn about data masking and encryption, the pros and cons of each, as well as when to use which.

Speaker(s):

Sean Werick

Track and Room: Application Database Development - 140

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.

Speaker(s):

Stacia Varga

Track and Room: Analytics and Visualization - 136

Title: It’s a Machine World - Predictive Analytics with Azure Machine Learning

Abstract: Introduces Microsoft Azure Machine Learning, explaining what Azure Machine Learning is and how it functions. Attendees are walked through a real world scenario of building and using a predictive analytics model with Azure Machine Learning. At the end of this session, attendees will understand fundamental Azure Machine Learning terminology, how to build, train and use a predictive analytics model and the key concepts around the various components used within predictive models.

Speaker(s):

Greg Deckler

Track and Room: Advanced Analysis Techniques - 109

Title: Introduction to Azure Streaming Analytics

Abstract: This session will cover what is Streaming Analytics and the various use cases. We will demonstrate the creation of a Streaming Analytics process which will output the data to a dashboard for review. The intention is to provide insights in how this technology can potentially be leveraged by the SQL community.

Speaker(s):

Warren Sifre

Track and Room: Cloud Application Development Deployment - 109

Title: SQL Server 2017 New BI Features

Abstract: While SQL Server on Linux is getting the major marketing push for 2017, there is plenty of other new features which will also be included in SQL Server 2017. This session will provide an overview and some demos on new features in SQL Server BI tools. This will include changes to SSAS, SSIS, SSRS (Power BI Report Server), and Machine Learning Services (formerly R Services).

Speaker(s):

David Mellinger

Track and Room: BI Platform Architecture, Development Administration - 229

Title: Crash Course on Better SQL Development

Abstract: SQL Development is a broad subject with many roads to choose from. Often times SQL Developers feel overwhelmed and unsure which areas they need to focus on. The purpose of this session is to give a high-level overview and present paths for further study and growth. Subjects reviewed in this session will include coding patterns, error handling, and execution plans. Demonstrations of free tools will also help developers find ways of simplifying their daily tasks. Attendees will leave this session empowered with knowledge and directions for further growth.

Speaker(s):

Vladimir Oselsky

Track and Room: Application Database Development - 144

Title: Introduction to Data Science

Abstract: This presentation is part of the SQL Starter Track an will give an Introduction to Data Science.

Speaker(s):

Sean Werick

Track and Room: SQL Starter Track - Auditorium

Title: Game of Thrones Discussion

Abstract: Winter is coming! Last minute replacement session…just a fun discussion of Game of Thrones. Spoilers will be abundant so come at your own risk.

Speaker(s):

Alan Dykes

Track and Room: Other - 109

Title: SSAS 2016 Tabular - Diving into the new features

Abstract: Taking a looking at all the new features of SSAS 2016 Tabular, how to use them effectively and avoid pitfalls. Features include Bi-Directional Cross Filtering, Parallel Partition Processing, Calculated Tables, etc.

Speaker(s):

Brian Beswick

Track and Room: BI Platform Architecture, Development Administration - 143

Title: How to get Microsoft Certified

Abstract: Microsoft has recently streamlined the certification process and this session focuses on what you need to know to get Microsoft Certified on SQL Server. The session is led by an expert Microsoft Certified Trainer (MCT) and Microsoft MVP who regularly teaches the SQL Server certification courses. The presenter walks you through the certifications, exams, and resources available to get you ready for success.

Speaker(s):

John Deardurff

Track and Room: SQL Starter Track - Auditorium

Speakers

This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Shannon Lowder

Twitter: - @shannonlowder

LinkedIn: Shannon Lowder

Contact: http://shannonlowder.com

For over 15 years Shannon Lowder has been spotting patterns and learning ways to work smarter instead of harder. He started with development and moved into database administration. Using TSQL, Database Jobs and PowerShell, he automated himself out of contracts quickly. As Business Intelligence became a greater demand, he moved into SSIS, SSRS, and SSAS development. Early on, he tried using PowerShell and .Net to automate BI Development. Later those efforts turned to Biml. After founding a startup six years ago, he finds himself a data platform consultant, designing and guiding other professionals to build highly automated enterprise solutions. Today, he is a Biml Hero candidate and is awaiting the final approval for the award.

Wendy Pastrick

Twitter: - @wendy_dance

Contact: http://wendyverse.blogspot.com

Wendy Pastrick is from Chicago, IL, and for the past 15 years has served as a Database Administrator supporting both development and production environments. Her many years of involvement with PASS include WIT Virtual Chapter and the Chicago Suburban User Group, serving as Regional Mentor, and as a PASS Board member since 2013. Wendy has organized several highly successful SQLSaturday events in Chicago.

Peter Shore

Twitter: - pshore73

LinkedIn: Peter Shore

Peter Shore is a seasoned IT professional with over 25 years of experience. He took the accidentally intentional DBA plunge in 2013 and has discovered that he loves to find the stories the data has to tell. Peter is comfortable working with both physical and virtual servers, where he tries to apply best practices to attain performance improvements. He is also adept at bridging the gap between technical and business language in order to bring technology solutions to business needs.

Ryan Wade

Twitter: - MrDataGeek

LinkedIn: Ryan Wade

Ryan is an experienced data analytics professional. His education and work experience enables him to understand things from a technical, analytical, and business viewpoint. He has the ability to present complex data in an intuitive way using sound analytical and visualization methods.

He has an advanced analytical and technical skill-set which includes Power BI, T-SQL, R, Python, Azure Machine Learning Services, Azure Databricks, SQL Server Machine Learning Services, Advanced Modern Excel, SSIS, SSAS Tabular.

He is a data analytics enthusiast that has spoken at a variety of database and data science conferences about various topics dealing with data analytics.

Martin Madsen

LinkedIn: Martin Madsen

A results-driven analyst with over 15 years’ experience building data solutions guiding customers through complete data projects from • Building data collection systems from IoT physical sensors to real-time social media feedback, • Gathering big data through scalable cloud-based platforms, • Extracting insights though advanced analytics and machine learning, to • Translating data results into actionable metrics.

Stacy Hein

Twitter: - @sqlstacy

LinkedIn: Stacy Hein

As a DBA for 15 years, I have a wide and varied experience in most industries and sizes of companies. My experience with SQL Server ranges from version 6.5 through version 2016.

I have two BS degrees in Chemistry and Biology and an MS in Cybersecurity. My favorite part of this career is the opportunity to learn something new everyday and share that knowledge with others. The opportunity to mentor other DBAs over the years has also been a enriching part of my career. Mentoring is another reason I love being a DBA.

Denis McDowell

Twitter: - mcdowell_is

LinkedIn: Denis McDowell

Denis McDowell is a Microsoft Data Professional with over 20 years of experience with SQL Server, scripting, virtualization, IT operations, and Cloud implementations across multiple industries. He currently works as the Solutions Engineering Manager for SentryOne and owns a consulting practice in the Charlotte, NC area. Denis has been a regular presenter at local, regional, and national conferences and events, including PASS Summit, Microsoft Hosting Summit, and numerous SQLSaturday and SQL User Groups around the U.S. In his free time, Denis enjoys traveling with his family, playing and recording in his home music studio, and catering to the needs of his three dogs.

David Mellinger

Twitter: - @HoosierDataDev

LinkedIn: David Mellinger

David started working with SQL Server as an application developer in 2003. He switched to focusing on the database over 10 years ago. He has created and worked with ERP, e-commerce, middleware, geo-spatial, and of course analytic (ODS, DW) databases. David is a Practice Lead for Allegient’s Data Platform Analytics practice. He loves working with businesses to get them setup to use technology for success. Diving into complex challenges or “can you\how can you do this” scenarios is fun for David. He is passionate about mentoring and sharing experiences to help others (and himself!) grow.

Dave Bland

Twitter: - @SQLDave29

LinkedIn: Dave Bland

Contact: https://www.davebland.com

Over 20 years of SQL Server experience that includes being a DBA, BI development and Application development using VB.NET. Dave currently is the Manager of the DBA team at Stericycle. Dave is a Friend of Red-Gate for 2019. He is a frequent presenter at SQLSaturday events and user groups around the country. Has been teaching SQL Server since version 2000 and is the SQL Server instructor at Harper College in Palatine, IL. Current certifications include: • Microsoft Certified Trainer • MCTS: SQL Server 2008, Implementation and Maintenance • MCTS: SQL Server 2008, BI Development and Maintenance • MCSA: SQL Server 2008 • MCSA: SQL Server 2016 • MCSE: SQL Server 2016 - BI • MCDBA: SQL Server 2000 • MCSD • MCSE: Data Management and Analytics

Amber Goins

LinkedIn: Amber Goins

I have been in IT since 1999, starting with Exchange Server. From there I moved into System Center. Now I work with Kelverion in a role that is both Engineering and Sales combined. I also manage our relationship with Microsoft and our Federal Customers. With Kelverion and the use of our SQL Integration Tools, I have been able to make Automation easier using a backend SQL Database to “persist” data. Orchestrator does not do this out of the box, everything exists in memory. Using Kelverion’ s SQL methodology I am able to use a small SQL DB to integrate automation with multiple 3rd Party software tools into ITSM.

Jonathan Stewart

Twitter: - sqllocks

LinkedIn: Jonathan Stewart

Contact: https://sqllocks.net/

Jonathan Stewart is a Business Intelligence consultant specializing in data visualization, data warehousing, and data management technologies. An advocate for educating others, he is a public speaker, teacher and blogger, continually teaching people about the Microsoft BI Stack. Since 2000, he has been working in the database field with industry leaders in healthcare, manufacturing, financial, insurance and federal, state and local governments.

Jonathan is very active in the community. He has presented on SQL Server, SSIS, Reporting Services, Power BI and Business Intelligence at numerous SQLSaturday events, local user groups, and conferences throughout the United States and around the world. He participates in webcasts, podcasts, and on

John Deardurff

Twitter: - SQLMCT

LinkedIn: John Deardurff

Contact: https://www.sqlmct.com

John has been a Microsoft Certified Trainer (MCT) for over 20 years teaching Azure, SQL Server, Exchange Server, and Windows Server networking courses. He is currently a SQL Premier Field Engineer for Microsoft. He is an MCT Regional Lead for the Eastern United States and a former Data Platform MVP.

Samir Behara

Twitter: - samirbehara

LinkedIn: Samir Behara

Contact: https://dotnetvibes.com/

Samir Behara is a Solution Architect with EBSCO Industries and builds software solutions using cutting edge technologies. He is a Microsoft Data Platform MVP with over 13 years of IT experience working on large-scale enterprise applications involving complex business functions, web integration, and data management in various domains like Insurance, Manufacturing and Publishing.

Samir is a frequent speaker at conferences such as PASS Summit, IT/Dec Connections, CodeStock, SQLSaturdays and CodeCamps. He is the Co-Chapter Lead of the Steel City SQL Server UserGroup, Birmingham, AL. He is the author of www.dotnetvibes.com

Ben Miller

Twitter: - DBAduck

LinkedIn: Ben Miller

Contact: https://dbaduck.com

Ben has been a member of the SQL Server Community since 2000. He loves a challenge and has fixed many SQL Servers and helped hundreds of people get more out of their DBA jobs. He is a Data Platform MVP a SQL Server Certified Master (MCM). He has worked at various companies throughout the USA, as well as at Microsoft for 7 years. He is passionate about SQL Server Infrastructure, High Availability, Automation and Integration using SMO and PowerShell. He teaches DBAs how to use PowerShell to do their job and teaches SQL Server Internals. He is @DBAduck all around the web (Twitter, LinkedIn, Facebook, Blog) so let’s catch up.

Britton Gray

Twitter: - IDreamInSQL

LinkedIn: Britton Gray

Britton Gray is a veteran of database development, data management, business intelligence, analytics, and data privacy in BI. He has successfully completed projects in a variety of technologies in different technology stacks. Coming from a family full of teachers, he thoroughly enjoys the opportunity to share knowledge and insights; it’s an extension of “getting the right information to the right people at the right time” mantra of BI. He lives near Indianapolis, Indiana, and is the Director of BI for Project Lead The Way, a nonprofit organization providing transformative learning experiences in computer science, engineering, and biomedical sciences.

Tracy Boggiano

Twitter: - TracyBoggiano

LinkedIn: Tracy Boggiano

Contact: http://databasesuperhero.com

Tracy Boggiano is a Senior Database Administrator for DocuSIgn. She has spent over 20 years in IT, using SQL Server since 1999, and is currently certified as an MCSE Data Platform. Tracy has worked on SQL Server since 6.5. She has spoken at local user groups and numerous SQLSaturdays. She is currently a co-leader of a TriPASS Local Group in Raleigh, NC.

Tracy also tinkered with databases in middle school to keep her sports card collection organized. She blogs at databasesuperhero.com.

Her passion outside of SQL Server is volunteering with foster children as their advocate in court through volunteerforgal.org and being a mental health advocate as part of the PAIMI NC Advisory Council.

Armando Lacerda

Twitter: - arlacerda

LinkedIn: Armando Lacerda

Over 30 years in the computing field as a developer and system integrator; over 20 years working with SQL Server since version 6; cross platform experience with Oracle and IBM SQL/DS and DB2; Microsoft Certified Trainer for over 20 years.

Aaron Cutshall

Twitter: - sqlrv

LinkedIn: Aaron Cutshall

Contact: http://sqlrv.com

Aaron N. Cutshall is an Enterprise Data Architect with 20 years of experience in analysis, design and development for applications and databases in manufacturing and warehousing plus over 15 years in the Healthcare Informatics field. His primary focus is in designing and developing solutions for extremely large data sets that perform quite well in SQL Server. He is active in the SQL Server community and speaks at SQLSaturday sessions across the country.

Ben Miller

Twitter: - DBAduck

LinkedIn: Ben Miller

Contact: https://dbaduck.com

Vladimir Oselsky

Twitter: - @VladyOselsky

LinkedIn: Vladimir Oselsky

Vladimir Oselsky (Vlady) is an IT Professional with over 15 years of experience in various IT Jobs. Born and raised in Siberia, moved to United States in late 90s. Passion for computer and programming started with DOS games and learning Borland Paschal in 8th grade as a hobby. IT career consisted of everything from hardware and software support to server administration. Current focus on SQL Server Database Development and .NET programming

Frank Gill

Twitter: - skreebydba

LinkedIn: Frank Gill

Contact: http://skreebydba.com/

Frank Gill is a Senior Data Engineer at Concurrency With 21 years of IT experience, the first 8 as a mainframe programmer, he has developed a love of all things internal. Over the past several years, he has worked extensively with SQL Server solution in Azure, including Managed Instance. When not administering databases or geeking out on internals, Frank volunteers at the Art Institute of Chicago and reads voraciously.

Dan (Annie) Xu

Twitter: - anniexu1990

LinkedIn: Dan (Annie) Xu

Contact: https://anniexu1990.com

Annie Xu is a Microsoft cloud solution architect focusing on Data and AI. She has comprehensive educational and working experience in business intelligence, database development and data engineering. In addition, she is building up her skills around AI and Machine Learning. Annie speaks at DMV area Power BI, SQL and Azure user groups. You are welcome to read her blog: https://xuanalytics.com or connect her through LinkedIn @anniexu1990

Kevin Feasel

Twitter: - feaselkl

LinkedIn: Kevin Feasel

Contact: http://www.catallaxyservices.com

Kevin Feasel is a Microsoft Data Platform MVP and CTO at Envizage, where he specializes in data analytics with T-SQL and R, forcing Spark clusters to do his bidding, fighting with Kafka, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL (https://curatedsql.com), president of the Triangle Area SQL Server Users Group (https://www.meetup.com/tripass), and author of PolyBase Revealed (https://www.apress.com/us/book/9781484254608). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather’s nice enough.

Matt Henderson

LinkedIn: Matt Henderson

A 20 year veteran of designing database architectures for high performance, business critical transactional and analytics systems, Matt has worked as an independent consultant, managed data centers for large corporations and most recently has been a solutions consultant and evangelizing force for startups in Silicon Valley including speaking engagements on 5 continents. Today Matt works for Vexata, an Intel-backed leader in all-flash storage who is transforming what is possible.

Warren Sifre

Twitter: - WAS_SQL

LinkedIn: Warren Sifre

Contact: http://www.broadstrokeconsulting.com/blog/, http://www.allegient.com

Warren Sifre has been in the IT community since 1998 and has worked in a variety of industries deploying solutions utilizing MS SQL Server in one capacity or another. In 2003, he decided to make SQL Server his mastery and has since developed skills in most defined disciplines of MS SQL. Currently he is a Principal Consultant and Technology Leader with Moser Consulting. He is responsible for BI Solution Architecture and the mentorship of team members. He has been a SQLSaturday Speaker since 2012, Azure Global Bootcamp, and many user groups in 2015 alone. He has a passion for knowledge transfer and solutions architecture, with a keen interested in Info Security.

David Maxwell

Twitter: - https://twitter.com/dmmaxwell

LinkedIn: David Maxwell

Contact: https://dmmaxwell.wordpress.com/

David Maxwell has almost 20 years of experience with SQL Server, with a keen interest in performance tuning, monitoring, and troubleshooting. He has experience in environments as diverse as health care institutions, auto manufacturers, and insurance companies. David has been a frequent presenter at SQLSaturday events around the United States since 2012, as well as a presenter for the DBA Fundamentals Virtual Group, the Performance Virtual Group, 24 Hours of PASS, and the annual PASS Summit. David participates in his local Columbus Ohio PASS Local Group, where he serves on the board of directors as SQLSaturday coordinator.

Alan Dykes

Twitter: - @dykesa

Alan has over 6 years of experience with SQL Server. He is a Microsoft Certified Professional in T-SQL and manages a team at First Databank, Inc. that tests data products.

David Maxwell

Twitter: - https://twitter.com/dmmaxwell

LinkedIn: David Maxwell

Contact: https://dmmaxwell.wordpress.com/

Stacia Varga

Twitter: - @StaciaV

LinkedIn: Stacia Varga

Contact: http://blog.datainspirations.com

Stacia Varga is a Microsoft Data Platform MVP and SSAS Maestro with a Bachelor’s Degree in Social Sciences. A consultant, educator, author, and principal of Data Inspirations, her career spans more than 30 years, with a focus on improving business practices through technology.

Since 2000, Stacia has provided consulting and education services for Microsoft’s Business Intelligence technologies. As Stacia Misner, she also authored several books covering the Microsoft BI stack.

Eddie Wuerch

Twitter: - @EddieW

LinkedIn: Eddie Wuerch

Contact: http://www.indydba.com

Eddie Wuerch has 20 years of experience as a SQL Server specialist in a much-longer IT career. A Microsoft Certified Master, Eddie spends his days in the Salesforce Marketing Cloud, focusing on performance, scale, and uptime for the massive SQL Server backend. These SQL Servers churn billions of transactions daily against trillions of rows of data in a 24x7 continuously-available online system accessed by millions worldwide every day.

Chris Koester

Twitter: - cjkoester

LinkedIn: Chris Koester

Contact: https://chris.koester.io/

Chris Koester is a Data Analytics Solution Architect at DMI, focusing on cloud data engineering and architecture. Chris graduated from Indiana University in 2008 with a Bachelor of Science in Informatics.

Jay Robinson

Twitter: - @downshiftdata

LinkedIn: Jay Robinson

Contact: https://downshiftdata.wordpress.com/

I write C# and T-SQL code that scales well. I teach others to do it. DBAs like me.

Ed Watson

Twitter: - http://twitter.com/SQLGator

LinkedIn: Ed Watson

Contact: http://sqlgator.com

Ed Watson is a Principal Data Platform Consultant for Improving Enterprises, a full-stack Microsoft consulting firm in Atlanta. Ed is a Microsoft Data Platform MVP since 2014 and like most children, Ed was born at an early age. Today, Ed specializes in the Business Intelligence stack and enjoys specializing in Power BI immensely. He currently lives in Atlanta and is active with the Atlanta MDF and Atlanta BI user groups and is an organizer for SQLSaturday Atlanta, Atlanta BI, and Pensacola.

Rob Volk

Twitter: - sql_r

LinkedIn: Rob Volk

Contact: http://weblogs.sqlteam.com/robv/

Rob Volk is a SQL Server DBA in the Metro Atlanta area since 2001. He also moderates and answers the forums on SQLTeam.com. While an old-time cranky DBA, he no longer considers quot;business intelligencequot; an oxymoron or quot;the cloudquot; as merely atmospheric moisture, and is delightedly dipping his toes into both of these new oceans, and loves to do things in new and and unusual ways.

Aaron King

Twitter: - https://twitter.com/trendoid

LinkedIn: Aaron King

Contact: http://www.aaronstanleyking.com

Aaron King is an application architect specializing in enterprise web applications and very large databases. He has helped several successful startups move to the software plus services model. He is currently working as an independent consultant on several long term engagements. Aaron is also a community leader and active in Indy PASS.

Warren Sifre

Twitter: - WAS_SQL

LinkedIn: Warren Sifre

Contact: http://www.broadstrokeconsulting.com/blog/, http://www.allegient.com

Robert Verell

Twitter: - @sqlcowbell

LinkedIn: Robert Verell

Contact: http://sqlcowbell.com/wordpress/

Robert Verell is a SQL Server professional working in the Nashville area and has worked in healthcare, insurance, and banking. He found his passion for databases by learning SQL Server Integration Services and writing stored procedures, and eventually became a database administrator. Robert is a chapter lead for the Nashville SQL Server User’s Group, a volunteer for SQLSaturday, and was a finalist in the 2016 PASS Summit Speaker Idol competition.

Drew Furgiuele

Twitter: - pittfurg

LinkedIn: Drew Furgiuele

Contact: http://www.port1433.com

Drew Furgiuele is a senior DBA that lives in Dublin, Ohio who is passionate about SQL Server and PowerShell. He’s been working with SQL Server since 2002. When he’s not accidentally dropping tables in production, he likes writing automation scripts, blogging about SQL Server Replication, wiring electronics, playing board games, and spending time with his dog. He’s also not embarrassed by his Spotify playlists.

Sean Werick

LinkedIn: Sean Werick

Contact: http://www.seanwerick.com

I have been in the data industry for 15 years, specializing in Microsoft business intelligence for the last decade. I have architected, developed and integrated end to end solutions for customers in various sectors including finance, government, health care and retail. I am extremely passionate about data and the endless possibilities for companies utilizing it in the best ways. I enjoy data science and business intelligence because the possibilities and magnitudes of impact are immeasurable.

Stan Siranovich

Twitter: - StanAtCC

LinkedIn: Stan Siranovich

Contact: http://www.crucialconnection.com/blog/

Stan has been doing Data Analysis and Data Science, using JMP, SAS, R and Tableau since before Al Gore invented the Internet. He has 15+ years of multinational experience doing laboratory Research, Product Development and Technical Marketing for Bayer, Cargill and Mobil Oil. He holds a BS in Chemistry from Allegheny College, an MBA with concentrations in both Finance and MIS from Duquesne University, and a Microsoft Network Engineer certificate from Sullivan University. He’s done graduate coursework in Chemistry at Rutgers University and holds multiple certs from ComTIA and Microsoft. Currently he’s interested in working at the intersection of Business and the natural Sciences.

Joe McTaggart

I am a Microsoft SQL Server Premier Field Engineer (PFE). I’ve been with Microsoft for 13 years with my time having been split working in SQL CTS support and PFE. My primary focus is SQL database engine but I do have experience with the full stack and all the SSxS components. Secondarily to working primary with customers on SQL, I have helped author a number of the SQL Server workshops offered by our Premier Services (most recently updates to SQL Server Features and Administration and SQL Server Hand-on Troubleshooting).

Wylie Blanchard

Twitter: - WylieBlanchard1

LinkedIn: Wylie Blanchard

Contact: https://WylieBlanchard.com/?utm_source=sqlsaturday.comutm_medium=profileutm_campaign=website

Wylie Blanchard, MCSE is an IT consultant, SQL Server professional and web strategist who enjoys helping people learn how to use technology as a tool to amplify their professional lives. He has 15+ years of experience in the IT Industry and holds several certifications in SQL and Oracle systems. He is a father of twin-girls, a gadget enthusiast and a self-proclaimed pizza connoisseur. Learn more about Wylie at: www.WylieBlanchard.com.

Andrew Loree

Twitter: - @LowOnDiskSpace

LinkedIn: Andrew Loree

Contact: http://www.andyloree.com

Andrew Loree has over nineteen years of database experience with roles in architecture, design, development, and implementation of enterprise-scale SQL Server data solutions, supporting industries from legal e-discovery to manufacturing. Areas of expertise since SQL Server 2000 include data migration and ETL/ELT solutions, disaster recovery planning, high availability service design, licensing and virtualization. Andrew holds fourteen Microsoft certifications, has both a Bachelor and Masters of Science in Computer Science from Wright State University and is a Columbus (Ohio) PASS board member.

Brian Beswick

LinkedIn: Brian Beswick

Contact: http://brianbeswick.com/

Brian is a Managing Consultant at Allegient. He has many years of experience in database architecture and development across multiple versions of SQL Server. He’s an accomplished Database Architect with a specialty in Business Intelligence. He’s particularly strong at understanding and designing solutions for complex requirements.

Alan Dykes

Twitter: - @dykesa

Alan has over 6 years of experience with SQL Server. He is a Microsoft Certified Professional in T-SQL and manages a team at First Databank, Inc. that tests data products.

Tamera Clark

Twitter: - https://twitter.com/tameraclark

LinkedIn: Tamera Clark

Contact: http://tameraclark.com

Tamera Clark has been involved in the IT industry for greater than ten years, with experiences ranging from systems analysis/engineering to SQL Server and SSRS administration/development. She is an active member of the SQL Server community, participating in the Women in Technology Virtual Chapter, Co-leading the Nashville BI Chapter, assisting the Nashville PASS Chapter and serving as a Regional Mentor. Tamera is also the event chair of SQLSaturday Nashville.

Greg Deckler

Twitter: - @GregDeckler

LinkedIn: Greg Deckler

Contact: https://www.linkedin.com/today/author/0_3IIpqzJXt0rHLHrw11HbE0?trk=prof-sm

I am a Director at Fusion Alliance and the Solution Director of Cloud Services. In addition, I am a Microsoft MVP for Data Platform. As an active member in the Columbus IT community, I founded the Columbus Azure ML and Power BI User Group (CAMLPUG) and have presented at many different conferences and events including Dog Food, SharePoint Saturday, CloudDevelop and M3. I have written numerous trade journal articles on business and technical subjects and the book “Achieving Process Profitability, Building the IT Profit Center”.

Gareth Swanepoel

Twitter: - @GarethSwan

Contact: http://mygareth.com

Gareth Swanepoel is a sysadmin-turned-SQL Server DBA. He has been working in the IT industry doing support and administration for over 25 years. He enjoys solving the complex problems that customers encounter when performance tuning SQL Server or when deploying SQL Server in large data warehouse environments. He is originally from South Africa and is currently a Dedicated Support Engineer (PFE) with Microsoft. He is a passionate member of the SQL Server community and is an accomplished author and speaker having presented at various user groups, SQLSaturdays, the PASS Summit and other technical conferences.

Brandon Lukes

Twitter: - balukes

LinkedIn: Brandon Lukes

Geek with 10+ years of SQL experience on a broad area of topics.

Ed Leighton-Dick

Twitter: - eleightondick

LinkedIn: Ed Leighton-Dick

Contact: http://www.edleightondick.com

Ed Leighton-Dick is a Microsoft MVP, SQL Server performance and architecture specialist, and Founder/Principal Consultant of Kingfisher Technologies. He is a frequent volunteer with PASS, including current roles as a Regional Mentor, co-leader of I-380 PASS local group, and co-leader of the HA/DR virtual group. He can often be found teaching sessions at local, regional, and national events, including user groups, SQLSaturday, and PASS Summit.

Kerry Tyler

Twitter: - AirborneGeek

LinkedIn: Kerry Tyler

Contact: http://airbornegeek.com

Kerry Tyler is a SQL Server, Business Intelligence, and Azure consultant. His initial IT experience was in network engineering and Windows system administration before moving into the data realm. This infrastructure background builds a firm foundation for performance tuning and cloud infrastructure design and implementation. Kerry has full-time DBA experience in SQL Server since version 2000 and business intelligence architecture since SQL Server 2005. In addition to consulting work, he delivers presentations and training on SQL Server administration, business intelligence, and Azure data and infrastructure components.

Kerry Tyler

Twitter: - AirborneGeek

LinkedIn: Kerry Tyler

Contact: http://airbornegeek.com

Sean Werick

LinkedIn: Sean Werick

Contact: http://www.seanwerick.com

Armando Lacerda

Twitter: - arlacerda

LinkedIn: Armando Lacerda

Ross LoForte

Ross LoForte is a Technology Architect at the Microsoft Technology Center in Chicago focused on SQL Server solutions. With more than 16 years of business development, project management, and SQL architecture solutions experience, he has been working with the Microsoft Technology Centers the past 10 years and has led architecture design and proof-of-concept engagements for Microsoft’s largest and most strategic customers to design enterprise, mission-critical SQL Server solutions.

Stacia Varga

Twitter: - @StaciaV

LinkedIn: Stacia Varga

Contact: http://blog.datainspirations.com

Peter Shore

Twitter: - pshore73

LinkedIn: Peter Shore

Stan Siranovich

Twitter: - StanAtCC

LinkedIn: Stan Siranovich

Contact: http://www.crucialconnection.com/blog/

Robert Verell

Twitter: - @sqlcowbell

LinkedIn: Robert Verell

Contact: http://sqlcowbell.com/wordpress/

Dave Mattingly

Twitter: - @dave_mattingly

LinkedIn: Dave Mattingly

Contact: http://www.davemattingly.net

Dave Mattingly has spent thirty years of designing, developing, databasing, documenting, and directing a variety of projects in many industries. In the past, he’s worked on space travel, fraud prevention, data accuracy, and virtual reality for industries such as games, ecology, health, religion, and money. He also writes, publishes, orates, teaches, and preaches.

Pat Phelan

Twitter: - @YetAnotherSQL

LinkedIn: Pat Phelan

Pat Phelan first joined a computer user group (DECUS) in High School, and has joined many more since then. Pat worked many jobs in high school and college, and over twenty years for a major accounting firm. Pat started working for Involta in 2007 and is now the database mentor and a member of the Engineering team. Involta builds, owns and operates world class colocation datacenters and also provides managed services and support staff to clients.

SQLSaturday #629 - Indianapolis 2017

Sessions

Title: Find out why SQL Server 2016 Service Pack 1 is an Industry Game changer

Title: Increase Your Coding Speed in SQL Server Management Studio

Title: SELECT Provider FROM Cloud

Title: Data Visualization: How to truly tell a great story!

Title: Query Store Primer

Title: Using SQL as the Key to Robust Automation

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

Title: Stop Ignoring the SQL Server Resource Governor

Title: Managing Availability Groups with PowerShell

Title: Handling Temporal Data in SQL Server 2016

Title: Tame Your Unruly Data With Constraints

Title: Securing SQL Server

Title: SQL Server Encryption

Title: Introduction to SQL Server Integration Services

Title: Read Dirty to Me - Isolation Levels/User Impact

Title: SQL Server and PowerShell: Let’s Get Serious

Title: From SQL to DAX – another way of extract data

Title: MS SSAS Business Value: Should I choose Tabular or Multidimensional?

Title: Installing SQL Server on Linux in AWS

Title: Reduce your DBA ( DEV) task list by using Microsoft BI tools

Title: Introduction to Relational Database Design Patterns

Title: SQL into R: an Absolute Beginners’ Guide to R for the SQL User

Title: SQL Server ColumnStore Indexes

Title: SSMS Tips and Tricks

Title: How to Keep Your Databases Secure in Just Minutes a Day

Title: 45 Minutes to Your First SSAS Tabular Model

Title: Anatomy of a Transaction

Title: The Data-Professional’s Junk Drawer

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

Title: SQL Election: Which Tech is Faster?

Title: SQL Server 2017 (Linux and Beyond)

Title: Introduction to Data Science

Title: Ethics, Morals, and Laws for the DBA 101

Title: Working with JSON in SQL Server 2016

Title: Leveraging SQL Server R Services to Perform Advanced Analytics

Title: Architecting for Performance

Title: Introduction to Business Intelligence

Title: SQL Server Tricks for Storage and I/O Performance in the cloud

Title: Getting Started with R and R Services

Title: Introduction to Database Administration

Title: MPP – Master Parallel Productivity in Azure SQL DW

Title: Introduction to Database Development

Title: An Adventure Works IoT Demo: moving beyond sales data

Title: Partitioned Tables and Query Performance

Title: Never Lose Data! Digging Out From Corruption

Title: Advanced Biml Concepts

Title: Right-Size Your Data Files

Title: Unleashing Stretched Databases

Title: Availablity Groups in SQL 2016 and beyond: Faster, Higher, Stronger

Title: Alexa, Talk to Me

Title: Introduction to Big Data

Title: SQL Server 2016: Data Masking and Encryption

Title: Getting Your Story Straight with Data Visualizations

Title: It’s a Machine World - Predictive Analytics with Azure Machine Learning

Title: Introduction to Azure Streaming Analytics

Title: SQL Server 2017 New BI Features

Title: Crash Course on Better SQL Development

Title: Introduction to Data Science

Title: Game of Thrones Discussion

Title: SSAS 2016 Tabular - Diving into the new features

Title: How to get Microsoft Certified

Speakers

Sponsors