SQLSaturday #705 - Richmond 2018

Event Date: 03/24/2018 00:00:00

Event Location:

Stratford University
11104 W. Broad Street
Glen Allen, Virginia

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

Sessions
Speakers
Sponsors

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: Controlling Competing Workloads with SQL Server Resource Governor

Abstract: With heavily consolidated instances and competing workloads, the Enterprise only Resource Governor feature is an incredibly useful tool for any DBA to have in their toolbox. It allows for the effective throttling and control of CPU, memory and I/O consumed by multiple workloads running on a single SQL Server instance. In this session, we will cover the fundamental concepts of the SQL Server Resource Governor and provide demonstrations of practical scenarios where Resource Governor can control resources for specific workloads. Some of these demonstrations include how to limit the amount of memory consumed by memory-optimized tables and how to prevent poorly-written queries from overwhelming your storage subsystem. We will also discuss cases where Resource Governor can mitigate parameter sniffing problems. Finally, we will look at ways to leverage the useful information contained in the Resource Governor DMVs for monitoring and reporting.

Speaker(s):

Brian Carrig

Track and Room: Enterprise Database Administration, Deployment Monitoring - 111

Title: Why Should I Care About … Partitioned Views?

Abstract: Partitioned tables are awesome and partitioned views are dead, right? Well, sure partitioned views are not sexy but there are still plenty of applications where they are critical. And not necessarily just for standard edition who aren’t on the new service pack yet. If your data is time stamped, do you see different queries run against older data than new data? Do you with you could segment your data across multiple columns? Do you have data you need to partition horizontally? It’s possible partitioned views may still be for you. Come hear why this is still an important topic long after cargo pants and trucker hats went away … and possibly even after 2016 SP1.

Speaker(s):

Rick Lowe

Track and Room: Enterprise Database Administration, Deployment Monitoring - 114

Title: 5 Minute No Sweat SQL Security Audits

Abstract: Security audits such as PCI, STIG, or HIPAA, are important and can be complicated. Depending on the requirements it may take considerable time to gather the information you will need. In this session, you will get scripts that I use for compliance audits that help to collect the information required for many different audits quickly. Even when you have multiple SQL Servers, you can quickly and easily identify where to focus your efforts to ensure you pass security audits. Through demonstration and discussion of what and why certain items get reviewed you will leave with a better understanding of how to be compliant within you SQL Server environment.

Speaker(s):

Chris Bell

Track and Room: Enterprise Database Administration, Deployment Monitoring - 114

Title: Using Columnstore Indexes For Data Analytics

Abstract: The concept of convenience typically involves ease of use and/or the ability to get results fast while maintaining quality and integrity. The industry of business intelligence and data analytics has been changing and evolving with this same concept in mind.

The traditional data warehouse includes various implementation and development phases that can be both costly and time consuming to architect. Although a viable solution for analytics based on query speed and performance, one of the biggest drawbacks is data latency from the OLTP engine to the OLAP engine. First introduced in SQL Server 2012, Columnstore indexes have made great strides in SQL Server 2016.

In this session, we will cover the architecture of columnstore indexes compared to traditional B-tree indexes. We will look at specific use case scenarios and performance statistics to understand if columnstore indexes can be your solution for data analytics with or without a traditional data warehouse.

Speaker(s):

Jeremy Frye

Track and Room: Database Design Architecture - 144

Title: Choosing Sides in the ETL vs ELT Debate

Abstract: The debate regarding the relative merits of extract transform load (ETL) and extract load transform (ELT) data migration strategies isn’t new, but it remains relevant. Making the right choice is critical, because the wrong solution will slow development cycles and execution times, and increase the cost and complexity of code maintenance. In this presentation, I’ll cover some best practices for implementing an ELT solution for a variety of data migration scenarios. Data enthusiasts of any level will benefit from a detailed discussion of methodologies, strategic benefits, and code examples. The discussion will focus on the SQL Server stack including Azure and code examples will use T-SQL and SSIS.

Speaker(s):

Cameron Snapp

Track and Room: Database Design Architecture - 112

Title: Data Protection Privacy in the World of Database DevOps

Abstract: Ensuring the ongoing protection of personally identifiable information is mandatory in today’s business, helping you to guard against data breaches, and comply with the GDPR. In a climate where cyber attacks are all too frequent, and data is spread across a growing number of different environments, the challenge of protecting your data can seem daunting. This session will address the implications of the GDPR on database management, and demonstrate a privacy-first approach to controlling and protecting data as it changes and moves through your SQL Server estate. As well as offering guidance for assessing your data estate for GDPR readiness, this session will include some great tools and tips for building data protection and privacy into your development processes, and dispel the myth that database DevOps and compliance can’t go hand in hand. With the right preparation, you can build compliance into your processes, keep sensitive data safe, and deliver value quickly to your end users.

Speaker(s):

Grant Fritchey

Track and Room: Application Database Development - Auditorium

Title: A Masters Passport to Extended Events

Abstract: “As is commonly the case, all good things come to an end. And now is as good a time as any for the use of SQL Trace and Profiler to come to an end. Let’s face it, Trace was a good tool and had some wonderful uses. Profiler for that matter was a good tool and was useful at times. It is time to let those old tools retire gracefully and move into the world of XE. This workshop will provide you the means to let Profiler and Trace be retired from your toolset as you discover all that XE has to offer.

This session on Extended Events will help prepare you to put this tool to immediate use as you walk back to your daily duties. This workshop will teach you about Extended Events starting with the basics and moving through how to create XE sessions that will get the right data for you, while doing so with minimal impact.

You will be exposed to advanced troubleshooting techniques as we work through complex issues that are made easier through the use of XE. Take advantage

Speaker(s):

Jason Brimhall

Track and Room: Enterprise Database Administration, Deployment Monitoring - Auditorium

Title: Extending DevOps To SQL Server

Abstract: Most organizations are under pressure to speed up the software delivery cycle, whether that’s to respond more quickly to the needs of the business, the needs of your customers or just to keep up with the competition. Unfortunately the database is commonly considered a bottleneck. Without the right processes in place, database change management can slow things down, adding risk, uncertainty, and getting in the way of development and operations working together to deliver. Any organization that wants to fully benefit from a DevOps approach is going to have to overcome some specific challenges presented by the database. This session will teach you how to take DevOps principles and practices and apply them to SQL Server so that you can speed up the database delivery cycle at the same time you protect the information contained within.

Speaker(s):

Grant Fritchey

Track and Room: Application Database Development - Auditorium

Title: TempDB 101 Plus

Abstract: TempDB is not your ordinary user database and should definitely not be treated like one. The usage patterns dictate that the configuration, monitoring and usage be done in a different way to get the best performance. We will see why aspects such as configuration and file placement play such a key role and why you need to plan ahead for TempDB. See how to detect the memory and space usage associated with the various users in TempDB along with some of the most common performance related scenarios that you will encounter with a well-used TempDB database. In addition we will explain the differences between temp tables and table variables and when to use one over another.

Speaker(s):

Andrew Kelly

Track and Room: Internals Performance - Auditorium

Title: Why I use cursors in SQL

Abstract: “Cursors are bad, never use them!” How many times have you been told this by your senior DBAs or developers?
In this session I will explore why I use cursors to solve certain problems.
Discuss when they are appropriate, and when they are not.

Speaker(s):

Anders Pedersen

Track and Room: Application Database Development - 143

Title: SSRS – Clean while you migrate

Abstract: Is it time to migrate your SSRS to the latest version? Do you really want to migrate everything or only those reports and objects actually in use? We will walk through some migration methods and find the data available to help manage report lifecycle (age, permissions, use, data sources).

Speaker(s):

George Maxson

Track and Room: Business Intelligence (SSAS, SSIS, SSRS, PowerBI) - 143

Title: SQL Server and Docker

Abstract: Containers are everywhere. If server virtualization dominated the past decade, then this decade belongs to the containers. Name any product, and there is a container image of that product ready to be deployed at a moment’s notice. Containers can be used for hosting any type of application, and in this session, we’ll take a look at what you need to know to get started with containers with respect to SQL Server, and address some of the common questions that come up during this setup.

Speaker(s):

Azhagappan Arunachalam

Track and Room: Virtualization - 113

Title: Instrument your code – Basic TSQL Logging

Abstract: Well-instrumented code not only helps others with troubleshooting our code but it also helps with performance analysis and provides a good audit of runs over time. In this session we will explore a small framework for TSQL Logging that is easy to use and generic enough to fit simple and advanced use-cases. We will see how we can track messages, errors duration of runs by code type without intruding on the functionality of common/shared code and how this functionality may be shared across databases with a single code base. Tying DMV’s to business logic side of what is in-flight, is covered. All of the code will be available for use in your own projects. Let us see how you can get your code instrumented on Day 1!

Speaker(s):

Jana Sattainathan

Track and Room: Application Database Development - 111

Title: Use Biml to Automate SSIS Design Patterns

Abstract: Perhaps you’ve heard the buzz about Business Intelligence Markup Language (Biml) and wondered, “Why is everyone so excited about Biml?” Occasionally, a new technology emerges that changes everything. For SSIS developers, Biml is one such technology. Business Intelligence Markup Language (Biml) is a powerful solution for rapidly creating SSIS packages and solutions. SSIS Design Patterns support various load profiles. Combined, Biml and SSIS Design Patterns offer a compelling solution for automating enterprise data integration.

In this session, you will learn:

How to rapidly build multiple SSIS packages using BimlHow to apply different SSIS Design Patterns using BimlHow to automate SSIS Design Patterns using Biml

Speaker(s):

Andy Leonard

Track and Room: Business Intelligence (SSAS, SSIS, SSRS, PowerBI) - 111

Title: Test Driven Development with SQL Server

Abstract: Test Driven Development, or TDD, is the mainstream in many areas of software development, but what about the database? In this session, we will explore TDD, the benefits of automated testing, and how testing data projects differs from other types of development. We’ll introduce the tSQLt testing framework and demonstrate its use with a live coding example. Finally, we will discuss some lessons learned in doing TDD with SQL Server.

Speaker(s):

David Moore

Track and Room: Application Database Development - 144

Title: Collecting and Analyzing File Wait Statistics

Abstract: Is your SQL Server instance running at its peak performance level? Probably not but the real question is do you know why? Is your disk subsystem too slow or are you lacking enough CPU’s or is it something else entirely? It is very easy to capture and analyze the file wait stat information that is automatically collected by the SQL Server instance so why not utilize them. We will see how you can stop chasing your tail and focus on which area of SQL Server performance bottlenecks are doing you the most harm. This should be part of every DBA’s arsenal so come make it part of yours as well.

Speaker(s):

Andrew Kelly

Track and Room: Internals Performance - Auditorium

Title: SQL Server on Linux for SQL DBA.

Abstract: For the last 25 years SQL Server DBAs administered SQL databases using only Windows GUI. For majority of them even Windows Core is too hard to accept. In the situation, when Microsoft invaded Linux territory with it’s flagship product, as SQL DBA, you must not outsource SQL Server administration to some Linux geeks. You can do it yourself! Your way! And I show you how to do it.

Speaker(s):

Slava Murygin

Track and Room: Enterprise Database Administration, Deployment Monitoring - 113

Title: Faster SSIS

Abstract: Ever wonder why SSIS runs so slow? Watch SSIS author Andy Leonard as he runs test loads using sample and real-world data and shows you how to tune SQL Server 2016 Integration Services (SSIS 2016) packages.

We’ll start by experimenting with SSIS design patterns to improve performance loading AdventureWorks data. We will implement different change detection patterns and compare execution performance for each. Then, we’ll explain a Data Flow Task’s bottleneck when loading binary large objects - or Blobs.

Finally, we’ll demonstrate a design pattern that uses a Script Component in a Data Flow to boost load performance to MySql, whether on-premises or in the cloud.

Speaker(s):

Andy Leonard

Track and Room: Business Intelligence (SSAS, SSIS, SSRS, PowerBI) - 143

Title: SQL Restore: Optimizing Your Data Recovery

Abstract: When disaster strikes, everyone’s immediate question becomes: How long until the system is back online? Whether it’s a single database or the whole SQL environment, time is essential… As everyone waits on the restore to complete.

How long will the restoration process take?
Can it run faster?

In this session, we’ll answer these questions by looking at how to establish and maintain a Restoration Baseline and the options available for performance tuning database restores.

Speaker(s):

Jamie Wick

Track and Room: Enterprise Database Administration, Deployment Monitoring - 111

Title: Working Effectively With Legacy SQL

Abstract: A legacy code base can be a frightening thing. Between strict deadlines, ever-evolving requirements, differing skill levels of contributors over time, and historical circumstances, keeping database code clean and concise is difficult at best. This example- and demo-driven talk will help you build out a mental framework to prune those gnarled code bases. Much of this talk will be familiar to software developers who know of the “clean code” philosophy, but no knowledge of the topic is necessary. If you shudder whenever you look at your SQL code base, this talk may be for you.

Speaker(s):

Kevin Feasel

Track and Room: Application Database Development - 112

Title: SQL Graph

Abstract: Graphs are everywhere! Microsoft has added a lot of new features to SQL Server 2017, and among them SQL Graph has been one - one that holds a lot of promises, though it’s still in its early stages (at least with Microsoft products). Microsoft recently added Graph DB to their DocumentDB (product) and released it as Cosmos DB. In this session, we’ll take a look at what this feature brings to the table, and how it compares with other Graph databases.

Speaker(s):

Azhagappan Arunachalam

Track and Room: Application Database Development - 113

Title: Indexing for performance

Abstract: Learn all you wanted to know about index design, but were afraid to ask. This session focuses on physical index structures as well as how the server chooses indexes. Note: Join optimization is a separate session

Speaker(s):

Jeffrey Garbus

Track and Room: Internals Performance - 113

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: Business Intelligence (SSAS, SSIS, SSRS, PowerBI) - 114

Title: Polybase In Action

Abstract: Polybase is Microsoft’s newest way of integrating SQL Server with external systems such as Hadoop and Azure Blob Storage. In this talk, we will get an overview of the Polybase technology and then implement it to work with an on-premises Hadoop cluster as well as Azure Blob Storage. We will then dive into the mechanics of how Polybase works, using packet captures to understand the cross-network communication. Finally, we will look at ways of tuning common Polybase scenarios and look at a few less-common scenarios.

Speaker(s):

Kevin Feasel

Track and Room: Application Database Development - 143

Title: Power Query Deep Dive

Abstract: Power Query is a great tool for extracting, transforming, and loading data. It has an intuitive interface that allows you to create queries without having to worry about writing code. Under the covers Power Query is creating the M code that gets executed. In this session we will pull back the covers to reveal and understand the M code that is being created. This will give you greater insight into how to debug your queries. In addition, we will look at creating advance queries that go beyond what is available using the Power Query user interface.

Speaker(s):

Dan Clark

Track and Room: Business Intelligence (SSAS, SSIS, SSRS, PowerBI) - 114

Title: Using the New SSRS PowerBI Server

Abstract: Power BI SSRS Server allows you to internally host On-Prem classic RDL Paginated Reports, KPIs, Mobile Reports and now Power BI reports, allowing you to create real-time Dashboards on data behind the firewall. This session will be a complete tutorial from setup, config and PBI Desktop publish from Start To Finish.

Speaker(s):

George Walkey

Track and Room: Business Intelligence (SSAS, SSIS, SSRS, PowerBI) - 112

Title: Deeper Into Azure Machine Learning

Abstract: Azure Machine Learning enables far more than supervised 2-class classifications and continuous value predictions. Azure ML clusters unsupervised data. Azure ML analyzes free form text for entity recognition, sentiment analysis, or topic detection. Azure ML even provides Jupyter Notebooks with fully functional R and Python environments. This sessions demonstrates some of these capabilities to help you solve some of your business problem.

Speaker(s):

Mark Hudson

Track and Room: Azure / Cloud / Big Data - 144

Title: Temporal Data Capture

Abstract: Come see how I solved that lack of CDC in SQL Azure Database by leveraging a new feature in SQL Azure database and SQL Server 2016: Temporal tables. In this in-depth 400-level session I will demonstrate the techniques that I created to simulate CDC in SQL Azure Database. We will examine the code that implements the solution, the code that automatically writes code for you, and a wizard that makes it simple to consume.

Speaker(s):

boB Taylor

Track and Room: Application Database Development - 111

Title: Would You Just Load Already?! Maximizing Your SSIS Data Load

Abstract: Loading data via SSIS is great! It’s fast too! Until you hit a bad record. Then things aren’t so great. Now you probably have to waste time dumping and reloading all the data, or worst figure out where the bad record is and try a partial load. In this session you will learn a simple method to load data via SSIS and identify, remove, and record those bad records allowing you to maximize the amount of data loaded while ensuring data integrity.

Speaker(s):

Chris Bell

Track and Room: Application Database Development - 143

Title: Data Types Do Matter

Abstract: They’re just numbers, right? A date’s a date. It’s just string data, who cares? I can’t tell you how many times I’ve heard these phrases. This session will help you understand why choosing the correct data type for your data is so important. It affects data quality, storage and performance. It can even produce incorrect query results.

Speaker(s):

Angela Henry

Track and Room: Database Design Architecture - 113

Title: Intro to Integration Services (SSIS)

Abstract: This session is a very basic introduction to Integration Services (SSIS). We’ll cover the basics; what it’s used for and the various parts and pieces to get you started creating your own projects in no time. We’ll talk about packages, connections and project parameters and their respective tasks/properties. We’ll also cover some basic performance tuning to make your packages run faster.

Speaker(s):

Angela Henry

Track and Room: Business Intelligence (SSAS, SSIS, SSRS, PowerBI) - 144

Title: The DBA Survival Guide for In-Memory OLTP

Abstract: You know it’s coming . . . one day soon, you’ll be asked to take ownership of a database that uses In-Memory OLTP. Then what?

Deploying In-Memory OLTP affects the database ecosystem, including monitoring, data migration, logging, capacity planning, backup, restore, recovery, and more.

DBAs need to know optimal methods of migrating large data sets from disk to In-Memory, the differences between restore and recovery for memory-optimized databases, and many other facets of the In-Memory world.

Attendees will gain a clear understanding of the knowledge and skills required to administer In-Memory OLTP environments.

Speaker(s):

Ned Otter

Track and Room: Enterprise Database Administration, Deployment Monitoring - 112

Title: Murder They Wrote

Abstract: Join Microsoft Certified Master, Jason Brimhall, as he examines numerous database design and coding implementations that they have seen over the years. They will explore these implementations and show how they can be murder on SQL Server in terms of performance, security, storage and even accuracy. You will learn how you can identify these “killers” and how you can implement alternatives that will keep data professionals, management, and end-users happy. All while keeping your databases happy, secure, turbo-charged and healthy. This is the Solo version of the Joint version normally done as an all-day precon.

Speaker(s):

Jason Brimhall

Track and Room: Enterprise Database Administration, Deployment Monitoring - 114

Title: Introducing Azure Machine Learning

Abstract: Not satisfied with Multidimensional Analysis Services’ data mining or maybe you are using Tabular Analysis Services? Looking for a flexible and robust predictive analytics tool? Consider Azure Machine Learning … a cloud service for advanced analytics. In this session, I quickly describe concepts and terms before jumping straight into a start-to-finish AzureML experiment. Join me to see how AzureML might meet your advanced data analysis needs.

Speaker(s):

Mark Hudson

Track and Room: Azure / Cloud / Big Data - 144

Title: Weird Stuff I Saw While … Working With Heaps

Abstract: We’ve all been told at some point that heaps are usually bad for select, update, and delete performance. But how bad are they really? Can they also be problematic for inserts? Are they ever a good idea? For this installment of Rick’s “Weird Stuff” series we will take a closer look at why heaps can cause issues and maybe see a deadlock or two.

Speaker(s):

Rick Lowe

Track and Room: Application Database Development - 112

Speakers

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

Cameron Snapp

Cameron Snapp is a MCSE and PMP certified IT Consultant with over 14 years of database architecture and development experience. He has worked on dozens of Microsoft SQL Server OLTP, Data Warehouse, and Business Intelligence projects. He holds a Computer Science degree from the University of Richmond and a Master’s degree in IT Management from the University of Virginia. Cameron specializes in IT Projects related to data strategy, modeling, integration and reporting.

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

Angela Henry

Twitter: - SQLSwimmer

LinkedIn: Angela Henry

Contact: http://SQLSwimmer.com

Angela is a Solution Architect, living in High Point, NC and loves what she does. She’s worked with all versions of SQL Server worn all the hats that come with dealing with SQL Server throughout the years: developer, administrator, data architect and BI developer. She has her MSCE in Data and Analytics (f.k.a., Business Intelligence), is a Data Platform MVP, and a Microsoft Certified Trainer (MCT). She is the former chapter leader for the PASS Triad SQL User Group in Greensboro, NC. In her spare time you can probably find her in or at the pool, she’s an avid US Masters Swimmer, Coach and Instructor.

Mark Hudson

Twitter: - HMarkHudson

Mark Hudson is an MCITP with many years of experience in business intelligence and data analysis. He has developed data solutions using numerous platform tools including multiple SQL Server versions. He is a data architect and developer with CapTech (www.captechconsulting.com) and served as a leader of the Richmond SQL Server User Group (www.richmondsql.org).

Azhagappan Arunachalam

Az Arunachalam has been working with SQL server since v4.21/SQLNT. He started his career with troubleshooting at chip level, worked as a network engineer managing Novell NetWare networks, graduated into managing Windows NT, moved onto development, administered databases, and is currently working as a database architect. He#39;s excited about all the cloud offerings that Microsoft and others have made possible, and in sharing his findings with aspiring data enthusiasts.

Angela Henry

Twitter: - SQLSwimmer

LinkedIn: Angela Henry

Contact: http://SQLSwimmer.com

George Walkey

Twitter: - sqlbytehd

Contact: http://insyncva.com

SQL Server DBA, Developer, IT Manager, Business Owner from the Richmond, VA USA Area Interested in pushing the limits of both hardware software and my own brain

Jason Brimhall

Twitter: - sqlrnnr

LinkedIn: Jason Brimhall

Contact: http://jasonbrimhall.info

Jason Brimhall has more than 20 years of experience and has worked with SQL Server 6.5 through SQL Server 2019. He has experience in performance tuning, high transaction environments, and large environments. He is currently a consultant specializing in performance tuning, server analysis, and problem resolution. Jason is a Microsoft Certified Master (MCM) and a Data Platform MVP.

Andy Leonard

Twitter: - AndyLeonard

LinkedIn: Andy Leonard

Contact: https://andyleonard.blog

Andy Leonard is founder and Chief Data Engineer at Enterprise Data Analytics, Microsoft Data Platform MVP, creator of the DILM (Data Integration Lifecycle Management) Suite, an SSIS trainer, consultant, developer, Business Intelligence Markup Language (Biml) developer and BimlHero, SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of “The Biml Book and SQL Server Integration Services Design Patterns” and author of “Managing Geeks - A Journey of Leading by Doing”, “Data Integration Lifecycle Management with SSIS”, “Building Custom Tasks for SSIS”, and the “Stairway to Integration Services”. Andy blogs at andyleonard.blog where you can learn more on the About Andy page.

Grant Fritchey

Twitter: - @gfritchey

LinkedIn: Grant Fritchey

Contact: http://scarydba.com

Grant Fritchey is a Data Platform MVP with over 20 years’ experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. Grant has written books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. He joined Redgate Software as a product evangelist in January 2011.

Rick Lowe

Twitter: - DataFLowe

LinkedIn: Rick Lowe

Contact: http://dataflowe.wordpress.com/

Rick is a Microsoft Certified Master with more than 20 years of SQL Server experience in a variety of roles. He currently lives in Washington state and works as an independent consultant providing remote performance DBA and performance tuning services for clients in the USA and Canada. His first exposure to SQL Server was as a database developer, but over time he became more and more interested in how the database engine operated… eventually specializing more on performance issues than code.

Rick will work with all things relational, but most enjoys helping smaller companies get better performance from MSSQL, as well as smoothing over relationships between DBA and development teams.

Andy Leonard

Twitter: - AndyLeonard

LinkedIn: Andy Leonard

Contact: https://andyleonard.blog

Anders Pedersen

Twitter: - @arrowdrive

LinkedIn: Anders Pedersen

Contact: http://blog.AndersOnSQL.com

20+ years of experience with SQL Server, from version 6.0 to 2017. Funnily enough, the only certification I have is on SQL 2012, the one version I have never used. Mostly worked at medium sized companies, by choice. Was a consultant for 6+ years, working on anything from facility security systems, background checks, retail PoS systems, to major financial systems. Passion for performance, and teaching people easy ways to better SQL performance.

Jana Sattainathan

Twitter: - www.twitter.com/SQLJana

LinkedIn: Jana Sattainathan

Contact: http://www.sqljana.wordpress.com

Jana works as a Senior Oracle and SQL Server DBA at SCOR, a leading Reinsurance company in the world. He has spent most of his professional life around databases. At work, he has automated most aspects of his job using PowerShell.

Most recently, he created PowerPump, a “PowerShell Database Copy Server” for his company to copy 50 billion rows (> 20 TB,) from 4000+ of Oracle/SQL Server tables on a recurring basis to SQL Server targets for migration/testing. He has also fully automated the database deployment which supports all components of SQL Server and Oracle using PowerShell (with about 150 functions) that is tracked extensively.

David Moore

LinkedIn: David Moore

David Moore is a software/data engineer with 20+ years of experience in a variety of roles, developing applications and data solutions. With a passion for continuous improvement, he seeks ways to make agile practices practical. He serves as a senior consultant with CapTech (www.captechconsulting.com).

Mark Hudson

Twitter: - HMarkHudson

George Maxson

Twitter: - @SPsqlMES

LinkedIn: George Maxson

George Maxson has been a Database Administrator for Elon University for the last 1.5 years, and was the Database Analyst in a manufacturing environment for the previous 7 years. He volunteers with PASS as a co-leader of the Triad BI User Group and volunteers for SQLSaturday events.

Azhagappan Arunachalam

Rick Lowe

Twitter: - DataFLowe

LinkedIn: Rick Lowe

Contact: http://dataflowe.wordpress.com/

Rick will work with all things relational, but most enjoys helping smaller companies get better performance from MSSQL, as well as smoothing over relationships between DBA and development teams.

Jason Brimhall

Twitter: - sqlrnnr

LinkedIn: Jason Brimhall

Contact: http://jasonbrimhall.info

Jeremy Frye

Twitter: - SQLBInstein

LinkedIn: Jeremy Frye

Contact: https://jeremyfrye.net

Jeremy Frye is the manager of the Business Intelligence and data warehousing team at RDX. He is a Business Intelligence architect and developer with a background in database administration as well. Jeremy has over 9 years of experience in SQL Server. He has spoken on BI topics at many SQLSaturday’s throughout the country, webinars, and local and remote SQL user groups. In his spare time, Jeremy often spends time trying to bridge the gap between keyboard strokes and workout reps.

Wayne Sheffield

Twitter: - @DBAWayne

LinkedIn: Wayne Sheffield

Contact: http://blog.waynesheffield.com/wayne

Wayne Sheffield, a Microsoft Certified Master in SQL Server and Microsoft Most Valuable Professional, started working with xBase databases in the late 80’s. With over 25 years in IT, he has worked with SQL Server (since 6.5 in the late 90’s) in various dev/admin roles, with an emphasis in performance tuning. He is the author of several articles at www.sqlservercentral.com, a co-author of “SQL Server T-SQL Recipes”, and enjoys sharing his knowledge by presenting at SQL events worldwide and blogging at http://blog.waynesheffield.com/wayne

Grant Fritchey

Twitter: - @gfritchey

LinkedIn: Grant Fritchey

Contact: http://scarydba.com

Andrew Kelly

Twitter: - gunneyk

Contact: http://sqlblog.com/blogs/andrew_kelly/default.aspx

Andrew J. Kelly is a Senior Technical Subject Matter Expert with B3 Group Inc. and lives in Clarkdale, AZ. He has over 20 years experience with relational databases and application development, but his main focus now is SQL Server. In addition to general SQL Server training and mentoring, he specializes in performance, scalability, and maintainability of large-scale SQL Servers. He is a regular speaker at conferences and user groups and was a SQL Server / Data Platform MVP for 18 years.

Jamie Wick

Twitter: - Jamie_Wick

LinkedIn: Jamie Wick

Contact: http://blog.wicktech.net

Jamie Wick is the Systems Database Engineer for The College of William Mary and has been working with SQL databases for the past 10+ years. His background includes working for several years as a SQL SysAdmin for the University of Queensland (Australia), a Masters degree in Computer Information Systems from Boston University, and assorted Microsoft SQL certifications. He is the Chapter Leader of the Richmond SQL Server Users Group, a volunteer and speaker at regional SQL events (User Groups/SQLSaturdays), helps run the SQLSaturday RVA events, and is an avid photographer.

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.

boB Taylor

Twitter: - sqlbobt

LinkedIn: boB Taylor

Contact: http://aka.ms\sqlbobt

In his 45-year IT career, boB Taylor has pretty much done it all – Fortran 66 on Hollerith Cards, assembly language programming on drum-based computers, and LOB application development. He served as a VP of Software Development and was Director of Database Technologies for Avanade West Region. Then he joined Microsoft’s Partner Advantage practice, advising ISVs on effectively using SQL Server. After becoming a Microsoft Certified Architect, boB moved to PFE and is now with the Oracle Compete Team. Besides passing 40+ certification exams on the first attempt, boB helped develop both SQL Server 2000 certification exams, SQL Server 2005 developer exams, and all MCSD.NET exams. Ask him about the spelling of his name!

Andrew Kelly

Twitter: - gunneyk

Contact: http://sqlblog.com/blogs/andrew_kelly/default.aspx

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.

Dan Clark

LinkedIn: Dan Clark

Contact: http://drclarkblog.wordpress.com/

Dan Clark is a senior data analytics consultant. He is focused on all things data analytics and training others how to get value from their data. Dan has published several books and numerous articles on .NET programming and data analytics. He is a regular speaker at various developer and database conferences and user group meetings and enjoys interacting with the Microsoft developer and database communities. His latest book Beginning Power BI published by Apress is a will get you up and running with self-service data analytics on the Power BI platform in no time.

Jeffrey Garbus

LinkedIn: Jeffrey Garbus

Contact: http://mssqlperformance.blogspot.com/

Jeff has been consulting on and performing technical training for MS SQL Server since 1989, Version 4, on OS/2. Since then, he has worked extensively with each release of the product, specializing in performance and tuning, from concept through legacy system, on systems of all sizes, from small start-up company applications to multi-terabyte data warehouses.

In addition to hands-on consulting, he speaks at SQLSaturdays several times/year, has a youtube channel with free training, and has written 20 books on database management systems.

His latest book is “Transact SQL the Definitive Guide.”

Chris Bell

Twitter: - @cbelldba

LinkedIn: Chris Bell

Contact: https://www.wateroxconsulting.com/

Chris Bell offers a unique view of how we live and work with data, both now and as we head into the future. Having braved many roles, lifecycles, and battles in the IT world, he has honed his DBA (Database Administration or Do ‘Bout Anything) skills in Information Systems and development, focusing on SQL Server. Currently, he serves as the lead DBA at The Motley Fool. You can keep up with Chris’ thoughts and technical community activities at WaterOxConsulting.com.

Slava Murygin

Twitter: - SlavaSQL

LinkedIn: Slava Murygin

Contact: http://slavasql.blogspot.com/

Started working with SQL Server 7.0 as DBA and Developer. Since then went through all SQL Server versions, migrations and multiple companies of different sizes and industries. Currently working as a contractor with all aspects of SQL Server, including, but not limited to: troubleshooting performance, designing/developing: databases, systems, processes, data warehouses, cubes, reports, ETLs; Refactoring old code; Migrating data from other systems to SQL Server; Securing the data on enterprise level.

Kevin Feasel

Twitter: - feaselkl

LinkedIn: Kevin Feasel

Contact: http://www.catallaxyservices.com

Brian Carrig

Twitter: - @briancarrig

Chris Bell

Twitter: - @cbelldba

LinkedIn: Chris Bell

Contact: https://www.wateroxconsulting.com/

Ned Otter

Twitter: - @NedOtter

LinkedIn: Ned Otter

Contact: http://www.nedotter.com

DBA with vast experience administering Microsoft SQL Server since version 4.21 to the present.

Certifications:
MCSE SQL Server 2012 Data Platform MCTS SQL Server 2008 Overall computer experience: 25 years SQL Server experience: 23 years

Currently obsessed with In-Memory technology.

Please see LinkedIn profile for more details.

SQLSaturday #705 - Richmond 2018

Sessions

Title: Controlling Competing Workloads with SQL Server Resource Governor

Title: Why Should I Care About … Partitioned Views?

Title: 5 Minute No Sweat SQL Security Audits

Title: Using Columnstore Indexes For Data Analytics

Title: Choosing Sides in the ETL vs ELT Debate

Title: Data Protection Privacy in the World of Database DevOps

Title: A Masters Passport to Extended Events

Title: Extending DevOps To SQL Server

Title: TempDB 101 Plus

Title: Why I use cursors in SQL

Title: SSRS – Clean while you migrate

Title: SQL Server and Docker

Title: Instrument your code – Basic TSQL Logging

Title: Use Biml to Automate SSIS Design Patterns

Title: Test Driven Development with SQL Server

Title: Collecting and Analyzing File Wait Statistics

Title: SQL Server on Linux for SQL DBA.

Title: Faster SSIS

Title: SQL Restore: Optimizing Your Data Recovery

Title: Working Effectively With Legacy SQL

Title: SQL Graph

Title: Indexing for performance

Title: Data Visualization: How to truly tell a great story!

Title: Polybase In Action

Title: Power Query Deep Dive

Title: Using the New SSRS PowerBI Server

Title: Deeper Into Azure Machine Learning

Title: Temporal Data Capture

Title: Would You Just Load Already?! Maximizing Your SSIS Data Load

Title: Data Types Do Matter

Title: Intro to Integration Services (SSIS)

Title: The DBA Survival Guide for In-Memory OLTP

Title: Murder They Wrote

Title: Introducing Azure Machine Learning

Title: Weird Stuff I Saw While … Working With Heaps

Speakers

Sponsors