SQLSaturday #781 - Columbus, GA 2018
Event Date: 10/13/2018 00:00:00
Event Location:
- Troy University Riverfront Campus
- 1510 3rd Ave
- Phenix City, Alabama
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 SQL Operations Studio
Abstract: “SQL Operations Studio (preview) offers a modern, keyboard-focused T-SQL coding experience that makes your everyday tasks easier with built-in features, such as multiple tab windows, a rich T-SQL editor, IntelliSense, keyword completion, code snippets, code navigation, and source control integration (Git). Run on-demand T-SQL queries, view and save results as text, JSON, or Excel. Edit data, organize your favorite database connections, and browse database objects in a familiar object browsing experience.”
And, it runs on a Mac (and Linux, and Windows, too). Similar to Visual Studio Code, SQL Operations Studio (still in pre-release form) lets you connect to and manipulate your databases without spinning up Visual Studio (or SSMS). We’ll walk through how to get the bits and install them, then connect to and query a database (in Azure) - we might not even use a mouse! If time permits, we’ll take a look at Code Snippets - a built-in capability to make your T-SQL coding super-productive!
Speaker(s):
- Eric Flamm
Track and Room: Enterprise Database Administration Deployment RM 201 - Room2
Title: Agile Database Development and Zero Downtime Deployments
Abstract: Does your database development process match your agile front-end counterparts? Is SQLServer Data Tools the right tool for an agile deployment methodology?
Join me in a fresh approach that will build deployments designed to be agile from the beginning, and also support the capability for zero down time deployments by supporting multiple states of the application, so database deployments can be made in advance, without breaking the application or requiring an outage.
We will touch on how about 35 different types of DDL changes can be prepared to support transition periods, so deployments can run against a live system with no disruptions to also support the next release of your application.
This approach is a new mindset, but with a few months of planning can be leveraged to turn a deployment from a feared event to showing off your true enterprise level DevOps skills. Some demonstrations will show how ReadyRoll can be used to build migrations that support transition periods.
Speaker(s):
- Jeff Reinhard
Track and Room: Application Database Development - Room1
Title: Database Project Makes Deployment Consistent
Abstract: The deployment process is frustrating; an object is missing, an object is deployed in the wrong order or an incorrect version. Deploying to multiple environments like Dev, QA, UAT, and Prod is a challenge whether on-premise or in the cloud. Source controlling database objects is paramount. Team development is required. Database code will only be deployed when changed. Proper security deployment will be repeatable per environment. Together, let us discover how using Database Project will help us with consistent releases. Deployments can cause you trouble but we will share a reliable deployment and version control process. Let’s see how Database Project can help us accomplish this goal.
Speaker(s):
- Thomas Norman
Track and Room: Enterprise Database Administration Deployment RM 201 - Room1
Title: DevOps, Continuous Integration Automated Testing: Rule them all
Abstract: Do you want to make your deployments risk free? Do you want to deliver business values to your customers faster? Do you want to increase the efficiency of your Team? Are your application and database deployment separate processes? Do you encounter issues while deploying your database changes? Do you want to automate your testing process? Is your database slowing you down?
If the answer to any of the above questions is a Yes, then this presentation is for YOU. Come join me in this 60 min session to understand the problems with traditional database development, why organizations are moving towards achieving Continuous Integration and Database DevOps, the problems it tries to solve and learn about the toolsets which will assist you in this journey towards painless database deployments.
Speaker(s):
- Samir Behara
Track and Room: Application Database Development - Room1
Title: PowerShell for BI Pros: Automating SSIS, SSRS, SSAS, and Power BI
Abstract: PowerShell has allowed DBAs to manage huge numbers of SQL servers, all automatically. Now BI practitioners can reap the same benefits of scale and automation. Scenarios that are normally extremely time consuming can be done quickly, all with a few lines of PowerShell. This session will be filled with demos based on real-life scenarios and use-cases. We will demonstrate how to scale and automate your BI solutions, with a minimum of effort. In particular, we will be covering PowerShell cmdlets their integrations with SSRS, SSIS, SSAS, and Power BI. By the end of the session, you’ll be able to accomplish in minutes what would normally take hours or days. You’ll know ways to quickly migrate and deploy hundreds of reports to multiple servers; or instantly identify and process stale SSAS dimensions. Additionally, you will also solve some pesky ETL tasks: deploying large-scale SSIS solutions, updating parameters for existing packages and streamlining data imports for Power BI Report Server
Speaker(s):
- Aaron Nelson
Track and Room: BI Platform Architecture, Development Administration RM 101 - Room4
Title: Supporting a very large environment
Abstract: This sessions introduces to the participants a slice in the life of a DBA managing and supporting a very large environment. It covers the differences between mid and large environment, key aspects to focus on and tips tricks to manage a very large environment. The session will provide some insight about CMS and PBM to the participants. Few techniques that can be implemented using CMS will be explored, along with some automation ideas. The audience would leave the session with a different mindset when they think of a very large environment. The presentation style being drafted will ensure that the participants stay engaged from start till the finish, as many interesting real life examples will be shared with the audience.
Speaker(s):
- Senthil Raghavan
Track and Room: Enterprise Database Administration Deployment RM 201 - Room2
Title: A Beginner’s Guide to the Query Store
Abstract: With the introduction of SQL 2016, Query Store has become a unique tool in the DBA toolkit for its almost surgical like performance adjustment capability for systems. This session will show how to use this feature in adjusting the performance of your SQL Servers in a much more granular way than the impact of using other performance tools that are available to the DBA - comparing and contrasting the Query Store with the traditional methods along the way. It will also show you how to monitor the impact of your changes, and the changes in the environment, from using Query Store. Finally the session will cover the basic architecture of query store, the reporting environment, and the DMVs that support query store.
Speaker(s):
- Steven Cush
Track and Room: Enterprise Database Administration Deployment RM 201 - Room2
Title: SQL Server R Services in SQL 2016 and 2017
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: BI Platform Architecture, Development Administration RM 101 - Room3
Title: PowerShell for the DBA
Abstract: PowerShell is a tool used by many people in DevOps and Infrastructure. Should the DBA get on board with using PowerShell? The answer is yes - as a DBA, PowerShell can have a significant impact on tasks that would be long and tedious with just T-SQL alone. Today there are specific modules that can be incorporated into PowerShell to help in automating every-day DBA tasks. Beyond that, PowerShell can be used to do things like automate deployments and audit permissions. In this session we will explore real-world examples and demonstrate how PowerShell can be leveraged by the DBA to not only improve efficiency but also streamline processes across an enterprise environment.
Speaker(s):
- Amy Herold
Track and Room: Enterprise Database Administration Deployment RM 201 - Room2
Title: Detecting and Capturing Change for Data Warehousing
Abstract: There are many ways of detecting and capturing changes to the data in your business system in order to populate your data warehouse. In this session we will compare and contrast several methods for loading slowly-changing dimensions in your ETL solutions, including SSIS design patterns, T-SQL code, change data capture (CDC) and temporal tables.
Attendees will gain a full understanding of the pros and cons of each of these solutions and become confident in choosing and implementing them in their own ETL solutions.
Speaker(s):
- Chris Hyde
Track and Room: BI Platform Architecture, Development Administration RM 101 - Room1
Title: Introducing Hadoop to SQL Server Pros
Abstract: Finding any IT industry publication that does not frequently reference Hadoop and Big Data is nearly impossible. Even so, to many SQL Server professionals it remains a mystery. ‘Introducing Hadoop to SQL Server Pros’ bridges the gap between knowledge of SQL Server and Hadoop. The first half of the session describes how Hadoop works by comparing it to what you already know about SQL Server. The second half is a series of demonstrations of Hadoop functionality. If you’ve ever wondered how Hadoop works and how it may effect you as a data professional, this is the session to attend.
Speaker(s):
- Jon Boulineau
Track and Room: BI Platform Architecture, Development Administration RM 101 - Room3
Title: A Beginner’s Guide to Power BI
Abstract: Are you new to Power BI? Do you want to learn what all the buzz is about and how to use it from a purely novice standpoint? Do you need to ramp up quickly to be able to build some great visualizations? This session is the session that you need! We will walk you through the basic architecture and nuances of Power BI all the while taking a fun adventure to building your first Power BI report. The attendee will leave the class ready to start using Power BI in the real world.
Speaker(s):
- Ed Watson
Track and Room: BI Platform Architecture, Development Administration RM 101 - Room4
Title: Introduction to T-SQL Windowing Functions
Abstract: T-SQL windowing functions can simplify many complex queries. They are the best thing that has happened to the T-SQL language in years, but many database professionals and developers haven’t heard about them. They were initially introduced with SQL Server 2005. In 2012, Microsoft added several new functions that let you do things like pull values from different rows without a performance penalty. Attend this session to learn how T-SQL windowing functions apply to many real world examples.
Speaker(s):
- Kathi Kellenberger
Track and Room: Application Database Development - Room3
Title: 2017 SSIS Scale Out: How and Why
Abstract: 2016 SSIS packages can access data anywhere throughout the network, but normally run on the server they are deployed on. And if something terrible happens to that server, the manual setup of the SSISDB can be time consuming. With 2017, SSIS packages can be deployed once and run on several servers, even simultaneously. At this meetup, Paul LaGrone will teach you how to set up 2017 SSIS Scale Out packages so that your SSIS packages can now be in a Highly Available and Disaster Recovery environment.
Speaker(s):
- Paul LaGrone
Track and Room: BI Platform Architecture, Development Administration RM 101 - Room4
Title: Lessons learned for optimum performance and up-time
Abstract: This interactive session will cover the lessons learned from the practical experience of a SAS provider as they went from 1 ½ 9s to 6 9s of availability concurrently expanding data volume from 500 GB to 5 PB while maintaining customer responsiveness . The session with cover all aspects of the processes used, design and evolution of the architecture, implementation strategies and processes used, monitoring, and the politics behind the availability.
Speaker(s):
- Steven Cush
Track and Room: Enterprise Database Administration Deployment RM 201 - Room2
Title: LUNCH
Abstract: LUNCH
Speaker(s):
- Tim Radney
Track and Room: Other RM 202 - Room1
Title: Source control, now. Peace through database lifecycle management.
Abstract: Database source control can be challenging and tricky to implement. This session will be a discussion on setting up a good foundation to implement source control. During this session we will go over getting buy-in for source control, managing database changes, and avoiding common pitfalls.
Speaker(s):
- Elizabeth Noble
Track and Room: Application Database Development - Room1
Title: Cosmos DB: Planet Earth Scale
Abstract: In this session you will be learn what Cosmos DB is and why it is the hottest thing in Azure. What does massively scalable, mullti-model, globally distributed, well-defined consistency models look like? Most important, who is going to be using it and why?
Speaker(s):
- Mike Lawell
Track and Room: Cloud Application Development Deployment RM 102 - Room3
Title: Azure Machine Learning 101
Abstract: You have probably heard the buzz about Azure Machine Learning, aka Azure ML, over the past few years. It is a surprisingly easy to use predictive analytic tool that you can learn for free. Attend this session to learn how to get started with Azure ML.
Speaker(s):
- Kathi Kellenberger
Track and Room: BI Platform Architecture, Development Administration RM 101 - Room3
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Jon Boulineau
Twitter: - @jboulineau
LinkedIn: Jon Boulineau
Contact: http://jonboulineau.me
Jon Boulineau works as a Data Architect and Data Engineer in Nashville, TN.
David Pless
Twitter: - @dpless
Contact: http://blogs.msdn.com/b/sql_pfe_blog/
For the past nine years, I have been a Technical Solution Professional with Microsoft. As a TSP I conduct full training workshops, conduct demo sessions, and perform architectural reviews on all supported builds of SQL Server. I mainly support the Southeast focusing on Florida, but I can be anywhere in the world.
My core areas are Performance Tuning and Optimization, Azure, AlwaysOn, Reporting Services (SSRS), custom monitoring, building custom dashboards, and more.
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.
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.
Senthil Raghavan
LinkedIn: Senthil Raghavan
Senthil, is an Atlanta based professional with rich experience in managing very large database environments. Currently managing a 15-member team for a legal process outsourcing organization that serves high profile clients with aggressive SLA’s. Senthil has previously served in the banking, payments, telecom and product warranty industries. Senthil is a hands-on individual in the SQL Server area and has broad experience in managing geographically distributed teams. His team is responsible for managing PostGres, MongoDB and MySQL servers besides SQL Servers.
Tim Radney
Twitter: - @tradney
LinkedIn: Tim Radney
Contact: http://www.timradney.com
Tim is a Data Platform MVP and has a whole collection of Microsoft and other industry certifications. His experience includes HA/DR, virtualization, SSIS, SSRS, and performance tuning, among everything else SQL Server-related. Tim is very active and passionate in the SQL Community. He runs the Columbus GA SQL Users Group, has been a PASS Regional Mentor for a number of years, was named a PASS Outstanding Volunteer in 2012, and is a frequent speaker at user groups, SQLSaturdays and PASS Summits. Tim is one of the top ranked in karma on ask.sqlservercentral.com, answers questions as @tradney on Twitter, and blogs at http://timradney.com and SQLskills blog at http://www.SQLskills.com/blogs/tim.
Paul LaGrone
Paul is currently in his fourth year as the ETL Manager for a local CRM software firm. Paul’s database work dates back to early database platforms like Dbase III and has worked with every version of SQL Server since SQL 7.0 was introduced. His certifications include MCSE, MCDBA, and MCT. Along with holding a DBA job for the City of Fort Worth, Texas, he also taught T-SQL Intro and Advanced classes to several departments and the North Texas GIS community. In 2006, he founded and ran the Greater Fort Worth SQL Server group for three years, which still continues today. While moving data and other SSIS tasks are Paul’s responsibility now, he has also been a Production DBA, worked heavily in the GIS database co
David Pless
Twitter: - @dpless
Contact: http://blogs.msdn.com/b/sql_pfe_blog/
For the past nine years, I have been a Technical Solution Professional with Microsoft. As a TSP I conduct full training workshops, conduct demo sessions, and perform architectural reviews on all supported builds of SQL Server. I mainly support the Southeast focusing on Florida, but I can be anywhere in the world.
My core areas are Performance Tuning and Optimization, Azure, AlwaysOn, Reporting Services (SSRS), custom monitoring, building custom dashboards, and more.
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.
Jeff Reinhard
Twitter: - @SQLMajor
LinkedIn: Jeff Reinhard
I have 25 years of database development experience, mostly with SQL Server, with companies such as Ernst amp; Young, Internet Security Systems/IBM, AirWatch, WebMD, CheckFree and others. My recent focus has been on AlwaysOn availability groups and database DevOps.
Mike Lawell
Twitter: - @sqldiver
LinkedIn: Mike Lawell
Contact: http://sqlserverassociates.com/Blog
Mike Lawell is an 19 year veteran of SQL Server, working with all versions since 6.5. He specializes in performance tuning and high availability as an independent consultant.
He is a Linchpin People Teammate, he also consults with SolidQ, Intellinet and Microsoft Consulting Services.
He is also a certified Scuba instructor with a long bucket list of dive sites.
He resides in Atlanta, GA and you can catch him at many of the SQLSaturdays in the SE region of the United States.
Thomas Norman
Twitter: - ArmorDba
LinkedIn: Thomas Norman
Contact: https://armordba.com/
Tom Norman is a Database Architect at KPA with a strong fervor to protect data. He works daily to review and improve data protection methodologies while reviewing governing laws affecting finance, healthcare, and personal data. His areas of expertise include encryption, auditing, data identification, and database object deployment. He is the current leader of the PASS Virtualization Group and Vice President of the TRIPASS user group. You can read his blog at https://armordba.com/ and reach him on twitter at @armordba. Tom speaks at a number of SQLSaturday events and SQL Server user groups.
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.
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.
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.
Steven Cush
Steven is a software professional with almost 20 years in the field. He has worked in all areas of the data profession from in both OLTP and OLAP disciplines, as well as having been a developer. He is currently working at a privately held CRM provider leading their data efforts.
Eric Flamm
Twitter: - eflamm
LinkedIn: Eric Flamm
Contact: http://blog.flammconsulting.com
Eric Flamm is the principal consultant with Flamm Consulting, which provides Business Intelligence and Data Engineering consulting services to a range of small and medium-sized businesses. His clients have included Pactiv Corp (formerly Tenneco Packaging), Colography Group, Principia Partners, and Tillster, Inc (formerly Snapfinger.com), along with a range of smaller clients and projects.
Eric graduated from Stanford and the Booth School at U of Chicago.
Eric has volunteered with SQLSaturday Atlanta since the first event (SQLSaturday #13 in 2009). He has presented to SQLSaturdays in Atlanta, Chicago, and Columbus (GA), Azure Data Fest (Atlanta), the Atlanta Power BI chapter, and the Kennesaw (GA) Amazon Web Services Meetup group.
Aaron Nelson
Twitter: - SQLvariant
LinkedIn: Aaron Nelson
Contact: http://sqlvariant.com/
Aaron Nelson is an author, public speaker, blogger, and leader in the community. He has over 15 years of experience in architecture, Business Intelligence, development, and performance tuning of SQL Server. Aaron has received many certifications and is a six time winner of the Microsoft MVP Award.
Aaron leads the PowerShell Virtual Group of PASS (SQLPS.io), is a board member of PowerShell.org, and is a volunteer at his PASS Local Group, AtlantaMDF.
Amy Herold
Twitter: - @texasamy
LinkedIn: Amy Herold
Contact: http://www.sqlkitten.com/
Amy Herold is currently a Premier Field Engineer with Microsoft, specializing in APS. Prior to this, she was a Sr. Database Administrator, focusing on PowerShell and automation. She is also currently the Director of Programs for the North Texas SQL Server User Group (NTSSUG). She frequently speaks at SQLSaturday and user group events across the United States and has also participated in numerous Women in Technology sessions as a panelist. Amy currently blogs at sqlkitten.com.
Steven Cush
Steven is a software professional with almost 20 years in the field. He has worked in all areas of the data profession from in both OLTP and OLAP disciplines, as well as having been a developer. He is currently working at a privately held CRM provider leading their data efforts.
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
Sponsors
The following is a list of sponsors that helped fund the event: