SQLSaturday #736 - Columbus 2018

Event Date: 07/28/2018 00:00:00

Event Location:

  • Roush Hall at Otterbein University
  • 27 S Grove Street
  • Columbus, Ohio

PDF of Schedule

This event has completed. All data shown below is from the historical XML public data available.

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).


Sessions

This is a list of sessions from the event, based on the schedule in the XML files.


Title: SQL Server and PowerShell: Let’s Get Serious

Abstract: Whether you’ve dabbled in PowerShell or wondered what all the fuss is about, make no mistake: PowerShell isn’t going away. It is definitely something worth learning to make your life as a SQL Server professional easier, and allow you to advance in your career as a DBA.

In this session, you’ll see practical, real-world examples of how you can blend SQL Server and PowerShell together. You’ll also get a look at the SQL Server PowerShell provider and how you can incorporate it into your automation scripts.

Instead of focusing on syntax, the session will plunge straight into examples and highlight various snippets of code and how they work. You can expect to see code examples on how PowerShell can do anything from comparing tables across servers, automating and centralizing your backups, and even doing in-depth security audits.

Speaker(s):

  • Drew Furgiuele

Track and Room: Enterprise Database Administration Deployment - Roush 213


Title: Learn History from Temporal Tables

Abstract: SQL Server 2016 came out with a bucket full of cool new features. One of them is Temporal Tables. SQL Server 2017 made some enhancements in this area. Temporal tables are basically history tables of the normal tables; that allows us to retrieve data from any point in time for every change such as updates and deletes. It does this all without any change to application code. In this session, we will see what the requirements of creating temporal tables are. We will see the demo on insert and update functionality and how to query historical information using new TSQL clause. We will touch upon retention of history as well. It has lots of demos and less theory.

Speaker(s):

  • Ameena Lalani

Track and Room: Enterprise Database Administration Deployment - Roush 117


Title: Getting started with SQL Azure Database: What you need to know

Abstract: Azure SQL Database offers a way quickly spin up new databases with minimal management requirements. However, the number of differences between on-premises SQL Server and Azure SQL Database can be overwhelming. Even worse, with DBaaS it’s not clear who is responsible for what anymore. In this session, we will cover all the basic steps of getting your first Azure SQL Database instance spun up. We’ll cover common gotchas, like firewall settings and resource locks. We’ll also dive into some more advanced options with templates, allowing you to make your processes reproducible. By the end of this presentation, you’ll understand if Azure SQL Database is the right choice for you and your needs. You’ll understand how it can simplify management and allow you to scale easily. Finally, you’ll have the confidence to go and create your own instance with ease.

Speaker(s):

  • Jim Donahoe

Track and Room: Cloud Application Development Deployment - Roush 116


Title: Know different AWS Database Products - their benefits and key features

Abstract: AWS offers a broad range of databases purpose-built for your specific application use cases. It offers managed Relational, Non-Relational, Data Warehouse, In-Memory Data Store, and Graph Databases. AWS fully managed database services include relational databases for transactional applications, non-relational databases for internet-scale applications, a data warehouse for analytics, an in-memory data store for caching and real-time workloads, and a graph database for building applications with highly connected data. To migrate their existing databases to AWS, the AWS Database Migration Service makes it easy and cost effective to do so. The specific session will cover all the different databases products offered by AWS and the features and the key benefits and also the key clients who all use the products and catering to their specific needs.

Speaker(s):

  • Sourav Mukherjee

Track and Room: Cloud Application Development Deployment - Roush 116


Title: Data To Impress Those That Sign The Checks - Azure Logic Apps, Social Media, and Sentiment Analysis

Abstract: The job of a data professional is evolving rapidly, driving many of us to platforms and technologies that were not on our radar screen a few months ago. I am certainly no exception to that trend. Most of us aren’t just monitoring backups and tuning queries - we are collaborating with teams throughout the company to provide them data and insights that drive decisions. This presentation walks you through how a silly idea from a soccer podcast got me thinking about how Azure Logic Apps, sentiment analysis, and Azure SQL DB combine to provide potentially powerful insights to any company with a social media and sales presence. Join me as I walk you through building a solution that can impact your company’s bottom line - and potentially yours too!

Speaker(s):

  • Matt Gordon

Track and Room: Cloud Application Development Deployment - Roush 118


Title: A Tour of R in the Microsoft Ecosystem

Abstract: Over the past few years R has been popping up in several areas within the Microsoft ecosystem. It was first introduced in Azure ML then later appeared in Power BI and SQL Server. Unfortunately, the benefits of the R programming language are not understood by many Microsoft professionals so these tools are not being fully utilized. I hope to change that for some with this talk.

In this session we will take a tour of R in the Microsoft ecosystem. We will show the different ways R can be leverage and present compelling reasons why it is a very valuable tool that you should add to your data analytics arsenal. No R experience is needed for this session.

Speaker(s):

  • Ryan Wade

Track and Room: Analytics and Visualization - Roush 117


Title: Common SQL Server Mistakes and How to Avoid Them

Abstract: Making mistakes is human nature, avoiding them comes from experience and shared wisdom from others. In this session, Tim Radney will share experiences he has encountered supporting multiple fortune level companies. Tim will share real world experiences of environments he has worked on and the impact he has seen from administrators not knowing how to properly configure and administer SQL Server. In this session you will learn many accepted best practices for installing, configuring and supporting SQL Server to help your environment run as smooth as possible. When you leave this session you will have a checklist of items to take back to your shop to make sure your environment is configured properly.

Speaker(s):

  • Tim Radney

Track and Room: Enterprise Database Administration Deployment - Roush 114


Title: Screw DevOps, Let’s Talk DataOps

Abstract: DevOps is the new hot topic for IT, but only answers part of the problem. This session and demo will discuss why data creates continual friction in the DevOps environment and how it must be incorporated into the solution. Reasons for this solution is required: -Data is getting bigger and more complex -Security concerns around critical data is becoming more evident every day -Data is created in silos in many sources, yet consumed in just as many locations, including on-premises and in the cloud.

We’ll discuss the tech, the politics and the challenges of bringing data into DevOps and how to do so more successfully with culture changes, tools, scripting, and virtualization.

Takeaways from this session:

  1. Learn the five principles of Data Ops 2. How embracing a dynamic data platform can eliminate challenges and provide automation. 3. Learn the difference between containers, packages and data pods. 4. Learn how to bridge the gap between data and people, eliminating culture from the scene

Speaker(s):

  • Kellyn Pot’Vin-Gorman

Track and Room: Enterprise Database Administration Deployment - Roush 118


Title: That’s So Metadata: Discover Your Database From the Inside

Abstract: Have you ever needed to learn a new database design and don’t know where to begin? Or are trying to find out why a query doesn’t perform well? Or need to provide security information to auditors or your security team?

SQL Server has a number of metadata facilities available to help you with these tasks, and more. Functions, dynamic management views, and system stored procedures can illuminate details from the smallest column up through an entire SQL Server instance and everything in-between. We will demonstrate metadata techniques to help you:

  • Document your database schema objects such as procedures, functions, tables, columns and indexes
  • Investigate performance and look for bottlenecks
  • Discover metadata to administer your databases backups, index maintenance, and security
  • Apply your own metadata using extended properties

We’ll also demonstrate the new SQL Data Discovery/Classification and Vulnerability Assessment features in SQL Server Management Studio.

Speaker(s):

  • Rob Volk

Track and Room: Enterprise Database Administration Deployment - Roush 117


Title: The Vocabulary of Performance Tuning

Abstract: This session is for the absolute beginner to learn the terminology of performance tuning and how queries are processed. This includes how queries are Parsed, Resolved, Optimized, Compiled and Executed. We will see how this effects Batches, Transactions, and Errors. We will also briefly discuss table structures and the differences between Heaps and Clustered Indexes. The session is led by an expert Microsoft Certified Trainer (MCT) and Microsoft MVP who regularly teaches the SQL Server certification courses.

Speaker(s):

  • John Deardurff

Track and Room: Application Database Development - Roush 114


Title: T-SQL Window Function Performance

Abstract: Window functions were first introduced with SQL Server 2005 and enhanced with SQL Server 2012. They enable easy development and great performance…well, sometimes. Learn what you need to know to take full advantage of these features. What you don’t know can hurt you when you are using window functions.

Speaker(s):

  • Kathi Kellenberger

Track and Room: Application Database Development - Roush 213


Title: How to get your Dream Job: Resume job hunting tips

Abstract: What do you want to be when you grow up? I want to be a DBA, a teacher, a blogger, and a world-traveler. I’m living my dream.

In this session, we’ll talk about how I got where I am, and how you can get to where you want to be. In addition to sharing my journey, I’ll give some helpful tricks to getting your next job. You’ll learn how to write a resume that gets you noticed, how to navigate interviews, and learn how to decide if a potential job and employer is right for you.

Bring your own resume to this session, and I’ll provide you some personal (and private) feedback on what I would do to help improve your resume so you can land your Dream Job.

Slides handouts available on GitHub: http://am2.co/dream-job-ppt

Speaker(s):

  • Andy Mallon

Track and Room: Professional Development - Roush 114


Title: Implementing Python in SQL Server 2017

Abstract: SQL Server 2016 added R to the analytical toolset and SQL Server 2017 has added Python. When looking at various lists of the most popular programming languages, Python always has one of the top positions. This session provides an introduction to Python, including why it is a good choice for analyzing data.
If you have not had a chance to review SQL Server 2017 yet, please attend to see some of the new changes coming later this year. One of the features covers will show what is needed to incorporate Python into SQL Server and how Python can be incorporated in stored procedures to provide the ability to analyze data using arguably the most popular programming language to review data.

Speaker(s):

  • Ginger Grant

Track and Room: Analytics and Visualization - Roush 213


Title: SQL Injection Attacks: Are Your Queries Secure?

Abstract: Sometimes using dynamic SQL is the only way to write a query that accomplishes what you need. But did you know that dynamic SQL statements can leave you vulnerable to SQL injection attacks?

In this session we’ll examine how SQL injection works and how we can write injection-proof queries through a series of examples and demos. We’ll also look at why some commonly used techniques aren’t as secure as many people think.

If you ever write or maintain dynamic SQL queries, or work with developers who do, then this session is for you. After all, do you really want to be the person responsible for allowing hackers into your database?

Speaker(s):

  • Bert Wagner

Track and Room: Application Database Development - Roush 117


Title: Analyzing Your Workload with Query Store

Abstract: I’ve said it before and I’ll say it again: Query Store is a game-changer for troubleshooting query performance. Yet when I ask people who are running SQL Server 2016 or higher if they’re using Query Store, less than half say they are. If you fall into that category, this session is for you. We’ll start by discussing Query Store configuration. Sound a little boring? It won’t be. There are multiple settings that affect how information is captured and you need to understand them. Next, we’ll look at the data. Definitely not boring, as it’s imperative you understand exactly what gets stored (and what doesn’t) so you can find problematic queries quickly.
Lastly, we’ll mine the data in Query Store, and mining is more than just finding queries that use a particular index, or those that access a specific table. We’ll discuss different workload characteristics and how they affect system performance, and how to use Query Store to better understand your own workload.

Speaker(s):

  • Erin Stellato

Track and Room: Enterprise Database Administration Deployment - Roush 114


Title: Is My Application Bias Showing?

Abstract: Computers can’t be biased, right? I mean, it’s just lines of code. Yes or No. Ones Zeros. Those lines of code are written by people. People have life experiences that color how they see the world. Okay, let’s be blunt. People have baggage. And that baggage is seeping into your application, surveys and web forms.
You’ve got an idea for a new app and it’s going to change the world! Right? It’s a brilliant idea no one has ever thought of it before. You’re working on the GUI for your company’s web portal and you know just what information to collect from the user. Are you sure about that? Odds are pretty good that the information you’re going to collect is a reflection of your life your experiences.
Learn how to identify bias when it seeps in, how to code to be inclusive instead of exclusive , and some quick tips tricks to make sure you’re accounting for all the users that will use YOUR application to change the world. Instead of just the ones that look like you.

Speaker(s):

  • Rie Irish

Track and Room: Application Database Development - Roush 210


Title: The Case for Change: Identifying and Remedying Bad Code

Abstract: There is no organization that is immune from performance issues with their SQL Server queries. Sometimes all it takes is one “perfect storm” that kills your server performance and lands you in the hot seat with everyone asking you what happened. While many performance issues can be addressed with an index or configuration change, what about when the root of the problem is the code itself? Whether it’s a stored procedure or dynamic T-SQL generated by an ORM, the burden of proof lies with the DBA to demonstrate how the code is negatively impacting performance.

How do you capture those bad queries? When you have this data what do you look at besides the query itself? How do you make the case to the business that a code change is necessary? In this session we will explore capturing and identifying those problem queries, the analysis of the performance data, and how to effectively communicate your findings to the business to get your proposed code change approved and implemented.

Speaker(s):

  • Amy Herold

Track and Room: Application Database Development - Roush 118


Title: Getting Started with Git/GitHub

Abstract: If you manage code, you understand the struggle of choosing how you source control it. While there are many choices out there, Git has become a popular option for many development teams. While it has many strengths, understanding Git can be a struggle for developers who are not used to distributed source control. In this session, we will go over the basic concepts of Git, from building and cloning a repository to branching, forking, and code merges. We will use real world examples of how Git and GitHub can be used to manage global development teams. Attendees will leave with a solid understanding of how Git works, how to get started with their own GitHub repository, and some tools that can be used to manage their code.

Speaker(s):

  • Michael Fal

Track and Room: Application Database Development - Roush 213


Title: (Not So) Accidental Personal Branding

Abstract: If you have an online presence, you have a personal brand. Most of us didn’t intend to create a brand when we made our first websites and social media profiles. They were just fun ways to share our lives and meet people. Now, they’re networking and career growth tools. In this talk, you’ll hear about people whose brands helped them become respected developers, managers, and community leaders. You’ll learn how to use your online presence to advance your career. You’ll also pick up best practices, common mistakes, and tips for balancing professional and personal content. Intentional personal branding opens the door to endless opportunities. Come see how to make that happen!

Speaker(s):

  • Cassandra Faris

Track and Room: Professional Development - Roush 116


Title: Introduction to System Catalog Views and System Dynamic Management Views

Abstract: System Catalog Views are all about the catalog METADATA in your database. Using basic T-SQL queries they let you look for objects in the database such as Tables, Stored Procedures, Functions, and more. System Dynamic Management Views let you monitor the health of your server instance and database, assist in performance tuning and diagnosing problems. Both can be core sources of information that let you do your job faster and better. Sure, on the surface they can seem rather mundane, but they can save your bacon when your database goes sidewise and you have no idea what’s going on. Join me as we begin our flight at 50,000 feet exploring many of the different types of views available and what they can provide you, then push the yoke forward and dive toward the ground to get a closer look at several in detail. But don’t worry, just as it looks like we’re going to crash and burn we’ll pull back on the yoke and slide in to a smooth landing.

Speaker(s):

  • Luis Gonzalez

Track and Room: Enterprise Database Administration Deployment - Roush 210


Title: Execution Plans 101

Abstract: Do you have a query that you want to tune, but don’t know where to start? Execution plans can be a great starting point for understanding what your query is doing under the hood. This course covers the bare bones basics: what an execution plan is, how to run them, how to read them, and additional features.

Speaker(s):

  • Eugene Meidinger

Track and Room: Application Database Development - Roush 117


Title: Detecting and Capturing Change for Data Warehousing

Abstract: There are many ways of detecting and capturing changes to the data in your business system in order to populate your data warehouse. In this session we will compare and contrast several methods for loading slowly-changing dimensions in your ETL solutions, including SSIS design patterns, T-SQL code, change data capture (CDC) and temporal tables.

Attendees will gain a full understanding of the pros and cons of each of these solutions and become confident in choosing and implementing them in their own ETL solutions.

Speaker(s):

  • Chris Hyde

Track and Room: BI Platform Architecture, Development Administration - Roush 114


Title: How to win Dev and influence QA

Abstract: Are you having a hard time enforcing or updating processes? Are you having trouble getting the business to see your vision of the future? Do you want to improve process or tasks at your office? Your answer to these challenges may be to improve relationships with key departments like Development and Quality Assurance.

In this session, I will go over steps I took to improve relationships with other members of the IT department. I will also discuss how improving my relationships helped me accomplish my long-term goals.

Speaker(s):

  • Elizabeth Noble

Track and Room: Professional Development - Roush 116


Title: Rubrik - Sponsor Session

Abstract: Sponsor session from Rubrik.

Speaker(s):

  • David Maxwell

Track and Room: Other - Roush 116


Title: Maintain SQL Server Performance Baseline with PowerShell

Abstract: Maintaining a solid set of information about our servers and their performance is critical when issues arise, and often help us see a problem before it occurs. Building a baseline of performance metrics allows us to know when something is wrong and help us to track it down and fix the problem. This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.

Speaker(s):

  • Allen White

Track and Room: Enterprise Database Administration Deployment - Roush 213


Title: Moving Past Imposter Syndrome

Abstract: We have heard a lot on recognizing Imposter Syndrome and how to address it. However, what if it’s not Imposter Syndrome after all? We will discuss working scenarios and how you approach or deal with them to determine “is it you or is it me?”

Speaker(s):

  • Wendy Pastrick

Track and Room: Professional Development - Roush 210


Title: Getting Started with Azure Data Lake Analytics (ADLA)

Abstract: Did you throw your data in a lake, specifically an Azure Data Lake? Are you now wondering what to do with all of that data? Microsoft provides Azure Data Lake Analytics (ADLA) “An on-demand analytics job service to power intelligent action.”
We will take a look at U-SQL, the big data language, which will empower you to leverage the T-SQL you know to extract meaningful insights from your big data.

Speaker(s):

  • Akhil Mahajan

Track and Room: Cloud Application Development Deployment - Roush 210


Title: Grokking the Grammar of Graphics

Abstract: One of the most popular libraries in R is ggplot2, a graphics library built on a concept called the grammar of graphics. In this example-heavy talk, we will learn about the grammar of graphics through ggplot2. We will start by building a series of simple visuals using ggplot2. Then, we will show how easy it is to add more and more complex functionality to our visuals, showing that we can incrementally add polish to our visuals. By the end of the talk, you will have the tools to build professional-quality visuals in R.

Speaker(s):

  • Kevin Feasel

Track and Room: Analytics and Visualization - Roush 117


Title: A Deep Dive into Locking, Blocking Latches

Abstract: This topic sounds scary, but it’s not. Regardless of whether you have a small database with only a few users, or a large multi-tenant system, you have Locking, Blocking, Latches, and Spinlocks. Understanding what they are and how they work is the first step in understanding how to troubleshoot them. Deadlocks are a problem, but they are a problem we can fix. In this session, we will explain and investigate how to find and fix the problems that we see in our database every day.

Speaker(s):

  • Gareth Swanepoel

Track and Room: Enterprise Database Administration Deployment - Roush 210


Title: Applying Forensic Accounting Techniques Using SQL And R

Abstract: Forensic accountants and fraud examiners use a range of techniques to uncover fraudulent journal entries and illegal activities. As data professionals, most of us will never unravel a Bernie Madoff scheme, but we can apply these same techniques in our own environments to uncover dirty data. This session will use a combination of SQL Server and R to apply these fraud detection techniques, which include Benford’s Law, outlier analysis, time series analysis, and cohort analysis.

Speaker(s):

  • Kevin Feasel

Track and Room: Analytics and Visualization - Roush 114


Title: Populating a Data Warehouse with SSIS and Biml Patterns

Abstract: This session will demonstrate how to leverage Biml Patterns, along with SQL Server Metadata, 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 most any ETL/ETL scenarios. The components used during this session:

  • Biml
  • BimlExpress
  • BimlSnap On-line are all available at no charge. In addition, attendees will receive:
  • A complete ‘SQL Server Metadata Manager’ solution (front and back end)
  • A fully functional SSIS Framework

Attend to see how Biml can revolutionize your SSIS development!

Speaker(s):

  • Jim Miller

Track and Room: BI Platform Architecture, Development Administration - Roush 210


Title: Cardinal Solutions Sponsor Session

Abstract: Sponsor Session from Cardinal Solutions.

Speaker(s):

  • David Maxwell

Track and Room: Other - Roush 118


Title: Azure Managed Instance: Reducing Maintenance Costs While Making Migration Simple

Abstract: While Azure SQL Database provides the full feature of the SQL Server database engine, it is designed primarily for newly developed, cloud-based applications. For existing applications running on traditional SQL Server instances, the cost and complexity of migration can be prohibitive. With the release of Azure Managed Instances, much of the cost and complexity have been removed. Join me for this session to learn about the differences between Azure SQL Database and Azure Managed Instances. Additionally, discover methods for migrating existing instances to Azure.

Speaker(s):

  • Frank Gill

Track and Room: Cloud Application Development Deployment - Roush 117


Title: SQL on Linux and Docker 101

Abstract: By now you’ve heard that SQL Server is available on various flavors of Linux and Docker. Join me in this session to go through the basics of these technologies. I want to show you how to setup, install, configure, and have a database to insert some data into and query. Then I want to go through your tool management options. All in all I hope to leave you with the ability to take this to your shop to see where it might make sense to use in the future.

Speaker(s):

  • Paul Popovich Jr

Track and Room: Enterprise Database Administration Deployment - Roush 116


Title: Temporal Tables in SQL Server 2016 and 2017

Abstract: SQL Server 2016 introduced the concept of a system-versioned temporal table. Further enhancements were added in SQL 2017. This is a type of user table that is designed to keep a complete history of all data changes to facilitate easy point-in-time analysis. In this session we will cover the basics of the internals of how temporal tables work, how to create them and their wide variety of use cases from auditing, to trend analysis and even recovery from data corruption.

Speaker(s):

  • Brian Carrig

Track and Room: Application Database Development - Roush 117


Title: Data Science in Reverse: Creating Credible Fake Data Sets

Abstract: Sometimes a data professional will find themselves in need of a large demonstration data set. However, non-proprietary options are few and usually lacking. This session will educate attendees in how to get around these obstacles by creating their own data. We’ll talk about the process of using real-world variability, creating inconsistency that leads to insight using some basic statistical concepts, the process of putting everything together, and getting the data set into SQL Server.

Speaker(s):

  • Britton Gray

Track and Room: Analytics and Visualization - Roush 213


Title: Extended Events: What are they and How do I use them

Abstract: Extended Events are an essential part of properly monitoring and every DBA should know what they are and how to use them. This session will cover the basics of Extended events as well as an introduction to the system_health session. This session will give someone who has never used Extended events before the skills to start using them!

Speaker(s):

  • Dave Bland

Track and Room: Enterprise Database Administration Deployment - Roush 118


Title: Monitoring Availability Groups

Abstract: Once you have successfully configured Availability Groups, what comes next? In this session, we will go beyond setup and look at how to monitor your Availability Groups. We will define and cover important metrics and alerts you need to manage a database in an Availability Group.

You will walk away from this session with tools you need to monitor your environment and know how to respond to alerts.

Speaker(s):

  • Tracy Boggiano

Track and Room: Enterprise Database Administration Deployment - Roush 114


Title: Data Compression: Squeeze Out Some Free Gains

Abstract: Since data compression is now a standard level feature (2016 SP1+) learn how to squeeze a little extra performance out of your databases for free! We’ll cover the types of compression available, the costs and benefits and how to determine good candidates for compression. Once we know what we want to compress we’ll cover three ways to apply it, including the easiest way to compress your whole database to meet best practices with just one line of code!

Speaker(s):

  • Jess Pomfret

Track and Room: Enterprise Database Administration Deployment - Roush 118


Title: Product Demonstration by Quest Software

Abstract: Product Demonstration by Quest Software

Speaker(s):

  • David Maxwell

Track and Room: Other - Roush 117


Title: Where Should My Data Live (and Why)?

Abstract: Long gone are the days where the only architecture decision you had to make when scaling an environment was deciding which part of the datacenter would store your new server. There is a dizzying array of options available in the SQL Server and Azure ecosystems and those are evolving by the day. Is “the cloud” a fad? Are private datacenters a thing of the past? Could both questions have a kernel of truth in them? In this session I will go over real world scenarios and walk you through real world solutions that utilize your datacenter, cloud providers, and everything in between to keep your data highly available and your customers happy.

Speaker(s):

  • Matt Gordon

Track and Room: Cloud Application Development Deployment - Roush 210


Title: Improving your PowerPoint Skills

Abstract: PowerPoint can enhance the presentation of any speaker or business professional, but using it effectively in your sessions or presentations can be difficult without practice. In this session, you will learn how to take your PowerPoint skills to the next level, using more advanced transitions, animations, and media in your presentations. This will help you engage your audience and communicate visually instead of just verbally, making your presentations more effective. After attending this session, you can feel confident that your PowerPoint skills have improved.

Speaker(s):

  • Evelyn Maxwell

Track and Room: Professional Development - Roush 116


Title: Little and Large - Cubes to Scale

Abstract: In 2018 creating a cube is one of the easier tasks in BI, however what happens when the cube you inherit is so big that it officially becomes the biggest cube in the Midwest, and therefore one of the biggest cubes in the country? This session shows how to handle tabular models of size and scale. It also delves into what assistance and considerations are required when considering moving, or even building, your cubes in Azure.

Speaker(s):

  • George Bryant

Track and Room: BI Platform Architecture, Development Administration - Roush 116


Title: Building REST API using SQL Server JSON functions

Abstract: SQL Server 2016 and Azure SQL Databases both contain JSON features that allow data to be accessed for either reading or writing JSON documents. This combined with REST APIs make it easier than ever for applications to exchange data directly with the database. We’ll demonstrate this feature using SQL Server’s built-in JSON support.

Speaker(s):

  • Sam Nasr

Track and Room: Application Database Development - Roush 118


Speakers

This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

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.

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.

Jim Donahoe

Twitter: - SQLFlipFlopsDBA

Contact: http://www.sqlflipflopsdba.com

Jim is a Premier Field Engineer for Microsoft in the Data/AI space. He lives in Pittsburgh in a small suburb. He loves working with all things Azure(ARM templates, DBaaS, SQL on IaaS). He is an avid collector of retro video games! He is a member of the Idera ACE program for 2018.

David Maxwell

Twitter: - https://twitter.com/dmmaxwell

LinkedIn: David Maxwell

Contact: https://dmmaxwell.wordpress.com/

David Maxwell has almost 20 years of experience with SQL Server, with a keen interest in performance tuning, monitoring, and troubleshooting. He has experience in environments as diverse as health care institutions, auto manufacturers, and insurance companies. David has been a frequent presenter at SQLSaturday events around the United States since 2012, as well as a presenter for the DBA Fundamentals Virtual Group, the Performance Virtual Group, 24 Hours of PASS, and the annual PASS Summit. David participates in his local Columbus Ohio PASS Local Group, where he serves on the board of directors as SQLSaturday coordinator.

Ameena Lalani

Twitter: - SQLHands

LinkedIn: Ameena Lalani

Ameena Lalani is a SQL Server veteran and started her journey with SQL Server 2000. She is a Microsoft Certified Solution Associate on SQL Server 2016 and also hold Azure Administrator Associate certification. Ameena works at Microsoft as a Premier Field engineer. She has implemented numerous High Availability and Disaster Recovery solutions at various companies. Ameena loves to share her technical knowledge and speaks at local user groups and SQLSaturday events throughout the United States.

Tracy Boggiano

Twitter: - TracyBoggiano

LinkedIn: Tracy Boggiano

Contact: http://databasesuperhero.com

Tracy Boggiano is a Senior Database Administrator for DocuSIgn. She has spent over 20 years in IT, using SQL Server since 1999, and is currently certified as an MCSE Data Platform. Tracy has worked on SQL Server since 6.5. She has spoken at local user groups and numerous SQLSaturdays. She is currently a co-leader of a TriPASS Local Group in Raleigh, NC.

Tracy also tinkered with databases in middle school to keep her sports card collection organized. She blogs at databasesuperhero.com.

Her passion outside of SQL Server is volunteering with foster children as their advocate in court through volunteerforgal.org and being a mental health advocate as part of the PAIMI NC Advisory Council.

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.

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.

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.

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.

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.

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.

Ryan Wade

Twitter: - MrDataGeek

LinkedIn: Ryan Wade

Ryan is an experienced data analytics professional. His education and work experience enables him to understand things from a technical, analytical, and business viewpoint. He has the ability to present complex data in an intuitive way using sound analytical and visualization methods.

He has an advanced analytical and technical skill-set which includes Power BI, T-SQL, R, Python, Azure Machine Learning Services, Azure Databricks, SQL Server Machine Learning Services, Advanced Modern Excel, SSIS, SSAS Tabular.

He is a data analytics enthusiast that has spoken at a variety of database and data science conferences about various topics dealing with data analytics.

Tim Radney

Twitter: - @tradney

LinkedIn: Tim Radney

Contact: http://www.timradney.com

Tim is a Data Platform MVP and has a whole collection of Microsoft and other industry certifications. His experience includes HA/DR, virtualization, SSIS, SSRS, and performance tuning, among everything else SQL Server-related. Tim is very active and passionate in the SQL Community. He runs the Columbus GA SQL Users Group, has been a PASS Regional Mentor for a number of years, was named a PASS Outstanding Volunteer in 2012, and is a frequent speaker at user groups, SQLSaturdays and PASS Summits. Tim is one of the top ranked in karma on ask.sqlservercentral.com, answers questions as @tradney on Twitter, and blogs at http://timradney.com and SQLskills blog at http://www.SQLskills.com/blogs/tim.

Eugene Meidinger

Twitter: - @sqlgene

Contact: http://www.sqlgene.com

Eugene Meidinger works as a BI consultant and full time Pluralsight author. He currently focuses on content on Power BI and related products. He also leads the Pittsburgh Power BI User Group. He is certified in querying and administering SQL Server.

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.

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

Cassandra Faris

Twitter: - cassandrafaris

LinkedIn: Cassandra Faris

Cassandra Faris is passionate about the human side of technology. Her career has focused on supporting tech professionals through community outreach, hiring, mentoring, and employee engagement. She is an international speaker who specializes in teaching people how to be more effective team members and advance their careers. She is also the President of the Microsoft and open source conference, DogFoodCon, and a Per Scholas Advisory Board member. She has an MBA in Organizational Leadership. When she’s not busy with the tech community, she is avid tabletop gamer, runner, and soccer fan who travels as much as possible.

Kathi Kellenberger

Twitter: - auntkathi

LinkedIn: Kathi Kellenberger

Contact: http://auntkathisql.com

Kathi Kellenberger is the editor of Simple Talk at Redgate and a Data Platform MVP. She has worked with SQL Server for over 20 years and has authored, co-authored, or tech edited over a dozen technical books. Kathi is the co-leader of the PASS Women in Technology Virtual Group and a volunteer at LaunchCode. When Kathi isn’t working, she enjoys spending time with family and friends, cycling, singing, and climbing the stairs of tall buildings. Be sure to check out her courses on Pluralsight.

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.

Kellyn Pot’Vin-Gorman

Twitter: - DBAKevlar

LinkedIn: Kellyn Pot’Vin-Gorman

Contact: http://dbakevlar.com

Kellyn Pot’Vin-Gorman is a member of the Oak Table Network and an Idera ACE and Oracle ACE Director alumnus. She is a Data Platform Architect in Power BI with AI in the EdTech group at Microsoft. Kellyn is known for her extensive work with multi-database platforms, DevOps, cloud migrations, virtualization, visualizations, scripting, environment optimization tuning, automation, and architecture design.

Kellyn has spoken at numerous technical conferences for Oracle, Big Data, DevOps, testing, and SQL Server. Her blog (http://dbakevlar.com) and social media activity under her handle, DBAKevlar, is well respected for her insight and content.

Britton Gray

Twitter: - IDreamInSQL

LinkedIn: Britton Gray

Britton Gray is a veteran of database development, data management, business intelligence, analytics, and data privacy in BI. He has successfully completed projects in a variety of technologies in different technology stacks. Coming from a family full of teachers, he thoroughly enjoys the opportunity to share knowledge and insights; it’s an extension of “getting the right information to the right people at the right time” mantra of BI. He lives near Indianapolis, Indiana, and is the Director of BI for Project Lead The Way, a nonprofit organization providing transformative learning experiences in computer science, engineering, and biomedical sciences.

Ginger Grant

Twitter: - desertislesql

LinkedIn: Ginger Grant

Contact: http://www.DesertIsleSQL.com

Ginger Grant manages the consultancy Desert Isle Group and shares what she has learned while working with data technology to people around the world. As a Microsoft MVP in Data Platform, Microsoft Certified Trainer and an instructor on DataCamp, she focuses on guiding clients to create solutions using the entire Microsoft Data Stack, which includes SQL Server, Power BI, and Azure Data Cloud components. When not working, she protypes the latest pre-release data technologies, maintains her blog http://www.desertislesql.com, and spends time on twitter @desertislesql.

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.

David Maxwell

Twitter: - https://twitter.com/dmmaxwell

LinkedIn: David Maxwell

Contact: https://dmmaxwell.wordpress.com/

David Maxwell has almost 20 years of experience with SQL Server, with a keen interest in performance tuning, monitoring, and troubleshooting. He has experience in environments as diverse as health care institutions, auto manufacturers, and insurance companies. David has been a frequent presenter at SQLSaturday events around the United States since 2012, as well as a presenter for the DBA Fundamentals Virtual Group, the Performance Virtual Group, 24 Hours of PASS, and the annual PASS Summit. David participates in his local Columbus Ohio PASS Local Group, where he serves on the board of directors as SQLSaturday coordinator.

Brian Carrig

Twitter: - @briancarrig

Brian Carrig is a Microsoft Certified Master of SQL Server and is currently a Senior Program Manager on the SQL Server Tiger Team at Microsoft focusing primarily on persistent memory technology and replication. In a previous life, Brian spent some time as an academic and holds a PhD in Computer Science. He is a native of Dublin, Ireland but now lives with his wife and two daughters in Redmond, Washington. If he is not talking about, thinking about or working with technology you will usually find him watching Chelsea FC.

George Bryant

Twitter: - Azure_George0

LinkedIn: George Bryant

George has over a decade of experience in the Business Intelligence industry and is an active member of the BI community across the Midwest. His knowledge spans multiple industries including, retail, manufacturing, finance, and medical, however recent years has seen him focus on the analytics in sports.

George specializes in BI architecture and end to end development in order to deliver advanced analytics and metrics to multiple organizations across the country. In recent years George has focused on and worked primarily in the Azure cloud, utilizing both established and recent offerings.

Gareth Swanepoel

Twitter: - @GarethSwan

Contact: http://mygareth.com

Gareth Swanepoel is a sysadmin-turned-SQL Server DBA. He has been working in the IT industry doing support and administration for over 25 years. He enjoys solving the complex problems that customers encounter when performance tuning SQL Server or when deploying SQL Server in large data warehouse environments. He is originally from South Africa and is currently a Dedicated Support Engineer (PFE) with Microsoft. He is a passionate member of the SQL Server community and is an accomplished author and speaker having presented at various user groups, SQLSaturdays, the PASS Summit and other technical conferences.

Bert Wagner

Twitter: - bertwagner

LinkedIn: Bert Wagner

Contact: https://bertwagner.com

Bert Wagner teaches data-focused developers how to use SQL Server efficiently every week on his YouTube channel “SQL with Bert.” When not filming episodes, he gains inspiration for his content through his work as a Principal Business Intelligence Developer for Progressive Insurance in Cleveland, OH.

Starting his career as an SSIS and SSRS developer, Bert fell in love with SQL Server query writing and performance tuning. Nowadays, he focuses on full stack web development and uses his database tuning skills to ensure that his applications run at peak performance.

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.

Evelyn Maxwell

Twitter: - @GeoCache_11

Contact: http://geocache11blog.wordpress.com

Evelyn Maxwell is a 10th grade student at Gahanna Lincoln Highschool, and an attendee and presenter at local SQLSaturdays. Since 4th grade, (age 10) Evelyn has been working with presentation software and has given multiple school presentations was well as three SQLSaturday presentation, and a webinar for WIT. She currently has 0 years of IT experience.

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.

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.

Akhil Mahajan

Twitter: - @_akhilm

LinkedIn: Akhil Mahajan

Managing consultant for Cardinal Solutions. Work with SQL Server and Azure.

Paul Popovich Jr

Twitter: - @pmpjr

LinkedIn: Paul Popovich Jr

Contact: https://pmpjr.wordpress.com/

Paul Popovich Jr. has been in the IT space for his whole career and tinkering with computers since his 486 PC back in the mid 1990s. Professionally he is a senior DBA for a large hospital system. You can find on twitter @pmpjr, email at paulpopovichjr@gmail.com.

Erin Stellato

Twitter: - erinstellato

LinkedIn: Erin Stellato

Contact: http://www.sqlskills.com/blogs/erin

Erin Stellato is a Data Platform MVP and lives outside Cleveland, OH. She has almost 20 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include performance tuning, Query Store, Extended Events, and helping accidental/involuntary DBAs understand how SQL Server works. Erin is an active member of the SQL Server community, has volunteered for PASS at the local and national level, and is a regular speaker at conferences including the PASS Summit, SQLIntersection, and SQLBits. Outside of time with family and friends, she enjoys running, spinning, movies, and all things chocolate.

Wendy Pastrick

Twitter: - @wendy_dance

Contact: http://wendyverse.blogspot.com

Wendy Pastrick is from Chicago, IL, and for the past 15 years has served as a Database Administrator supporting both development and production environments. Her many years of involvement with PASS include WIT Virtual Chapter and the Chicago Suburban User Group, serving as Regional Mentor, and as a PASS Board member since 2013. Wendy has organized several highly successful SQLSaturday events in Chicago.

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.

Michael Fal

Twitter: - @Mike_Fal

LinkedIn: Michael Fal

Contact: http://mikefal.net

Mike is a specialist in data management technologies. As a community advocate, public speaker, and blogger, Mike is a practicing thought leader for data and automation. He is passionate about DevOps and data, building platforms to optimize, protect, and use data efficiently.

Since 1999, Mike has been working in the database field, focusing primarily on SQL Server and specializes in automating data solutions to improve the reliability and efficiency of his environments. He has been caught playing trombone in public on more than one occasion.

David Maxwell

Twitter: - https://twitter.com/dmmaxwell

LinkedIn: David Maxwell

Contact: https://dmmaxwell.wordpress.com/

David Maxwell has almost 20 years of experience with SQL Server, with a keen interest in performance tuning, monitoring, and troubleshooting. He has experience in environments as diverse as health care institutions, auto manufacturers, and insurance companies. David has been a frequent presenter at SQLSaturday events around the United States since 2012, as well as a presenter for the DBA Fundamentals Virtual Group, the Performance Virtual Group, 24 Hours of PASS, and the annual PASS Summit. David participates in his local Columbus Ohio PASS Local Group, where he serves on the board of directors as SQLSaturday coordinator.

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.

Luis Gonzalez

Twitter: - SQLLou

LinkedIn: Luis Gonzalez

I really don’t know much of anything. I’m surprised anyone even shows up to listen to me.

Frank Gill

Twitter: - skreebydba

LinkedIn: Frank Gill

Contact: http://skreebydba.com/

Frank Gill is a Senior Data Engineer at Concurrency With 21 years of IT experience, the first 8 as a mainframe programmer, he has developed a love of all things internal. Over the past several years, he has worked extensively with SQL Server solution in Azure, including Managed Instance. When not administering databases or geeking out on internals, Frank volunteers at the Art Institute of Chicago and reads voraciously.

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.

Sponsors

The following is a list of sponsors that helped fund the event:

Back to the SQLSaturday Event List

Back to the home page