SQLSaturday #576 - Salt Lake City 2016

Event Date: 11/19/2016 00:00:00

Event Location:

Spencer Fox Eccles Business Building
1655 Campus Center Dr
Salt Lake City, Utah

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: Creating an Always On Distributed Availability Group

Abstract: Always On has developed and matured into an effective HA/DR solution with SQL 2016. Most enterprise DBAs have built a cluster and installed Always On Availability Groups (AOAG), this session will take the Always On technology one step further and discuss the new features in SQL 2016 that will allow a DBA to have live, read only database replicas in a geographically diverse location, in a completely different domain cluster and as a member of a completely separate Availability Group (AG). This session will go through the steps of identifying the pre-requisites, limitations and installation steps to setup a Distributed Availability Group from start to finish! Come and watch how to do it!

Speaker(s):

Dale Cunningham

Track and Room: Enterprise Database Administration Deployment - Main Floor 1180

Title: Inside the SQLPS 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 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.

Speaker(s):

Ben Miller

Track and Room: Enterprise Database Administration Deployment - Third Floor 3180

Title: Advanced SSIS Techniques

Abstract: As an ETL developer using SQL Server Integration Services have you ever wondered how to:

Import all .csv files from a folder
Replace dynamic SQL using variables in SSIS
How to configure the data flow buffer
Create custom logging solutions
Use a script component as a data flow transformation This session focuses on advanced techniques that are used in SSIS and is meant for the experienced SSIS developer. We will focus on tasks and techniques that are native to SSIS 2005-2014 as well as some of the more advanced and vague properties.
Attendees must have a good working knowledge of SSIS as well as familiarity with VB.NET or C# as some time will be taken looking at extending SSIS with script tasks and components. Upon completion of this workshop attendees will be able to:
Import/export multiple sources/destinations
Use an execute SQL task with variables to replace dynamic SQL within a package
Dynamically handle errors within any part of a package

Speaker(s):

David Dye

Track and Room: BI Platform Architecture, Development Administration - Third Floor 3106

Title: Dealing With Errors in SSIS

Abstract: Errors can occur anywhere within an SSIS package and the cause and error message can be somewhat cryptic. This session focuses on identifying error causes and handling them dynamically and proactively. The means of dealing with errors is defined by where the error occurs and we will cover error handling in control flow, data flow, and script tasks in great detail.

You will learn: •To identify the different error handling methods in control flow, data flow, and script tasks •Be able to utilize event handlers to proactively handle errors •Be able to redirect data error and proactively handle data flow errors •Be able to identify error descriptions and log error details

Speaker(s):

David Dye

Track and Room: BI Platform Architecture, Development Administration - Third Floor 3106

Title: SQL Server R Services in SQL 2016

Abstract: One of the most exciting new features of SQL Server 2016 is the integration of the R statistical programming language into the platform with the brand-new SQL Server R Services. In this introductory session we’ll briefly introduce the R language and then look at how to install and administer SQL Server R Services. We’ll start to demonstrate the power of R by showing you how to create and run simple R 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 R to integrate data analytical methods in real-world situations, and wow your customers with the power of statistics!

Speaker(s):

Chris Hyde

Track and Room: Analytics and Visualization - Lower Level 160

Title: MMM: Making the Most of the M Language - Real World Power Query for Excel and Power BI

Abstract: Learn how to leverage the diverse abilities of Power Query to acquire and transform data in this example driven session. Our journey will begin with CSV and we will work our way through HTML tables, JSON data, stop to examine REST and OData endpoints, and end with the spectacular view of connecting to SQL Server 2016. Each of these data types can present a unique opportunity to combine elements of the M language in Power Query to transform and massage the data before finally presenting to the visualization engine for display. Come learn to use the tricks of expanding records and nested tables to flatten out your data model and be better prepared to tackle any size or shape of data that comes your way.

Speaker(s):

Greg McMurray

Track and Room: Advanced Analysis Techniques - Third Floor 3170

Title: Bare Naked Skinny on SQL Server

Abstract: Ever feel like there are just too many layers with SQL Server? You peel off a layer and behold there is yet another layer. SQL Server is rather complex. The complexities can be rather frustrating from time to time.

Join this NSFW (not safe for whining) session as we strip SQL down to the bare bones. I will help you undress the complexities of a few of the basic SQL Server concepts. These concepts will include locks, principals, query directives and deadlocks.

In this session I will disrobe misunderstandings related to the aforementioned topics. I will show the different types of principals in SQL Server. I will also show various scenarios involving locks and deadlocks along with some of their effects with and without query directives. The goal is to better understand these topics and to hopefully stop using and perpetuating common mis-uses of terminology and common misconceptions about the technology.

Speaker(s):

Jason Brimhall

Track and Room: Enterprise Database Administration Deployment - Third Floor 3180

Title: SQL Server 2016 Always On Availability Groups Perf Internals

Abstract: Always On Availability Groups (AGs) were introduced in SQL Server 2012. AGs significantly expanded our HA/DR options. However, in both SQL 2012 and SQL 2014 two limitations were extant in the code—both Network Transport and Log Redo significantly compromised performance. In SQL Server 2016, these limitations have been significantly improved.

Our work shows enhancements of 7x – 10x, allowing over 1/2GB/s (4Gb/s) across the wire. These improvements expand solutions options for Tier 1 OLTP and Data Warehouse workloads, Tier 1 and Tier 2 consolidation, and more. This presentation explains the improvements, characterizes the new solutions, and shows commodity servers and modern non-shared in-server flash storage showing the profound contrast between SQL Server 2014 vs. 2016. Doing so moves the performance bottleneck from the SQL Server codebase to the CPU where it belongs.

Speaker(s):

J May

Track and Room: Strategy and Architecture - Third Floor 3170

Title: PowerBI, from a DBA

Abstract: Microsoft’s PowerBI is the new hotness. In this session, you will get your hands dirty and dive into PowerBI and create an actual report, with actual data. You will get to learn from examples from what a DBA has done to implement PowerBI in his shop and make his data accessible.

As a DBA, we often need to collect and display data in a friendly and interactive fashion. We will play with some PowerShell to collect data from several systems, store this data in an Azure DB in the Cloud, then point PowerBI at this data to display and interact with said data. You will learn a little about PowerShell, Azure SQL DB, PowerBI, and how to make these work for you.

You will be given permissions to an Azure DB, and get connected to this source. You will also need to have PowerBI desktop downloaded and installed. We will be using this to create the report during the session. So please come prepared to interact with the internet, with a cloud-based database you will be provided, and PowerBI Desk

Speaker(s):

TJay Belt

Track and Room: Enterprise Database Administration Deployment - Main Floor 1180

Title: Introduction to the SQL Server Query Store

Abstract: Don’t you wish there was a recording of everything running on your SQL Server instance tracking performance data? Well in SQL Server 2016, Microsoft has introduced a new feature called the Query Store. This session will go over how the query store works, how you configure it for your workloads and how to use the information to track performance data. When you leave this session, you will know how to get started using the Query Store.

Speaker(s):

Brandon Preece

Track and Room: Enterprise Database Administration Deployment - Third Floor 3106

Title: Database Restore Testing…Automated

Abstract: How do we know the backup files of our databases are free from corruption? Why would we care? The hardware storing the backup files is reliable…right? What could possible go wrong? Right? The only way to know our database backup files are in good order is to validate them. How do we do that? One way is to restore the databases from those backup files and check the integrity of the restored databases. This session will show some benefits of database restore testing and walk through the code of a SQL Agent job that automates it.

Speaker(s):

Robert Every

Track and Room: Enterprise Database Administration Deployment - Main Floor 1180

Title: Extended Events - Better than Profiler

Abstract: Extended Events were introduced in SQL Server 2008. With SQL 2014, we have seen a significant upgrade to this feature. Join me for a little adventure into the realm of extended events. We will discuss how to use extended events to aid in performance tuning and in day to day administration. We will also explore some background and the architecture of extended events. This is a fast paced session and will be a lot of fun. Attendees will be able to take back several sample XE sessions to help troubleshoot different issues and get to more intimately know their data/environment.

Speaker(s):

Jason Brimhall

Track and Room: Enterprise Database Administration Deployment - Lower Level 160

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 - Main Floor 1170

Title: Using Powershell to Document SQL Server

Abstract: Most DBAs use multiple native and third party tools to fully document SQL Server instances yet still dont get all the objects. Even using Visual Studio and Database Projects, not all objects are exported because they live at the server level, above the database. Using Powershell, we will script out an organized set of files that can be checked into any Source Control system and or used for Disaster Recovery purposes. Objects exported include: SQL Agent Jobs/Alerts/Schedules, NT Service Credentials, SSIS-MSDB, SSIS-Catalog, SSAS Cubes, SSRS Reports, Logins, Server Configs, Linked Servers, DB Mail Operators/Accounts, Server Triggers and much more

Speaker(s):

George Walkey

Track and Room: Enterprise Database Administration Deployment - LowerLevel 130

Title: But it worked great in Dev! Perfomance for Devs

Abstract: If you’ve ever found yourself stating the above, this session is for you. For many developers, writing T-SQL that works is not the challenge. But too often, functional T-SQL is not the same as good T-SQL. In this session, we will examine why “SQL that works” is not good enough. Understanding indexes, exectuion plans, sargability, and more are all critical to writing good T-SQL. We will also examine several real-world examples of T-SQL that “worked great in dev” but caused major issues when it hit production.

Speaker(s):

Randy Knight

Track and Room: Application Database Development - Third Floor 3170

Title: Locks, Blocks, and Deadlocks, Oh My!

Abstract: “I’ve got a locking problem”, “I need to get rid of blocking,” and “deadlocks are normal behavior” are all things heard way too many times.

In this session targeted at the accidental or new DBA, we will walk through each of these items, what they are, what their causes are, which of them are normal behavior and which are not, and some common causes of deadlocks and excessive blocking.

Speaker(s):

Randy Knight

Track and Room: Application Database Development - Third Floor 3170

Title: Disaster Recovery Where to Begin

Abstract: So you have a good backup strategy in place, but now you have to think about a disaster recovery. Where do you start and what are your options? SQL Server offers several options, but then how do you choose the right one to meet your business requirements? In this session, we will go over some of the common DR options including log shipping, replication, mirroring, clustering, and AlwaysOn. Then we will talk about how to choose the best one to meet your business needs.

Speaker(s):

Tracy Boggiano

Track and Room: Strategy and Architecture - Main Floor 1170

Title: Power to the people

Abstract: Over the years Microsoft has released many power products. We are all familiar with PowerPoint and PowerShell but how familiar are you with PowerQuery, Power QA, PowerView and Power BI? In this session we will take a closer look at the new tools Microsoft has released to enable true self service BI

Speaker(s):

Steve Seeley

Track and Room: BI Information Delivery - Third Floor 3180

Title: Alerts: Knowing Is Half the Battle!

Abstract: Learn how to quickly configure alerts for several instances using tools that ship with SQL Server. Increasing visibility of the errors occurring in your servers can expose the cobras that have been hiding there all along. Scripts will be made available to attendees.

Speaker(s):

Lars Rasmussen

Track and Room: Enterprise Database Administration Deployment - LowerLevel 130

Title: Introduction to Azure SQL Data Warehouse

Abstract: This session will introduce you to Microsoft Azure SQL Data Warehouse and show you how it compares to other technology options. You will learn about the benefits and idiosyncracies of working with SQL DW’s massively parallel processing architecture. Then you will get to see a demo of provisioning, loading, and querying SQL DW.

Speaker(s):

Scott Cameron

Track and Room: BI Platform Architecture, Development Administration - Third Floor 3106

Speakers

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

Brandon Preece

Twitter: - @sqlboarder

LinkedIn: Brandon Preece

Contact: http://brandon.preece.xyz/

Brandon Preece started from the early days of SQL Server. His first migration was from SQL Server 6.5 to SQL Server 7.0. Since that day, he has loved being a Database Administrator working with every major version since then. He now manages the best SQL Server Team you will ever find (maybe he is a little biased). He love teaching technology and helping others find the best way to use this incredible tool that we all love called SQL Server.

I work with SQL Server during the day and have been for many years. I enjoy teaching and making a difference.

In my free time, I like action sports. I enjoy snowboarding and Mountain Biking. I started doing triathlons in 2015 and am liking the challenge.

I am also a huge fan of the University of

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.

TJay Belt

Twitter: - @tjaybelt

LinkedIn: TJay Belt

Contact: http://tjaybelt.blogspot.com

TJay Belt is an outdoorsman at heart who enjoys riding dirtbikes, waterskiing, boating, playing racquetball and spending time with his family. When he can’t be out playing, TJay loves to tinker with databases. TJay has been an IT professional for over a decade and a half. Currently serving as a Senior Database Administrator with Imagine Learning. TJay has progressed through several roles in his database career including developer, data guy, database developer, database analyst and DBA.

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.

Robert Every

LinkedIn: Robert Every

Robert graduated from BYU in April, 1983 with BS degree in Design Graphics Technology. His first job after graduation was as a CAD applications developer for General Electric in Pittsfield, MA, and then in Fort Wayne, IN. In Fort Wayne he also managed an electronic document management system (EDMS) for nine years. For five years he developed Visual Basic applications. In 2005 he transferred to Genworth Financial, a division of GE located in Lynchburg, VA. A week later Genworth was spun off and became its own company. At Genworth he was a systems analyst, data analyst, and an IT project manager. In 2012 he moved to northern Utah and became a SQL Database Administrator, working for a government contracting company at Hill Air Force Base.

Tracy Boggiano

Twitter: - TracyBoggiano

LinkedIn: Tracy Boggiano

Contact: http://databasesuperhero.com

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

Steve Seeley

My database experience began almost 25 years ago while working in a small accounting department. I started working with MSSQL 6.0 and have used every version since. I am a former Microsoft Certified Trainer and am now leading a slower life as a programmer specializing in data warehouse design, ETL and BI development.

Jason Brimhall

Twitter: - sqlrnnr

LinkedIn: Jason Brimhall

Contact: http://jasonbrimhall.info

Jason Brimhall has more than 20 years of experience and has worked with SQL Server 6.5 through SQL Server 2019. He has experience in performance tuning, high transaction environments, and large environments. He is currently a consultant specializing in performance tuning, server analysis, and problem resolution. Jason is a Microsoft Certified Master (MCM) and a Data Platform MVP.

Chris Hyde

Twitter: - ChrisHyde325

LinkedIn: Chris Hyde

Chris Hyde is a Microsoft Data Platform MVP and Microsoft Certified Trainer based in Albuquerque, New Mexico. He works as an independent SQL Server BI and DBA consultant, and is the leader of the Albuquerque PASS local user group. He is also part of the Friends of Redgate program and was a member of the Idera ACE class of 2018. He loves loud music and cricket, but usually not at the same time.

George Walkey

Twitter: - sqlbytehd

Contact: http://insyncva.com

SQL Server DBA, Developer, IT Manager, Business Owner from the Richmond, VA USA Area Interested in pushing the limits of both hardware software and my own brain

Jason Brimhall

Twitter: - sqlrnnr

LinkedIn: Jason Brimhall

Contact: http://jasonbrimhall.info

Brandon Preece

Twitter: - @sqlboarder

LinkedIn: Brandon Preece

Contact: http://brandon.preece.xyz/

I work with SQL Server during the day and have been for many years. I enjoy teaching and making a difference.

In my free time, I like action sports. I enjoy snowboarding and Mountain Biking. I started doing triathlons in 2015 and am liking the challenge.

I am also a huge fan of the University of

Tracy Boggiano

Twitter: - TracyBoggiano

LinkedIn: Tracy Boggiano

Contact: http://databasesuperhero.com

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

David Dye

David is a Sergeant with the Cape Coral Police Department and currently works as a database administrator and developer in the Administrative Services Division. He began his career with the police department in 1990 in the patrol division and worked various assignments until being promoted to Sergeant in 1998. Based on his education and experience David was assigned to his current position in 2002 and is responsible for database administration, software integration, and development for public sa

Randy Knight

Twitter: - randy_knight

LinkedIn: Randy Knight

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

Randy Knight is a data professional who has worked with Microsoft technology for over 25 years, focusing on SQL Server since 1997. He has worked in a variety of settings, including 6 years as a database architect for match.com. In 2010, he founded SQL Server Solutions Group LLC, a boutique SQL Server consultancy. A Microsoft Certified Master (MCM) in SQL Server, he speaks often at events all over the country including the PASS Summit, SQLIntersections, and numerous SQLSaturday and User Groups.

Greg McMurray

Twitter: - @goyuix

LinkedIn: Greg McMurray

Greg McMurray has been working in technology for almost 20 years and living it much longer. He started coding at about age 8 on an Apple II with a friend when they decided the Lemonade Stand game just wasn’t awesome enough. Greg is currently a senior level software developer for the non-profit Western Electricity Coordinating Council and has operated his own successful consulting firm since 1998. Greg has extensive experience developing with many of the products in the Microsoft stack. You can find Greg online at @goyuix or linkedin.com/in/goyuix.

Scott Cameron

Scott Cameron is an experienced senior business intelligence architect who has worked with organizations to design, develop, and implement high quality data warehouse and business intelligence solutions. He has helped multiple companies with their initial SQL Server BI implementations. Mr. Cameron has taught classes in the United States and Europe, presented at the SQL PASS Community Summit, Microsoft Business Intelligence Conference, Microsoft World-Wide Partner Conference, and the SAP SAPPHIRE NOW conference. He was a contributing author of Microsoft SQL Server 2005 Analysis Services Step by Step, co-authored Microsoft SQL Server 2005 Integration Services Step by Step, and authored Microsoft SQL Server 2008 Analysis Services Step by Step.

David Dye

Randy Knight

Twitter: - randy_knight

LinkedIn: Randy Knight

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

Lars Rasmussen

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

LinkedIn: Lars Rasmussen

Contact: http://larsrasmussen.blogspot.com/

Lars Rasmussen was born in Illinois, a few miles from St Louis(Go Cards!), and makes his home in Lehi, Utah. Playing board games is one his favorite pastimes. Lars’ wife and four children help him smile and laugh. He considers SQL Server, PowerShell, and CMD.EXE some of his dearest frenemies. Lars enjoys the company of SQL Server professionals and sysadmins - he used to be one of the latter, and currently works as a database administrator for MaritzCX.

Dale Cunningham

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

LinkedIn: Dale Cunningham

Contact: http://www.dalecunningham.com

Dale Cunningham is a Sr. Database Administrator and has worked for enterprises both large and small. Performance tuning, Clustering, High Availability and Disaster Recovery are his preferred fields of focus in the MS SQL arena. In his spare time, Dale enjoys flying as a private pilot and playing racquetball. As a father of 5 children and grandfather to 4, family is an important part of his life. Dale enjoys visiting foreign countries and exploring the world. He has recently been married to a wonderful woman from Ukraine and they enjoy traveling the world together. Dale desires to build a home that is energy self-sufficient by using solar, wind and hydro electric power. He enjoys Call of Duty on XBox under the handle XO UEG Barricuda.

J May

Twitter: - @aspiringgeek

LinkedIn: J May

Contact: http://blogs.msdn.com/jimmymay

Jimmy May is a Microsoft Certified Master (MCM). He’s formerly a Principal Architect at Microsoft as well as Senior Program Manager for the SQL Server Customer Advisory Team (SQL CAT) where he managed the Customer Lab which hosts the biggest, fastest, most interesting SQL Server apps from all over the world. More recently he was a SQL Server Technologist for what was Fusion-io’s Data Propulsion Lab (DPL). He is a founder of the IndyPASS IWUG user groups.

SQLSaturday #576 - Salt Lake City 2016

Sessions

Title: Creating an Always On Distributed Availability Group

Title: Inside the SQLPS PowerShell Module

Title: Advanced SSIS Techniques

Title: Dealing With Errors in SSIS

Title: SQL Server R Services in SQL 2016

Title: MMM: Making the Most of the M Language - Real World Power Query for Excel and Power BI

Title: Bare Naked Skinny on SQL Server

Title: SQL Server 2016 Always On Availability Groups Perf Internals

Title: PowerBI, from a DBA

Title: Introduction to the SQL Server Query Store

Title: Database Restore Testing…Automated

Title: Extended Events - Better than Profiler

Title: Query Store Primer

Title: Using Powershell to Document SQL Server

Title: But it worked great in Dev! Perfomance for Devs

Title: Locks, Blocks, and Deadlocks, Oh My!

Title: Disaster Recovery Where to Begin

Title: Power to the people

Title: Alerts: Knowing Is Half the Battle!

Title: Introduction to Azure SQL Data Warehouse

Speakers

Sponsors