SQLSaturday #553 - Oklahoma City 2016

Event Date: 08/27/2016 00:00:00

Event Location:

  • Moore/Norman Technology Center South Penn Campus
  • 13301 South Pennsylvania Avenue
  • Oklahoma City, Oklahoma

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: Create a Data Loading Strategy

Abstract: Loading large amounts of data into SQL Server can be challenging. Many factors may challenge your goal for tuned performance. To make the decision making process more difficult, many of the choices listed below have both Pros and Cons to their implementation. For this reason, bulk loading large amounts of data requires a strategy.

Create a strategy to optimize your massive data loading processes. • High Performance Data Loading • Minimal Logging and Bulk Loading • Indexing Considerations • Delayed Durability • Eager Write

This session uses a Virtual Sandbox to demonstrate “real” data loads using these techniques listed above. We will look at the T-SQL used in these data loads. We will briefly discuss how the different settings and configurations effect the data loads. Power Point slides and sample SQL will be provided.

Speaker(s):

  • Ryan Casey

Track and Room: BI Platform Architecture, Development Administration - Room B


Title: Unit Testing SQL Server

Abstract: In the nearly 20 years I have been working with SQL Server, most of that as an independent consultant, I can count on two hands the number of clients I have come across that had ANY database tests constructed. I can count on TWO FINGERS the number of them that had repeatable database tests. Even the most ardent Agile/Scrum/pick-your-new-and-shiny-development-mantra shops hardly ever do anything more than wave a magic wand at testing the database, because it can be REALLY HARD to do and do correctly. In this session we will cover examples of why repeatable database testing is CRITICALLY important and then examine both a free and a low-cost commercial product to ease the pain and improve developer efficiency.

Speaker(s):

  • Kevin Boles

Track and Room: Application Database Development - Room A


Title: Are There Time Bombs in your SSIS Packages?

Abstract: Could your seemingly-normal SSIS package be hiding a disaster, waiting to detonate at the most inconvenient time? Integration Services is an incredibly flexible product, and that flexibility can lead to good - and occasionally bad - design patterns. Small and seemingly trivial design decisions can lead to big issues down the road, including leaky data flows, data quality issues, paralyzing performance issues, and other explosive behaviors.

In this session, we will explore some of the most common SSIS design patterns that are potentially more harmful than they first appear. From package configuration to control flow constraints, and data flow transformations to logging, we’ll demonstrate what can go wrong and show some alternative designs to prevent these types of problems from developing into bigger issues.

Speaker(s):

  • Tim Mitchell

Track and Room: BI Platform Architecture, Development Administration - Room D


Title: Testing SSIS Packages

Abstract: Senior developer: “How do you test your code?” Junior developer: “I compile it.” It’s an old joke, but too often this reflects the reality of testing. If the code compiles, it has passed its test. Sadly, this principle is sometimes applied to Extract-Transform-Load (ETL) processes as well: “When the SSIS package runs without error, testing is complete.”

As in software development, testing of SQL Server Integration Services (SSIS) packages should not end at when the package executes successfully. You must also confirm that the package does what it was intended to do without placing an undue performance burden on the system.

This session walks through design patterns for testing SSIS packages during and after the development process. The session covers topics such as these:

  • Performance testing
  • Patterns for validating execution results at runtime
  • Validating package metadata before execution
  • Design time versus runtime testing
  • Making a graceful exit: testing for error handling

Speaker(s):

  • Tim Mitchell

Track and Room: BI Platform Architecture, Development Administration - Room D


Title: Unraveling Tangled Code:A Spellbinding Tale of Victory Over Chaos

Abstract: Once upon a time, you inherited an application or a database that was filled with chaos and inconsistencies. The T-SQL code is overly complex and impossible to ken. The architecture is painful to behold, and grueling to code for. One might optimistically say that query performance is “spectacularly mediocre”. If you’re without good documentation or system architects to guide you, how do you break the curse of confusion? In this session you’ll learn several methods for conquering chaotic code, and how to seek and destroy some of the nastier coding mistakes and inefficiencies. We will break complicated queries into key pieces, turn them upside-down, and reform them into something sensible. We will vanquish major issues like data abuse and index negligence. We will restructure joins and tame subqueries. We will emerge victorious!

Speaker(s):

  • Jennifer McCown

Track and Room: Application Database Development - Room E


Title: SQL Server R Services in SQL 2016

Abstract: One of the most exciting new features of SQL Server 2016 is the integration of the R statistical programming language into the platform with the brand-new SQL Server R Services. In this introductory session we’ll briefly introduce the R language and then look at how to install and administer SQL Server R Services. We’ll start to demonstrate the power of R by showing you how to create and run simple R scripts from within T-SQL. We’ll then discuss some of the powerful open source packages that are available to aid your data analyses. Finally, we’ll go through some examples of how to use R to integrate data analytical methods in real-world situations, and wow your customers with the power of statistics!

Speaker(s):

  • Chris Hyde

Track and Room: Analytics and Visualization - Room E


Title: Get Your Optimizer to Give up All Its Secrets

Abstract: You know that execution plans can provide you with vital information to tune a query, but just how does that plan get generated? In this session, we will examine details the query optimization process that are not very well known. We will discuss how SQL Server parses a T-SQL statement then and begins applying rules to make it more efficient. Did you know that SQL Server can be coaxed into outputting hidden structures such as parse trees and memos? We’ll do just that, and then take it a step further with a unique visualization tool that I have created. With a better understanding of how SQL Server optimizes T-SQL (and sometimes doesn’t do it as well as might be hoped), you can write more efficient SQL statements.

Speaker(s):

  • Brian Hansen

Track and Room: Enterprise Database Administration Deployment - Room E


Title: T-SQL’s Hidden Support Feature

Abstract: The most effective T-SQL support feature comes installed with every edition of SQL Server, is enabled by default, and costs no overhead. Yet, the vast majority of database administrator underutilize or completely neglect it. That feature’s name is “comments”. #160; In this session, Microsoft Certified Master Jennifer McCown will demonstrate the various commenting methods that make code supportable. Attendees will#160;learn what’s important in a header comment, use code blocking to edit code, build a comprehensive help system, and explore alternative comment methods in stored procedures, SSIS packages, SSRS reports, and beyond.#160; These methods help prevent errors and reduce troubleshooting.

Speaker(s):

  • Jennifer McCown

Track and Room: Application Database Development - Room E


Title: Introduction to BIML and BimlScript

Abstract: You have a lot of data to move and a lot of pieces to manage. Perhaps you’re a developer and know that SSIS is the best way to move it, but you naturally dislike GUI-based development or you’re just not looking forward to the tedium.

Or perhaps you’re a team lead/architect and are looking for an efficient platform that best utilizes the development skills of your team.

Jeremy Marx will introduce BIML, a language you can quickly pick up to develop SSIS solutions with code, and BIMLscript, intelligently mixing in C# to make your BIML practically build itself.

Jeremy will demonstrate how to build a simple, single-table SSIS package using BIML, then extend it to many tables with just a few lines of code, and finally apply a more robust data flow designed for reuse. You’ll leave with tools and resources to begin coding SSIS solutions faster and more efficiently.

Speaker(s):

  • Jeremy Marx

Track and Room: BI Platform Architecture, Development Administration - Room D


Title: SSIS Performance Tuning with Biml

Abstract: You may heard that Biml can automate ETL loads, but what if your data warehouse is several terabytes with a tight load window. In this demo focused presentation, we’ll discuss how to use BimlScript to dynamically create multiple SSIS packages for a data warehouse ETL load, each following a different best practice design pattern. The included framework then automatically executes each package repeatedly, records the results for analysis, and determine which package version should be used in production. The only way to be sure that your SSIS packages are performing optimally is to test them against multiple patterns. Make your life easier and let BimlScript do the work for you.

Speaker(s):

  • David Stein

Track and Room: BI Platform Architecture, Development Administration - Room A


Title: EMC - Maximizing Microsoft SQL Server Storage Investments

Abstract: Bradly Crowe will be presenting for EMC on the below Abstract:

2016 is the year of All-Flash for primary storage and EMC’s industry leading portfolio of All-Flash arrays unlock the speed, efficiency, and agility that your business stakeholders have been demanding. Whether supporting 1,000 or 10,000,000 IOPS, EMC has a broad portfolio to ensure consistent sub-millisecond response time regardless of workload type.

Beyond just production database performance, EMC provides robust database repurposing via our iCDM or Integrated Copy Data Management capabilities. Creating and maintaining test/dev, near real-time analytic, or sandbox environments has never been simpler. Join us and hear how we can address the needs of all of your Microsoft SQL Server instances.

Speaker(s):

  • William Barnes

Track and Room: Other - Room C


Title: Accidental DBA Dev Edition

Abstract: There is a steep learning curve moving from a traditional application development role into writing database code. Your experience is telling you one thing and the DBAs are telling you another. Making sense of what’s going on can be quite a struggle. Join me and let’s try to smooth out some of the biggest points of confusion. Including subjects like, the anatomy of a table, what’s up with NULLs, why should I be cautious with functions, and how can I start tuning my queries.

Speaker(s):

  • Kenneth Fisher

Track and Room: Application Database Development - Room D


Title: Deadlock, Block Two Smoking Barrels: Breaking Down Blocking and Deadlocks

Abstract: While blocking and deadlocks are part of the territory for a DBA, dealing with them can be another story. In this session we will break down locking types, capturing and identifying deadlocks and the code behind them, and things you can do to resolve and prevent blocking and deadlocks. If you are frequently dealing with deadlocks in your databases this session is for you.

Speaker(s):

  • Amy Herold

Track and Room: Enterprise Database Administration Deployment - Room B


Title: Scale out SQL Server PaaS in Azure Elastically

Abstract: You have heard all the hype how the cloud can help you scale your databases horizontally, providing you limitless capacity, but how do you do that? In this presentation we will take a look at the Elastic Database tools. We will focus on the key use cases for shard map management, data dependent routing and multi-shard querying.

Speaker(s):

  • Shawn Weisfeld

Track and Room: Cloud Application Development Deployment - Room B


Title: Lunch

Abstract: none

Speaker(s):

  • William Barnes

Track and Room: Other - Room A


Title: Intro Data Warehousing for the DBA\Dev: From “Stupid Data” to Star Schema

Abstract: Data Warehouses are expensive, right? I mean, companies charge hundreds of thousands of dollars to build them for you. We all know the hardest part is just getting started, in this session we will talk about general dimensional design, how to start modeling your schemas, and by the end of this session you will have built your first star schema.

Speaker(s):

  • Matthew Brimer

Track and Room: Strategy and Architecture - Room C


Title: Loading SQL Server Data with Powershell

Abstract: Powershell has become the defacto standard for scripting Microsoft products. However, putting data in text files doesn’t scale. Here I’m going to show you the ins and outs of loading data into SQL Server using Powershell for the purpose of centralizing collections. We’re going to cover RBAR as well as bulk operations and the types of things you need to take into consideration in an enterprise setting. This is a no holds barred session taught by an enterprise SQL Server scripting expert. You can’t afford to miss this session if you do any level of scripting in your shop.

Speaker(s):

  • Sean McCown

Track and Room: Enterprise Database Administration Deployment - Room E


Title: Analyze your query plan like a Microsoft Engineer! (SQL 2016 Edition)

Abstract: This session is a deep dive into query plans and is presented by a former Microsoft PFE (Field Engineer). Learn how a Microsoft Engineer looks at plans and go beyond the typical! There will be plenty of demos and a lot to learn. Join me as I cover the “noteworthy” query plan patterns that go beyond the normal areas that customer tend to investigate. This session covers SQL Server 2005 forward and includes the new SQL Server 2016 Query Store and Live Query Statistics.

Speaker(s):

  • Daniel Janik

Track and Room: Advanced Analysis Techniques - Room B


Title: SQL Server Reporting Services - Zero to Automated Reports Today!

Abstract: Perhaps you’ve heard about the power of SQL Server Reporting Services. Or, you have created some basic reports and you’re ready to automate delivery. If so, this session is for you. You’ll learn how to create your first SSRS report using Business Intelligence Design Studio (BIDS) and deliver reports to the business automatically in under an hour.

Speaker(s):

  • Rudy Rodarte

Track and Room: BI Information Delivery - Room D


Title: Know What Your Code is Doing to SQL Server!

Abstract: ORMs - oh how I LOVE them! As a consultant when I see them in play at a client I go KACHIIINNNNGGGG!! :-D Seriously though, they can provide some substantial benefits for coding throughput. But if you don’t Read The Fine Manual and do some things right and avoid some major gotchas you will fall prey to one of my favorite Guruisms: “Anything that allows developers to slap code together more quickly is inversely proportional to the performance and scalability you will get from that code”! Although this talk is based on Entity Framework, most ORMs suffer from a lot of the same flaws.

Speaker(s):

  • Kevin Boles

Track and Room: Application Database Development - Room A


Title: Administering SQL Server on Server Core with PowerShell

Abstract: Ever wondered what the craze of Server Core is all about? There is a lot of power in Core and with it comes the admin challenge of NO GUI. But there are settings that you want to change in the OS, how do you do that? This session will take you through some of the challenges that are not really challenges when you know. We will use the builtin method of making some changes and also use PowerShell and commandline tools to get you where you want to be with Core. I built a 6 node cluster on Server Core and created it with PowerShell (Cluster and all) and it runs very nicely with a little footprint in RAM for the effort.

Speaker(s):

  • Ben Miller

Track and Room: Enterprise Database Administration Deployment - Room C


Title: Techlahoma

Abstract: Lunch Sponsor Session

Speaker(s):

  • William Barnes

Track and Room: Other - Room D


Title: Deploy SQL Server with Microsoft Azure Virtual Machine

Abstract: Microsoft Azure provides multiple options to migrate SQL Server to the Cloud. But migrating SQL Server requires good understanding of the different options and the constraints. This session focuses on Microsoft Cloud option for SQL Server, how to deploy SQL Server on Azure Virtual Machine, how SQL Licensing works on Azure Virtual Machine, deploying Alwayson AG and Hybrid Cloud Scenarios.

Speaker(s):

  • Bala Shankar

Track and Room: Cloud Application Development Deployment - Room A


Title: SQL Server 2016: It Just Runs Faster

Abstract: Join me in taking a deep dive and a behind the scenes look at how SQL Server 2016 ‘It Just Runs Faster’, focused on scalability and performance enhancements. This talk will discuss the improvements, not only for awareness, but expose design and internal change details. The beauty behind ‘It Just Runs Faster’ is your ability to just upgrade, in place, and take advantage without lengthy and costly application or infrastructure changes. If you are looking at why SQL Server 2016 makes sense for your business, you won’t want to miss this session.

Speaker(s):

  • Bob Ward

Track and Room: Enterprise Database Administration Deployment - Room C


Title: Build ETL efficiently (10x) with Minimal Logging

Abstract: This session is designed to teach DBAs and developers the best strategy to transfer large data.

We will first analyze how data gets accessed from the source and how data gets updated or inserted to the target server: index access patterns in read operation and minimal logging in wring operation. I will introduce TF610 and cover its benefit for minimal logging even in full recovery mode.

Speaker(s):

  • Simon Cho

Track and Room: BI Platform Architecture, Development Administration - Room A


Title: Microsoft

Abstract: Lunch Sponsor Session

Speaker(s):

  • William Barnes

Track and Room: Other - Room B


Title: Inside the SQL Server Query Store

Abstract: In this session you will understand how the SQL Server Query Store can be used to take you to the next level for query performance monitoring, tuning, and troubleshooting. You will see how the Query Store works, what its capabilities are, and even how to troubleshoot when problems occur with its execution. There will be plenty of demos in this session covering both SQL Server 2016 and Azure SQL Database scenarios/

Speaker(s):

  • Bob Ward

Track and Room: Enterprise Database Administration Deployment - Room C


Title: PoShDBA: Practical PowerShell for the DBA

Abstract: This session will cover real world functions that are used for real DBA work. There will be a few slides but mostly demos with actual scripts to help you do your job. I will also introduce some outside modules created to assist as well. Things like Reading/Changing the following: Permissions, DB Owner maintenance and database space management. We all could use a few standard things in our DBA world of ever changing roles and “I have to have it now” stuff, that Management Studio can get in the way of getting it done faster. Join me for a fun PowerShell hour and never try to reuse a click again.

Speaker(s):

  • Ben Miller

Track and Room: Enterprise Database Administration Deployment - Room B


Title: TARDIS: Time And Relative Dimensions in SQL!

Abstract: In this session, you’ll learn why you need a date table, how to build one and how to use one. We’ll look at a couple common uses for date tables and explore how to get the most of them!

Speaker(s):

  • Tim Costello

Track and Room: BI Platform Architecture, Development Administration - Room C


Speakers

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

Kevin Boles

Twitter: - @TheSQLGuru

LinkedIn: Kevin Boles

Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.

Ben Miller

Twitter: - DBAduck

LinkedIn: Ben Miller

Contact: https://dbaduck.com

Ben has been a member of the SQL Server Community since 2000. He loves a challenge and has fixed many SQL Servers and helped hundreds of people get more out of their DBA jobs. He is a Data Platform MVP a SQL Server Certified Master (MCM). He has worked at various companies throughout the USA, as well as at Microsoft for 7 years. He is passionate about SQL Server Infrastructure, High Availability, Automation and Integration using SMO and PowerShell. He teaches DBAs how to use PowerShell to do their job and teaches SQL Server Internals. He is @DBAduck all around the web (Twitter, LinkedIn, Facebook, Blog) so let’s catch up.

Bob Ward

Twitter: - bobwardms

Contact: http://aka.ms/bobsql

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 26+ years on every version of SQL Server shipped from OS/2 1.1 to SQL Server 2019 including Azure SQL. Bob is a well-known speaker on SQL Server, often presenting talks on new releases, internals, and performance at events such as PASS Summit, Red Hat Summit, Microsoft Ready, SQLBits, SQLIntersection, Microsoft Inspire, and Microsoft Ignite. You can follow him at @bobwardms or linkedin.com/in/bobwardms. Bob is the author of the books Pro SQL Server on Linux and SQL Server 2019 Revealed available from Apress Media. Twitter: http://twitter.com/bobwardms.

William Barnes

Temp

Chris Hyde

Twitter: - ChrisHyde325

LinkedIn: Chris Hyde

Chris Hyde is a Microsoft Data Platform MVP and Microsoft Certified Trainer based in Albuquerque, New Mexico. He works as an independent SQL Server BI and DBA consultant, and is the leader of the Albuquerque PASS local user group. He is also part of the Friends of Redgate program and was a member of the Idera ACE class of 2018. He loves loud music and cricket, but usually not at the same time.

Jennifer McCown

Twitter: - http://www.Twitter.com/MidnightDBA

LinkedIn: Jennifer McCown

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.

Tim Costello

Twitter: - timcost

LinkedIn: Tim Costello

Contact: http://www.timcost.com

Tim Costello is an MCITP, MCTS specializing in etl and data analytics for Interworks Inc. Tim is an international speaker that is always looking for opportunities to share his passion for SQL Server, Tableau and data visualization. Tim is active in the SQL community and leads a data visualization focused user group in the Dallas area.

Rudy Rodarte

Twitter: - http://www.twitter.com/shadyrudy

Contact: http://www.rodolforodarte.com

Rudy Rodarte works at Dimensional Fund Advisors as a DBA optimizing existing TSQL code, deploying SQL Server 2012, and implementing DB change tickets. Previously, Rudy spent 3 years at HotSchedules.com maintaining databases used by all major restaurants in the US. Rudy also spent 9 years at Dell Inc, in Americas Services Parts creating and maintaining logistics databases that managed inventory in the Americas. Away from the keyboard, Rudy is a big fan of Liverpool Football amp; the Baylor Bears

William Barnes

Temp

Ryan Casey

Twitter: - @AimYourData

LinkedIn: Ryan Casey

Contact: https://www.AimYourData.com/

Microsoft Data Platform MVP, Public Speaker, and Group Moderator

SQLSaturday Speaker @ • Houston, TX 2018 • Dallas, TX 2018, 2017 (BI), 2016, 2015 • Phoenix, AZ 2018, 2017 (BI) • Kansas City, MO 2017 • Baton Rouge, LA 2017 • Oklahoma City, OK 2016 • San Antonio, TX 2016

SQL User Group Speaker @ • NTSSUG, Dallas, TX • CACTUSS, Austin, TX • OKCSQL, Oklahoma City, OK • MSBIC, Dallas, TX • SALSSA, San Antonio, TX • FWSSUG, Fort Worth, TX

AIM Business Driven Data Solutions combines the collaborative and creative arts included in Technical Communication, the business acumen of a Harvard MBA program, and the technical discipline of object-oriented programming and business intelligence (data warehouses).

David Stein

Twitter: - @Made2Mentor

LinkedIn: David Stein

Contact: http://www.Made2Mentor.com

David Stein - Agile Data Warehouse Architect and Independent Consultant - has more than a decade of experience working in SQL Server Business Intelligence. He’s designed multi-terabyte, multi-tenant Data Warehouses from scratch as well as saved projects in serious jeopardy.

Jeremy Marx

Twitter: - http://twitter.com/jmarx

LinkedIn: Jeremy Marx

Contact: https://www.interworks.com/company/our-team/staff/jeremy-marx

Jeremy Marx is#160;a Data Engineer with InterWorks, specializing in staging data for business intelligence initiatives for clients from nonprofits to Fortune 500 corporations. He also has a decade of experience in SQL Server as a DBA and is President of the Tulsa SQL Server User Group.

Tim Mitchell

Twitter: - @Tim_Mitchell

LinkedIn: Tim Mitchell

Contact: http://www.TimMitchell.net

Tim Mitchell is a business intelligence architect, author, and trainer. He has worked with SQL Server for over a decade, specializing in data warehousing, ETL/SSIS, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas AM at Commerce, and is recognized as a Microsoft Data Platform MVP. Tim is a business intelligence consultant and principal at Tyleris Data Solutions.

Tim is an active community speaker and volunteer, having spoken at over 100 events including the PASS Summit, SQLBits, Dev Connections, SQL Intersection, and scores of SQLSaturdays. He blogs at TimMitchell.net, and tweets at @Tim_Mitchell.

Kenneth Fisher

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

LinkedIn: Kenneth Fisher

Contact: http://www.sqlstudies.com

Kenneth Fisher works as a senior database administrator for a large multinational insurance company and has over two decades of experience as a DBA. He enjoys writing, and his credits include a number of technical articles and SQL Server related crossword puzzles. He also blogs incessantly at www.sqlstudies.com. Kenneth is honored to be a Data Platform MVP.

William Barnes

Temp

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.

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.

Kevin Boles

Twitter: - @TheSQLGuru

LinkedIn: Kevin Boles

Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.

Bob Ward

Twitter: - bobwardms

Contact: http://aka.ms/bobsql

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 26+ years on every version of SQL Server shipped from OS/2 1.1 to SQL Server 2019 including Azure SQL. Bob is a well-known speaker on SQL Server, often presenting talks on new releases, internals, and performance at events such as PASS Summit, Red Hat Summit, Microsoft Ready, SQLBits, SQLIntersection, Microsoft Inspire, and Microsoft Ignite. You can follow him at @bobwardms or linkedin.com/in/bobwardms. Bob is the author of the books Pro SQL Server on Linux and SQL Server 2019 Revealed available from Apress Media. Twitter: http://twitter.com/bobwardms.

Bala Shankar

Bala is a Senior Escalation Engineer in the Microsoft Data Platform support team in Dallas, Texas. Bala has worked 11 Years at Microsoft supporting SQL Server stretching back to SQL 7.0. He has interacted with many large SQL Server deployments on various component of SQL Server like the database engine, performance, replication and Azure. Bala is the lead for SQL Server on Azure Virtual Machine within Microsoft Support.

Simon Cho

LinkedIn: Simon Cho

Contact: http://simonsql.com

Simon Cho is one of the founders of SQLAngeles.com, which is a Los Angeles Korean Tech PASS community group.

As a Local Group leader, he is a Microsoft SQL community speaker. He has presented many times at SQLSaturdays and to PASS Local Groups.

He moved his passion to VISA Inc, the largest credit card provider in the world, where he used database technology to build a strong solution and a secure environment, with new strategies and features to maintain thousands of SQL Servers.

He has now joined the Nowcom Corp, as a Director of DevOps, where he leads the DevOps team and DBA team.

He is pretty much working on SQL server running on kubernetes.

Brian Hansen

Twitter: - tf3604

Contact: http://www.tf3604.com

Brian is a database administrator at Children International in Kansas City. He has been working with SQL Server technologies since 1998, including roles in report development, application development and database administration.

William Barnes

Temp

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.

Shawn Weisfeld

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

LinkedIn: Shawn Weisfeld

Contact: http://www.usergroup.tv

Shawn (http://www.shawnweisfeld.com, shawn@shawnweisfeld.com) is passionate about building awesome applications and websites with .NET technologies and Azure. He is currently a Technical Evangelist for Microsoft based in Austin TX and founder of http://UserGroup.tv. Read his full bio at http://about.me/shawnweisfeld

Daniel Janik

Twitter: - @SQLSME

LinkedIn: Daniel Janik

Contact: http://www.sqltechblog.com

Daniel Janik has been supporting SQL Server for 18 years. Six of those years were at Microsoft Corporation supporting SQL Server as a Senior Premier Field Engineer (PFE) where he supported over 287 different clients with both reactive and proactive database needs. Daniel has presented at many community events and SQLSaturdays.

Ben Miller

Twitter: - DBAduck

LinkedIn: Ben Miller

Contact: https://dbaduck.com

Ben has been a member of the SQL Server Community since 2000. He loves a challenge and has fixed many SQL Servers and helped hundreds of people get more out of their DBA jobs. He is a Data Platform MVP a SQL Server Certified Master (MCM). He has worked at various companies throughout the USA, as well as at Microsoft for 7 years. He is passionate about SQL Server Infrastructure, High Availability, Automation and Integration using SMO and PowerShell. He teaches DBAs how to use PowerShell to do their job and teaches SQL Server Internals. He is @DBAduck all around the web (Twitter, LinkedIn, Facebook, Blog) so let’s catch up.

Jennifer McCown

Twitter: - http://www.Twitter.com/MidnightDBA

LinkedIn: Jennifer McCown

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.

Tim Mitchell

Twitter: - @Tim_Mitchell

LinkedIn: Tim Mitchell

Contact: http://www.TimMitchell.net

Tim Mitchell is a business intelligence architect, author, and trainer. He has worked with SQL Server for over a decade, specializing in data warehousing, ETL/SSIS, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas AM at Commerce, and is recognized as a Microsoft Data Platform MVP. Tim is a business intelligence consultant and principal at Tyleris Data Solutions.

Tim is an active community speaker and volunteer, having spoken at over 100 events including the PASS Summit, SQLBits, Dev Connections, SQL Intersection, and scores of SQLSaturdays. He blogs at TimMitchell.net, and tweets at @Tim_Mitchell.

Sponsors

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

Back to the SQLSaturday Event List

Back to the home page