SQLSaturday #827 - Cincinnati 2019
Event Date: 03/30/2019 00:00:00
Event Location:
- College of Education, Criminal Justice, and Human Services University of Cincinnati
- 250H Teachers-Dyer Complex
- Cincinnati, Ohio
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: Infrastructure for the DBA: An Introduction
Abstract: It doesn’t matter if you are a Junior DBA, an accidental DBA or all the way up to a Senior DBA, the infrastructure your SQL Server environment runs on is important. Many among the DBA community came in as developers or perhaps directly into database administration roles it is equally possible that you have been out of the operations world long enough to have fallen out of the loop with what is happening. This session is intended to provide a full stack infrastructure overview so that you can talk shop with your cohorts in operations to resolve issues and maybe even be proactive. We will discuss, in an introductory fashion, hardware, network, storage, virtualization and operating system layers. Additionally, some suggestions as to where to find more information will be provided.
Speaker(s):
- Peter Shore
Track and Room: Enterprise Database Administration Deployment - 537
Title: Azure Data Studio - The Open-Source, Cross-Platform, Cloud Database Tool for SQL
Abstract: Azure Data Studio (formerly SQL Operations Studio) is the modern, cross-platform database management tool for SQL Server, both on-premise and in the cloud. A simple, clean approach to a UI creates an experience different from other SQL management tools today. Fully integrated intellisense with customizable code-snippets, connection management, and dashboards, Azure Data Studio, provides the T-SQL editor experience most of us expect today. Unlike other tools, Azure Data Studio is 100% open-source, easily extensible, and has full integration to modern source control solutions like GIT. In this session, we introduce Azure Data Studio and interacting with SQL Server environments. We will focus on productivity comparable to SSMS, shortcuts and time savers, as well as how to leverage source control. Lastly, we will cover extending Azure Data Studio by setting up a development environment, and walking through the process of build and debugging a custom dashboard component, using Electron
Speaker(s):
- Andrew Loree
Track and Room: Cloud Application Development Deployment - 525
Title: Help Me SSIS Logging, You’re My Only Hope!
Abstract: When something goes wrong with your SSIS package and you need to tell your boss more than “I have a bad feeling about this…”, let the Force of SSIS logging save you from the dark side!
SSIS logging may be the last thing on your mind when starting a new project, but getting it right in the beginning is well worth your while. Logging can help troubleshoot errors, tackle inefficiencies, and even raise a red flag when there are issues in your data flow. Newer versions of SQL Server have brought new options for logging. Learn what information is available for each option along with how to implement custom logging when the built-in options aren’t robust enough for your project’s needs.
Speaker(s):
- Vanessa Kesten
Track and Room: BI Platform Architecture, Development Administration - 537
Title: Azure-d Availability: Scaling SQL Server to the Cloud
Abstract: Has your manager come to you and said “I expect the SQL Server machines to have zero downtime?” Have you been told to make your environment “Always On” without any guidance (or budget) as to how to do that or what that means? This session will walk you through the high availability options in on-premises SQL Server, the high availability options in Azure SQL Database, and how those can be combined to enable you to achieve the ambitious goals of your management. Beyond the academic knowledge, we’ll discuss real world case studies covering exactly how your on-premises environments and Azure services can work together to keep your phone quiet at night.
Speaker(s):
- Matt Gordon
Track and Room: Enterprise Database Administration Deployment - 504
Title: Getting Started with Apache Spark
Abstract: As companies work to gain insight from ever-increasing amounts of data, data platform practitioners need tools which can scale along with the data. Early big data solutions in the Hadoop ecosystem assumed that data sizes overwhelmed available memory, emphasizing heavy disk usage to coordinate work between nodes. As the cost of memory decreases and the amount of memory available per server increases, we see a shift in the makeup of big data systems, emphasizing heavy memory usage instead of disk. Apache Spark, which focuses on memory-intensive operations, has taken advantage of this hardware shift to become the dominant solution for problems requiring distributed data. In this talk, we will take an introductory look at Apache Spark. We will review where it fits in the Hadoop ecosystem, cover how to get started and some of the basic functional programming concepts needed to understand Spark, and see examples of how we can use Spark to solve issues like calculating PageRank.
Speaker(s):
- Kevin Feasel
Track and Room: Analytics and Visualization - 540
Title: Microsoft Machine Learning Services
Abstract: SQL Server 2017 Machine Learning Services is more than just R and Python language support for SQL Server. SQL Machine Learning Services provides analytics for any size of data, runs in SQL Server, or alongside Windows, Linux, HDInsight Spark or Hadoop clusters, is simple to administer and allows you to integrate and deploy simply. In this session, learn architecture and deployment options, stand-alone and in-database, along with some real-world use-cases. Learn how to leverage Machine Learning Services with new TSQL language support, training and deploying models, scaling beyond memory with RevoScaleR to generating millisecond predictions in-database. With any size data environment, SQL Machine Learning Services can provide analytics in both an operationally sound and easy to administer paradigm.
A beginner level understanding of Machine Learning and process is highly recommended but not required. Beyond SQL Machine Learning Services, an overview of all Microsoft Machine Learning
Speaker(s):
- Andrew Loree
Track and Room: Analytics and Visualization - 525
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 - 138
Title: Building the HASSP: Putting SQL Server In Space
Abstract: In today’s world, technology is a pervasive part of our lives. We have “smart” appliances everywhere: from cars, thermostats, and even refrigerators contain built-in systems to collect, store, and transmit data. Small embedded devices can also be used for scientific purposes as well, offering new and exciting ways to collect data for studies or projects at home.
The High-Altitude SQL Server Project, or HASSP, is one such project.
The HASSP team has created a high-altitude balloon that uses sensors to collect various data points and store the results in an embedded version of SQL Server!
In this session, you’ll hear about how this is possible: we’ll discuss the hardware used, the custom device that we built, and the software used to make it all work together. Best of all, you’ll see how to recreate (and hopefully improve!) the project on your own.
Speaker(s):
- Drew Furgiuele
Track and Room: Professional Development - 533
Title: Populating a Data Warehouse with SSIS and Biml Patterns
Abstract: This session will demonstrate how to leverage “Biml powered SSIS Patterns”, to rapidly build SSIS packages. The focus of this session will be on populating a data warehouse, however the concepts presented could be applied to any ETL/ETL scenarios. The components used during this session: BimlSnap_v2 (an Open-Source, Biml integrated SQL Server database), and BimlExpress (a Visual Studio Add-in used to generate SSIS package) are both available at no charge. In addition, attendees will receive a ‘SQL Server Metadata Manager’ solution, along with a fully integrated SSIS Framework. Attend to see how Biml can revolutionize your SSIS development!
Speaker(s):
- Jim Miller
Track and Room: BI Platform Architecture, Development Administration - 533
Title: AzureVM + Log Shipping + Automation = Bargain Basement DR Solution (How To)
Abstract: Operating on a budget can result in some creative solutions. Recently I’ve come up with a creative solution for traditional on-premise client-server solutions that allows for full redundancy in the cloud, but at a budget price. This is accomplished through VMs, copying of logs to Blob Storage, automation of hydration, updates de-allocation. It may be a bit of a Rube Goldberg machine, but it works! The result is an extremely pro-rated and affordable DR solution that is within 1 hour or less of production in restorability. Come to this session to learn more about the hurdles faced when putting this solution together and to brainstorm together how it can even be improved.
Speaker(s):
- Mindy Curnutt
Track and Room: Enterprise Database Administration Deployment - 537
Title: “Black Arts” Index Maintenance #1: How the “Best Practice” Methods are Silently Killing Performance
Abstract: Most people don’t realize it but the current “Best Practice” Methods are actually a leading cause of perpetual logical and physical fragmentation, totally unnecessary wasted memory, costly and continuous “Bad” page splits, unexplainable blocking, comparatively insane amounts of log file generation and, in an interesting “Catch 22”, a major part of why we have to do so much index maintenance.
This isn’t your typical presentation on Index Maintenance.
In this first of two back-to-back sessions on the subject, we’ll explore what happens to an index in the first year of its life for four different common Fill Factors along with how “Best Practice” methods executed once per week and once per day have their way with you, your indexes, your log files, wasted memory, and the performance of your code even if it’s perfect code. We’ll also introduce a new way to graphically see actual index structure using a new “Black Arts” stored procedure called “sp_IndexDNA” that you have to see to believe.
Speaker(s):
- Jeff Moden
Track and Room: Enterprise Database Administration Deployment - 540
Title: “Black Arts” Index Maintenance #2: Better Methods that Can Actually Prevent Fragmentation for Weeks.
Abstract: Most people don’t realize it but the current “Best Practice” Methods are actually a leading cause of perpetual logical and physical fragmentation, totally unnecessary wasted memory, costly and continuous “Bad” page splits, unexplainable blocking, comparatively insane amounts of log file generation and, in an interesting “Catch 22”, a major part of why we have to do so much index maintenance.
This isn’t your typical presentation on Index Maintenance.
In this second of two back-to-back sessions, we’ll learn of several incredibly easy modifications to your Index Maintenance routines to actually prevent fragmentation for weeks rather than perpetuating it, virtually eliminate “Bad” page splits, reduce wasted memory, make your log file log file backups a whole lot more happy and increase the overall performance of even perfect code.
We’ll also learn that no simple method is a panacea, what to do about the horror of “expAnsive” updates, and how to make even GUID-keyed indexes work well.
Speaker(s):
- Jeff Moden
Track and Room: Enterprise Database Administration Deployment - 138
Title: Successfully Virtualizing SQL Server on vSphere - Straight from the Source
Abstract: Over the years, virtualization has matured from the exotic black magic realm to become a mainstream standard IT practice. quot;Virtualize Firstquot; is now a well-accepted default practice in most enterprises and any deviation is now considered an anomaly. In spite of this trend, many IT administrators and architects still have some reservations about virtualizing SQL Server workloads. They consider SQL too quot;criticalquot; to be virtualized; they wonder and worry about scale about performance; they are looking for guidance and reassurance. If this is where you (or your clients) are today, be sure to attend this session. You will gain valuable insights from what others have done to successfully undertake similar tasks in their environments. We will talk about configuration pitfalls to avoid and also review the configuration and current performance data for some of the most demanding applications in customers environments. Got an SQL virtualization or performance question? Bring i
Speaker(s):
- Deji Akomolafe
Track and Room: Strategy and Architecture - 528
Title: Hello My Friends, Welcome to CosmosDB
Abstract: Microsoft says Azure Cosmos DB is a globally distributed, multi-model database. Your reaction might be something like, “what the heck is it”, “why would I use it”, or “how do I use it”. The fundamental purpose of this session is to answer those very questions. After briefly discussing what CosmosDB is, we’ll take some time to discuss why you might use CosmosDB instead of SQL Server or another platform, and finally touch on some basics to get you started with CosmosDB. Upon completion of this session you will be better equipped to discuss the value of CosmosDB to your organization.
Speaker(s):
- Peter Shore
Track and Room: Cloud Application Development Deployment - 540
Title: Applying Visual Design Best Practices in Power BI
Abstract: This session will focus on the how to of visual design in Power BI and equip you to take your report designs to the next level! We will create and implement custom report themes, demo how to design reports for different audiences in your organization and explore how to use Power BI’s out of the box formatting options to help you deliver consistent and effective reports.
Speaker(s):
- Michael Hewitt
Track and Room: Analytics and Visualization - 138
Title: Python in SQL Server 2017
Abstract: SQL Server 2017 has finally arrived, bringing with it a host of exciting new features. Of particular interest to BI practitioners and data scientists is the integration of the Python programming language into the SQL ecosystem. This integration opens up a number of possibilities for in-database analytics and intelligent database applications, so let’s get started!
In this introductory session we’ll briefly introduce the Python language and then look at how to install and administer Machine Learning Services. We’ll start to demonstrate the power of Python by showing you how to create and run simple 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 Python to integrate data analytical methods in real-world situations, and wow your customers with the power of analytics!
Speaker(s):
- Chris Hyde
Track and Room: Advanced Analysis Techniques - 533
Title: SQL Server Database Security: Do Your Part, Be Security Smart!
Abstract: With data being stolen nearly daily from even the most prestigious companies, data security should be at the forefront of all keepers of database servers and server instances. How can your SQL Server data get in the wrong hands? What are some common SQL Server specific security considerations? What are the best practices? When and where should they be implemented? What techniques for security can be used in SQL Server? What can I do as a DBA or Developer to ensure data is secured in all environments? Tips and troubleshooting with real world DevOps experience will be presented to attendees to identify the most common but hardest to resolve issues. Some topics to be discussed will be Data Masking, Security Groups, Named Instance security, and Linked Servers.
Speaker(s):
- Julie McLain-Harper
Track and Room: Enterprise Database Administration Deployment - 504
Title: Who’s Pissing in Your Data Lake?
Abstract: The new data terms of Data Lake, Data Reservoir, and Data Swamp have left me with more questions than answers. In this presentation, Karen discusses the types of data anomalies that organizations can run into when they use external data, the wrong datasets for the right reasons and the right datasets for the wrong reasons.
These errors in design, oversights and old school, traditional practices can impact the success of your projects, even if you don’t use any data lakes.
We’ll look at end-to-end processes, data capture issues, impractical designs, balancing performance against data quality. I’ll be using examples from my own personal data to show you just how my data has been mistreated in IT systems. Plus we’ll talk about your data and your data stories.
We will build a list of good practices and tools to use to spare you from a flood of data issues in your organization.
Speaker(s):
- Karen Lopez
Track and Room: Application Database Development - 525
Title: Demystifying Data Compression
Abstract: SQL Server 2016 SP1 makes data compression available in all editions. Data compression can reduce storage costs, and provide a performance boost—and now compression is available without the added cost of Enterprise Edition. Whether you are a developer or a DBA, it’s important to know how to use compression to save money and improve speed.
Come learn about how data compression actually works, the differences between ROW and PAGE compression, and learn how to pick the best compression level for your data. This session will cover the details of the compression algorithms, and the costs and benefits associated with each type of compression.
By the end of this session, you’ll have a better idea of how the different compression algorithms work, when compression is the right solution, as well as what type of compression to use.
Speaker(s):
- Andy Mallon
Track and Room: Application Database Development - 504
Title: Your SQL Servers are misconfigured
Abstract: Your SQL Servers are misconfigured!
And it is probably not your fault.
90% of the SQL Servers I have seen in my 18 year career are just wrong. Not “crash” or “won’t start” wrong. More like “why is the website so slow” wrong.
We are going to roll through a clean install and look at some things that can be made right during the install. And then we will look at some configurations that can only be done after the install.
Things like:
Instant File Initialization Backup Compression MAXDOP TempDB configuration Cost Threshold for Parallelism And more if we have time!
Fair warning…I’m going to overuse the phrase “It Depends”
Dallas DBAs is dedicated to helping you find these issues, test them, remediate them and get the most stability, reliability and performance out of your SQL Server.
Speaker(s):
- Kevin Hill
Track and Room: Enterprise Database Administration Deployment - 533
Title: Azure Data Factory Ingestion Framework
Abstract: In this session we will discuss Data Strategy around data lake ingestion and how that shapes the design of a framework to fuel Azure Data Factory. This session will take you through the development of a Metadata database designed using Data Vault modeling, the collection of the metadata, as well as building a fully automated Data Factory pipeline.
Speaker(s):
- Sean Forgatch
Track and Room: BI Platform Architecture, Development Administration - 528
Title: Better Together: Power BI Dataflows and Azure Data Lake Storage
Abstract: Power BI Dataflows bring advanced self-service data preparation capabilities to power users and business analysts. Azure Data Lake Storage offers massively scalable and performant storage solution for enterprise big data analytics. The ability to integrate Power BI Dataflows with Azure Data Lake Storage promises to open a new set of opportunities for collaboration between business analysts, data engineers, and data scientists. In this demo-rich session, we’ll take a look at an example of such collaborations and discuss the questions and limitations that you should consider as you begin working with these services.
Speaker(s):
- Slava Trofimov
Track and Room: BI Platform Architecture, Development Administration - 540
Title: A Beginners Guide to Transactions
Abstract: This session is for the absolute beginner to learn the basics of Transactions and will answer questions such as, What is a Transaction? What are the ACID properties of a Transaction? How does the Transaction Log work to provide consistency to a database? What is a checkpoint? Are dirty pages bad or good? What is a lock? 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 - 533
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 - 528
Title: Azure Migration Options for the SQL Server BI Stack
Abstract: The SQL Server Analytics\BI stack is widely used and mature. Azure PaaS offerings have matured greatly well beyond just Azure SQL DB the last couple of years. This session is designed for SQL Server professionals who want to expand their knowledge set to Azure or those interested in learning more about Azure data solution options. The focus will be on SQL Server on-premise (or on Azure VM\IaaS) to Azure equivalences, complementary tools, and hybrid approaches and possible challenges. Azure SQL DB, Azure SQL DW, Azure Data Factory, Azure Analysis Services, Power BI and more will be covered.
Speaker(s):
- David Mellinger
Track and Room: BI Platform Architecture, Development Administration - 528
Title: Statistics - Why are they there and what do I do with them
Abstract: In this session you will learn the basics of statistics and what they are used for. You will learn how to gather information about the statistics and how to use the information to improve performance. It is important the statistics are maintained to work properly so we will also discuss what on going maintenance should be done on statistics.
Speaker(s):
- Dave Bland
Track and Room: Enterprise Database Administration Deployment - 525
Title: Understanding and making good decisions on SQL licensing
Abstract: SQL licensing is not the most exciting part of the job for a lot of people, but it is one of the most expensive. The decisions that are made regarding this can have a significant cost benefit or consequence to your organization. In this session, we will dive through each of the ways you can license, review common misconceptions and discuss optimization opportunities you can start using immediately.
Speaker(s):
- Dustin Dorsey
Track and Room: Enterprise Database Administration Deployment - 537
Title: Snowflake - The Data Warehouse Built For The Cloud
Abstract: Snowflake is the only data warehouse built for the cloud, enabling the data-driven enterprise with instant elasticity, secure data sharing and per-second pricing across multiple clouds. Snowflake combines the power of data warehousing, the flexibility of big data platforms and the elasticity of the cloud at a fraction of the cost of traditional solutions. Snowflake: Your data, no limits. Find out more at snowflake.com.
Come by the Snowflake booth to learn more.
Speaker(s):
- Ryan Morris
Track and Room: Advanced Analysis Techniques - 540
Title: Getting Started with Azure Databricks
Abstract: Azure Databricks is gaining a large amount of momentum as it helps many organizations tackle large big data, advanced analytics, and streaming workloads. In this session, you will be introduced to the Azure Databricks platform, how it can fit into your architecture, and how you can get started using the platform today.
Speaker(s):
- Todd Walker
Track and Room: Advanced Analysis Techniques - 525
Title: Optimizing the ETL Development Process with BIML
Abstract: In this discussion, we will overview the benefits Biml can bring to the ETL Development process. How used in conjunction with other languages like SQL and PowerShell, can build out large scale ETL packages in a fraction of the time it would take under traditional SSIS development.
Speaker(s):
- Joshua Higginbotham
Track and Room: BI Platform Architecture, Development Administration - 540
Title: AI Cognitive Services: Vision 101
Abstract: Are you curious about Visual Recognition and Object Detection in Azure? Are you wondering what the difference is between the Computer Vision API and the Custom Vision API? Do you want a quick introduction to get you up to speed on both, so that you can quickly build and deploy a Cognitive Services model?
Join us for an introduction to the Cognitive Services Computer Vision and Custom Vision APIs on Azure.
In this session, we will look at the basics of Cognitive Services Vision. First learn how to create your Cognitive Services model. Then you can see how to train and improve accuracy. Finally, we will step through python code in Azure Notebooks to call the APIs.
Speaker(s):
- Alicia Moniz
Track and Room: Advanced Analysis Techniques - 528
Title: DBA - What’s Most Important
Abstract: There are so many topics for a DBA to focus on that it can be overwhelming, especially for a new or accidental DBA. Without knowing what’s most important, you can find yourself spending lots of time trying to figure out what’s important. This session focuses on the five topics that matter most to a DBA, whether you’re an aspiring DBA, a new DBA or a seasoned professional.
Speaker(s):
- Ed Wagner
Track and Room: Enterprise Database Administration Deployment - 504
Title: Stretch DB – Moving your SQL Server Database to the Cloud One Record at a Time
Abstract: Ok… so maybe it is 9,999 records at a time. New with SQL Server 2016, this technology allows a hybrid way to separate their cold and hot data with minimal code changes.
Clark will share his real world experience with trying to implement Stretch DB as well as a demonstration of the setup using both the wizard and T-SQL scripts.
Speaker(s):
- Clark Hahn
Track and Room: Strategy and Architecture - 140
Title: Are you following SQL Server Development Best Practices?
Abstract: Coding is always a fun but challenging job. Developers do not only have to execute the right output based on the business requirement but also need to maintain right coding standards by using the optimum use of variable sizes and keeping in view the other best practices. The session will cover the key best practices which developers can follow and get benefited. Many of us already may have been using these steps already but for those who are new to the development process or want to brush up, the session is for you.
Speaker(s):
- Sourav Mukherjee
Track and Room: Enterprise Database Administration Deployment - 540
Title: Install Configure SQL Server with PowerShell DSC
Abstract: Get on the cutting edge by implementing infrastructure as code for your SQL Server environment. Using PowerShell Desired State Configuration (DSC) we’ll look at how to take a newly built Windows Server and get it ready for prime time while discussing the benefits associated with infrastructure as code.
- Setup Pre-Requisites
- Install SQL Server
- Configure SQL Server
- Make SQL Server Application Ready
Speaker(s):
- Jess Pomfret
Track and Room: Enterprise Database Administration Deployment - 528
Title: PBI Dataflows for the BI Pro
Abstract: New Power BI features such as Dataflows are blurring the lines between a citizen BI developer’s role and a professional BI developer’s role. In this session we’ll look at how PBI Dataflows should be used by a professional BI developer (hint… AI is one reason) and when more robust analytic tools should be used.
Speaker(s):
- Josh Burgin
Track and Room: BI Platform Architecture, Development Administration - 504
Title: Lambda architecture design using Azure Databricks for advanced analytics
Abstract: In this session, we will review the history of Azure Databricks, world records it broke, and how to accelerate your data platform solutions. We will cover lambda architecture, Azure Databricks components, and how to integrate other Microsoft Azure services. Then we will see a demonstration on creating clusters, notebooks, team collaboration, and advanced analytics. Finally, we will take a look at additional information on how to further utilize Azure Databricks.
Speaker(s):
- Lucas Feiock
Track and Room: Cloud Application Development Deployment - 533
Title: Encryption: Not just for the NSA anymore
Abstract: Are you interested in data encryption? Do you store sensitive data in SQL Server databases? Does GDPR affect your company? If you answered yes to any of these questions then this session is for you. In this session we will introduce and implement 4 methods of encryption available in SQL Server –Backup encryption, Transparent Data Encryption, AlwaysEncrypted, and connection encryption.
Speaker(s):
- Eric Blinn
Track and Room: Enterprise Database Administration Deployment - 525
Title: Data Visualization: How to truly tell a great story!
Abstract: We have more information available to us today than ever before. So much so that we run the risk of not being able to tell concise stories. There’s a lot more to creating that story than just getting the correct information. Come learn not just the do’s and don’ts, but the whys…
Speaker(s):
- Jonathan Stewart
Track and Room: Analytics and Visualization - 537
Title: Deep Into the Cosmos(DB)
Abstract: Have you ever wanted to see what an end-to-end solution looks like with Cosmos DB? Well look no further, in this session we will be pulling back the covers and walking through a scenario (with code) which is using Cosmos DB, Databricks, and Machine Learning to create great experiences for retail customers.
Speaker(s):
- Anthony Mattas
Track and Room: Cloud Application Development Deployment - 504
Title: Get Near Realtime ETL with Service Broker
Abstract: Most of the time you’ll see ETL being done with a tool such as SSIS, but what if you need near-realtime reporting? You need to get the updates in your OLTP database to the Data Warehouse quickly, but with minimal impact on your application. This session will demonstrate how to keep your data warehouse updated in near real-time using Service Broker messages from your OLTP database.
Speaker(s):
- Allen White
Track and Room: Application Database Development - 140
Title: Migrate Your Database 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 - 537
Title: Data Time Travel with SQL Server Temporal Tables
Abstract: Many times developers have to support users by answering the “What happened to the data?” The task of retrieving data from a specific point in time is not an easy one. Often this involves retrieving a backup and restoring the data in question (hopefully!). SQL Server 2016 introduced Temporal Tables, allowing a developer to retrieve data from a specific point in time, without backups. With a few TSQL commands a historical table can be created, automatically updated, and readily accessed.
Speaker(s):
- Sam Nasr
Track and Room: Application Database Development - 533
Title: The Curious Case of the Foreign Key
Abstract: Foreign keys are basic constraints used widely in database design. This session will show how they can improve performance when used correctly. There are, however, some options that developers need to use with care because they can degrade performance significantly… and sneakily!
Speaker(s):
- Lisa Bohm
Track and Room: Application Database Development - 140
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Jess Pomfret
Twitter: - https://twitter.com/jpomfret
LinkedIn: Jess Pomfret
Contact: http://jesspomfret.com
Jess Pomfret is a SQL Server DBA at Westfield Group in Westfield, Ohio. She started working with SQL Server in 2011 and currently works as part of a team administering over 100 instances ranging from 2005 to 2017. She enjoys the problem-solving aspects of performance tuning and automating processes with PowerShell.
She also enjoys contributing to dbatools and dbachecks, two open source PowerShell modules that aid DBAs with automating the management of SQL Server instances.
She grew up in the South West of England and outside of her DBA life enjoys Crossfit, cycling and watching proper football.
Andy Mallon
Twitter: - AMtwo
LinkedIn: Andy Mallon
Contact: http://www.AM2.co
Andy is a Data Platform MVP and SQL Server DBA that has managed databases in the healthcare, finance, e-commerce, and non-profit sectors. He has been supporting high-volume, highly-available OLTP environments with demanding performance needs since 2003.
Andy is the founder of the BostonSQL User Group, and previous co-organizer of SQLSaturday events in Boston. He blogs at am2.co.
Andy lives just outside Boston, Massachusetts, USA with his husband and their two dogs.
Ryan Morris
LinkedIn: Ryan Morris
Sales Director for Snowflake based out of Cincinnati, Ohio. Focused on empowering every organization to become data driven. Enabling better, quicker business decisions, while reducing the costs associated with managing and scaling data analytics.
Lisa Bohm
Twitter: - LisaGB_SQL
LinkedIn: Lisa Bohm
Contact: http://www.lisagb.info
Lisa started in IT as a web developer. Designing databases as back ends for the web applications left the desire to learn more about solid design and coding for SQL performance. She has been on an ongoing mission to learn and improve code wherever she goes.
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.
Alicia Moniz
LinkedIn: Alicia Moniz
Alicia Moniz is a Microsoft AI MVP. She authors the blog HybridDataLakes.com, a blog focused on cloud data learning resources. Alicia has been in the Database/BI services industry for 14+ years and is an expert in T-SQL, Data Modeling, Database Administration, Analytics, Data Visualization, and Data Warehousing. Her skill set spans SQL Server 2005 through 2016 and Azure. She has hands on experience architecting, developing, and optimizing BI solutions in the Microsoft ecosystem.
Alicia holds certifications for both AWS/Azure Architect and AWS/Azure Big Data, and is a Microsoft Certified Solution Expert (MCSE): Data Management and Analytics.
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
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.
Michael Hewitt
Twitter: - mdhewitt83
Michael works as a business intelligence developer based out of Nashville, TN. My primary interests are data visualization, data storytelling, UI/UX, PowerBI, Tabular modelling, and using the technology tools available to make business better! When I’m not nerding out with data, I can be found spending time with my wife and 3 kids, serving my church community, playing drums or hiking.
Julie McLain-Harper
LinkedIn: Julie McLain-Harper
As “The Goddess of the Database”, I am a Sr DBA, Technical Professional and Microsoft Certified Trainer who has over 25 years of experience and a passion for EDUCATING, new technology, system performance and troubleshooting. My experience started with Hierarchical Databases and thankfully moved to Relational Databases, Open Systems technology, and SQL Programming. Because of my desire to give Developers a new perspective on their process of interacting with database data, I began educating co-workers and then training others in SQL Programming best practices. I have significant background as a professor/educator; a Sr. DBA; in performance tuning; as a data, app and infra architect; an Adopter of PowerShell and am MCSA Certified.
Kevin Hill
Twitter: - @Kevin3NF
LinkedIn: Kevin Hill
Contact: http://www.dallasdbas.com/Blog
I have been working with Microsoft Database technologies since 1994, in Design, Data Modeling, Development and Administration. 18 years of that time have been with SQL Server, going all the way back to 6.5.
I find that I am most passionate about the Admin and HA/DR side, but will still dive into design when called upon.
The Azure cloud is exciting and I believe is the future of SQL Server. I love teaching new and accidental DBAs all of the things I didn’t know when I started.
Ed Wagner
Ed is a Senior DBA with more than 27 years experience in database development and administration. He enjoys high-performance and “black arts” SQL. He’s a member of SQL PASS In Detroit (SPID) and a frequent poster on SQLServerCentral.com. He’s passionate about SQL Server and actually enjoys it.
Sean Forgatch
Twitter: - 4gatchsql
LinkedIn: Sean Forgatch
Contact: https://www.modern-dataengineering.com
Sean Forgatch is a Manager in Data Engineering consulting Avanade\Accenture based out of Chicago, IL focusing on Data Strategy, EIM , and Data Archtiecture. Serving multiple Fortune and Global 500 companies he has helped push the limits of Azure and is working on some of the largest Azure Data Lake and Analytics implementations in the industry. He has spoken at over 25 conferences across the United States since 2016, was the President of the Northeast Wisconsin PASS, and served on the board for SQLSaturday Madison.
Originally from Southern Illinois, Sean enjoys running and lifting, as well as casual conversations with coffee, and spending time with his dog Sailor, an all white Siberian Husky.
Slava Trofimov
LinkedIn: Slava Trofimov
Slava Trofimov has over 15 years of experience in leading business transformation using data and and analytics. He currently works as a Cloud Solution Architect at Microsoft, specializing in Data AI.
Todd Walker
Todd Walker manages the Data AI team for the Cincinnati branch of Insight Digital Innovation (previously Cardinal Solutions). Todd has delivered projects for local clients in the BI, Data Warehousing, Big Data, Advanced Analytic, and Cloud over the past 11 years and is driven to help customers use a data-centered approach to make decisions and solve problems.
Sam Nasr
Twitter: - SamNasr
LinkedIn: Sam Nasr
Contact: http://samnasr.blogspot.com/
Sam Nasr has been a software developer since 1995, focusing mostly on Microsoft technologies. He’s a Sr. Software Engineer with NIS Technologies where he consults and teaches clients about the latest .Net technologies. Sam has achieved multiple certifications from Microsoft (MCSA, MCAD, MCTS, MCT), and is the leader of the Cleveland C#/VB.Net User Group since 2003. In addition, he’s the leader of the .Net Study Group, an author for Visual Studio Magazine, and a Microsoft MVP since 2013. When not coding, Sam loves spending time with his family and friends or volunteering at his local church.
Peter Shore
Twitter: - pshore73
LinkedIn: Peter Shore
Peter Shore is a seasoned IT professional with over 25 years of experience. He took the accidentally intentional DBA plunge in 2013 and has discovered that he loves to find the stories the data has to tell. Peter is comfortable working with both physical and virtual servers, where he tries to apply best practices to attain performance improvements. He is also adept at bridging the gap between technical and business language in order to bring technology solutions to business needs.
Jim Miller
LinkedIn: Jim Miller
Contact: https://https://www.bitracks.com/blog
Jim has worked in various facets of the IT business for over 30 years, with a primary focus on data warehousing, reporting and analytics, business intelligence, data modeling (relational, multi-dimensional), ETL frameworks, database architecture, as well as database performance tuning. In previous engagements, Jim has fulfilled roles as Data Architect, DBA, IT Director, and Senior Consultant. He also has experience in account management, marketing/technical support, and software application training. Jim has also had some extraordinary opportunities to lead IT organizations, with multinational participants, on reconstruction projects based in Bosnia and Iraq.
Anthony Mattas
Twitter: - amattas
LinkedIn: Anthony Mattas
Contact: http://www.anthonymattas.com
Anthony Mattas is a Sr. Solution Architect on a world wide team at Microsoft focused on helping customers with distributed data systems.
Anthony has a B.S. in Computer Science Theory and Analysis from Western Michigan University, has multiple MCSE certifications, and is a Microsoft Certified Trainer.
Prior to joining Microsoft Anthony worked as a Business Intelligence consultant for the Microsoft Partner BlueGranite, and also formerly Technical Lead and Architect for a large medical device manufacturer’s global business intelligence platform.
Sourav Mukherjee
Twitter: - https://twitter.com/sourav_tech
LinkedIn: Sourav Mukherjee
Sourav Mukherjee is a Senior Database Administrator based out of Chicago. He has more than 12 years of experience working with SQL Server Platform. His work focus in Microsoft SQL Server started with SQL Server 2000. Being a Consultant worked with different Chicago based client projects. He has helped many companies in designing and maintaining their high availability solutions and providing query performance tuning to improve the overall SQL Server performance.
He holds a bachelor’s degree in Computer Science, Master’s Degree in Project Management. He is an MCT (Microsoft Certified Trainer) and TOGAF, PMP and ITIL Certified. He writes articles and blogs in LinkedIn and other social media sites.
Deji Akomolafe
Twitter: - @dejify
Contact: http://blogs.vmware.com/apps
Deji Akomolafe (a member of the Office of the CTO Ambassador Program and Staff Solutions Architect within VMware#39;s Global Field and Partners Readiness Group) specializes in the virtualization of Microsoft Business Critical Applications on VMware#39;s vSphere platform. Deji is a regular speaker at VMworld, Partners Exchange Conference, VMUG, SQLSaturday and EMCWorld, presenting technical subject matters related to Microsoft Applications virtualization and providing technical guidance to help clients enhance their expertise and ability to optimally virtualize and operate their critical applications.
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.
Mindy Curnutt
Twitter: - @sqlgirl
LinkedIn: Mindy Curnutt
Contact: http://www.mindycurnutt.com
Mindy Curnutt is a 5X Microsoft Data Platform MVP, Business Owner and Entrepreneur. Her specialties include SQL Server hardware, configuration, migrations, scalability, performance tuning. She has been actively involved in the SQL Server Community for over two decades and has become a well known speaker within the SQL and Transportation Management communities. She is a two-time PASS Volunteer of the Month, has presented at 6 SQLPASS Summits, Live360, DevConnections, MVPMix and too many SQLSaturdays to count. She is currently the President of the North Texas SQL Server User Group out of Dallas/Fort Worth, TX.
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.
Allen White
Twitter: - SQLRunr
LinkedIn: Allen White
Contact: http://dataperfpro.com/blog/
Allen White is a Data Platform consultant. He has been both a developer and an administrator, so he understands both perspectives towards database technology. He loves sharing his experiences and helping people learn how to use SQL Server. Allen has spent over 40 years in IT, using SQL Server since 1992, and has been awarded Microsoft’s MVP Award for the last 13 years. Allen was a PASS Director from 2016 - 2018.
Matt Gordon
Twitter: - sqlatspeed
LinkedIn: Matt Gordon
Contact: http://www.sqlatspeed.com
Matt is a Microsoft Data Platform MVP and has worked with SQL Server since 2000. He is the leader of the Lexington, KY PASS local group and a frequent domestic and international community speaker. He’s an IDERA ACE alumnus and 2020 Friend of Redgate. His original data professional role was as a database developer, which quickly evolved into query tuning work that further evolved into being a full-fledged DBA in the healthcare realm. He has supported several critical systems utilizing SQL Server and managed dozens of 24/7/365 SQL Server implementations. He currently utilizes that real world experience as a data platform consultant helping clients design solutions that meet their ever-changing business needs.
Vanessa Kesten
Twitter: - VanessaEHL
LinkedIn: Vanessa Kesten
Vanessa Kesten is a Data Engineer with BrightSpring Health Services. She is an Microsoft Certified Solutions Expert (MCSE) in Data Management and Analytics. Vanessa has over a decade of experience with the Microsoft BI Stack and has led large scale deployments of data warehousing solutions and has worked in a variety of industries, including manufacturing, health insurance, and government contracts.
Eric Blinn
Twitter: - @SQL2TheSequel
LinkedIn: Eric Blinn
Contact: https://ericblinn.com/
Eric has been a SQL Server DBA in the legal, software, transportation, and insurance industries for over 10 years. Currently he is the Sr Data Architect for Squire Patton Boggs, a leading provider of legal services with 47 offices in 20 countries.
Eric is a 2018-2019 Idera Ace and has co-authored 2 Idera Whitepapers.
He has been a presenter at PASS Summit, SQLSaturdays, the in.sight transportation conference, and the Ohio North SQL Server User’s Group.
Drew Furgiuele
Twitter: - pittfurg
LinkedIn: Drew Furgiuele
Contact: http://www.port1433.com
Drew Furgiuele is a senior DBA that lives in Dublin, Ohio who is passionate about SQL Server and PowerShell. He’s been working with SQL Server since 2002. When he’s not accidentally dropping tables in production, he likes writing automation scripts, blogging about SQL Server Replication, wiring electronics, playing board games, and spending time with his dog. He’s also not embarrassed by his Spotify playlists.
Dave Bland
Twitter: - @SQLDave29
LinkedIn: Dave Bland
Contact: https://www.davebland.com
Over 20 years of SQL Server experience that includes being a DBA, BI development and Application development using VB.NET. Dave currently is the Manager of the DBA team at Stericycle. Dave is a Friend of Red-Gate for 2019. He is a frequent presenter at SQLSaturday events and user groups around the country. Has been teaching SQL Server since version 2000 and is the SQL Server instructor at Harper College in Palatine, IL. Current certifications include: • Microsoft Certified Trainer • MCTS: SQL Server 2008, Implementation and Maintenance • MCTS: SQL Server 2008, BI Development and Maintenance • MCSA: SQL Server 2008 • MCSA: SQL Server 2016 • MCSE: SQL Server 2016 - BI • MCDBA: SQL Server 2000 • MCSD • MCSE: Data Management and Analytics
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.
Kevin Feasel
Twitter: - feaselkl
LinkedIn: Kevin Feasel
Contact: http://www.catallaxyservices.com
Kevin Feasel is a Microsoft Data Platform MVP and CTO at Envizage, where he specializes in data analytics with T-SQL and R, forcing Spark clusters to do his bidding, fighting with Kafka, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL (https://curatedsql.com), president of the Triangle Area SQL Server Users Group (https://www.meetup.com/tripass), and author of PolyBase Revealed (https://www.apress.com/us/book/9781484254608). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather’s nice enough.
Jeff Moden
With more than 51,000 posts and 39 mostly 5 star articles, Jeff Moden is a strong contributor on SQLServerCentral.com where he coined the term “RBAR” (Row By Agonizing Row) and helped make the “Tally Table” a household name. Jeff has more than 2 decades of experience with SQL Server and is mostly self-trained in what he calls the “Black Arts” of T-SQL. He’s known worldwide for his informative articles, high performance T-SQL coding methods, and methods of mentoring. His dedication to helping others earned him the MS SQL Server MVP award for nine years and the RedGate Exceptional DBA Award in 2011. His mantra is “Performance is in the code”.
Josh Burgin
Twitter: - @joshbdata
LinkedIn: Josh Burgin
Helping people turn data into knowledge using Microsoft products.
Clark Hahn
Twitter: - @ClarkHahn
A Data Professional with over 30 years experience. Working with SQL server exclusively since 2010. Currently working with the State of Ohio to perform migrations to Azure on many data related activities.
Peter Shore
Twitter: - pshore73
LinkedIn: Peter Shore
Peter Shore is a seasoned IT professional with over 25 years of experience. He took the accidentally intentional DBA plunge in 2013 and has discovered that he loves to find the stories the data has to tell. Peter is comfortable working with both physical and virtual servers, where he tries to apply best practices to attain performance improvements. He is also adept at bridging the gap between technical and business language in order to bring technology solutions to business needs.
Lucas Feiock
Twitter: - @LucasFeiock
LinkedIn: Lucas Feiock
Contact: https://sql-stack.com
Lucas Feiock is a Senior Business Intelligence Consultant with KiZAN Technologies. He has four years of experience with the Microsoft BI Stack. In addition to data warehousing, data integration and data visualization, Lucas is also involved with machine learning and advanced analytics. He has experience working in multiple industries including manufacturing, sales, gas and electric utilities, and health care.
Andrew Loree
Twitter: - @LowOnDiskSpace
LinkedIn: Andrew Loree
Contact: http://www.andyloree.com
Andrew Loree has over nineteen years of database experience with roles in architecture, design, development, and implementation of enterprise-scale SQL Server data solutions, supporting industries from legal e-discovery to manufacturing. Areas of expertise since SQL Server 2000 include data migration and ETL/ELT solutions, disaster recovery planning, high availability service design, licensing and virtualization. Andrew holds fourteen Microsoft certifications, has both a Bachelor and Masters of Science in Computer Science from Wright State University and is a Columbus (Ohio) PASS board member.
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.
Jeff Moden
With more than 51,000 posts and 39 mostly 5 star articles, Jeff Moden is a strong contributor on SQLServerCentral.com where he coined the term “RBAR” (Row By Agonizing Row) and helped make the “Tally Table” a household name. Jeff has more than 2 decades of experience with SQL Server and is mostly self-trained in what he calls the “Black Arts” of T-SQL. He’s known worldwide for his informative articles, high performance T-SQL coding methods, and methods of mentoring. His dedication to helping others earned him the MS SQL Server MVP award for nine years and the RedGate Exceptional DBA Award in 2011. His mantra is “Performance is in the code”.
Karen Lopez
Twitter: - @datachick
LinkedIn: Karen Lopez
Contact: http://datamodel.com
Karen Lopez is a Sr. Project Manager and Architect for InfoAdvisors. A frequent speaker at conferences and local user groups, she has 20+ years of experience in project and data management on large, multi-project programs. Karen is a chronic volunteer, a Data Platform MVP, and an active advocate for science, technology, engineering, and mathematics (STEM) education and data quality.
Karen’s presentations are known for their lively and interactive approach to learning. Her motto: “Love Your Data!”
Peter Shore
Twitter: - pshore73
LinkedIn: Peter Shore
Peter Shore is a seasoned IT professional with over 25 years of experience. He took the accidentally intentional DBA plunge in 2013 and has discovered that he loves to find the stories the data has to tell. Peter is comfortable working with both physical and virtual servers, where he tries to apply best practices to attain performance improvements. He is also adept at bridging the gap between technical and business language in order to bring technology solutions to business needs.
David Mellinger
Twitter: - @HoosierDataDev
LinkedIn: David Mellinger
David started working with SQL Server as an application developer in 2003. He switched to focusing on the database over 10 years ago. He has created and worked with ERP, e-commerce, middleware, geo-spatial, and of course analytic (ODS, DW) databases. David is a Practice Lead for Allegient’s Data Platform Analytics practice. He loves working with businesses to get them setup to use technology for success. Diving into complex challenges or “can you\how can you do this” scenarios is fun for David. He is passionate about mentoring and sharing experiences to help others (and himself!) grow.
Andrew Loree
Twitter: - @LowOnDiskSpace
LinkedIn: Andrew Loree
Contact: http://www.andyloree.com
Andrew Loree has over nineteen years of database experience with roles in architecture, design, development, and implementation of enterprise-scale SQL Server data solutions, supporting industries from legal e-discovery to manufacturing. Areas of expertise since SQL Server 2000 include data migration and ETL/ELT solutions, disaster recovery planning, high availability service design, licensing and virtualization. Andrew holds fourteen Microsoft certifications, has both a Bachelor and Masters of Science in Computer Science from Wright State University and is a Columbus (Ohio) PASS board member.
Joshua Higginbotham
Twitter: - codenamesql
LinkedIn: Joshua Higginbotham
Contact: https://codenamesql.blog/
Joshua Higginbotham is a Data Services Manager at Republic Bank based out of Louisville, KY. He’s worked in various roles including Software Development, Database Administration, and Business Intelligence. He’s an active speaker within the SQL community and the Co-Chapter leader of the Louisville SQL Server and Power BI User Group.
Sponsors
The following is a list of sponsors that helped fund the event: