SQLSaturday #870 - Memphis 2019
Event Date: 10/05/2019 00:00:00
Event Location:
- FedEx Institute of Technology
- 365 Innovation Drive
- Memphis, Tennessee
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: Intro to Graph Databases
Abstract: Recent years have seen an uptick in the adoption of alternative data storage methods. While the traditional RDBMS is still the de-facto Swiss Army knife for backing applications, technologies such as NoSQL and time series databases are increasingly used due to their performance and usability characteristics in certain use cases.
One of the latest entrants on the scene is the graph database. In this session we’ll discuss what they are and how they are used. The introduction of graph database support in MSSQL 2017 provides us with a convenient mechanism for presenting our existing data through a graph.
• What is a Graph Database? • Basic Graph Theory • Relational vs Graph data models • Graph Databases in MSSQL • Use cases
Speaker(s):
- Pete Brown
Track and Room: Application Database Development - 203
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 - 203
Title: Exploring the latest T-SQL enhancements
Abstract: With the most recent release of SQL Server 2017 and the upcoming release of SQL Server 2019, there are several enhancements that were introduced for the T-SQL language. This includes new string functions, bulk access options and approximate query processing among others that address several challenges that SQL developers have to confront.
In this demo heavy session, we will go over several of the new features, provide a demonstration of how you can use them, and share any considerations that you may need to consider before doing so. This session is intended for anyone interested in what’s new in the T-SQL language and will focus primarily just on enhancements to traditional T-SQL for the database engine.
Speaker(s):
- Dustin Dorsey
Track and Room: Application Database Development - 227
Title: Get Your Optimizer to Give up All Its Secrets
Abstract: You know that execution plans can provide you with vital information to tune a query, but just how does that plan get generated? In this session, we will examine details the query optimization process that are not very well known. We will discuss how SQL Server parses a T-SQL statement then and begins applying rules to make it more efficient. Did you know that SQL Server can be coaxed into outputting hidden structures such as parse trees and memos? We’ll do just that, and then take it a step further with a unique visualization tool that I have created. With a better understanding of how SQL Server optimizes T-SQL (and sometimes doesn’t do it as well as might be hoped), you can write more efficient SQL statements.
Speaker(s):
- Brian Hansen
Track and Room: Enterprise Database Administration Deployment - 226
Title: Get your Git on with Source Control
Abstract: Have you tried implementing source control? How has your continuous integration (CI) process gone?
This session is for developers, database administrators, database engineers, and data architects that want to automate their database deployments. Particularly for those individuals that have hit roadblocks along that way. We will discuss the differences between migration and stated-based deployment methods. We will also discuss options with branching and merging.
At the end of the session, attendees will know how to select the best deployment method for their environment. In addition, attendees will be familiar with branching and merging strategies that can be used as part of their continuous integration strategy.
Attendees should be familiar with general concepts about source control and be comfortable with Visual Studio or VS Code.
Speaker(s):
- Elizabeth Noble
Track and Room: Strategy and Architecture - 226
Title: Relational Design Critique
Abstract: The process of designing a relational database is not overly complex, and may be done by almost anyone on the development team. The process requires one to take the time to understand the requirements, when they exist, and apply a straightforward set of transforms to produce table structures that meets the needs. The tough part is that the process requires time and experience, neither of which anyone has enough of. In this session, to help the attendee differentiate right-enough designs from overly simple or overly complex designs, we will look at a variety of database snippets, each inspired from a real life design. We will discuss the pros and cons of the approach taken, and consider possible remediations to learn from a failure that was made by someone else.
Speaker(s):
- Louis Davidson
Track and Room: Application Database Development - 227
Title: That’s So Metadata: Discover Your Database From The Inside
Abstract: Have you ever needed to learn a new database design and don’t know where to begin? Or are trying to find out why a query doesn’t perform well? Or need to provide security information to auditors or your security team?
SQL Server has numerous metadata facilities available to help you with these tasks and more. Functions, dynamic management views, and system stored procedures can illuminate details from a single column up through an entire SQL Server instance. We will demonstrate metadata techniques to help you:
- Document your database schema objects such as procedures, functions, tables, columns and indexes
- Investigate performance and look for bottlenecks and tuning opportunities
- Discover metadata to administer your databases backups, index maintenance, and security
- Apply your own metadata using extended properties
We will also cover the official Microsoft documentation on these features and other resources on how to use them.
Speaker(s):
- Rob Volk
Track and Room: Application Database Development - 227
Title: The Community Speaks: WIT, LGBTQ, diversity and inclusion.
Abstract: Join us as we (yes, including attendees) discuss incidents and look for ways as victims, as by-standers and as event host to react. Let’s enable each other to do what is right, speak up and support one another. It’s time for the community to come together, make their voice be heard and share ways and tools to deal with these difficult situations. Although some stores are inspired in part by a true incident, they are fictional and do not depict any actual person or event.
Speaker(s):
- Tamera Clark
Track and Room: Professional Development - 227
Title: The Modern Power BI approach
Abstract: Power BI continues to become one of the best ways to report and analyze business data. With recent announcements in Power BI roadmap around Dataflows, Composite models, AI integration, Common Data Service and Power Suite integration there are many more ways to add value to your existing Power BI environment. Come learn about all the key new features in Power BI you should be using and what new features are coming down the roadmap so you can increase value and usage of Power BI across the organization.
Speaker(s):
- Dan Evans
Track and Room: BI Platform Architecture, Development Administration - 226
Title: Inside the Database Engine
Abstract: This session is for the absolute beginner to learn the basic components of the Database Engine (Relational Engine, Storage Engine, and SQLOS) and what is the purpose of each of these three components in the execution of a simple query. The relational engine to process a query, the storage engine to access data and the SQLOS to manage resource access. The session is led by an expert Microsoft Certified Trainer (MCT) and former Microsoft MVP who regularly teaches SQL Server certification courses.
Speaker(s):
- John Deardurff
Track and Room: Application Database Development - 225
Title: The Future of Database Development with Containers
Abstract: Containers are dramatically changing the way that application developers design and build their systems. Databases will need to be a part of this revolution as every application needs a data store. Come see a future vision of how full stack application development might look in the next few years.
Speaker(s):
- Steve Jones
Track and Room: Application Database Development - 203
Title: Become a T-SQL Pivoting Ninja in 59.5 Minutes Or Less
Abstract: Would you like to create Pivot Tables in SQL with ease?
Become a query writing ninja who uses the Pivot operator to move unique column values into multiple column names for better data insight. In this demo-heavy presentation, you will learn how to create pivot tables enhanced with multiple aggregate columns and column totals using Rollup and Cube operators, and the grouping function. Attendees will also learn to use the Unpivot Operator.
Come join me, and by the end of this session, you will have the knowledge to level up your pivoting skills to that of a ninja or maybe even *Chuck Norris. *Not Possible
Speaker(s):
- Peter Doyle
Track and Room: Analytics and Visualization - 226
Title: D.R.E.A.M. (Data Rules Everything Around Me) - Creating a data-driven business culture
Abstract: Deploying a new Big Data initiative is a daunting undertaking in it’s own right, which can lead many business leaders to forget a crucial piece of the puzzle - changing company culture. What good is new technology if it does not align with the way the organization actually makes decisions? This session dives into strategies to obtain stakeholder buy-in and get organization members not just tolerant of, but EXCITED about new technology initiatives.
Speaker(s):
- Lena Winfree
Track and Room: Strategy and Architecture - 225
Title: User Experience Brilliance in Power BI Dashboards
Abstract: User Experience (UX) and Design Thinking are common buzz words around the office. What do these words have to do with BI and Dashboards, anyway? Sure, Power BI itself is intuitive and user friendly, but are YOU building dashboards that give the best user experience? In this session we will explore in a hands-on exercise what UX and Design thinking is, how to apply the methodologies to our daily work and then how we could apply it to BI to make kick ass dashboards and reporting for our internal and external customers.
Speaker(s):
- Hilary Wilkie
Track and Room: Professional Development - 225
Title: Goin’ Fishin’ on the Azure Data Lake
Abstract: Get yer queries ready we’re goin’ fishin’ on the Azure Data Lake. Azure Data Lake is hyper-scale storage service that serves as the foundation for a Modern Data Warehouse. We’ll explore what makes this service unique, the pricing structure, and how to start storing data. Then we’ll open our tackle boxes to learn how to use tools such as HDInsight, Azure SQL DW, and Data Lake Analytics (U-SQL) to access data for processing, analytics, and machine learning.
Speaker(s):
- Spencer Swindell
Track and Room: BI Platform Architecture, Development Administration - 203
Title: Managing Your Schema with Database Projects in Visual Studio
Abstract: Integrating databases schema changes into a Software Development Lifecycle Management (SDLC) process can be a daunting and often tedious proposition. Adding the complexity of version control to the mix complicates this scenario. Fortunately, Database Projects in Visual Studio add a bit of an “easy” button to this process. In this session, you will learn about the features and capabilities of VS Database Projects and how to use them to improve the lifecycle of your database structures, even if your organization does no code management.
Speaker(s):
- Kerry Tyler
Track and Room: Application Database Development - 225
Title: Azure Data Factory V2
Abstract: Moving data around in On-Prem databases is easy.
Moving data around when involving Azure - may be not. Especially if you don’t have a VM or an On-Prem server to move things around on.
We’ll look at moving data around from On-Prem to Azure, moving files to Azure, and moving data between Azure databases.
Speaker(s):
- Kevin Wilkie
Track and Room: Cloud Application Development Deployment - 203
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
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.
Steve Jones
Twitter: - way0utwest
LinkedIn: Steve Jones
Contact: http://www.voiceofthedba.com/
Steve Jones is a Microsoft SQL Server MVP and has been working with SQL Server since version 4.2 on OS/2. After working as a DBA and developer for a variety of companies, Steve co-founded the community website SQLServerCentral.com in 2001. Since 2004, Steve has been the full-time editor of the site, ensuring it continues to be a great resource for SQL Server professionals. Over the last decade, Steve has written hundreds of articles about SQL Server for SQLServerCentral.com, SQL Server Standard magazine, SQL Server Magazine, and Database Journal.
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.
Lena Winfree
Twitter: - RachelWinfree
Contact: https://www.RachelWinfree.com
Lena Winfree is the co-founder/CEO of Rachel + Winfree Data Analytics Consulting firm. She is a Data Scientist with experience in Data wrangling, curation, analysis, mining, etc. Recent projects include the implementation of an infrastructure build for the newly launched MMC Data Science Institute. Rachel + Winfree specializes in data strategy design and implementation for small businesses, and data warehousing.
Peter Doyle
Twitter: - https://twitter.com/thepeterdoyle
LinkedIn: Peter Doyle
On Jan 12, 2019, Peter attended his first SQLSaturday and experienced an engaging and uplifting community that encouraged everyone regularly to give back. That experience resulted in teaching eleven sessions and delivering a SQL Fundamentals pre-conference the last six months of the year. He is passionate about sharing knowledge on building a solid T-SQL foundation without wasting time.
Peter’s journey from minimal Excel knowledge to writing Dynamic SQL all started from watching Youtube videos for three hours every morning before work. Managers took notice of the results and transferred him to the reporting department. A few months later, a co-worker suggested he should learn SQL Server and his world of data has never been the same.
Hilary Wilkie
LinkedIn: Hilary Wilkie
Hilary Wilkie has worked with prominent companies like Home Depot and small solo entrepreneurs. She is a Business Analyst with a Six Sigma Black Belt and currently working at AutoVIN, a division of KAR Auction Services. Hilary has worked with professionals at all levels of business including C-level, managers, and even the warehouse person! She believes behind all good processes and software are great people; often we get so passionate about the technology we forget about the people.
Pete Brown
Twitter: - https://twitter.com/jpbrown1
LinkedIn: Pete Brown
Pete Brown is a Memphis based infrastructure technologist. He supported various functional areas for over 15 years before learning the dark arts of object oriented programming. When he’s not working on a software project he can be found cycling, playing a VR game or shuttling his 5 kids to their respective activities.
Dan Evans
Twitter: - @danthebiman
LinkedIn: Dan Evans
Dan Evans is a Data and Analytics evangelist with over 25 years’ experience deploying strategic and innovative analytic solutions. He’s focused on Microsoft technologies including Data Platform, Advanced Analytics and Business Applications. Current focuses include SQL Server, Power Suite, Cognitive Services, Artifical Inteligence and other Data Platform related topics in Azure. Dan presents at many local, regional and national events including SQL PASS, DAMA, TDWI, TechEd and Ignite and supports best practices in Microsoft data and analytics across North America.
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.
Dustin Dorsey
Twitter: - sql_dd
LinkedIn: Dustin Dorsey
Contact: https://dustindorsey.com/
Dustin Dorsey has been architecting and managing SQL Server solutions for companies for well over a decade. While Dustin is skilled in many areas, he has a unique specialization in cost management and architecture around the data platform both on-premise and in the cloud that he has used to provide significant savings for multiple organizations and loves sharing information about this. Dustin is an avid speaker and can be seen writing articles on popular SQL websites, as well as, on his own blog at DustinDorsey.com. He is also active in the Nashville community as a local user group leader and co-organizer of his local SQLSaturday. Dustin currently serves as Director of Data Management at Lifepoint Health.
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.
Brian Hansen
Twitter: - tf3604
Contact: http://www.tf3604.com
Brian is a database administrator at Children International in Kansas City. He has been working with SQL Server technologies since 1998, including roles in report development, application development and database administration.
Spencer Swindell
Twitter: - @SpencerSwindell
LinkedIn: Spencer Swindell
Spencer Swindell is the Lead Architect with Think Data Insights, LLC. Think Data Insights a consulting group based out of Nashville, TN that works with companies to implement and maintain their Enterprise Data Platform. Since graduating from Tennessee Tech in 2011, he has built and delivered solutions for numerous organizations in the Nashville area utilizing SQL Server and the Microsoft BI Toolset. Spencer lives in Mount Juliet with his wife and son.
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.
Kevin Wilkie
Twitter: - Oskaruth
LinkedIn: Kevin Wilkie
Contact: http://sherpaofdata.com
Kevin has 15+ years experience with SQL Server and has worked with the product since version 6.5, although he remembers with distaste the early versions of the product. He started working with SQL Server as an “Accidental” DBA, and has moved up through the ranks as a SQL Developer, a BI Associate, and Production DBA at various parts of his career. Currently, he works as a Lead Data Analyst spreading the gospel of how great data can be to anyone and everyone who will listen.
Elizabeth Noble
Twitter: - SQLZelda
LinkedIn: Elizabeth Noble
Elizabeth Noble is a Director of Database Development in the metro Atlanta area. When she was introduced to her first database over 10 years ago, it was love at first sight. Her passion is to help others improve the quality and speed of deploying database changes through automation. When she is not trying to automate all of the things, she can be found spending time with her dogs, playing disc golf, or taking a walk at the gym.
Louis Davidson
Twitter: - drsql
LinkedIn: Louis Davidson
Contact: https://www.red-gate.com/simple-talk/author/louis-davidson/
Louis Davidson has worked in the IT industry for over 25 years as a corporate database developer and architect. He has been a Microsoft SQL Server MVP for 15 years and has written five books on database design, and contributed to many other SQL Server books as an author and tech editor. He has a bachelor’s degree in Computer Science from the University of Tennessee at Chattanooga. You can read more about Louis at http://drsql.org.
Sponsors
The following is a list of sponsors that helped fund the event: