SQLSaturday #277 - Richmond 2014

Event Date: 03/22/2014 00:00:00

Event Location:

  • ECPI
  • 800 Moorefield Park Drive
  • Richmond, Virginia

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: Squeezing the Most out of Row Page Compression

Abstract: SQL Server 2008 brought us the ability to do Row and Page level compression in our databases but even today many people are not taking full advantage of these wonderful features. The most common bottle neck today is physical I/O and SQL Server compression can help with that in most cases. If you are not sure how these features work or how to apply them in your environment this session is for you. We will discuss in detail how the compression schemes work at both the row and page levels along with which data types may or may not be able to participate. We will see from various demos what else affects the compression ratio and just how extensive it can be under the right conditions. Nothing comes for free though so we will also cover the pros and cons along with why, when and most importantly how to use it effectively.

Speaker(s):

  • Andrew Kelly

Track and Room: Track #4 (DBA) - N/A


Title: SQL Server Internals Party: Storage, Memory and the Query Life-cycle

Abstract: Come meet the Internals of SQL Server at this special get-together! In this presentation we will cover the basics of data storage and querying with SQL Server. We will cover how data is stored in pages and extents and how that translates to data reads/writes with the storage system. Additionally, we will explore how different queries are processed by SQL Server and how the query life cycle works in general. Finally we will cover disk storage and memory and tie it all together. This session is intended to be broad and to give a general overview of how a query is processed in SQL Server and how storage and memory play a part in that. Everyone is invited to this introductory level presentation and should be appealing to DBAs, DB BI Developers and System Administrators. Party hats not included, rated G for Geeks.

Speaker(s):

  • Ayman El-Ghazali

Track and Room: Track #5 (Dev) - N/A


Title: SQL 2012 Table Compression

Abstract: SQL Server 2008 has introduced Table compression to the DBA toolkit. We all know there are different kinds of compression available in SQL Server. What some may not know is the subtleties of compression. Such subtleties include that not all Page Compressed tables are entirely page compressed. This session will show you how to reach into the database and discover compression states at the page level. At the lower level, this session will also show how to determine compression settings of objects in the database. Participants will be able to use undocumented commands as well as commands such as PIVOT to derive some interesting information from the database engine.

Speaker(s):

  • Jason Brimhall

Track and Room: Track #7 (Misc) - N/A


Title: Database Performance Monitoring with Spotlight on SQL Server Enterprise

Abstract: Don’t miss this educational session that will help put an end to your application outages. See how to ensure peak SQL Server performance and keep your applications up and running. Learn how to simplify your work with in-depth monitoring and diagnostics. Experience easy tips to:

  • Set up comprehensive data collections within seconds
  • Create a series of threshold-based alerts automatically and tie them to email notifications
  • View the historical state of the instance when an issue occurred
  • Monitor the entire application stack to identify bottlenecks
  • Diagnose the source of CPU or I/O problems immediately
  • Integrate Spotlight on SQL Server data with SSRS
  • Monitor additional connections, such as SSAS, VMware, SQL Azure, and any Windows OS

Speaker(s):

  • David Orlandi

Track and Room: Track #7 (Misc) - N/A


Title: SQL 2012 Extended Events

Abstract: Extended Events were introduced in SQL Server 2008. With SQL 2012, we have seen a significant upgrade to this feature. Join me for a little adventure into what extended events are. We will discuss how to use extended events to aid in performance tuning and in day to day administration. We will also explore some background and the architecture of extended events.

Speaker(s):

  • Jason Brimhall

Track and Room: Track #7 (Misc) - N/A


Title: Database Performance Analyzer

Abstract: Are you struggling with performance issues and your current tools are not providing answers? This presentation outlines a method for determining the best approach for tuning SQL statements by utilizing response-time analysis. Real-life case studies are used to demonstrate the techniques. Much of what you’ll learn falls beyond OEM, so this is a “must-see” for those who rely on Performance Packs.

Speaker(s):

  • Carlos L Chacon

Track and Room: Track #4 (DBA) - N/A


Title: 12 Steps to Workload Tuning

Abstract: We might know how to tune a query for optimal performance or create additional indexes to ensure faster execution, but how do we ensure that our changes don’t hurt our total workload? Have you ever completed an upgrade and wondered if you were truly getting better performance? Do we know if the new 3rd Party application upgrade will make performance better or worse? In this session, we will go over a process used to tune a workload and answer the common questions above. In this presentation we will also use Distributed Replay, XEvents and ClearTrace to answer these questions and even give you a little insight into how you can document these changes to help you get that next raise.

Speaker(s):

  • John Sterrett

Track and Room: Track #6 (Misc) - N/A


Title: Crazy Things That Developers Do

Abstract: Throughout my career, I’ve seen developers do some pretty crazy things to databases (and truth be told, I’ve done some of these myself!). Come to this session to learn what we do (from opening up the database to SQL Injection attacks, how SQL can use Referential Integrity to optimze queries, and the pitfalls of using NOLOCK), why it’s bad to the database server (or your career)… and alternatives that can be used instead. Trust me… your DBA will love you for making these changes.

Speaker(s):

  • Wayne Sheffield

Track and Room: Track #6 (Misc) - N/A


Title: DataViz You Thought You Couldn’t Do with SSRS

Abstract: Despite SQL Server Reporting Services (SSRS) being a very flexible and adaptable tool when it comes to visualization techniques, very few venture beyond its ready-made charts. Most of the time, all it takes to build a chart considered “outside the scope” of SSRS is a bit of lateral thinking. Sometimes, we need to go a little further and use custom code. Join this session as we bust popular myths around “impossible in SSRS” visualizations and construct them live in SSRS!

Speaker(s):

  • Jason Thomas

Track and Room: Track #1 (BI) - N/A


Title: Data Warehouse ETL Rollback with SSIS 2012

Abstract: Loading a data warehouse can be fraught with data quality issues, data type mismatches, and failed loads. To combat these issues and load your data quickly can be a challenge. This session will explain step-by-step how to implement an ETL rollback framework to remove any data that was loaded incorrectly. Based on a real-world implementation, this framework can either automatically or manually load the corrected data, making your life easier.

Speaker(s):

  • Jessica Moss

Track and Room: Track #1 (BI) - N/A


Title: Administering Managing the Power BI Environment

Abstract: Power BI for Office 365 is Microsoft’s new self-service BI offering. Just because it emphasizes self-service doesn’t mean a system administrator isn’t an important role! In this session we will discuss the overall system components and how a Power BI site in SharePoint Online differs from an on-premises SharePoint BI site. We will walk through how to best handle setting up connectivity to data sources, when a gateway is needed, and what data refresh capabilities exist. We will also consider how and when to create OData feeds from your corporate on-premises data sources, and how those OData feeds affect Enterprise Data Search functionality.

Speaker(s):

  • Melissa Coates

Track and Room: Track #2 (BI) - N/A


Title: Treating Tables Like Legos, Partitioning Basics

Abstract: Partitioning allows us to isolate parts of our table as small chunks called partitions. In turn, these partitions allow us to do some really cool tricks for manageability and performance. In this session we’ll look at the concepts surrounding partitioning and how we can apply them. We’ll reinforce what we cover with some cool demo’s showing some really neat tricks.

Speaker(s):

  • Brandon Leach

Track and Room: Track #5 (Dev) - N/A


Title: Practical SQL: High Availability and Disaster Recovery for SQL Server

Abstract: From log shipping to Always On Availability Groups, SQL Server has a lot of options for keeping your systems up and your data safe. In this session we will look at the various HA/DR options available in SQL Server and discuss the pros, cons, tips and tricks to each of them. Be sure to bring your questions because we won’t leave until the last question is answered.

Speaker(s):

  • Mike Sullivan

Track and Room: Track #5 (Dev) - N/A


Title: Inside of Indexes

Abstract: We will navigate through the internal differences between Clustered and non-Clustered indexes. Will take a look how indexes are built, what page splits are and how SQL Server uses indexes to retrieve a data. In that session we will use DBCC IND and DBCC PAGE and dig into pages’ binary code. That is Intermediate session for everybody who already knows about indexes, but doesn’t really know how they work.

Speaker(s):

  • Slava Murygin

Track and Room: Track #4 (DBA) - N/A


Title: Wrangling performance with Resource Governor

Abstract: In this introductory session we’ll delve into the basics of the resource governor feature in SQL Server. We’ll look at the types of issues this feature can help resolve. We’ll then delve into various components of the feature, such as a classifier function, workload groups and resource pools. Finally we’ll bring all this together with an example implementation. From there, if time allows, we’ll look at best practices and questions to answer to ensure a successful implementation.

Speaker(s):

  • Brandon Leach

Track and Room: Track #6 (Misc) - N/A


Title: Judge, Jury, and Executioner–A First Look At Execution Plans

Abstract: When a query is run against a database, a plan is formed to do the work. This session will serve as an introduction on how to read and interpret execution plans. We will also take a look at the execution plan that won the ‘Hairy’ Execution Plan contest on SQLCruise Miami in 2013! Take a peek at http://sqlcruise.com/winner-of-the-2013-caribbean-landlubber-sql-sentry-hairy-execution-plan/

Speaker(s):

  • Carlos L Chacon

Track and Room: Track #4 (DBA) - N/A


Title: Your Best Interview Ever

Abstract: Are you looking for a career change? Good News! Technology is back on the move and companies are again hiring. I’ll cover key strategies you can use to make your face-2-face interview the best ever increasing chances for a new job and new adventure.

Speaker(s):

  • Chris Skorlinski

Track and Room: Track #3 (Pro Dev) - N/A


Title: Making Predictions with Microsoft Data Mining Tools

Abstract: Whether predicting customers or All Stars, the process and the tools remain the same. Microsoft’s Analysis Services Data Mining tools enable you to quickly profile your data, identify hidden relationships and predict future outcomes based on those relationships. Join me to see what data mining is, what data mining is not and how Microsoft’s data mining tools can help you analyze your business. During this session, I will walk us through a start-to-finish data mining prediction project. It’s easier than you might have thought.

Speaker(s):

  • Mark Hudson

Track and Room: Track #2 (BI) - N/A


Title: Community and Cool Stuff

Abstract: Learn how to navigate the SQL Server Community. There are a lot of great resources out there - Most of them Free. Learn what is available and how you can get the most of the community. We will them explore THREE cool features in SQL Server 2014 - Clustered Column-Store Index, Buffer Pool Extension, and In-Memory OLTP Database Technology (aka Hekaton).

Speaker(s):

  • Rick Heiges

Track and Room: Track #4 (DBA) - N/A


Title: Floating on a Hybrid Cloud: SQL Server 2014 Windows Azure

Abstract: In this session we will discuss and demonstrate the cloud integration capabilities of SQL Server 2014, the Windows Azure Platform, and scenarios for leveraging hybrid cloud infrastructure. We will discuss and demonstrate deploying SQL Server 2014 running on a Windows Azure Virtual Machine and also discuss and demonstrate the Windows Azure SQL Database. We will also discuss best practices and demonstrate techniques for managing both on-premises and cloud-based resources.

Speaker(s):

  • Timothy McAliley

Track and Room: Track #2 (BI) - N/A


Title: Check Engine Lights

Abstract: Together we’ll explore SQL Server “check engine lights”, those little indications that SQL Server needs your attention. Ignore these and you could be stuck alongside the road with a broken engine.

Speaker(s):

  • Chris Skorlinski

Track and Room: Track #7 (Misc) - N/A


Title: Automate your daily checklist with PBM and CMS

Abstract: This talk will give you an introduction into monitoring SQL Server using Policy Based Management and Central Management System which is provided out of the box with SQL Server. I will then show you how you can combine these features with the Enterprise Policy Management Framework on codeplex to provide monitoring for your whole SQL Server farm. This topic assumes you know nothing about PBM and CMS and will include lots of examples with only a few PowerPoint slides.

Speaker(s):

  • John Sterrett

Track and Room: Track #5 (Dev) - N/A


Title: Congrats on your promotion to DBA, now what?

Abstract: For those of you that don’t have a full time DBA on staff, this session is built around you. I will give you the skills and tools necessary to successfully manage Microsoft SQL Server. Automation is the key to any monitoring effort and SQL Server is no different. I will show you publicly available tools and scripts to alert you when key areas of SQL Server are being stressed. Proactively monitoring SQL Server will make you more efficient and allow you to continue your success within your role.

Speaker(s):

  • Doug Purnell

Track and Room: Track #3 (Pro Dev) - N/A


Title: SSIS Templates Can Make Your Life Easier

Abstract: How many times have you started a new SSIS project and added the same components that you’ve added to almost every other package you’ve created? Components to handle logging and errors or even a standard workflow for loading data files. In this session I’ll show you how you can create standard templates that already contain any and all of the common components you desire. We’ll also look at how to implement and use these templates so that the next time you create a SSIS package you can spend your time on the work you actually need to do instead of implementing common components over and over again.

Speaker(s):

  • Brian Davis

Track and Room: Track #2 (BI) - N/A


Title: Know Backups and Know Recovery

Abstract: It is easy to schedule full backups to run each night, but is that the right decision for your organization? You say you have a backup strategy, but what is your recovery strategy? Do you have a well-executed recovery plan? In this session I will cover several methods for performing much needed backups and how to recover those backups. Full, Differential, File Group, Transaction logs and recovery the tail end of a the log. He will discuss industry best practices and hopefully cause you to validate and test your current strategy.

Speaker(s):

  • Tim Radney

Track and Room: Track #4 (DBA) - N/A


Title: T-SQL Anti-Patterns

Abstract: Experience with a platform gives us patterns: common techniques which we can use to solve a number of recurring problems. They also give us anti-patterns: common techniques we often use to solve a number of recurring problems incorrectly. This session will cover a number of anti-patterns related to writing T-SQL code. We will cover each anti-pattern in detail, explaining the problem, why you might reach for the anti-pattern, and better alternatives which won’t leave you hurting for performance.

Speaker(s):

  • Kevin Feasel

Track and Room: Track #7 (Misc) - N/A


Title: Hacking the SSIS 2012 Catalog

Abstract: Integration Services 2012 offers a brand new way to store, log, and execute SSIS packages – the SSIS Catalog. How does the Catalog work? Can it be customized? Can it be extended? Yes it can! In this presentation, Andy Leonard shows you how!

Speaker(s):

  • Andy Leonard

Track and Room: Track #1 (BI) - N/A


Title: The Spy Who Loathed Me - An Intro to SQL Security

Abstract: You have lots of data you have painstakingly collected over the years. How do you ensure that data is protected from hackers, spies and other ne’er-do-wells? Understanding the vast array of security features available in SQL Server is the first step in helping you determine what actions you need to take now to protect your data.

Speaker(s):

  • Chris Bell

Track and Room: Track #5 (Dev) - N/A


Title: Using BIML as an SSIS Design Patterns Engine

Abstract: Business Intelligence Markup Language provides a powerful solution for creating and managing SSIS Design Patterns. Andy Leonard, one of the authors of SSIS Design Patterns, demonstrates the flexibility of BIML in this session.

Speaker(s):

  • Andy Leonard

Track and Room: Track #1 (BI) - N/A


Title: Using Expressions to Avoid Three SSRS Annoyances

Abstract: As powerful as it is, SQL Server Reporting Services still has frustrating annoyances. Three in particular are: 1) non-queried parameter values must be entered one value at a time, with lots of clicking along with way; 2) the page header and page footer sections cannot contain data regions and therefore cannot display sets of data-driven values; and 3) matrix reports promise the analytical ability of Excel PivotTables but fall short because they are fixed and lack the ability to dynamically slice-and-dice data by values selected by the user. With the expression techniques taught in this session, these annoyances will annoy no longer because you will be able to work around all three.

Speaker(s):

  • Geoff Johnson

Track and Room: Track #1 (BI) - N/A


Title: Basic Monitoring with Perfmon

Abstract: Perfmon is a standard windows monitoring tool available on every windows deployment. It can provide a wealth of information about the activities within your system. We will cover the basics in this session which include how to setup/schedule perfmon to capture data as well as some basics around initial analysis. This session will have a strong component of demos.

Speaker(s):

  • Rick Heiges

Track and Room: Track #7 (Misc) - N/A


Title: ETL Architecture Chekup: Avoiding Costly Mistakes

Abstract: In this session, we will review a list of costly mistakes we make when designing and building ETL and data integration processes, and provide with actionable recommendations to avoid them. You will get a check-list you can use in your projects to ensure the ETL processes include the capabilities a solid data integration sub-system should have and you will be better prepared to assess the robustness and reliability of ETL solutions.

Speaker(s):

  • Rafael Salas

Track and Room: Track #2 (BI) - N/A


Title: How to Write a DML Trigger

Abstract: Triggers are extremely powerful and useful (if somewhat rarely needed) objects that are coded very similar to a common stored procedure. Yet for their similarity, there are some very important differences that need to be understood. In this session, I will walk through what goes into writing a robust DML trigger, starting with a simple version of a trigger, and working through some very useful applications of DML Triggers..

Speaker(s):

  • Louis Davidson

Track and Room: Track #6 (Misc) - N/A


Speakers

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

Rick Heiges

Twitter: - heigesr2

LinkedIn: Rick Heiges

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

Rick is a Former Data Platfrom MVP and Sr. Consultant for Microsoft where he focuses on working with customers on their data estate. His career includes work as a DBA, University full-time faculty member, Systems Analyst, Project Leader, and Developer. He has found his passion in working with data and the community. Rick served nine years on the PASS Board of Directors and spearheaded the popular 24 Hours of PASS event. He also started his local User Group in 2002. Today, he spends much of his time with his head in the clouds.

Carlos L Chacon

Twitter: - @CarlosLChacon

LinkedIn: Carlos L Chacon

Contact: http://sqldatapartners.com/blog

Carlos Chacon is the managing partner of SQL Data Partners LLC and co-host of the popular SQL Data Partners Podcast. While getting his start as a typical accidental DBA, Carlos has sat on Microsoft exam review panels, served as regional mentor and chapter leader. He enjoys traveling and has been to four continents, speaks Spanish and can eat his weight in raspberries (not yet proven). He and his family live in Richmond, Virginia.

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.

Mike Sullivan

Mike Sullivan has been working with SQL Server since Version 4.21 (running on NT 3.1). In his current role as a Senior Premier Field Engineer for Microsoft, he is responsible for improving the customers experience by providing enterprise class solutions for SQL Server. Mike lives in central Virginia and when he’s not tinkering with technology, he enjoys camping, cycling, and sailing with his wife and two daughters.

Ayman El-Ghazali

Twitter: - thesqlpro

LinkedIn: Ayman El-Ghazali

Contact: http://www.thesqlpro.com

Ayman is a passionate SQL Server DBA, Developer, and BI Developer. His passion for technology started when he was a young boy playing DOS games on his father’s computer. He can be reached via his blog or twitter handle and is looking forward to connecting with other SQL Geeks.

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.

Jessica Moss

Twitter: - @jessicammoss

Contact: http://www.jessicammoss.com

Jessica M. Moss is a well-known architect, speaker, author, and Microsoft MVP of SQL Server Business Intelligence. Jessica#39;s expertise includes data warehouse modeling, Integration Services ETL, Analysis Services semantic modeling, Reporting Services report design, and helping customers across industries successfully implement and enhance their BI solutions. She enjoys sharing her knowledge with the SQL community and has co-authored numerous technical books.

Brandon Leach

Twitter: - SQLServerNerd

LinkedIn: Brandon Leach

A Microsoft Data Platform MVP, Brandon manages the DB Operations team for financial company x. With a data estate of several petabytes, he puts a high focus on performance tuning and automation. He is a frequent speaker at events like conferences and user groups.

Rick Heiges

Twitter: - heigesr2

LinkedIn: Rick Heiges

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

Rick is a Former Data Platfrom MVP and Sr. Consultant for Microsoft where he focuses on working with customers on their data estate. His career includes work as a DBA, University full-time faculty member, Systems Analyst, Project Leader, and Developer. He has found his passion in working with data and the community. Rick served nine years on the PASS Board of Directors and spearheaded the popular 24 Hours of PASS event. He also started his local User Group in 2002. Today, he spends much of his time with his head in the clouds.

Jason Thomas

Twitter: - @SqlJason

LinkedIn: Jason Thomas

Contact: http://www.SqlJason.com

Jason Thomas is a Microsoft Certified SQL Server professional with over 10 years of Microsoft BI experience. He is a BI Consultant for BlueGranite, based in Charlotte, NC. When he#39;s not at work, Jason likes sharing his time between the MSDN forums (for which he was recognized with the Microsoft Community Contributor award), blogging about MSBI (www.SqlJason.com), speaking at SQL Server events, and watching movies with his wife (not necessarily in that order).

David Orlandi

Contact: http://www.dell.com

David Orlandi brings over 13 years of experience in software consulting to his position as Systems Consultant at Dell Software. Dave is responsible for supporting the sales division by communicating and demonstrating the value of the Performance Monitoring suite of solutions. Prior to Dell, Dave held similar positions at Embarcadero Technologies, Toshiba, and Thomson. Dave graduated from the Whitman School of Management at Syracuse University with a bachelor’s degree in Marketing.

Timothy McAliley

Twitter: - sysframeworks

LinkedIn: Timothy McAliley

I am currently a Microsoft Cloud Solutions Architect in the Washington, DC area. Previously, I was a Microsoft Technology Solutions Professional (TSP), a Microsoft Account Technology Strategist and a SQL Server Premier Field Engineer. Prior to Microsoft, I was a Technical Trainer and DBA in the Enterprise Security Group at Symantec . I have been in IT for over 20 years. My particular interests are IT operations, IT auditing, IT audit frameworks, IT service management (ITSM), ITIL, information security, project management, and database/application tier high availability solutions. I also co-run the Northern Virginia SQL Server User Group ( @novasl) and also co-run the Azure Datafest events.

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.

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.

Chris Skorlinski

Chris Skorlinski has been with Microsoft for 17 years. He is a Support Escalation Engineer at the Microsoft Charlotte NC office specializing in performance tuning and troubleshooting Replication. His is a contributor to SQLShare.com training as well as his own BLOGs on Replication Performance at http://blogs.msdn.com/ReplTalk/. #160;

John Sterrett

Twitter: - JohnSterrett

LinkedIn: John Sterrett

Contact: https://johnsterrett.com/community/

John Sterrett is a MCSE: Data Platform, Principal Consultant, and the Founder of Procure SQL LLC. John has experience presenting at community events, including Microsoft Ignite, PASS Member Summit, SQLRally, 24 Hours of PASS, SQLSaturdays, PASS Chapters, and Virtual Chapter meetings. John is a leader of the Austin SQL Server User Group and is the founder of the HADR Virtual Chapter. John’s community activities can be found at https://johnsterrett.com/community/

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.

Louis Davidson

Twitter: - drsql

LinkedIn: Louis Davidson

Contact: https://www.red-gate.com/simple-talk/author/louis-davidson/

Louis Davidson has worked in the IT industry for over 25 years as a corporate database developer and architect. He has been a Microsoft SQL Server MVP for 15 years and has written five books on database design, and contributed to many other SQL Server books as an author and tech editor. He has a bachelor’s degree in Computer Science from the University of Tennessee at Chattanooga. You can read more about Louis at http://drsql.org.

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

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).

Brandon Leach

Twitter: - SQLServerNerd

LinkedIn: Brandon Leach

A Microsoft Data Platform MVP, Brandon manages the DB Operations team for financial company x. With a data estate of several petabytes, he puts a high focus on performance tuning and automation. He is a frequent speaker at events like conferences and user groups.

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.

Rafael Salas

Twitter: - @RafSalas

Contact: http://www.rafael-salas.com

Rafael Salas is a recognized speaker and published author with more than 17 years of experience in business intelligence and information architecture. He is the recipient of multiple industry recognition, including the Microsoft MVP Award and The Data Warehouse Institute Best Practices Award. Rafael is also an active member of the SQL Server technical community and blogs regularly at www.rafael-salas.com.

Brian Davis

Twitter: - @Brian78

LinkedIn: Brian Davis

Contact: http://blogs.sqlsentry.com

Brian Davis is a Product Integration Engineer at SentryOne and has over 15 years in the IT field in multiple areas including software development, support, user training, and as a DBA. He has been working with SQL Server since 2003 and has hands-on experience with SQL Server 2000 through 2016. Brian is also a PASS Regional Mentor and an active member and leader of the Ohio North SQL Server User Group.

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.

Chris Skorlinski

Chris Skorlinski has been with Microsoft for 17 years. He is a Support Escalation Engineer at the Microsoft Charlotte NC office specializing in performance tuning and troubleshooting Replication. His is a contributor to SQLShare.com training as well as his own BLOGs on Replication Performance at http://blogs.msdn.com/ReplTalk/. #160;

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.

Andrew Kelly

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

Andrew J. Kelly is a SQL Server MVP with over 20 years’ experience with relational databases and application development but specializes in Performance, Scalability and Maintainability of large scale SQL Servers. He is a regular speaker each year and a contributing editor and writer for SQL Server Magazine.

Melissa Coates

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

LinkedIn: Melissa Coates

Contact: https://www.CoatesDataStrategies/blog

Melissa Coates is a data architect with a background in data warehousing and business intelligence. Her current professional focus is enterprise-level Power BI governance, deployment, security, and administration. As the owner of Coates Data Strategies, Melissa produces training and consults to help companies strengthen and sustain their data-driven initiatives. Melissa is big supporter of the technical community, and has been a Microsoft Data Platform MVP since 2013. You can visit Melissa’s website at CoatesDataStrategies.com, which includes community resources like diagrams, blogs, and videos.

Geoff Johnson

Twitter: - @chaunticleer86

Contact: http://selectstatements.blogspot.com

Geoff is the BI Developer for Custom Data Systems, Inc., a software company offering data management for CPA associations and similar non-profit groups. He has been working with SQL Server for over fifteen years, with a focus on BI and SSRS for 6+ years. Since January of 2016 he has been designed and implemented a data warehouse solution for CDS, Inc. He is an active member of the Richmond SQL Server User Group and counts it a privilege to share what he has learned the hard way with others so they don’t have to. He also occasionally blogs about his lessons learned.

John Sterrett

Twitter: - JohnSterrett

LinkedIn: John Sterrett

Contact: https://johnsterrett.com/community/

John Sterrett is a MCSE: Data Platform, Principal Consultant, and the Founder of Procure SQL LLC. John has experience presenting at community events, including Microsoft Ignite, PASS Member Summit, SQLRally, 24 Hours of PASS, SQLSaturdays, PASS Chapters, and Virtual Chapter meetings. John is a leader of the Austin SQL Server User Group and is the founder of the HADR Virtual Chapter. John’s community activities can be found at https://johnsterrett.com/community/

Carlos L Chacon

Twitter: - @CarlosLChacon

LinkedIn: Carlos L Chacon

Contact: http://sqldatapartners.com/blog

Carlos Chacon is the managing partner of SQL Data Partners LLC and co-host of the popular SQL Data Partners Podcast. While getting his start as a typical accidental DBA, Carlos has sat on Microsoft exam review panels, served as regional mentor and chapter leader. He enjoys traveling and has been to four continents, speaks Spanish and can eat his weight in raspberries (not yet proven). He and his family live in Richmond, Virginia.

Doug Purnell

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

LinkedIn: Doug Purnell

Contact: http://sqlnikon.wordpress.com

Doug Purnell is a DBA at Elon University and is a co-leader for the Triad SQL BI PASS User Group. In his spare time you can find Doug taking photos and cooking up some BBQ on his cooker.

Sponsors

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

Back to the SQLSaturday Event List

Back to the home page