SQLSaturday #884 - Pensacola 2019
Event Date: 06/29/2019 00:00:00
Event Location:
- Pensacola State College, Main Campus
- 1000 College Blvd
- Pensacola, Florida
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: Encrypting Data within Sql Server
Abstract: Data breaches abound! Do you want to keep off of the data breach list? What are some of the data privacy laws affecting you? How will encrypting data affect your database performance? What data fields should you encrypt? What else can you do to protect your sensitive data?
In this session, we will review each option to encrypt data within SQL Server, Transparent Data Encryption, Cell Level Encryption and Always Encrypted. The session will deep dive into setting up Always Encrypted encryption and share my experiences implementing the encryption. In addition, the session will review auditing of sensitive data usage.
You will leave the session with a deeper understanding about SQL Server encryption options and how encryption can affect your performance. In addition, you will gather information on how to fully protect and review your sensitive data usage.
Speaker(s):
- Thomas Norman
Track and Room: Application Database Development - 1774
Title: Designing Data Intensive Cloud Native Applications
Abstract: Cloud is rapidly changing the way modern day applications are being designed. Data is at the center of multiple challenges while architecting solutions in cloud.
With technology changing rapidly, there are new possibilities for processing data efficiently. Come join me in this session to learn more about the tools and technologies that will help you to design data intensive systems. We will take a structured approach towards architecting data-centric solutions, covering technologies like message queues, data partitioning, search index, data cache, event sourcing and NoSQL solutions.
If you are a Data professional, Software Engineer or Architect, come join me in this session to understand the high-level design principles that will help you build scalable, resilient and maintainable systems in cloud.
Speaker(s):
- Samir Behara
Track and Room: Cloud Application Development Deployment - 1774
Title: Performance Dreams started at SQL Server 2014 and came true now at SQL Server 2016,2017
Abstract: “Performance Dreams started at SQL Server 2014 and came true now at SQL Server 2016,2017 “, it is just like this because you there are unbelievable performance reads and substantial improvements that can drive your DB environment to a distinct level of stability and Performance to be a leading environment in a very short time ..! It looks like apparently a myth or legend to see those new SQL Server 2016 features how they could flipped up SQL Server Powers from the old generation to the new generation of in-advanced analytics using In-memory and CCI (Colmnstore indexes) where no longer need for any DWH solutions at all but just reading data directly from production DBs with ZERO performance impacts on end users ..! come in here to my session and you will know more about many new features and rich powers of SQL Server 2014 2016 regarding performance particularly like Microsoft project “Hekaton” for In-memory built in for OLTP , CCI( columnstore index) ,Resource Governor for IO
Speaker(s):
- Shehab El-Najjar
Track and Room: Enterprise Database Administration Deployment - 1778
Title: Level Up: Data Modeling for the Power BI Rockstar
Abstract: In the world of Power BI, data modeling is what separates the Rockstars from the Rookies. Join me to learn how dimensional modeling - a concept developed 20+ years ago - continues to be the best approach for delivering self-service BI to the masses.
Not only will good data modeling result in better Power BI solutions that support a wider range of reporting requirements, but they will also be easier for the business users to understand and work with.
In this session, you’ll learn how to create flexible data models that can be expanded upon over time, unlock the power of the date table, and a variety of DAX patterns supporting common but complex business logic. If your Power BI solutions typically contain a single table, if you’re frequently banging your head against the wall trying to figure out how to write a DAX calculation, or if you’ve never heard the term “dimensional model” this session is for you.
Speaker(s):
- Bill Anton
Track and Room: BI Platform Architecture, Development Administration - 1773
Title: How to perform a health check
Abstract: Are you uncertain about the health and capacity of your SQL Server? Are you taking over a new server and need to get a better understanding of the health of the server? Are you uncertain if your servers are following industry best practices?
In this session we will start by discussing the importance of performing a Health Check. We will then show how to run the popular Blitz script by Brent Ozar. After that we will review the other key areas to check like the VM configuration, Windows Configuration, SQL Configuration, Security configuration, and Database configuration. Finally, we’ll show how to save the results for capacity and trending analysis
At the end of the session you will be able to: (1) Perform a Health Check on a server; (2) List the key areas for improvement; (3) Save the results for capacity and trending analysis.
Speaker(s):
- Carl Roepe
Track and Room: Enterprise Database Administration Deployment - 1777
Title: Indexing Like a Rocket Scientist
Abstract: Performance is what your users care about, and indexes can both improve and decrease performance. As a SQL Developer, do you understand the difference between a clustered and non-clustered index or what a covering index is? What is different between OLTP and data warehouse databases when it comes to indexing? This session is a deep dive into Clustered indexes Non-clustered indexes B-Tree traversal Primary Keys Covering indexes
This session will feature live query demos illustrating index utilization and performance using statistics and query plans. Understand indexing like a rocket scientist by attending this session!
Some knowledge of T-SQL and Management Studio is recommended.
Speaker(s):
- Mike Byrd
Track and Room: Application Database Development - 2146
Title: Giving Feedback: How to Effectively Communicate to your Employees
Abstract: As a manager or team leader giving effective feedback is vital to the success of projects. Managers often ascend the hierarchy due to their technical skill set but rarely learn ways to successfully communicate with their team. In this session, we will discuss soft skills and best practices to give feedback. We’ll learn the essentials for an interaction and how to prepare for tough conversations. Using sample coaching conversations, we’ll run through examples to help you prepare for your next tough dialog. Whether it is a simple coaching sit down, or performance improvement related, and even disciplinary actions, learn how to handle confrontation tactfully.
Speaker(s):
- Christine Assaf
Track and Room: Professional Development - 2151
Title: Managing Packages in Integration Services (SSIS)
Abstract: SQL Server Integration Services (SSIS) introduced the Catalog to help with managing project deployments, execution monitoring. It was created to get rid of configuration files for packages in earlier versions. But what this has added is the ability to rollback a version, configure different environments as well as dashboard reports for monitoring. This session will start with the installation and configuration of the catalog. The flow will change to the project management of packages. Here, project parameters will be used to configure different steps of a package and how this configuration can be shared with multiple packages. The project will be deployed as well as a single package deployment. The configuration will be changed at the SQL Server Agent Job and deployed project levels. Environments will be setup to show development versus QA versus production. The report monitoring dashboard will conclude the session showing error messages as well as a package performance chart.
Speaker(s):
- Thomas LeBlanc
Track and Room: BI Platform Architecture, Development Administration - 1773
Title: How to Build Your Disaster Recovery Plan
Abstract: So your boss asked for a copy of your DR plan. Once you’ve wiped that deer-in-the-headlights look off your face, you realize “We’ve got database backups,” isn’t exactly a plan. You need to come up with a plan to recover your business when disaster strikes. This session will help you build this plan by defining what a disaster could be, documenting the business impact, and identifying your limitations. We will show how to use this information to establish metrics (such as RTO and RPO), document current recovery configurations, and design an effective recovery strategy that meets the needs and budget of your business. Attending this session will give you the knowledge and tools to create an effective disaster recovery plan that will make your boss happy and ensure the continuity of your business.
Speaker(s):
- Rie Irish
Track and Room: Enterprise Database Administration Deployment - 1778
Title: Understanding Deadlock Printouts in the Error Log
Abstract: You know to look out for deadlocks on your system. You know how to capture deadlocks to your error log. You know some techniques to apply to problem code to reduce deadlocks. But…
Going through the error log is a pain. There are many extraneous values. The details you want are buried in there somewhere, and don’t always make sense. Why isn’t it easier to find exactly where the deadlock is occurring?
Come walk with me through the error log to find all the details we need. There are many helpful details in the log you didn’t know existed because they were hard to read. We can find out where in the code a deadlock happened, which objects deadlocked, and why they deadlocked. We’ll go through the extra values to help put meaning to them. After doing this a few times, it gets easier to find the main details you want, and have supporting evidence when you need it.
Speaker(s):
- Mike Burek
Track and Room: Application Database Development - 1774
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 - 2146
Title: Revenge: The SQL!
Abstract: Pop quiz DBA: Your developers are running rampant in production. Logic, reason, and threats have all failed. You’re on the edge. What do you do? WHAT DO YOU DO? Hint: You attend Revenge: The SQL! This session will show you how to “correct” all those bad practices. Everyone logging in as sa? Running huge cursors? Using SELECT * in ad-hoc SQL? Stop them dead, without actually killing them. Ever dropped a table, or database, or WHERE clause? You can prevent that! And if you’re tired of folks ignoring your naming conventions, make them behave with Unicode…and take your revenge! Revenge: The SQL! is fun and educational and may even have some practical use, but you’ll want to attend simply to indulge your Dark Side. Revenge: The SQL! assumes no liability and is not available in all 50 states. Do not taunt Revenge: The SQL! or Happy Fun Ball.
Speaker(s):
- Rob Volk
Track and Room: Enterprise Database Administration Deployment - 2142-Auditorium
Title: Adopting a Compliant Database DevOps Process
Abstract: Presented by Redgate
DevOps is transforming software development, with many organizations and individuals adopting lean development practices, implementing Continuous Integration (CI), Continuous Deployment (CD), and performing on-demand deployments to their production environments. However, the database is largely ignored and seen as a bottleneck for a DevOps software development process. We will discuss the challenges of database development and deployment and examine why many developers find the database to be an impediment. We examine the risks of sensitive data in the development process and how you can ensure that data security concerns do not get in the way of the need for speed and agility. We’ll look at how you can adopt a Compliant Database DevOps approach that removes the database bottleneck while ensuring compliance with regulations governing the use of data within your organization such as GDPR, HIPPA or SOX. We’ll discuss the techniques used to include the data
Speaker(s):
- Steve Jones
Track and Room: Application Database Development - 2151
Title: Dynamic Hierarchical Row Level Security for Power BI using SSAS Tabular and Active Directory
Abstract: Attendees will learn how to design a Dynamic Hierarchical Row Level Security system using for Power BI using Active Directory, Powershell and SSAS Tabular.
Speaker(s):
- Pat Byrne
Track and Room: BI Platform Architecture, Development Administration - 1773
Title: SQL Admin Best Practices with DMVs
Abstract: In this practical and script-focused session, with roots in SQL 2005 but updated continuously thru SQL 2017, we’ll discuss many best practices regarding SQL Server administration, maintenance, optimizations and monitoring using Dynamic Management Views. DMV’s are essential tools for the SQL administrator, but have a wide range of applications by developers, network engineers and DBAs. We will delve into best practices for server maintenance, index fragmentation, XEvents, wait type analysis and future features. This session will be informative and eye-opening to anyone from a junior DBA on up.
Speaker(s):
- William Assaf
Track and Room: Enterprise Database Administration Deployment - 2142-Auditorium
Title: Azure Databricks (ADB) and the Traditional DBA
Abstract: As more data services come online in Microsoft Azure, DBAs are being tasked with bringing these services into their organizations. Azure Databricks is one such service that has the appeal of combining scalable compute resources with collaborative development and analytic tools in Notebooks and workspaces. To the traditional DBA, however, many of the concepts and language support may be foreign. What the heck is Scala anyway? This session is designed to introduce the DBA to the Azure Databricks workspace and show how to easily integrate it with upstream and downstream services like Azure Data Factory, Machine Learning and Power BI.
Speaker(s):
- Rodney Landrum
Track and Room: BI Platform Architecture, Development Administration - 2151
Title: Careers in IT - Pensacola 2019
Abstract: Careers in IT will feature a panel of industry leaders and experts who directly interact with participants in a moderated question and answer session. This will allow participants to gain insight into what the IT community sees as valuable (skill-sets, certifications, experience, and etc) so that they can be better prepared for a career transition or to start work in the IT field for the first time.
Speaker(s):
- Michael Viron
Track and Room: Professional Development - 2151
Title: SSMS to Azure Data Studio: The Big Switch
Abstract: We’ve used SSMS to interact with SQL Server instances since 2005. Now, Microsoft is provides us with something new - Azure Data Studio.
I’m starting to use Azure Data Studio over SSMS where possible, and this talk is meant to share my experience with others. Azure Data Studio is certainly different, and it offers some interesting and impressive new ways to interact with our SQL Server instances.
Speaker(s):
- Jason Hall
Track and Room: Application Database Development - 1774
Title: Why You Should Consider Implementing Indexed Views
Abstract: This session will include an explanation of what indexed views are, the types of problems that they solve, and their limitations. Additionally, I will provide a methodology for determining whether or not you should consider using indexed views to solve problems in your environment - including how to test and compare them to some alternatives. I will then go through some demonstrations in order to clarify my points further and provide more opportunities for the audience to ask questions.
Speaker(s):
- Alexander Fleming
Track and Room: Application Database Development - 1774
Title: My IT career is an accident.
Abstract: My IT career has been filled with one accidental job title after another. In this session I will talk about how to adjust and be productive in a path that you never prepared for. I will also discuss ways to make yourself open for these careers when they come along.
Speaker(s):
- Johnathan Sluder
Track and Room: Professional Development - 2151
Title: Microsoft Azure Modern Data Warehouse
Abstract: The Microsoft Azure Ecosystem has a rich toolset to build a modern data warehouse using tools like Azure Data Factory v2, Azure Data Lake gen2, Azure SQL DB and Data Warehouse, Azure Analysis Services and Databricks.
This session will give an overview of each of the pieces of this modern data warehouse and demos of how to setup this architecture for you environment.
Speaker(s):
- Jamey Johnston
Track and Room: BI Platform Architecture, Development Administration - 1773
Title: Performance Tuning for the BI Professional
Abstract: Being a BI Professional, you need all the performance tuning the DB folks get and more. In this hour, we will go over important performance tuning tips that you can use to help make your deliverables faster and more effective. We will touch on the MSBI tools of SSIS, SSAS, SSRS and PowerBI.
Speaker(s):
- Jonathan Stewart
Track and Room: BI Platform Architecture, Development Administration - 2142-Auditorium
Title: Migrate Your Database(s) with Distributed AGs
Abstract: You find yourself needing to migrate to new hardware or new operating system. If you’re running SQL Server 2016+, you’re in luck! Distributed Availability Groups (AGs) may just be the solution you want.
In this session I will explain the purpose and usages of Distributed AGs, create a Distributed AG and the associated AGs, and perform a mock data center migration.
NOTE: This session expects that attendees are already familiar with Availability Groups.
Speaker(s):
- Elizabeth Noble
Track and Room: Enterprise Database Administration Deployment - 1778
Title: Do I need to know about BIML? Of course you do!
Abstract: This topic will be about creating dynamic SSIS packages using BIML. Dynamic SSIS packages will help eliminate the hassle of having to manually change items in a Data Flow task when an underlying table change occurs. This talk will start from the ground up, showing a basic SSIS package, what it would take to create it dynamically in C#, and then the same package using BIML. While we will show some examples of BIML and C#, no experience in either of these is required, as the talk will be more concepts to get ideals flowing.
If you have data to move, BIML could be your new friend!
Speaker(s):
- Paul LaGrone
Track and Room: BI Platform Architecture, Development Administration - 1773
Title: A Primer on SQL Server Clustered Index Architecture
Abstract: How often when creating a new table you just made the Clustered Index using an Integer column with Identity properties. Seems like that is all I have done for last many years. But, in the last two years I’ve really dove into indexes and finally with this presentation looked at what really makes a good Clustered Index with benchmarks and varying scenarios. In some scenarios a well-defined clustered index may out perform a covering non-clustered index. Results are very interesting and may surprise you.
Speaker(s):
- Mike Byrd
Track and Room: Application Database Development - 1778
Title: SentryOne Success Stories
Abstract: A a collection of stories and cases demonstrating how SentryOne customers found success using various software products from SentryOne. They span many industry verticals, and their needs are diverse, yet we will demonstrate how solutions from SentryOne are used to improve business performance for their firms and quality of life for their data professionals.
Speaker(s):
- Jason Hall
Track and Room: Strategy and Architecture - 2142-Auditorium
Title: Look, over there, your permissions are showing!
Abstract: You just walked into that fancy new gig, and you’re getting your first cup of coffee. Your boss walks up and asks, “Who has access to that prod server?”, do you know how to get the answers in the next hour? More importantly, do you know what these permissions mean, what an attacker could do with these permissions? In this session we’ll start from scratch assuming that you have no experience with an audit with this question in mind. We’ll work back from here to develop a strategy of how to harden your server.
Speaker(s):
- Travis Page
Track and Room: Enterprise Database Administration Deployment - 1778
Title: What’s new in Azure SQL Database
Abstract: If you’re not currently using Azure SQL Database, but you want to stay up-to-date, this is the session for you. You will learn about and see the changes to Azure SQL Database that have taken place over the past few months. The focus will be on staying abreast so you can be a valuable resource in your company when the inevitable discussion about moving to the cloud happens. Expect to find details on the different licensing models, Managed Instance, security, and more.
Speaker(s):
- Sven Aelterman
Track and Room: Cloud Application Development Deployment - 1777
Title: Fundamentals That Will Improve Your Query Performance!
Abstract: Time and time again the same misunderstandings by developers and query writers appear when query performance issues arise. In this demo heavy presentation, we will review these specific topics such as data types, implicit conversions, sargability, and some others that all have an impact on query performance. Come join me and by the end of this session you will have the knowledge to boost your query performance!
Speaker(s):
- John Wells
Track and Room: Application Database Development - 2146
Title: Women in Tech: Thriving Not Just Surviving
Abstract:
Join us for a panel discussion where we’ll talk about succeeding as a woman in tech. It’s hard. We get it. We’ve been there before. We’ll be there again. Sometimes it’s hard, throwing yourself into that brick wall. All day. Every day. But you can do it. I know you can.
But it’s about more than just living in a man’s world.
Let’s talk tech, Where we’ve been Where it’s going. How we keep our skills sharp. How we mentor other women. How YOU can mentor other women.
Speaker(s):
- Rie Irish
Track and Room: Professional Development - 2151
Title: Data Types Do Matter
Abstract: They’re just numbers, right? A date’s a date. It’s just string data, who cares? I can’t tell you how many times I’ve heard these phrases. This session will help you understand why choosing the correct data type for your data is so important. It affects data quality, storage and performance. It can even produce incorrect query results.
Speaker(s):
- Angela Henry
Track and Room: Application Database Development - 2146
Title: Temporal Tables: Creation, Use, and Optimizing
Abstract: With SQL 2016, Microsoft introduced Temporal tables. In this session we will learn what a Temporal table is, and discuss uses in current environments. We will learn how to create the tables, query the data from the tables for different scenarios, and optimize them for query performance allowing simplicity for the consumers of the data.
Speaker(s):
- Dale Sullenberger
Track and Room: Application Database Development - 2146
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 - 1777
Title: Future 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 - 2142-Auditorium
Title: Performance Tuning, Getting the Biggest Bang for Your Buck
Abstract: Everyone wants to know if there are magic buttons you can push to make SQL Server run faster, better and more efficiently. In this session we will go over some of my go-to performance tricks that you can implement to get the biggest improvement with the least amount of change. When it comes to performance tuning, every second counts. We will cover memory optimization, isolation levels, trace flags, statistics, configuration changes and more. I’ll go over real life scenarios we come across as consultants and the changes we made to fix them.
Speaker(s):
- Monica Rathbun
Track and Room: Enterprise Database Administration Deployment - 2142-Auditorium
Title: Azure Basics for the DBA
Abstract: It’s not a question of whether or not the landscape for the common DBA is changing. Without a doubt, it is. Azure offers up a new world of possibilities for DBA’s and we should all strive to learn it. In this session, we’ll cover some basic knowledge and terminology of Azure as well as how easy it is to incorporate Azure into your environment. We will stand up a new Azure virtual machine as well as a setup SQL DB. You will see how easy it is to accomplish this. This new-found knowledge will help propel your career into the new landscape.
Speaker(s):
- John Morehouse
Track and Room: Cloud Application Development Deployment - 1777
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Thomas LeBlanc
Twitter: - TheSmilingDBA
LinkedIn: Thomas LeBlanc
Contact: http://Thomas-LeBlanc.com
Thomas LeBlanc (Microsoft Data Platform MVP) is a Data Warehouse Architect in Baton Rouge, and uses his 30+ years in IT to develop OLTP systems with normalized databases for high-performing T-SQL and dimensional data marts. Development is done in SSIS, SSAS, SSRS, Power BI, and Excel. As a PASS volunteer, he is past chair of Excel BI and Data Arch VCs and is active in the Baton Rouge Analytics and SQL Server User groups, as well as SQLSaturday in Baton Rouge. You can find his blog at TheSmilingDBA.BlogSpot.com and website at Thomas-LeBlanc.com
Angela Henry
Twitter: - SQLSwimmer
LinkedIn: Angela Henry
Contact: http://SQLSwimmer.com
Angela is a Solution Architect, living in High Point, NC and loves what she does. She’s worked with all versions of SQL Server worn all the hats that come with dealing with SQL Server throughout the years: developer, administrator, data architect and BI developer. She has her MSCE in Data and Analytics (f.k.a., Business Intelligence), is a Data Platform MVP, and a Microsoft Certified Trainer (MCT). She is the former chapter leader for the PASS Triad SQL User Group in Greensboro, NC. In her spare time you can probably find her in or at the pool, she’s an avid US Masters Swimmer, Coach and Instructor.
Carl Roepe
LinkedIn: Carl Roepe
Carl Roepe is a senior DBA with Perimeterdba.com. He has 12 certifications from SQL 2008 thru 2014. He has 25+ years as staff, director, president and CEO of multiple companies managing data on an enterprise level. His extensive experience with massive data sets, high volume banking and CPA firms, he has a unique approach in configuring and building data ecosystems for speed, reliability, security and precision. In addition to his administrative and database skills, his skill sets included TSQL, C#, PowerShell, SharePoint, SSAS, SSRS and PowerBI. Carl can be reached at carl@perimeterdba.com.
Michael Viron
Twitter: - mviron
LinkedIn: Michael Viron
Michael Viron has a wide range of experience as a senior IT manager amp; business owner. As Director of IT amp; Software Engineering at KAMedData, Inc, he has been heavily involved in coordinating numerous product launches amp; both company amp; division startups. A key team member, his main responsibilities include technical operations, project management, security, short and long range technical planning, and development. As owner of General Education Online, he handles both IT and business operations.
Rie Irish
Twitter: - IrishSQL
LinkedIn: Rie Irish
Rie lives with her family just north of Atlanta, Georgia. She worked as a SQL Server DBA, manager director for over 20 years. She’s worked in many industries including the non-profit sector, education, big pharma, and e-commerce. She was awarded the MVP in the Data Platform 3 times beginning in 2017 and gave that up to accept her role as a Senior Program Manager with Microsoft in 2019. She is very involved with the Atlanta MDF User Group, SQLSaturday Atlanta and is co-leader of the PASS Women in Tech virtual group.
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.
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.
Sven Aelterman
Twitter: - @svenaelterman
LinkedIn: Sven Aelterman
Contact: https://svenaelterman.wordpress.com
Sven Aelterman is the Director of IT for the Sorrell College of Business at Troy University; a role with a global scope. He is also a lecturer in Information Systems and teaches courses in data warehousing and information security. He continues consulting work through Adduxis, where he assists customers with various Microsoft technology implementations. Co-author of The Art of SQL Server FILESTREAM, published by Red Gate; and SQL Server 2017 Administration Inside Out, published by Microsoft Press. Cloud Software Architect at Sorrell Solutions, L.L.C. developing a Microsoft Azure-hosted Electronic Health Record system.
Jason Hall
Twitter: - @SQLSaurus
LinkedIn: Jason Hall
Contact: http://blogs.sqlsentry.com/jasonhall
Jason Hall (@SQLSaurus) leads SentryOne’s Product Management team, which is responsible for managing product design, development and delivery.
Jason has worked in varied technology roles for over 20 years and holds industry certifications including MCSE (legacy), MCSD, MCTS, MCPD, and PMC-III.
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.
Shehab El-Najjar
Twitter: - https://twitter.com/MSQLPerformance
LinkedIn: Shehab El-Najjar
Contact: http://sqlserver-performance-tuning.net/
Shehab El-Najjar was the ONLY Microsoft SQL Server MVP in Gulf for the past 6 years and the 2nd one all over the Middle East , he is the founder of SQL Gulf events series (SQL Gulf #1 , #2 and #3 ) where he spent so much time and efforts to broadcast Microsoft SQL Server technologies all over the Gulf such as KSA and Emirates and other Gulf cities ahead ..)
He is now Professional Services Manager at Saudi Emircom
He was previously COO and business leader in KSA market through his startup WAJA IT for 3 years
He is an influencing Database community leader all over the region A senior Database Consultant (SQL Server MVP for 6 years in row) -The 2nd MVP awardee SQL Server all over Middle East and Arabic region
John Wells
Twitter: - @SQLServerDBA318
LinkedIn: John Wells
Contact: https://sqlrookieinthe318.wordpress.com/
I’m a DBA at Lamar Advertising in Baton Rouge. I’m a member of the Baton Rouge User Groups Board as well as a co-organizer for the ONLY SQLSaturday that serves Jambalaya for lunch! I started speaking in 2018 and enjoy everything about this powerful community! I enjoy performance tuning, helping developers with best practices and DBATools.
Jamey Johnston
Twitter: - STATCowboy
LinkedIn: Jamey Johnston
Contact: http://STATCowboy.com
Jamey Johnston is a Senior Data Scientist/Engineer for a large independent OG company. For over 25 years, he has worked for Fortune 500 companies architecting successful platforms in the cloud, on the edge, and on-premises for BI reporting, statistical analysis, ML, and AI. Lately, he spends his time in Azure, Python, R, Power BI, MS SQL, and SAS JMP. He holds a BS in Spatial Analysis from LSU and a Masters of Science in Analytics from Texas AM. He is a professor at the Mays Business School at Texas AM in the MS Analytics program. He is active in his PASS Local Group in Houston, co-leader of the local Power BI users group and data analytics group. He regularly speaks and volunteers at PASS events. He is also a Microsoft Data Platform MVP.
William Assaf
Twitter: - william_a_dba
LinkedIn: William Assaf
Contact: http://www.sqltact.com
William Assaf, Data Platform MVP, is a principal consultant in Baton Rouge, LA. Initially a .NET developer, and later into database administration and architecture, William currently works with clients on SQL Server and Azure SQL platform optimization, management, disaster recovery and high availability, and leads a crack multi-city team of consulting SQL DBA’s. William has written for Microsoft SQL certification exams since 2011 and was the lead author of the 2017 and 2019 editions of “SQL Server Administration Inside Out” by Microsoft Press. William is a member of the Baton Rouge User Groups board, a regional mentor for PASS, and past lead of the annual SQLSaturday Baton Rouge Planning Committee, having run one of the largest SQLSaturdays.
Rie Irish
Twitter: - IrishSQL
LinkedIn: Rie Irish
Rie lives with her family just north of Atlanta, Georgia. She worked as a SQL Server DBA, manager director for over 20 years. She’s worked in many industries including the non-profit sector, education, big pharma, and e-commerce. She was awarded the MVP in the Data Platform 3 times beginning in 2017 and gave that up to accept her role as a Senior Program Manager with Microsoft in 2019. She is very involved with the Atlanta MDF User Group, SQLSaturday Atlanta and is co-leader of the PASS Women in Tech virtual group.
Bill Anton
Twitter: - https://twitter.com/SQLbyoBI
LinkedIn: Bill Anton
Contact: http://byobi.com/blog/
Bill Anton is an expert in Analysis Services and an experienced data warehouse practitioner. In 2013, he founded Opifex Solutions, a consulting firm with deep expertise in enterprise-scale architecture, design, and performance optimization of Analysis Services and Power BI solutions. He loves eating and spends most of his free time convincing his beloved wife to adopt more golden retrievers.
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.
Christine Assaf
Twitter: - https://twitter.com/HRTact
LinkedIn: Christine Assaf
Contact: https://www.hrtact.com
Christine Assaf is an experienced HR pro who is passionate about the mental health of employees, leadership, and organizations. She is a leadership development professional with over 15 years experience in human resources and 20 years in business management. She holds a BS in Business Management, received her HRM certification at LSU, and is finishing up her master’s degree at Colorado State University in Industrial and Organizational Psychology. She is a certified DDI Trainer, experienced public speaker, and is dedicated to teaching others about ways to support a culture of “expressiveness” in the workplace that creates connectivity.
Alexander Fleming
I think T-SQL is the best thing since sliced bread and I thoroughly enjoy reading and writing T-SQL whenever I can. I’m also doing increasingly advanced PowerShell scripting and ETL development with SSIS, PowerShell, and TSQL.
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 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
Johnathan Sluder
Twitter: - https://twitter.com/sqlslaughter
LinkedIn: Johnathan Sluder
Contact: http://sqlslaughter.com
After 10 years as a systems admin, I’m taking a new adventure into the world of SQL. I currently work doing ETL testing in a Data Warehouse environment. I am currently studying database development and Data Science.
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
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.
Dale Sullenberger
LinkedIn: Dale Sullenberger
Dale lives in Valrico, FL with his wife Connie and son Nathan, three dogs and two cats.
While there is some prior user level database experience, Dale has been working with SQL Server in some manner since 1997, and has been in a DBA role for 13 years.
Rodney Landrum
Twitter: - @sqlbeat
Rodney Landrum has been architecting solutions for SQL Server for over 15 years. He has worked with and written about many SQL Server technologies, including DTS, Integration Services, Analysis Services, and Reporting Services. He has co-authored 4 books on Reporting Services. He has been a regular contributor to SQL Server magazine, sqlservercentral.com and Simple-talk.com. Rodney was also a Microsoft Data Platform MVP from 2008 through 2016.
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.
Mike Byrd
Twitter: - ByrdNest_TX
LinkedIn: Mike Byrd
Contact: http://logicalread.solarwinds.com/?s=byrd, www.TSQLMentoring.com and SQLServerCentral.com
Former rocket scientist and USAF Fighter Pilot – now a SQL Server geek (24 years)! Past opportunities include free-lance technical writer for PC Magazine, Senior Software Manager for government sponsored munitions effectiveness committee, and insurance company CTO. Currently senior database engineer consultant for several Austin companies.
Presenter at many SQLSaturdays over last 6 years in United States, Europe, and Australia.
Specialize in SQL Server performance tuning; database (OLTP OLAP) architecture; trouble-shooting; teaching TSQL (Basic through Advanced).
Video presentations (for local SQL Server user groups or SQLSaturdays) can be found at http://usergroup.tv/videos/category/speaker/mike-byrd
Mike Burek
Twitter: - mikeburek
LinkedIn: Mike Burek
Contact: http://tikiwiki.mikeburek.com
He started by building a complete computerized inventory management system for a multi-state store. Next, he managed Texas Medicare and Medicaid claim data to keep it processing, and building new monitoring metrics. Afterwards, he processed and analyzed marketing data on tens of millions of customers and sent hundreds of millions of multi-lingual marketing messages worldwide. Upgrading those marketing skills, he then worked to process and query tune marketing data for tens of thousands of worldwide enterprise customers, bringing in tens of millions of dollars per campaign. Now he monitors database servers to keep them running well, tunes queries, and helps businesses build new ETL processes. He also runs the Austin, TX user group.
Monica Rathbun
Twitter: - SQLEspresso
LinkedIn: Monica Rathbun
Contact: http://www.sqlespresso.com
Monica Rathbun lives in Virginia, is a Microsoft MVP for Data Platform and Microsoft Certified Solutions Expert. She has nearly two decades of experience working with a wide variety of database platforms with a focus on SQL Server and the Microsoft Data Platform. She is a frequent speaker at IT industry conferences on topics including performance tuning and configuration management. She is the Leader of the Hampton Roads SQL Server User Group and a Mid‐Atlantic PASS Regional Mentor. She is passionate about SQL Server and the SQL Server community, doing anything she can to give back. Monica can always be found on Twitter (@sqlespresso) handing out helpful tips. You can find Monica blogging at sqlespresso.com
Mike Byrd
Twitter: - ByrdNest_TX
LinkedIn: Mike Byrd
Contact: http://logicalread.solarwinds.com/?s=byrd, www.TSQLMentoring.com and SQLServerCentral.com
Former rocket scientist and USAF Fighter Pilot – now a SQL Server geek (24 years)! Past opportunities include free-lance technical writer for PC Magazine, Senior Software Manager for government sponsored munitions effectiveness committee, and insurance company CTO. Currently senior database engineer consultant for several Austin companies.
Presenter at many SQLSaturdays over last 6 years in United States, Europe, and Australia.
Specialize in SQL Server performance tuning; database (OLTP OLAP) architecture; trouble-shooting; teaching TSQL (Basic through Advanced).
Video presentations (for local SQL Server user groups or SQLSaturdays) can be found at http://usergroup.tv/videos/category/speaker/mike-byrd
Travis Page
LinkedIn: Travis Page
Most recently a Senior Database Administrator with Jackson Hewitt, Travis is on the leadership team of the Pinellas SQL User group and an active member of PASS. Passionate about all things related to technology, he maintains a CISSP certification.
Jason Hall
Twitter: - @SQLSaurus
LinkedIn: Jason Hall
Contact: http://blogs.sqlsentry.com/jasonhall
Jason Hall (@SQLSaurus) leads SentryOne’s Product Management team, which is responsible for managing product design, development and delivery.
Jason has worked in varied technology roles for over 20 years and holds industry certifications including MCSE (legacy), MCSD, MCTS, MCPD, and PMC-III.
John Morehouse
Twitter: - SQLrUs
LinkedIn: John Morehouse
Contact: http://www.sqlrus.com
John Morehouse is currently a Consultant with Denny Cherry Associates living in Louisville, Kentucky. With over 2 decades of technical experience in various industries, John now focuses on the Microsoft Data platform and specializes in Microsoft SQL Server. He is honored to be a Microsoft Data Platform MVP, VMWare vExpert, Friend of Red Gate, Sentry One PAC member Community Ambassador, and 2016 Idera Ace. John has a passion around speaking, teaching technical topics, and giving back to the technical community as much as possible. He is a user group leader, SQLSaturday organizer, and former PASS regional mentor. He is also a blogger, avid tweeter, and a frequent speaker at SQLSaturday’s as well as other conferences.
Jonathan Stewart
Twitter: - sqllocks
LinkedIn: Jonathan Stewart
Contact: https://sqllocks.net/
Jonathan Stewart is a Business Intelligence consultant specializing in data visualization, data warehousing, and data management technologies. An advocate for educating others, he is a public speaker, teacher and blogger, continually teaching people about the Microsoft BI Stack. Since 2000, he has been working in the database field with industry leaders in healthcare, manufacturing, financial, insurance and federal, state and local governments.
Jonathan is very active in the community. He has presented on SQL Server, SSIS, Reporting Services, Power BI and Business Intelligence at numerous SQLSaturday events, local user groups, and conferences throughout the United States and around the world. He participates in webcasts, podcasts, and on
Pat Byrne
I have over 26 years of IT experience as a Tech Support Rep, Programmer, and Solutions Architect, with over 12 years in Business Intelligence and Data Warehousing, including the design and implementation of a data warehouse for a large K-12 public school district.
Sponsors
The following is a list of sponsors that helped fund the event: