SQLSaturday #887 - Salt Lake City 2019
Event Date: 08/03/2019 00:00:00
Event Location:
- Karen G Miller Conference Center
- 9750 S 300 W Sandy, UT
- Salt Lake City, Utah
This event has completed. All data shown below is from the historical XML public data available.
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: SQL DevOps Simplified with Production Databases
Abstract: DevOps is based on building an application binary (immutable artifact) that supports a highly reliable, repeatable engineering process. In the case of SQL Server, however, a database is already in production, and isn’t simply replaced (as an app binary), but is upgraded. Current SQL Server DevOps methods use source control to build a “development” database, with schema and objects and static data needed for functional testing. “Near production data” is used in Staging, and finally production is upgraded. This approach involves complexity, and breaks the principle of working with immutable artifacts throughout the process. Our session introduces a new approach to SQL Server DevOps, with production databases used in all stages. Production database clones are delivered more quickly than “built” databases, are more easily integrated with source control, and produces higher fidelity outcomes. Learn how leading enterprises are simplifying SQL DevOps.
Speaker(s):
- Paul Stanton
Track and Room: Application Database Development - 150EF
Title: What’s New in SQL Server 2019: 100% Demos
Abstract: You haven’t installed SQL Server 2019 yet, and you don’t want to sit through a bunch of slides. You want to see a series of real-world demos focusing on the features of SQL Server 2019 that will make your users happier with as little work as possible on your part. You don’t have time to rewrite all your queries or learn new languages - you just want the database to go faster.
I’m Brent Ozar, and I’ll give you the whirlwind tour. I’ll focus on just the features that make the biggest bang for the buck, things you can implement right away and see a noticeable difference. I’ll show you what kinds of code will benefit the most so you can go back to the office and have an honest discussion with management about what to expect.
No slides here - not even an about-me slide. Let’s dive into some queries!
Speaker(s):
- Brent Ozar
Track and Room: Application Database Development - 150AB
Title: Beginning Admin: The Care and Feeding of SQL Server
Abstract: Design and development may be exciting, but database administration is absolutely critical (and, reasonably well-paying!) The care and feeding of a server tends to get short-changed or neglected. In this class, we’ll cover the basics of the big five administrator tasks:
- Backups – You must set up regular backups, to keep copies of your databases…just in case something breaks, or someone makes a bad, bad mistake.
- Integrity checks – Regularly and automatically check databases for corruption, which is when bits get scrambled, lost, and ruined.
- Index maintenance – Databases need regular upkeep so they’ll continue to run well.
- Disk management – It’s actually your job to find out about full disks before they happen. After all, databases grow!
- Alerting – Alerts tell you what’s wrong, so you don’t have to go looking for problems.
Being a database administrator is a big job, but we can cover the basics in one session!
Speaker(s):
- Jennifer McCown
Track and Room: Enterprise Database Administration Deployment - 150AB
Title: Azure Machine Learning 101
Abstract: There are several ways to create a machine learning model. You can use R or Python or even other languages such as C#. Advanced coding skills are required no matter which language you choose. Once the solution is created, it’s often difficult to deploy.
Microsoft addresses those problems with Azure Machine Learning, or Azure ML. Azure ML has built-in transforms for cleansing and munging data. It also contains a variety of configurable machine learning models that can be used without coding. Deploying the model is easy, and users can link to it directly with Excel or a custom application can be written.
If you are experienced in machine learning but haven’t seen Azure ML or if you are curious about machine learning and data science, this session is for you.
Speaker(s):
- Kathi Kellenberger
Track and Room: BI Platform Architecture, Development Administration - 150EF
Title: Reducing The Surface Area Of Risk in Data Security
Abstract: Data masking is likely to become a new legal requirement. Don’t let this catch your organization unaware and flat-footed!
For decades, IT has been negligent, using production data during software development and testing, exposing sensitive data to those not authorized to access it. That decades-old practice must end.
Data masking is the solution for providing non-production environments (i.e. DEV, TEST, etc) with realistic but artificial data for development and testing, while reducing the surface area of risk for breaching data.
The alternative, generating test data, incurs classic problems of engineering bias as well as blindness to true-to-life data scenarios which arise in the “wild”.
Masking real production data retains realistic data conditions and distributions while merely obfuscating real data.
Masking is important, and sophisticated software packages are available today, but the field is new enough that there is lots of room for improvement in all of them.
Speaker(s):
- Tim Gorman
Track and Room: Enterprise Database Administration Deployment - 150AB
Title: Inside the DBAtools PowerShell Module
Abstract: There has been a movement towards PowerShell in the SQL Server Community lately. With so much out there, how do you get ahead. I will take you through this massive module that has grown very quickly to over 300 functions for use in your daily DBA job. This module can single handedly migrate an entire server with one command, or you can choose the parts you want to do and just do those. Join me to find out how you can quickly leverage the power of this module. This is one tool you want in your PowerShell toolbox.
Speaker(s):
- Ben Miller
Track and Room: Enterprise Database Administration Deployment - 150AB
Title: Azure AD authentication methods for SQL Azure
Abstract: Deploying to SQL Azure? What are the best ways to login/authenticate to SQL Azure? Learn about Azure AD Authentication methods: Integrated Windows authentication, Azure AD principal name and a password, Application token authentication, and additional Azure Active Directory methods Integrated, Universal with MFA, and Interactive
Speaker(s):
- David Lundell
Track and Room: Cloud Application Development Deployment - 150CD
Title: Are all RDBMS systems created equally?
Abstract: We all love SQL Server but is it really so much different than Postgres, Oracle or Mysql? I’ve spent a lot of years in many of these technologies and I want people to understand the good and the bad about the different technologies out there. My goal with this session is to entertain and to hopefully open your eyes to the reality that if you have skills and knowledge of RDBMS you shouldn’t be afraid of ever finding a job in any of these technologies.
Speaker(s):
- Pat Wright
Track and Room: Strategy and Architecture - 150CD
Title: Women In Tech Panel
Abstract: The greatest supporter of women are other women! Women are 18% of the professional field in data analytics. This is even less than the IT field as a whole. For those that identify as women, feel motivated seeing other women in this space share their journeys. For allies, take an opportunity to see and hear from women and other allies on how to support them.
Speaker(s):
- Liz Amador
Track and Room: Professional Development - 150AB
Title: SSAS 101
Abstract: Basic walk-through of creating a tabluar cube, deploying the cube and querying the data using Power BI.
Speaker(s):
- Matt Horton
Track and Room: BI Platform Architecture, Development Administration - 150GH
Title: Improving concurrency with Read Committed Snapshot Isolation
Abstract: At some point or another, every DBA has to deal with concurrency issues. Read Committed Snapshot Isolation (RCSI) is one of the many appealing options you have in your quiver as a DBA to resolve concurrency problems. This session will focus on how RCSI works, and when it may be useful for you as a DBA or developer.
Speaker(s):
- Jacob Case
Track and Room: Application Database Development - 150GH
Title: Real-World Data Movement and Orchestration Patterns using Azure Data Factory V2
Abstract: In this session, we will start with an overview of Azure Data Factory V2 concepts, then show you how you can use metadata to quickly build scalable serverless pipelines to move data from disparate data sources including On-Premises and Platform As A Service. Next, we will look at how to integrate the solution using continuous integration and deployment techniques. Finally, we will look at how to schedule, monitor and log our solution. Whether you are just getting started with Azure Data Factory or looking to make your current data factory robust and enterprise-ready this session will take you to the next level.
Speaker(s):
- Jason Horner
Track and Room: BI Platform Architecture, Development Administration - ROOM3
Title: Advanced Power BI Modeling Techniques
Abstract: Creating a Power BI data model is pretty easy, but sometimes we have to deal with more complex scenarios the require us to dig a little deeper.
In this session we’ll take your modeling skills to the next level as we explore a few advanced techniques that deal with displaying measures in the rows of a table (as opposed to the columns), dynamic currency conversions and an alternate approach to role-playing dimensions.
Speaker(s):
- Martin Schoombee
Track and Room: BI Information Delivery - 150GH
Title: Availability Groups: What They’re Not Telling You
Abstract: SQL Server 2012 brought to life a new form of high availability and disaster recovery in the form of Availability Groups (AGs). This all sounds fantastic, but in reality there are issues and problems that are generally not discussed, or well known, that can impact your HA/DR story and cause major performance issues. In this session, I’ll give a brief overview on AGs in SQL Server 2012 and the enhancements that come in 2014 and 2016. Then we’ll get into some of the problems that exist, that I’ve seen in the real world of using AGs, and that you should be aware of before implementing it in your environment.
Speaker(s):
- Nicholas Cain
Track and Room: Enterprise Database Administration Deployment - 150CD
Title: Dynamic SQL: When, Why, and How to Use It
Abstract: You’re comfortable writing T-SQL, and you’ve built a lot of stored procedures that have a bunch of parameters. For example, you have that “product search” stored proc with parameters for product category, name, price range, sort order, etc, and you have to accept any of ‘em.
So how do we make those go fast? And how can we get ‘em to use indexes?
In one all-demo hour, performance tuner Brent Ozar will show you several ways that fail in comically bad ways. You’ll learn how to write dynamic SQL that’s easy to tune, manage, and troubleshoot.
Speaker(s):
- Brent Ozar
Track and Room: Application Database Development - 150AB
Title: Use Visual Studio Code to get started with PowerShell
Abstract: You’ve heard you should be using PowerShell but how do you get started… Come find out. Using Visual Studio Code with some extensions and open source PowerShell modules we’ll get you up and running in a few mins. Then we’ll talk about ways you can use PowerShell to make your life a little easier.
Speaker(s):
- Steve Peterson
Track and Room: Enterprise Database Administration Deployment - 150CD
Title: Clustered, Non-Clustered and Covering Indexes Oh My!
Abstract: So you have a brand new table with lots of data and when you do a query it takes forever to return. So you add an index to improve performance and it still takes forever. Huh? Let’s talk about what an index really is, the different kinds of indexes, and we will finish with a scenario where even though you have the perfect index, it is still not used.
Speaker(s):
- Steve Seeley
Track and Room: Application Database Development - 150EF
Title: The Lost Science of Set Theory
Abstract: Many database developers today do not have a Computer Science degree and may also have begun their career developing software using procedural programming languages (Java, C#, etc.). As a result, they may not have the background needed to conceptualize solutions in terms of sets of data and therefore may not be able to develop efficient set-based queries. In this session, we will review the basics of set theory and how it applies to database development to enable you to turn cursors, loops, and other procedural programming practices into efficient set-based operations that make the most use of a relational database engine.
Speaker(s):
- Aaron Cutshall
Track and Room: Application Database Development - 150GH
Title: Possiblities and Limitations of System-Versioned Temporal Tables beyond the Basics
Abstract: This technical presentation shows how to manipulate data with versioning switched off, what to consider when building queries referencing multiple temporal tables and building views.
Speaker(s):
- Reinhard Flügel
Track and Room: Application Database Development - 150GH
Title: Faster Transactions: Query Tuning for Data Manipulation
Abstract: Your server has dozens of CPUs, terabytes of RAM, and solid-state drives, and yet your UPDATE query still takes hours. Why? In this demo-filled session we will discuss common pitfalls for any SQL professional who is manipulating large sets of data with INSERT, UPDATE, and DELETE statements. Not only will you learn about potential issues involving data pages, locks, and the transaction log, but also what techniques you can use to improve performance.
Speaker(s):
- Jeff Iannucci
Track and Room: Application Database Development - 150GH
Title: Short Circuit Bad User Queries
Abstract: How to prevent your users from writing bad queries. Tips for teaching the non-IT user how to query basic business data.
Speaker(s):
- Jenny Adams
Track and Room: Other - 150CD
Title: ROI with Power BI: Do more than Excel
Abstract: Nifty tips and tricks to start taking your business from Point A to Point B2B using Power BI. We will use real world use case examples of combining supplier, syndicated, or retail data in Power BI in a way that can help you move the needle.
We will cover:
• Sales Dax/M: Options for measures and columns • Real life examples of converting data to continual, common sense Business Intelligence • Actionable items: Dashboards, Alerts, and KPIs • Sharing: B2B permissions, New and Classic Workspaces
No matter what business you are in, we will cover the basics and benefits of advancing your company from emailing excel trackers to cloud collaboration.
Speaker(s):
- Erika Haase Nalley
Track and Room: BI Platform Architecture, Development Administration - 150EF
Title: SQL Server Management Studio Tips and Tricks
Abstract: Have you ever watched a Microsoft SQL Presentation and wondered how in the world they did that cool trick? What was that keyboard shortcut? Come find out Microsoft SQL tips and tricks that will help you be more productive in your day to day work and give you a few cool ideas to make other SQL people jealous. There will even be a few SQL Server Management Studio 18 tricks.
Speaker(s):
- Andrea Allred
Track and Room: Application Database Development - 150CD
Title: Keys to Successfully Governing Power BI for your Organization
Abstract: Discussion of the best practices and considerations for security, governance, and administration of Power BI. Not only of the available options, but tips and tricks for how to navigate those options and set yourself and your organization up for success down the road.
Speaker(s):
- Amie Mason
Track and Room: BI Platform Architecture, Development Administration - 150EF
Title: Introduction to SQL Server Graph DB
Abstract: Have you heard about all the hot new features in SQL Server 2017? One of the game-changing features is Graph DB. Come see what it is, how you can use it, and what scenarios it excels in - specifically where data has strongly defined relationships and is more interconnected.
Speaker(s):
- Greg McMurray
Track and Room: Application Database Development - 150EF
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Reinhard Flügel
Started as an application developer in the early 90’s using C++, Access and SQL-Server. Since around 2010 focusing on Database Development mainly SQL-Server. Holding several Microsoft certifications such as: MCSE Data Platform, Business Intelligence and Data Management and Analytics (Charter).
Brent Ozar
Twitter: - BrentO
LinkedIn: Brent Ozar
Contact: https://www.BrentOzar.com
Brent Ozar loves to make SQL Server faster. He created sp_Blitz and the SQL Server First Responder Kit. He shares what he’s learned at BrentOzar.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.
Nicholas Cain
Twitter: - @sirsql
LinkedIn: Nicholas Cain
Contact: http://sirsql.net
Nicholas Cain is a SQL Server MCM. His current job title is “Epic BDA” thanks to a boss with a sense of humor. He has over 15 years of SQL Server experience working in a variety of production environments, where he has supported databases ranging in size from a couple of MB up to multiple TB. He has implemented various high availability and disaster recovery techniques to ensure necessary access to data for his customers. Nicholas is always looking for ways to make the administration of SQL Server easier and more productive.
Tim Gorman
Twitter: - @TimGormanTech
LinkedIn: Tim Gorman
Contact: http://evdbt.com
Tim Gorman is a senior technical consultant for Delphix who securely enables masked data virtualization to increase the agility of IT development and testing while ending decades of security risk in SDLC.
Tim has co-authored six books on data warehousing and database administration, has performed technical review on eight more books, and has an author#39;s page on Amazon.com (http://www.amazon.com/Tim-Gorman/e/B00BKCTO5E).
Jeff Iannucci
Twitter: - DesertDBA
LinkedIn: Jeff Iannucci
Contact: https://desertdba.com/
Jeff Iannucci is a Senior Database Administrator for DriveTime in Tempe, AZ. He has over 20 years of SQL Server experience as both a DBA and Developer in diverse environments such as health care, finance, retail sales, and government. He writes about solving problems for database professionals on both twitter (@DesertDBA) and his blog (desertdba.com), and has been chosen as an IDERA ACE for 2020.
David Lundell
Twitter: - https://twitter.com/DavidLundell
LinkedIn: David Lundell
Contact: http://Blog.ilmbestpractices.com
Author of How to Be an MVP in Life, Author of FIM Best Practices Volume 1, Microsoft MVP, Speaker, Entrepreneur and Consultant. 20+ years in IT. MBA, BS Computer Engineering both at University of Arizona. Helped establish database care and feeding best practices among Microsoft Identity Management professionals. Created unique SSIS and SSAS based solutions to problems in the Identity Management area.
Martin Schoombee
Twitter: - sqlmartin
LinkedIn: Martin Schoombee
Contact: http://www.martinschoombee.com
Martin is an independent Business Intelligence Analytics consultant, helping customers make sense of their data for more than 15 years.
Liz Amador
Twitter: - @conmuchoamador
LinkedIn: Liz Amador
Contact: https://conmuchoamador.com
Liz is interested in using data for social good and making the tech space more welcoming for everyone. She blogs, teaches, and loves to read.
A Liz le interesa usar data por el bien de la sociedad, y hacer la comunidad de technologia mas abierto para todos. Ella escribe en su blog, ensena, y le encanta leer.
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.
Andrea Allred
Twitter: - @RoyalSQL
LinkedIn: Andrea Allred
Contact: http://www.RoyalSQL.com
Once upon a time in a kingdom not far away, Andrea was sick of answering phones and filing forms. Her kingdom was running low on gold and the wise wizard told her to find work that she loved and she would never truly work a day in her life. When she found the magical SQL Server, she knew it was the calling for her. She is passionate about SQL Server, “works” as a Database Administrator, loves her #SQLFamily and finds joy in helping others find their passion too. She is celebrating her 15th year with SQL Server this year.
Brent Ozar
Twitter: - BrentO
LinkedIn: Brent Ozar
Contact: https://www.BrentOzar.com
Brent Ozar loves to make SQL Server faster. He created sp_Blitz and the SQL Server First Responder Kit. He shares what he’s learned at BrentOzar.com.
Jason Horner
Twitter: - jasonhorner
LinkedIn: Jason Horner
Contact: http://blog.jasonhorner.com
Hi, my name is Jason I’m a practice lead at Redapt. I spend most of my day helping clients solve business problems mostly in the Data and Advanced Analytics spaces. Sometimes this involves various and sundry cloud technologies including Azure Data Factory, Azure SQL Data Warehouse, Azure Data Lake Store, Azure Databricks, HDInsight and Azure SQL Database. I’m fluent in several languages including: SQL, C#, Python, and PowerShell.
I’m a Microsoft Certified Master of SQL Server (MCM) and have been recognized for my technical excellence and evangelism efforts by Microsoft by being awarded the Most Valuable Professional (MVP) for the last 5+ years.
In my off hours I like to snowboard, karaoke, ride roller coasters, and play arcade games
Jacob Case
LinkedIn: Jacob Case
Jacob started working with data in February 2007. He has worked with Oracle, SQL Server, MySQL, MariaDB, Teradata and a little with PostgreSQL. He’s worked in Business Intelligence, Database Architecture, and traditional software development environments in the Direct Selling, Mortgage, Health Care, and Online Retail industries. Jacob is currently a Senior Database Administrator at Mountain America Credit Union.
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.
Kathi Kellenberger
Twitter: - auntkathi
LinkedIn: Kathi Kellenberger
Contact: http://auntkathisql.com
Kathi Kellenberger is the editor of Simple Talk at Redgate and a Data Platform MVP. She has worked with SQL Server for over 20 years and has authored, co-authored, or tech edited over a dozen technical books. Kathi is the co-leader of the PASS Women in Technology Virtual Group and a volunteer at LaunchCode. When Kathi isn’t working, she enjoys spending time with family and friends, cycling, singing, and climbing the stairs of tall buildings. Be sure to check out her courses on Pluralsight.
Paul Stanton
Twitter: - https://twitter.com/Paul_E_Stanton
LinkedIn: Paul Stanton
Contact: https://www.windocks.com/blog-2
Co-founder of Windocks, Paul is a former Microsoft engineer who is focused on delivering solutions for SQL Server development and test, including SQL Server containers and database cloning.
Jenny Adams
Twitter: - sqljennyadams
LinkedIn: Jenny Adams
I have been passionately advocating for awesome database architecture for 17 years. I love the ugly beauty of data and uncovering the story it has to tell.
Amie Mason
LinkedIn: Amie Mason
Consultant with a demonstrated history of working with clients across multiple verticals to leverage their data to improve reporting and decision making in their business. Able to quickly assess business requirements and skilled in report design and predictive analytics enabling a direct translation from those requirements to business impact. Broad background includes experience in the public sector, survey design, and grassroots campaign management.
Pat Wright
Twitter: - www.twitter.com/sqlasylum
LinkedIn: Pat Wright
Contact: http://www.sqlasylum.com
Pat Wright has been working in the DBA space for 10+ years. Focusing on Performance tuning and ETL/DW projects. He helped found the local SQL Users group(www.slcsql.com) and founded the Not For profit Organization Utah Geek Events(www.utahgeekevents.com) which was founded to help the local community put on events.
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.
Steve Peterson
Twitter: - @SQLFitness
I have worked in ASP.NET and C# for a number of years before turning to SQL Server and T-SQL where Steve has been a SQL Server DBA for over 12 years with a focus on up time and performance. MCP MCTS Steve also likes photography.
Erika Haase Nalley
Twitter: - ErikaHaase
Erika Nalley works with STX Business Solutions in Bentonville, Arkansas specializing in retail data solutions for adult beverage suppliers and distributors. As Microsoft Silver Partners in Data Analytics, STX uses all Microsoft Platform solutions. With certifications in Category Management and Wine Production, Power BI has been our preferred way to slice and visualize data for the last few years. It’s a rough life working with data, whiskey, and wine, but someone has to do it!
After work, Erika can usually be found hiking with her husband and three dogs or trying to keep up with friend and co-worker, Amber Muehlbach on a trail run (which usually doesn’t happen:).
Matt Horton
Twitter: - GoDataNinjaGo
MS SQL Professional with 15+ years of experience. I enjoy everything data! I also an adjunct professor for Weber State University. I have lived in Utah almost my whole life. I love spending time with my family traveling, playing video games or watching movies.
Jennifer McCown
Twitter: - http://www.Twitter.com/MidnightDBA
LinkedIn: Jennifer McCown
Contact: http://www.MidnightDBA.com/Jen
Jen McCown is CEO of MinionWare, LLC; a Microsoft Certified Master for SQL Server; and an independent consultant. She is Senior Editor at MidnightDBA.com, where she creates training videos, the DBAs at Midnight webshow, blogs, reviews, and podcasts. Jen is a member, volunteer, and speaker in PASS, and the PASS Women in Technology Virtual Group.
Sponsors
The following is a list of sponsors that helped fund the event: