SQLSaturday #300 - Kansas City 2014

Event Date: 09/13/2014 00:00:00

Event Location:

  • Cerner Corporation’s Riverport Campus
  • 6711 NE Birmingham Rd
  • Kansas City, Missouri

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


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

Title: Analyzing I/O Subsystem Performance

Abstract: SQL Server is often I/O bound - but why? Do you feel lost when talking to your storage administrator? Are your storage subsystems like a mysterious black box where your databases live but you can’t go visit? This session will get you up to speed with the fundamentals of storage subsystems for SQL Server. You will learn about the different types of storage that are available, and how to decide what type of storage to use for different workload types. You will also learn useful tips and techniques for configuring your storage for the best performance and reliability. We’ll cover methods to effectively measure and monitor your storage performance so that you will have valuable information and evidence available the next time you have to discuss IO performance with your storage administrator. Come to this session to learn how to analyze I/Os as well as options to reduce the bottlenecks.


  • Glenn Berry

Track and Room: - N/A

Title: Outages; Dispatchers, Cops and Detectives

Abstract: Recently I watched the news as a crisis situation was played out. There were police officers were running around, moving behind large solid objects like cars, putting on their protective gear.  At first it looked like mass chaos but after watching it closely the officers moved like a well-oiled machine.   The more I watched the more I realized that as database professionals we have crisis situations as well. As the situations are compared there are a number of things that we can learn by watching how other professionals handle crisis.  This session is dedicated to looking at how others handle crisis so that we can learn from what they do.


  • Chris Shaw

Track and Room: - N/A

Title: Geekin’ Out on Extended Events -Deconstructing the system_health session to solve performance issues

Abstract: Extended Events are used to gather a wide range of performance information to help troubleshoot performance problems in SQL Server. The system_health session is an Extended Events session that is included by default with SQL Server. This session starts automatically when the SQL Server database engine starts, and runs without any noticeable performance effects. This presentations will take you on an in-depth tour of the data provided in the system_health event session and how to use it to troubleshoot performance issues. Cases studies from real-life examples will be used to demonstrate tips and tricks.


  • Janis Griffin

Track and Room: - N/A

Title: Increase your SSIS productivity with Biml

Abstract: Business Intelligence Markup Language (Biml) is an XML language for Microsoft Business Intelligence that can take your Integration Services package development to the next level. Creating template packages added productivity to your Integration Services development effort. If the template design changes after development begins, a fair amount of rework to packages could be needed. See how Biml can help create template packages that can better adapt to changing business needs and allow for more comprehensive design or redesign.

This session will be a demo based session that will inspire you to make Biml your number one integration services development tool. Learn how to use Biml scripts to create staging tables and integration services packages. Add metadata to your Biml scripts and really watch the possibilities expand.


  • Reeves Smith

Track and Room: - N/A

Title: Twice in a Lifetime: T-SQL Refactoring 101

Abstract: Whether it’s because you inherited the code from the “last guy,” or your stored procedures haven’t been looked at since the database was created in 2001, there will come a time when you need to rewrite old code. When you start this project you may ask yourself, how did I get here? And you may ask yourself, how do I work this? This is not my beautiful database. This is not my beautiful T-SQL. Letting the data go by, information flowing to the end users is the goal. Refactoring old code can be tedious, but necessary. Sometimes it isn’t just about identifying the worst queries in your application, but figuring out how to rewrite everything to introduce the best practices that the last guy didn’t know about five years ago.

This session will cover ways to quickly find old T-SQL antipatterns, tools that can help make things easier to update code, and deprecated features that can’t be used in modern versions of SQL Server. Don’t leave your old T-SQL the same as it ever was.



Track and Room: - N/A

Title: Capture Change and Apply it With Change Data Capture SSIS

Abstract: Whether you are trying to setup a new data warehouse, keep it updated, audit changes to your databases or quickly load changes to another database Change Data Capture (CDC) is a solution for all of these and can now be setup and supported easily with SQL Server SSIS 2012! Change Data Capture (CDC) has been around since SQL Server 2008, but has been underused because it was difficult to fully implement. SSIS 2012 now provides support for CDC with new components that make consuming the captured data very easy to apply. This session will define what CDC is and with live demos show how it is setup on your databases. Once it has been setup then you need to consume and apply those changes, this will be demonstrated with live demos using SSIS 2012 to create packages that apply the changes.


  • Steve Wake

Track and Room: - N/A

Title: SSIS Project Deployment Model: Deployment and maintenance

Abstract: In this session, you’ll learn everything you need to know to successfully deliver a modern SSIS solution. We’ll cover the mechanics of deployment; creation, configuration and migration of Environment variables; monitoring execution troubleshooting.


  • Bill Fellows

Track and Room: - 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.


  • Tim Radney

Track and Room: - N/A

Title: Can you check on the database?

Abstract: How many times have you heard the phrase, “Can you check on the database?”. There’s a problem, and they want YOU to validate it’s not a problem with Sql Server. How do you quickly validate the health of Sql Server? Is there a problem you’re not seeing? At what point is Sql Server not the problem? This session covers a step by step guide to validate that Sql Server is healthy and running its best. This also provides a framework to keep Sql Server healthy over time and prevent future problems. If you’re not sure how to “check on the database”, this session is for you!


  • Tristan Wilson

Track and Room: - N/A

Title: Introduction to Powershell cmdlets for DBAs

Abstract: You’ve been hearing about this newfangled craze, and it’s time to learn exactly why it’s called POWERshell. You’ll want to take notes, or better yet, bring your laptop and start using Powershell immediately. We will get Posh running and then I’ll introduce you to the basic concepts, with examples to make things happen right away. We’ll work on SQL Server with Powershell, and learn some cool techniques. Come see this all-demo, hands-on session!


  • Jennifer McCown

Track and Room: - N/A

Title: Troubleshooting the Memory of SQL Server

Abstract: Memory is one of the most confusing and least understood topics for SQL Server. In this session, we will discuss and demonstrate tools and techniques for memory related problems that can occur with the SQL Server Database Engine based on actual customer scenarios as seen by Microsoft support. This is an advanced session as we will talk about the memory architecture of SQL Server and demonstrate and teach you the tools and metrics to have a more complete understanding of SQL Server memory. This session can also help prepare you to monitor and manage memory consumption of your SQL Server to be proactive and prevent problems before they occur


  • Bob Ward

Track and Room: - N/A

Title: Master of All I Survey - track code changes and more across your environment

Abstract: Almost everyone’s seen it happen - problems due changes made on servers, be it SPs, index rebuilds, or even configuration changes. But what if you could look historically across servers and track down what changes were made when, by who, and from where? It exists, it’s already built into SQL Server standard edition from 2005-2014, and it’s easy to implement. Come learn what Event Notification is and why you’ll want it in your environment. We’ll start at the basics and end by checking new production code changes into TFS.


  • Michael Bourgon

Track and Room: - N/A

Title: Introduction to Execution Plans

Abstract: Ever wonder what happens when a query is processed? Got a process that is running slow at the office and your boss in looking at you for answers? Want to look like a hero to your boss for fixing something that no one else could figure out? Then you might want to consider this session. Execution plans tell you what steps were taken to generate the results sets you did. In analyzing these plans, you can figure out what you are doing that is not efficient, so you can fix it. This session will give you the foundation you will need to do analysis so you can write better code and help your company with their performance issues.


  • Nathan Heaivilin

Track and Room: - N/A

Title: Fill Factor: Performance or Nuisance?

Abstract: We expand on a little known but widely modified feature of SQL Server. Fill Factor is something to address in performance tuning after all the low hanging fruit has been addressed. This is not a deep dive into the underlying mechanics of how SQL Server works, but a softer more useful approach to this subject. We will be looking into why changing this could be either good or bad for your environments. This presentation is useful for DBA’s as well as developers trying to get a little more out of their servers.


  • WIlliam Barnes

Track and Room: - N/A

Title: Data Modeling 101

Abstract: Covering the basics for the beginner and those that have been thrown into a modeling role and have been cowboy’n it like the Wild West. We’ll cover why you should bother with a conceptual model and invest some of your project time in the modeling task. We will go over some different modeling techniques around Normalized, Dimensional and Data Vault options. And lastly, considerations for scalability, sustainability and empowering you with a Data Access Layer so you stay in control of your architecture as opposed to the application beast. Yee-Haw!


  • Leslie Weed

Track and Room: - N/A

Title: REGEX for DBAs

Abstract: As DBAs there are many tasks we’re asked to do every day that we just accept as taking a long time because of some manual component we can’t get around. Many of these tasks can be brought into line with regex. You can use it to format your own T-SQL and create code that writes code with relative ease. I’m going to teach you the basics of regex and show you how to perform many tasks that’ll make your life much easier like deploying code, formatting T-SQL, and much more.


  • Sean McCown

Track and Room: - N/A

Title: TempDB Parasites!

Abstract: Unless you happen to be Chuck Norris, your SQL Server instances only have one tempDB. That makes tempDB a single point of contention for an instance. What’s worse is that there are a lot of things going on in tempDB that you may not be aware of. Let’s look at some things that can use tempDB while we’re not looking.


  • Jason Hall

Track and Room: - N/A

Title: Continuous Integration for Databases

Abstract: Building software is hard, and we often find that fixing bugs is expensive if they are not caught early. Continuous Integration has proven to be a valuable technique in improving software quality by finding problems quickly and letting developers know immediately they have introduced a bug.This session demonstrates how you can implement CI for SQL Server databases, execute automated tests against your code and inform developers that they have caused a problem immediately.


  • Steve Jones

Track and Room: - N/A

Title: Visual Studio Database Projects and Database Deployment

Abstract: How does your shop keep track of changes to your database schema? What are the database deployment procedures? Do you just make changes directly in production? In this beginner level session you will learn how to easily manage your database schema by leveraging SSDT in Visual Studio with Database Projects, create deployment scripts, and generate re-runnable deployment packages called DACPAC’s. We will review how source control interacts with database projects as well as discuss how you can use PowerShell to automate your database deployments.


  • Jason Kassay

Track and Room: - N/A

Title: Read Dirty to Me - Isolation Levels/User Impact

Abstract: Issue a “SELECT {data} FROM {myTable}” statement and users need to trust the data returned is accurate. What happens when multiple processes access the same data? What happens further if one of those process is an UPDATE or even a DELETE statement? How about if both processes will be updating that data? Understanding Isolation in SQL Server is paramount in ensuring data integrity in your system. We will cover the different levels of isolation and how they impact what a user views when accessing the data at a given point-in-time.


  • Wendy Pastrick

Track and Room: - N/A

Title: DBA 911 - Database Corruption

Abstract: Database corruption is simply a fact of a DBA’s life - if you haven’t seen it yet, you will. Success or failure depends on having a solid plan to deal with different types of corruption. In this session, we will discuss usage of related DBCC commands, monitoring for corruption with SQL Agent Alerts and Jobs, and when to restore versus repair. After attending this session, you will be able to check for corruption, identify different types of corruption, and take the appropriate measures for dealing with it.


  • David Maxwell

Track and Room: - N/A

Title: Table Partitioning 101

Abstract: Do you have large tables you can’t delete old data from or perform maintenance on? Then this may be for you! Table Partitioning 101 will make an introduction to table partitioning through the GUI and a code based approach. The session will be a discussion about how to make it work and will include: creating partitioned tables, partition schemes, left vs. right facing partition functions and how to do a basic switch operation. A small deep dive about how to find out which partition your data is in and what exactly does it mean for an index to be “aligned” will also be discussed.


  • Robert Smith

Track and Room: - N/A

Title: The Fundamentals of Great SQL Query Performance

Abstract: Whether you’re a SQL developer or a DBA, a sound understanding of the factors that make a query perform either well or poorly is vital. In this session, you’ll learn (through many examples) how to find performance pitfalls in your code and the best ways to mitigate those issues.


  • Matt Wigdahl

Track and Room: - N/A

Title: Build ETL in 30 minutes or less with SSIS

Abstract: Learn how to use integration services to create a fast reliable ETL structure that’s designed to insert or update your destination from nearly any source.


  • Zane Brunette

Track and Room: - N/A

Title: XPath - XQuery; I guess if I HAVE to

Abstract: I don’t know anyone who likes it, but the reality is sooner or later you’ll have to use XML in your database career. XML appears in extended events, ring buffer queries, the plan cache, and more and more in stored procedures and columns. Attend this session to find out what you need to know to leverage xpath, xquery, and semi-structured data in administering databases.


  • Russ Thomas

Track and Room: - N/A

Title: Yesterday I Couldn’t Even Spell ‘DBA’.

Abstract: Referred to as “DBA by Default” or “Reluctant DBA”, many people are faced with the situation of suddenly becoming a SQL Server database administrator. Once the initial shock passes they realize that they need help. This is a great place to start finding resources! The abundance of SQL Server books and websites that exist, some good and some not so good, might only increase confusion leading to panic and rash decisions. DON’T PANIC! In this session we will cover ways to address basic problems and offer some suggestions for finding good places to find help.


  • Larry Toothman

Track and Room: - N/A

Title: Making the Leap from Developer to DBA

Abstract: You are a Developer (.NET, SQL or otherwise) but you have been doing some DBA work and have now decided that is all you want to do - how do you make the transition? What do you need to know? This session will cover this topic from first-hand experience.


  • Amy Herold

Track and Room: - N/A

Title: Tabular vs Multidimensional. Lets build it together!

Abstract: This session will be one big demo where we will build both a Tabular and Multidimensional model side by side to contrast and compare the uses of both methods. By the end of this session you should have a good understanding of both modeling methods and how to make use of them in the future.


  • Lance Kolie

Track and Room: - N/A

Title: 10 Ways To Abuse T-SQL

Abstract: Learn 10 common T-SQL mistakes and how to avoid them. Procedural coding, misuse of user-defined functions, and non-SARGable filters are just some of the topics we’ll cover.


  • Tracy McKibben

Track and Room: - N/A

Title: NULL: A Love Story

Abstract: NULL - an unknown value. At least, that’s what it’s SUPPOSED to be. The problem is, NULL is often treated differently based on what you’re doing - even equality is suspect. Join JK as he works on demystifying NULLs in the database, looking at how they interact with various queries and how to work around and with the idiosyncrasies of this sometimes misunderstood concept.


  • JK Wood

Track and Room: - N/A

Title: SQL Server Features That Will Blow Your Mind!

Abstract: How many lines of code does it take to generate a running total? How would you find a value in the next row of data - without using a cursor or loop? How can you efficiently store rows of data with a lot of optional fields, and how can you quickly find which of those rows have values? And how can you eliminate locking without resorting to dirty reads? SQL Server has answers for all of these questions, and none requires more than a few lines of code. Give me an hour, and I will blow your mind!


  • Ed Leighton-Dick

Track and Room: - N/A

Title: Understanding the SQL Server Transaction Log

Abstract: The SQL Server transaction log is one of the most misunderstood components of the database engine. What makes it grow? How does it get truncated? Should I shrink it? What is a VLF? In this session we will answer these questions and more.


  • Randy Knight

Track and Room: - N/A

Title: BI Basics - Finding Return on Data

Abstract: This session will you chart the waters through the sea of Business Intelligence (BI) options. IT departments need tools to turn data into useful information for users. Instead of ROI, this session talks about Return on Data’ for IT Managers.

In this session we look at the roles of data warehousing, big data and business intelligence systems. The Microsoft BI stack has evolved from traditional OLAP cubes to include tabular models, PowerBI, integration with HADOOP, reporting tools and full integration with SharePoint. This session is non-technical.


  • Allen Smith

Track and Room: - N/A

Title: Data Vault Data Warehouse Architecture

Abstract: Data vault is a compelling architecture for an enterprise data warehouse using SQL Server 2014. A well designed data vault data warehouse facilitates fast, efficient and maintainable data integration across business systems. In this session I will review the basics about enterprise data warehouse design, introduce you to the data vault architecture and discuss how you can leverage new features of SQL Server 2014 help make your data warehouse solution provide maximum value to your users.


  • Jeff Renz

Track and Room: - N/A

Title: Writing Better T-SQL Queries with Window Functions

Abstract: SQL Server 2005 and later versions introduced several T-SQL features that are like power tools in the hands of T-SQL developers. If you aren’t using these features, you’re probably writing code that doesn’t perform as well as it could.

This session will teach you how to get great performance, avoid cursor solutions, and create simpler code by using the window functions that have been introduced between 2005 and 2012. You’ll learn how to use the new functions and how to apply them to several design patterns that are commonly found in the real world.


  • Kathi Kellenberger

Track and Room: - N/A

Title: Advanced Spatial Analysis: Beyond Bubble Charts

Abstract: Are you finally ready to unlock the power in your spatial data? In this session, we will explore some advanced spatial analysis techniques, including clustering, binning, and the basic use of spatial statistics. We will then discuss several options for visualizing the results in SQL Server Reporting Services and PowerPivot. Get ready to go beyond bars and bubble charts!


  • Jason Horner

Track and Room: - N/A

Title: Scaling the relational model

Abstract: More data being captured than ever and more business decisions are needing to be made real-time with high volumes of transactions. A well designed relational model is imperative to most business/products success. But, how do we scale it? This talk will cover methodologies for tackling this challenge and will cover techniques using SQL Azure, SQL 2014, and some other cutting edge technologies.


  • Chase Aucoin

Track and Room: - N/A

Title: Concurrency and Asynchronous Processing in SQL Server

Abstract: The fastest way to process large amounts of data in SQL Server is using set-based operations. That is if you can stand the blocking. This session walks through different ways to think about applications when transaction blocking becomes your biggest problem. It covers specific T-SQL suggestions to minimize the rows locked, application architectures to maximize concurrency and reporting solutions to reduce impact on the production database. And always lots of demos and spirited discussion.


  • Bill Graziano

Track and Room: - N/A

Title: SQL Server Virtualization 101

Abstract: What is virtualization? What impact does it have on DBAs and their systems? What aspects of their job stays the same, and what changes? What is really going on inside that black box? The fundamentals of private cloud computing and how it impacts data professionals will be discussed in this interactive session. Tips on how to use the best of virtualization to improve their daily tasks and efficiencies will be demonstrated, and common questions and concerns will be addressed.


  • David Klee

Track and Room: - N/A

Title: The Top Customer Problems: How to avoid calling Bob

Abstract: Come learn about the top problems customers call Microsoft for the SQL Server Database Engine. We will cover a range of topics including performance, errors, memory, and others. Learn more about the details of what customers bring to Microsoft support and learn the specific steps Microsoft uses to help customers resolve these problems. This session will include demonstrations of the tools built into the SQL Server product that you can use every day while deploying, managing, or troubleshooting your SQL Server environment As a bonus, we will talk about new troubleshooting tools coming for SQL Server 2014.


  • Bob Ward

Track and Room: - N/A

Title: SQL Security Best Practices Shrinking Your Attack Surface

Abstract: Every industry has a governing body or standard that requires some layer of security to your data. In my travels I have come to realize that when someone mentions security, DBA’s tend to get frightened. This could be due to a lack of understanding of the requirements or not knowing what SQL Server offers to meet those requirements. In this session we will go over what SQL Server has to offer, Security Best Practices and how you can shrink your attack surface to meet Confidentiality, Integrity and Availability of your Servers and Data. In addition, attending this talk is worth 1.5 Continuing Education credits.


  • Matthew Brimer

Track and Room: - N/A

Title: Fun with Availability Groups

Abstract: Follow along as we adventure through the vastness that is Availability Groups in SQL Server. In this beginners guys we show you how to make an Availability Group from scratch, the new system tables that go along with Availability Groups, and how to troubleshoot your Availability Group using the system tables and SSMS.


  • Christopher Wolff

Track and Room: - N/A

Title: Social Networking Is Alive!!!

Abstract: Social Networking/Media is all over the news today. Did you see that on Facebook? Johnny 5 said what on Twitter?? Can you believe Susie moved to that company?? Do any of those sound familiar? No? Never heard of Twitter? Don’t have any fear as this session is for you! Social networking can be a very confusing place and when you don’t know where to start, that makes it even worse. In this session, we will go over different facets of Social Networking/Media and how you can use them to enhance not only your personal lives but just as importantly, your professional one. We’ll be covering Facebook, LinkedIn and Twitter.


  • John Morehouse

Track and Room: - N/A

Title: Policy Based Management, Trolls and Watchmakers

Abstract: Peanut Butter and Jelly holds two slices of bread together what can hold my Sql Servers together, PBM? Do you like to be constant, have a pattern and be reliable? I have way too much to do, I can’t review every line of code. Help me, please! PBM is your friend, your ally and the gateway to your system. Policy Based Management can be your bridge to your Sql Server. Let PBM be your troll, letting the best pass. But wait, PBM can also be your watchmaker. Policy Based Management, Trolls and Watchmakers, come watch PBM control our systems.


  • Thomas Norman

Track and Room: - N/A


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

Thomas Norman

Twitter: - ArmorDba

LinkedIn: Thomas Norman

Contact: https://armordba.com/

Tom Norman is a Database Architect at KPA with a strong fervor to protect data. He works daily to review and improve data protection methodologies while reviewing governing laws affecting finance, healthcare, and personal data. His areas of expertise include encryption, auditing, data identification, and database object deployment. He is the current leader of the PASS Virtualization Group and Vice President of the TRIPASS user group. You can read his blog at https://armordba.com/ and reach him on twitter at @armordba. Tom speaks at a number of SQLSaturday events and SQL Server user groups.

Bob Ward

Contact: http://blogs.msdn.com/psssql

Bob Ward is a Principal Architect for the Microsoft Azure Data SQL Server team, which owns the development for all SQL Server versions. Bob has worked for Microsoft for 25+ years on every version of SQL Server shipped from OS/2 1.1 to SQL Server 2019 including Azure. Bob is a well-known speaker on SQL Server, often presenting talks on new releases, internals, and performance at events such as PASS Summit, SQLBits, SQLIntersection, Microsoft Inspire, and Microsoft Ignite. You can follow him at @bobwardms or linkedin.com/in/bobwardms. Bob is the author of the new book Pro SQL Server on Linux available from Apress Media.

Jason Horner

Twitter: - jasonhorner

LinkedIn: Jason Horner

Contact: http://blog.jasonhorner.com

Hi, my name is Jason I’m a practice lead at Redapt. I spend most of my day helping clients solve business problems mostly in the Data and Advanced Analytics spaces. Sometimes this involves various and sundry cloud technologies including Azure Data Factory, Azure SQL Data Warehouse, Azure Data Lake Store, Azure Databricks, HDInsight and Azure SQL Database. I’m fluent in several languages including: SQL, C#, Python, and PowerShell.

I’m a Microsoft Certified Master of SQL Server (MCM) and have been recognized for my technical excellence and evangelism efforts by Microsoft by being awarded the Most Valuable Professional (MVP) for the last 5+ years.

In my off hours I like to snowboard, karaoke, ride roller coasters, and play arcade games

John Morehouse

Twitter: - SQLrUs

LinkedIn: John Morehouse

Contact: http://www.sqlrus.com

John Morehouse is currently a Consultant with Denny Cherry Associates living in Louisville, Kentucky. With over 2 decades of technical experience in various industries, John now focuses on the Microsoft Data platform and specializes in Microsoft SQL Server. He is honored to be a Microsoft Data Platform MVP, VMWare vExpert, Friend of Red Gate, Sentry One PAC member Community Ambassador, and 2016 Idera Ace. John has a passion around speaking, teaching technical topics, and giving back to the technical community as much as possible. He is a user group leader, SQLSaturday organizer, and former PASS regional mentor. He is also a blogger, avid tweeter, and a frequent speaker at SQLSaturday’s as well as other conferences.

WIlliam Barnes

Contact: http://www.dbaonthego.com

I have been in IT roughly 12 years now and dealing with SQL Servers for 3+. He is a vice president of the OKC SQL Users group and has been assisting with the OKC SQLSaturdays in one form since 2010.

Tristan Wilson

Tristan is a Kansas City local and currently a database administrator at Datapipe managed hosting. He#39;s worked with all versions of Sql Server starting with 2000 including reporting services. He also has experience with Oracle, DB2, and MySql. Tristan is a returning speaker from previous SQLSaturdays and also the Kansas City Sql Server users group.

Glenn Berry

Twitter: - GlennAlanBerry

LinkedIn: Glenn Berry

Contact: https://glennsqlperformance.com/

Glenn works as a Principal Consultant for Dr. DMV, LLC in Elizabeth, CO. He was a Data Platform MVP from 2007-2017, and he has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS, which proves that he likes to take tests. His expertise includes DMVs, high availability, hardware selection, performance tuning, and Azure SQL Database. He is also an Adjunct Faculty member at University College - University of Denver, where has been teaching since 2000. He has completed the Master Teacher Program at Denver University - University College. He is heavily involved in the SQL Server community, and is a frequent speaker at user groups, SQLSaturdays, and the PASS Community Summit.

Allen Smith

Contact: http://www.cognitiveinfo.com

Allen Smith is a business intelligence and data warehouse builder, speaker and trainer. Allen has an MBA in Computer Sciences and has worked in database services and data warehousing since 1998. Allen has a MCTS certification in Business Intelligence. Allen is a Sr. Business Intelligence Lead at Devon Energy. He enjoys sushi, traveling to obscure places, fixing Rubik’s cubes and prefers Marvel over DC.

JK Wood

Contact: http://www.sqlslacker.net

JK Wood is a Data Warehouse developer with three years of experience working with SQL Server and has worked and played with computers since the mid nineties. He is passionate about helping people to move beyond just writing code to writing beautiful, functional, and above all maintainable software. JK is an active member of the SQL community. He is involved with the Southwest Missouri SQL Server User Group and blogs at http://www.sqlslacker.net

Chris Shaw

Twitter: - @SQLShaw

LinkedIn: Chris Shaw

Contact: http://chrisshaw.wordpress.com/

Chris Shaw started his database career in 1993. Following the Marines, Chris continued working with databases for companies such as Wells Fargo, Pulte Mortgage, and Yellow Pages Inc. Chris has been writing and speaking about SQL Server for over 15 years at events such as SQL Connections, PASS Summit, and SSWUG Ultimate conferences. Chris received his 5th Microsoft MVP award.

Bob Ward

Contact: http://blogs.msdn.com/psssql

Bob Ward is a Principal Architect for the Microsoft Azure Data SQL Server team, which owns the development for all SQL Server versions. Bob has worked for Microsoft for 25+ years on every version of SQL Server shipped from OS/2 1.1 to SQL Server 2019 including Azure. Bob is a well-known speaker on SQL Server, often presenting talks on new releases, internals, and performance at events such as PASS Summit, SQLBits, SQLIntersection, Microsoft Inspire, and Microsoft Ignite. You can follow him at @bobwardms or linkedin.com/in/bobwardms. Bob is the author of the new book Pro SQL Server on Linux available from Apress Media.

Nathan Heaivilin

Just a DBA who wants to give back to the community who gave so much to me.

Chase Aucoin

Contact: http://vinsolutions.com

Chase Aucoin has nearly a decade working several large scale data driven application including FedEx Freight, with over half a billion transactions per day.

Jason Hall

Twitter: - @SQLSaurus

LinkedIn: Jason Hall

Contact: http://blogs.sqlsentry.com/jasonhall

Jason Hall (@SQLSaurus) leads SentryOne’s Product Management team, which is responsible for managing product design, development and delivery.

Jason has worked in varied technology roles for over 20 years and holds industry certifications including MCSE (legacy), MCSD, MCTS, MCPD, and PMC-III.

Russ Thomas

Twitter: - @SQLJudo

LinkedIn: Russ Thomas

Contact: http://www.sqljudo.com

Prior to focusing full time on IT Management and Database Administration in the Denver Colorado financial sector, Russ spent several years in law enforcement including four as a training Sergeant and Washington CJTC Instructor specializing in Emergency Vehicle Driving at Portland Intl Raceway. An experienced public speaker and trainer, Russ also has two decades of hands on IT work and leadership experience. Russ is a SQL Server Data Platform MCSE and is active in the SQLSaturday community.

Reeves Smith

Twitter: - SQLReeves

LinkedIn: Reeves Smith

Contact: http://reevessmith.wordpress.com

Reeves Smith, owner and principal architect of Macer Consulting, is passionate about applying data technologies that empower organizations. Reeves wields his knowledge and experience to lead, design, architect, and teach, working with both data center and business project teams. He approaches every project by first understanding the organization’s business challenges, and then developing a unique approach that targets those business needs accurately and effectively.

Reeves Smith has more than 20 years of experience working on the SQL Server stack. He is a Microsoft Data Platform MVP and Microsoft Certified Master, and regularly delivers technical presentations at international, regional, and local 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.

Steve Wake

Twitter: - stevewake

LinkedIn: Steve Wake

Contact: http://blog.wakebi.com

Steve Wake is currently the Principal BI Developer at Brown and Caldwell and has experience in consulting, advertising, media, manufacturing, retail, charities, telecommunications and financial services organizations using the full on-premises Microsoft BI stack. Recent experience with the Azure services: Analysis Services, Logic Apps, Data Factory, Databricks, Snowflake and Power BI. Steve is also very involved in the SQL community, speaking at events around the world.


Twitter: - SQLMD


Contact: http://sqlmd.wordpress.com

Michael Donnelly has been working with SQL Server for 15+ years and holds the MCSE: Data Platform certification. He is an avid runner, blogger, and a wannabe gourmet chef. Currently living the SQL Life on the Jersey Shore.

Michael Bourgon

Twitter: - @mbourgon

LinkedIn: Michael Bourgon

Contact: http://thebakingdba.blogspot.com

Michael Bourgon started his IT career by performing tech support and managing Sybase databases on Unix starting in 1995, before moving to SQL Server 7… continuing all the way to SQL Server 2017. His focus on automation has led him to such diverse topics as Service Broker, WMI, Table Partitioning, Shell scripting, In-Memory Tables, and Powershell. He’s currently a senior DBA with a large healthcare company, dealing with millions of transactions of day and managing hundreds of servers. In his spare time he rides a bicycle, reads science fiction, blogs about SQL Server and Baking, and tries to raise his daughter to be a geek, too.

Ed Leighton-Dick

Twitter: - eleightondick

LinkedIn: Ed Leighton-Dick

Contact: http://www.edleightondick.com

Ed Leighton-Dick is a Microsoft MVP, SQL Server performance and architecture specialist, and Founder/Principal Consultant of Kingfisher Technologies. He is a frequent volunteer with PASS, including current roles as a Regional Mentor, co-leader of I-380 PASS local group, and co-leader of the HA/DR virtual group. He can often be found teaching sessions at local, regional, and national events, including user groups, SQLSaturday, and PASS Summit.

Lance Kolie

I’m an Independent Business Intelligence Architect / Senior SQL Server DBA at Opportune Tech with 15+ years of professional experience building solutions on the Microsoft platform. My professional experience covers a wide range of industries from marketing, transportation, non-profit, telecom and technology. I enjoy supporting local SQL user groups, sharing knowledge and mentoring.

Robert Smith

LinkedIn: Robert Smith

I#39;m a happy, go-lucky type of guy who#39;s addicted to learning why and how things work, perpetually seeking answers to life#39;s questions and searching for meaning in the journey.

Tracy McKibben

Twitter: - @RealSQLGuy

LinkedIn: Tracy McKibben

Contact: http://realsqlguy.com

Database background extending back to 1994, includes Clipper, FoxPro, dBase, all versions of SQL from 7.0 forward.

Currently managing a team of production DBAs for Pearson VUE, and serving as the Director Of Program Development for PASSMN.

Matt Wigdahl

Twitter: - @mlwigdahl

LinkedIn: Matt Wigdahl

Contact: http://wigdahl.net

Matt Wigdahl is Director of Software Quality at ScriptPro LLC and a SQL Server MCP. He has configured, developed with, and optimized queries for SQL Server for over 15 years, on both sides of the developer / DBA line.

Larry Toothman

Contact: http://IowaTechBear.com

Larry has been a Database Administrator for a non-profit health system in Cedar Rapids, IA since late 2007. With over 20 years of software and database development experience, he was drafted to be the DBA in 1999 for a dev company. Amazed by the wide variety of people in the SQL Server community as well as the support from the “SQL Family” Larry is always looking for opportunities to pay it forward, spread the word mentoring.

Matthew Brimer

Twitter: - @sqlcenturion

LinkedIn: Matthew Brimer

Contact: http://www.sqlcenturion.com

Matthew Brimer has 10 years experience with SQL Server, 3 of which was spent as a Database Security expert for a Department of Defense Agency and 5 as the Database/Security Manager for a leading Pharmacy Services Company. These days Matt can be found helping customers get the most out of the Databases/Servers/Networks as a Consultant for InterWorks. Matt also holds several Security and Microsoft Certifications, is the President of OKC SQL PASS Chapter and is the former Event Chair for SQLSaturday Oklahoma City.

Sean McCown

Twitter: - @KenpoDBA

Contact: http://www.midnightdba.com/dbarant

Sean McCown is a Certified Master with 23 years of experience in databases. He is also founder and co-owner of the MidnightDBA.com website, where he records free SQL Server training videos. He also writes the popular Minion Maintenance suite, the most configurable maintenance solution on the planet.

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.

Steve Jones

Twitter: - way0utwest

LinkedIn: Steve Jones

Contact: http://www.voiceofthedba.com/

Steve Jones is a Microsoft SQL Server MVP and has been working with SQL Server since version 4.2 on OS/2. After working as a DBA and developer for a variety of companies, Steve co-founded the community website SQLServerCentral.com in 2001. Since 2004, Steve has been the full-time editor of the site, ensuring it continues to be a great resource for SQL Server professionals. Over the last decade, Steve has written hundreds of articles about SQL Server for SQLServerCentral.com, SQL Server Standard magazine, SQL Server Magazine, and Database Journal.

Bill Graziano

Contact: http://scalsql.com/

Bill Graziano is a SQL Server consultant specializing in high-throughput transaction environments using SQL Server. He spends his days counting the milliseconds behind credit card swipes. Bill is the former President of PASS and runs a web site for SQL Server developers and administrators at SQLTeam.com.

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.

Jason Kassay

Twitter: - @jasonkassay

LinkedIn: Jason Kassay

Contact: http://www.JasonKassay.com

Jason Kassay is a database administrator, software engineer amp; speaker from Colorado with over 12 years of experience. He is passionate about SQL Server, programming, release process, automation amp; performance tuning. Jason is an active member of the SQL Server community amp; volunteers/presents at events such as Colorado User Groups, SQLSaturday amp; Colorado GiveCamp. When not tuning databases or coding, Jason will most likely be found spending time with his family, playing hockey or running.

Jennifer McCown

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

Contact: http://www.MidnightDBA.com/Jen

Jen McCown is CEO of MinionWare, LLC; a Microsoft Certified Master for SQL Server; and an independent consultant. She is Senior Editor at MidnightDBA.com, where she creates training videos, the DBAs at Midnight webshow, blogs, reviews, and podcasts. Jen is a member, volunteer, and speaker in PASS, and the PASS Women in Technology Virtual Group.

Zane Brunette

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

Contact: http://sqlandcomics.com/

I#39;ve been working in SQL Server for 4 years. I specialize in SSIS development and query performance tuning.

David Klee

Twitter: - kleegeek

LinkedIn: David Klee

Contact: http://davidklee.net

David Klee is a Microsoft Data Platform MVP and VMware vExpert with a lifelong passion for technology. David spends his days focusing on the convergence of data and infrastructure as the Founder of Heraflux Technologies. His areas of expertise include cloud, virtualization, performance, and business continuity. David speaks at a number of national and regional technology related events, including PASS Summit, VMware VMworld, SQLBits, SQLSaturday events, and many SQL Server User Groups.

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.

Janis Griffin

Twitter: - DoBoutAnything

LinkedIn: Janis Griffin

Janis Griffin has over 30 years of DBA/database experience including design, development and implementation of many critical database applications. Before coming to Quest Software, Janis primarily worked in the Telecom/Network Industry, working with both real-time network routing databases and OLTP business to business applications. Janis also held positions as a Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning.

Bill Fellows

Twitter: - @billinkc

LinkedIn: Bill Fellows

Contact: http://blog.billfellows.net

Bill Fellows is a SQL Server MVP and has been a database developer for most of his career, with the past 15 years focused on ETL. He is the organizer of Kansas City’s eight SQLSaturdays and a speaker at many other SQLSaturdays, User Groups and the PASS Summit. Bill is the owner of Sterling Data Consulting where he gets to solve interesting data problems.

Christopher Wolff

Twitter: - @tickytong

LinkedIn: Christopher Wolff

Contact: http://sqlred.blogspot.com/

Chris Wolff has been a developer, report writer, and an admin in Microsoft and SQL Server Space since SQL Server 2000 in industries such as telecommunications, green energy, money transfers, and online accounting. He has been an active member of the Denver SQL User Group since 2011 and enjoys learning new things about computers. His interests includes video games, movies, and enjoying time with his wife and 2 kids.

Jeff Renz

Twitter: - jeff_renz

LinkedIn: Jeff Renz

Contact: http://www.revgen.com

Jeff Renz is a Senior Architect at RevGen Partners, currently working as the design architect and implementation lead on several projects for a Fortune Top 50 company. Jeff has worked with SQL Server and BI for 15+ years and has 10 years’ experience with data warehouse design and implementation. In addition to consulting, he is joining the University of Denver adjunct faculty and is expected to begin teaching in the ICT program starting in June. He received his bachelor’s degree in Computer Science, his master’s degree in Operations Research from Colorado School of Mines, and will be graduating from the Harvard Business Analytics Program in December.

Randy Knight

Twitter: - randy_knight

LinkedIn: Randy Knight

Contact: http://www.sqlsolutionsgroup.com/blog

Randy Knight is a data professional who has worked with Microsoft technology for over 25 years, focusing on SQL Server since 1997. He has worked in a variety of settings, including 6 years as a database architect for match.com. In 2010, he founded SQL Server Solutions Group LLC, a boutique SQL Server consultancy. A Microsoft Certified Master (MCM) in SQL Server, he speaks often at events all over the country including the PASS Summit, SQLIntersections, and numerous SQLSaturday and User Groups.

Leslie Weed

Twitter: - @weederbug

Leslie Weed is currently a Data and BI Architect with RevGen Partners in Denver, CO. She has been a SQL Professional specializing in Business Intelligence, data analytics, systems implementation, integration, and solutions delivery for the last 20ish years, including a variety of Enterprise Data Warehouses in various industries.


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

Back to the SQLSaturday Event List

Back to the home page