SQLSaturday #444 - Kansas City 2015
Event Date: 10/03/2015 00:00:00
Event Location:
- Rockhurst University
- 1100 Rockhurst Road
- Kansas City, Missouri
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: Dimensional Modeling Design Patterns: Beyond Basics
Abstract: Dimensional modeling is arguably one of the most important fundamentals of business intelligence. It is still relevant even as new technologies like PowerPivot and SSAS Tabular Models are becoming more popular. Correctly modeling your organization’s data not only protects the most important asset your company has but ensures that your data mart or data warehouse will be responsive and capable of accommodating emerging requirements.
This session provides a deeper dive into the art of dimensional modeling. We will look at the different types of fact tables and dimension tables, how and when to use them. We will also some approaches to creating rich hierarchies that make reporting a snap. Finally we will cover physical design choices.This case study and demo based session promises to be very interactive and engaging, bring your toughest Dimensional Modeling quandaries.
Speaker(s):
- Jason Horner
Track and Room: BI Platform Architecture, Development Administration - ARP 116
Title: Introduction to Microsoft Azure DocumentDB
Abstract: In this session I will demonstrate how to create a DocumentDB instance in Azure, how to work with JSON documents, create Ad hoc queries with familiar SQL syntax, create application logic as stored procedures, triggers and user defined functions (UDFs) using standard JavaScript. Goals: #1 Show how to create validate JSON strings using Notepad++, validate the JSON against a schema using C# Newtonsoft dll. Demonstrate how to work with JSON in SQL Server as a reference on how hard it is to work with JSON when it is not natively stored. #2 Demo the basics of DocumentDB - Create the database, collections and documents using the web interface. Demo how to perform basic selects, joins and filtering. Review java script basics as java script is fundamental in creating stored procedures #3 Demo of how to work with DocumentDB in a C# by creating collections, documents and querying the database using lync and SQL syntax.
Speaker(s):
- Jeff Renz
Track and Room: Application Database Development - ARP 212
Title: Extending Your Availability Group for Disaster Recovery
Abstract: Did you know that SQL Server Availability Groups can be a great solution for disaster recovery? Availability groups have become well known for their high availability capabilities, and for good reason: they work well, they remove some of clustering’s limitations, and they are fairly straightforward to setup. Extending an availability group to multiple sites for disaster recovery becomes more complicated. A lot of moving parts have to come together for it to work properly - SQL Server, Windows, Active Directory, and DNS all get involved in this advanced configuration. In this session, we’ll discuss some of the factors that complicate a multi-site availability group deployment, and we’ll walk through a multi-site deployment so you can see how it’s done.
Speaker(s):
- Ed Leighton-Dick
Track and Room: Enterprise Database Administration Deployment - ARP 210
Title: Profiler is Dead! Long Live Extended Events!
Abstract:
Did you know that Profiler and SQL Trace are deprecated? I know it still works (even in SQL Server 2016 CTP2), but it will never be updated with the latest features. In fact it will never be updated at all! That means if you want to capture information about any new feature, from version SQL Server 2012 and beyond, you need to use another tool.
That new tool is Extended Events (XE). Not only has it replaced Profiler, and can be used to capture information on all new features, but it is a substantially better tool!
In this session we will discuss the architecture of Extended Events, how to setup a new trace from scratch or convert an existing Profiler trace, and the new abilities that never existed in Profiler. We will also cover the difference in overhead cost of Profiler and Extended Events.
Profiler was a friend of mine, but it is time to embrace the new king!
Speaker(s):
- Keith Tate
Track and Room: Enterprise Database Administration Deployment - ARP 210
Title: Data Integration with Master Data Services
Abstract: Master Data Services (MDS) enables the management of non-transactional data that defines business entities within the enterprise. Get a good business and technical understanding of how MDS can help obtain better business clarity across the organization through a Data Governance strategy. Data Governance is a methodology that represents quality, policies, and process management, in relation to handling your enterprise data. The session will demonstrate the architecture of a Master Data Management solution and the data integration required to implement it within the enterprise. In this session, you will learn:
- A brief introduction to Master Data Management and Data Governance
- Master Data Management staging architecture
- Data integration with the entity-based staging tables
- Batch processing to move data in the MDS specific tables
- Publishing data to external systems with subscription views and web services
Speaker(s):
- Reeves Smith
Track and Room: BI Platform Architecture, Development Administration - ARP 116
Title: CSI: DW – Anatomy of a VLDW!
Abstract: Put on your CSI caps as we delve into the anatomy of a Very Large Data Warehouse environment! During this case study session, we’ll take a look at the data warehouse environment at the Department of Veterans Affairs. The VA is the largest healthcare organization in the US and has an extensive national DW and BI infrastructure, now in its seventh year of evolution. We’ll take a look at the database infrastructure, the data loading process, and the various reporting and analytics solutions that provide over 150,000 knowledge workers and report consumers with timely data and information. We’ll also take a look at some of the processes in place to support the myriad of extended reporting and analytics teams throughout the VA who build and manage second-tier downstream data marts and other reporting solutions.
Speaker(s):
- Dave Fackler
Track and Room: BI Platform Architecture, Development Administration - ARP 116
Title: Date Dimension: Past Future in One Script
Abstract: All data warehouses need a date and time dimension to enable proper analysis across time. Most Data Warehouse designers will just use one provided by tools or create it in Excel, but what if you need to set up custom holidays or want different calendars, such as Fiscal or Julian? You can have any date and time dimension you need by using a single SQL script that can be modified and rerun as necessary. Learn what it takes to design a date and time dimension that does all of the calculations and formatting up-front so the reports can be easier to create. Sample script will be provided that creates the date and time dimensions and can be reused as often as necessary without breaking your data warehouse and it only take seconds to run!
Speaker(s):
- Steve Wake
Track and Room: BI Platform Architecture, Development Administration - ARP 116
Title: Know what your machines are doing besides SQL Server - WMI, WQL, and PoSH
Abstract: There’s far more occurring on your Windows servers than just SQL Server, and looking at ERRORLOG won’t show you the whole story: other applications stealing your memory, OS issues, hardware errors, and more. We’ll start by looking at different ways to collect Event Logs. From there we’ll delve into WMI and WQL, which allow us to query servers (remotely or locally) to get information such as performance statistics, System and Event Logs, and even changes within SQL Server.
We’ll finish it off with two immediately-usable implementations you can set up on Monday.
Speaker(s):
- Michael Bourgon
Track and Room: Enterprise Database Administration Deployment - ARP 114
Title: Setting up your PowerShell Environment
Abstract: Whether you are new to PowerShell or have some experience, have you ever looked at customizing your environment? Do you know how many profiles PowerShell has? Do you hate typing a long command and wish there was a shortcut? Do you want to quickly setup your environment so you don’t have to setup the same aliases each time you start PowerShell? Learn the answer to these questions and more during our discussion. You will walk away with many quick tips and tricks you can use immediately.
Speaker(s):
- Andre DuBois
Track and Room: Enterprise Database Administration Deployment - ARP 314
Title: Visualizing Your Indexes - Science vs Art
Abstract: Indexes make queries run faster, right? Not always, no. And finding the right indexes for your needs is often more of an Art than a Science. Attend this session as we take a visual tour of how indexes are laid out and the way data is accessed when indexes are utilized. We will discuss clustered indexes as well as non-clustered indexes and also when to use indexed views along with some other variations.
Speaker(s):
- Wendy Pastrick
Track and Room: Application Database Development - ARP 314
Title: Lightning Talks
Abstract: This session will contain 3 lightning talks: “Trees, Forests and Predictive Models” by Myles Gartland; “Power BI: From Nothing to Dashboard in 10 Minutes!” by Steve Wake; “Why Data Viz is Important for All Data Professionals” by Meagan Longoria
Speaker(s):
- KC SQLSaturday
Track and Room: Other - ARP 316
Title: Azure Machine Learning - Building New Value From Old Data
Abstract: We have lots and lots of data. Typically when it comes to data analysis we have to know what our measures of success are before we design our BI. These are typically manifested by competency, or domain driven KPI’s but what if those metrics don’t actually measure success at all?
In this talk we will be discussing how to leverage azure machine learning to answer questions in your organization about success and how to find the KPI’s that really matter and drive results.
Speaker(s):
- Chase Aucoin
Track and Room: Advanced Analysis Techniques - ARP 212
Title: What, Why, and How of Cloud Migrations
Abstract: IaaS, PaaS, SaaS, Storage, Hybrid etc. etc. are you confused? If you are, that’s ok. In this session I explore the different capabilities that are available to migrate on-prem workloads to the cloud. I discuss what workloads are more conducive to a cloud migration and how you can determine the ‘low hanging fruit’. I will walk you through a framework I developed to examine all the dependencies that you need to understand and evaluate before migrating to the cloud. I will also lead you through various migration options and architectures that are being commonly deployed in the cloud.
Speaker(s):
- Sudhir Gajre
Track and Room: Cloud Application Development Deployment - ARP 210
Title: Create a Simple Operational Data Store
Abstract: If you or your users frequently run large, sweeping reporting-style queries against your OLTP system, you know the pain of having your system grinding to a halt under the resulting strain. One solution is to create a basic operational data store on another server where those big queries can execute. In this session, I will share some scripts to create a simple ODS system and to automatically refresh your databases.
Speaker(s):
- Brian Hansen
Track and Room: Enterprise Database Administration Deployment - ARP 314
Title: “But It Sounded So Simple!”: Building a Messaging System in Service Broker
Abstract: There’s a lot of general verbiage and API documentation about Service Broker, but how do you fit the queues, services, contracts, and conversations together to actually make something that will work reliably in production? In this session you’ll follow the architecture, design, implementation, and troubleshooting of a simple but production-tested Service Broker messaging framework and get a battlefield-level view of the pitfalls and the payoffs involved in Service Broker development.
Speaker(s):
- Matt Wigdahl
Track and Room: Application Database Development - ARP 116
Title: Splitting your tables: Partitioning Basics
Abstract: Partitioning is a strategy in SQL Server that allows you to physically separate data in your table along a given field, granting benefits to performance in specific circumstances, but at the cost of some additional maintenance. Here we’ll discuss the benefits and drawbacks of Table Partitioning in MS SQL Server, as well as when you should, or should not, consider partitioning your tables.
Speaker(s):
- Brandon Reno
Track and Room: Application Database Development - ARP 314
Title: Defense in Depth - Minimizing the Risk of SQL Injection
Abstract: During this session you will be thrust into the role of the DBA hired to fix SQL Server to prevent it from ever getting SQL Injected, or at least minimize the damage that can be done when it does. From bottom to top this session will cover how services should be configured, how SQL Server should be configured, benefits and risks of SQL Server security configurations, and best practices for app development. Come learn how to defend your servers from hackers, or how to become a SQL Injection hacker yourself!
Speaker(s):
- Rob Kraft
Track and Room: Other - ARP 224
Title: Continuous Deployments using SSDT
Abstract: DevOps is a word that gets thrown around a lot these days and is the way most shops will operate in the future. In my presentation I’ll show you how to fast forward to the future by automating your deployments from SSDT using Powershell and SQLPackage.exe.
Speaker(s):
- Christopher Wolff
Track and Room: Application Database Development - ARP 224
Title: Cardinality estimation and how it affects your execution plan
Abstract: What is cardinality estimation and how you can use it to your advantage. In this session we’ll cover the mechanics behind cardinality estimation and why it is so very critical to query performance. We will also be discussing some of the changes that were made to the estimator for SQL Server 2014.
Speaker(s):
- Zane Brunette
Track and Room: Enterprise Database Administration Deployment - ARP 114
Title: What is Biml and why are SSIS people talking about it?
Abstract: This session is designed for you, the experienced SSIS developer who’s been hearing about Biml but hasn’t taken the plunge. We will cover what Biml is and walk through some examples from Hello World equivalent to a fully baked truncate and reload pattern. You will leave this session armed with the knowledge of how Biml can help you achieve a consistent and reproducible approach for the creation of SSIS solutions.
Speaker(s):
- Bill Fellows
Track and Room: BI Platform Architecture, Development Administration - ARP 210
Title: Power BI: Architecture, Integration Points, Implementation Options
Abstract: In this session we will review Power BI V2 architecture and integration points with corporate data sources, SaaS services, Azure, and third party apps. We will examine and demonstrate key capabilities in the Power BI web-based service, Power BI Desktop, Excel, and mobile apps. Implementation options for Power BI involving cloud, on-premises, and hybrid approaches will be explored. Finally, the concept of “Bimodal BI” will be introduced with use cases for how Power BI might be utilized for both self-service BI and certain corporate BI initiatives.
Speaker(s):
- Melissa Coates
Track and Room: BI Platform Architecture, Development Administration - ARP 212
Title: SQL Server and ElasticSearch Integration
Abstract: ElasticSearch is a No-SQL document store and search engine that scales up to very large data volumes and down to very small ones effectively. Using ElasticSearch to do full-text searching makes a lot of sense. This talk will introduce ElasticSearch and discuss strategies and practices for integrating it into a SQL Server environment. Specifically discussed will be using queuing systems, LogStash and ETL paradigms to share data with ElasticSearch. Considerations of deployment and operations will also be discussed.
Speaker(s):
- Chris Miller
Track and Room: Application Database Development - ARP 316
Title: Building a Modern Transaction System on SQL Server
Abstract: Developers today face an onslaught of data storage applications. Various NoSQL offerings promise performance, scalability and easy development on commodity boxes. How does one get these benefits in SQL Server? What does a SQL Server application built today using the newest features and best practices look like? This session will discuss client applications, new SQL Server features and application architectures to support a modern, high-throughput transaction environments.
Speaker(s):
- Bill Graziano
Track and Room: Application Database Development - ARP 224
Title: Sql Server Architecture for World Domination
Abstract: It’s common to start with a small database server; but when activity increases, how do you know when to scale? This session will cover scaling Sql Server from express to enterprise and VM to a scale-out HADR architecture. You’ll learn common upgrade and migration techniques along with things to keep in mind when building new environments. We’ll start with a stand alone server and work our way up to a large scale out and scale up deployment.
Speaker(s):
- Tristan Wilson
Track and Room: Strategy and Architecture - ARP 114
Title: The Usual SUSPECTs: When Good Databases Go Bad
Abstract: You just finished patching your SQL Server. After rebooting it, though, some of your databases aren’t coming online. What do you do? In this session we’ll cover some of the various states that a database can be in. We’ll look at useful states like OFFLINE and STANDBY, as well as damaged states like SUSPECT or RECOVERY_PENDING. You’ll learn how databases get into those states, and the proper techniques to bring your data safely back online.
Speaker(s):
- David Maxwell
Track and Room: Enterprise Database Administration Deployment - ARP 114
Title: Source Control practices for your BI World
Abstract: Source Control is a critical part of any development effort. For small shop developers tools like TFS can be overwhelming especially for developers that come from organizations with little to no source control experience. Let’s talk about practices and ways to implement source control for SSIS, SSRS and Database Projects in both multi-developer and multi-tiered environments. We will cover when and how to branch, merge and shelve and discuss ideas around process for deployment and continuous integration.
Speaker(s):
- Leslie Weed
Track and Room: BI Platform Architecture, Development Administration - ARP 224
Title: Connected at the hip for MS BI: SharePoint and SQL
Abstract: SQL Server has always been the foundation of the Microsoft Business Intelligence (BI) story. However, SharePoint has quickly moved into being the presentation layer for this important data. In this session, you will learn the many different options for combining SharePoint and SQL, the location of all the different pieces, how these pieces communicate, some licensing hints, and how Kerberos helps tie it all together.
Speaker(s):
- JD Wade
Track and Room: BI Platform Architecture, Development Administration - ARP 316
Title: Trees, Forests and Predictive Models
Abstract: This session will introduce people to a couple of modern forms of data mining for predictive analytics problems. We will review Decision Trees, Random Forests and other ensemble methods. These are methods are highly popular in data science. We will show some cases studies of how these are used in business for increased prediction .
Speaker(s):
- Myles Gartland
Track and Room: Advanced Analysis Techniques - ARP 316
Title: Database Continuous Delivery Your Salvation!
Abstract: Continuous Integration Delivery isn’t a new concept. Application Developers have been doing it for quite a while and now it’s time for Database Professionals to catch up. Whether you are a database administrator, database developer, or even an application developer, database continuous delivery can help you find your salvation. I’ll show you how to apply these concepts to areas of security, collaboration, testing, support and deployments. We will look at what continuous delivery means, demonstrate some tools that can help you easily get it into place, and dive into why it’s important.
Speaker(s):
- John Morehouse
Track and Room: Enterprise Database Administration Deployment - ARP 212
Title: Power BI Open QA
Abstract: Bring your questions, problems, concerns, and ideas to this open QA and we’ll talk through them. There’s no predefined agenda for this session, though potential discussion topics may include things like production considerations, integration with Office 365 unified groups, how to manage organizational content distributed to a group of users, importing vs. connecting to data sources, changes since V1 of Power BI, and use of Excel vs. Power BI Desktop.
Speaker(s):
- Melissa Coates
Track and Room: BI Platform Architecture, Development Administration - ARP 114
Title: Dell Software Performance Monitoring Solutions for SQL Server
Abstract: A discussion of the Dell Software offerings in the SQL Server Performance monitoring space.
Speaker(s):
- KC SQLSaturday
Track and Room: Other - ARP 114
Title: SQL in SAS and R
Abstract: SAS and R, two statistical programming languages, have adopted SQL into their environments. The purpose of this presentation is to introduce novice users to PROC SQL in SAS and the sqldf package in R. Topics cover include select and join statements.
Speaker(s):
- Xuan Pham
Track and Room: BI Information Delivery - ARP 316
Title: The PROCESS of Queries
Abstract: This session focuses on the PROCESS of queries and how this effects Batches, Transactions, and Error Handling. The session is led by an expert Microsoft Certified Trainer (MCT) who regularly teaches the SQL Server certification courses.
Speaker(s):
- John Deardurff
Track and Room: Application Database Development - ARP 314
Title: In Memory Tables; Not Just For OLTP
Abstract: In Memory OLTP is one of the most popular features of SQL Server 2014. Many BI professionals are finding memory optimized objects make excellent tools in the quiver of the ETL developer as well. Attend this session to see how “hekaton”, memory optimized objects, native stored procedures, and schema only designs can be applied to staging and transformations to achieve incredible performance gains over traditional models.
Speaker(s):
- Russ Thomas
Track and Room: BI Platform Architecture, Development Administration - ARP 212
Title: A Look At SQL Server 2016 Always Encrypted
Abstract: A deep-dive into what is sure to become a very critical feature of SQL Server 2016. We’ll walk through some use-cases for the technology, and discuss why this kind of technology is needed - and how it can make a DBA’s life easier - including making some regulatory compliance easier. We’ll then walk though a typical implementation scenario live, and walk though a few demos and practical examples.
Speaker(s):
- Dave Walden
Track and Room: Enterprise Database Administration Deployment - ARP 210
Title: Navigating the Hadoop Stack
Abstract: Hadoop distributions can be a complicated road to navigate. Application names such as Spark, Pig, Hive, Falcon, and Ranger are interesting but give no indication as to what purpose they server or how they can be helpful to your organization. We’ll take time in this session to work through the various components (Hortonworks HDP ships with 23 projects) and find which ones fit into your specific needs.
Speaker(s):
- Scott Shaw
Track and Room: BI Platform Architecture, Development Administration - ARP 316
Title: Data Science at Rockhurst
Abstract: Learn more about the Data Science degree and certificate programs sponsored by Rockhurst’s Helzberg School of Management
Speaker(s):
- KC SQLSaturday
Track and Room: Other - ARP 116
Title: T-SQL Window Function Performance
Abstract: Window functions were first introduced with SQL Server 2005 and enhanced with SQL Server 2012. They enable easy development and great performance…well, sometimes. Learn what you need to know to take full advantage of these features. What you don’t know can hurt you when you are using window functions.
Speaker(s):
- Kathi Kellenberger
Track and Room: Application Database Development - ARP 224
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
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
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.
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.
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.
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.
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.
Andre DuBois
Twitter: - @MtnDBA
Contact: http://MtnDBA.wordpress.com
Andre has been in the IT industry for over 25 years in various positions with the majority working as database administrator, designer and programmer. His experience has been in the financial, travel and education industries.
Myles Gartland
LinkedIn: Myles Gartland
Dr. Gartland is a Professor of Analytics and Management at Rockhurst University. He spends his time teaching and researching in the areas of analytics, data mining, predictive models, business intelligence and big data. His speciality is classification models for predictive analytics. He has more than a dozen published articles and book chapters, as well as numerous international presentations. Dr. Gartland is also the Director of Graduate Business Programs.
Scott Shaw
Twitter: - @shawsql
LinkedIn: Scott Shaw
Contact: http://www.dbaexperience.com
Scott Shaw has over a decade of experience in data management. He is a frequent speaker at local and national community events and has co-authored two books on T-SQL. He teaches as well as implements Pig, Hive, Hadoop, as well as teaches courses on SQL Server, and Microsoft BI. He is currently working on a book titled quot;Practical Hive” to be published by Apress publishing. He lives in St. Louis and is a Sr. Solutions Engineer for Hortonworks.
Dave Walden
With over 20 years of experience in large, high performance, mission critical environments, Dave brings a wealth of knowledge and experience. While his primary focus is the data platform, Dave has deep expertise in other fields, including Cloud (Private/Public/Hybrid), Storage, Virtualization, Compute and Networking. Dave also has deep experience in the Big Data space, having worked in technologies such as Hadoop, Data Lake, Cosmos DB and MongoDB. Dave is a international speaker on SQL Server related topics, most recently on SQL Server on Linux.
Dave Fackler
Twitter: - @sqlbiguru
LinkedIn: Dave Fackler
Contact: http://davefackler.blogspot.com/
Dave Fackler is a business intelligence architect, focusing on enterprise data warehouse and business intelligence solutions using Microsoft technologies. Dave has helped organizations design and implement large-scale data warehouses, exploiting SQL Server enterprise database features using dimensional modeling design principles and best practices. He has also architected and developed several enterprise ETL processes using SSIS and its robust set of high-performance tasks and transformations. Dave has delivered various end-user reporting solutions using SSAS and SSRS, often coupled with SharePoint and Office components. Dave speaks about business intelligence at numerous technical conferences, user groups and professional groups each year.
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.
Keith Tate
Twitter: - https://twitter.com/keith_tate
LinkedIn: Keith Tate
Contact: http://thesqlchef.com
Keith Tate is a Senior Database Administrator with over 17 years of experience as a data professional. During Keith#39;s professional career he has been a developer, DBA and data architect. Keith is also active in the SQL Server community and is currently the chapter leader of the Albuquerque SQL Server User Group.
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.
Brian Hansen
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.
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.
Xuan Pham
LinkedIn: Xuan Pham
Xuan Pham teaches time series analysis and forecasting, business intelligence, applied data mining, spatial analysis, and economics at Rockhurst University.
KC SQLSaturday
test
JD Wade
Twitter: - https://twitter.com/jdwade
LinkedIn: JD Wade
Contact: http://wadingthrough.com
JD Wade has been providing solutions using various Microsoft products in the St. Louis area for over 18 years. J.D.’s expertise is the architecture, design, deployment, and troubleshooting of SharePoint and Microsoft Cloud solutions as well as interfacing with the surrounding technologies (directory services, e-mail, load balancers, DNS, SQL, WAN accelerators, etc.). J.D. has worked on the deployment of various corporate intranet, extranet, and public-facing web sites.
Rob Kraft
Twitter: - @robkraft
LinkedIn: Rob Kraft
Contact: http://csharpdeveloper.wordpress.com
Rob Kraft is an independent software architect, project manager, and developer from Lee#39;s Summit, MO. He was a certified trainer on SQL Server and co-authored a few books about SQL Server and network security. He has been a full or part-time SQL Server DBA since version 4.2. He runs www.KansasCityUserGroups.com and he blogs occasionally at http://csharpdeveloper.wordpress.com/.
Chris Miller
Twitter: - @syscomments
I spent several years designing, deploying and managing large scale SQL Server infrastructure for various companies. Now I#39;m a data architect, specializing in modeling and transformation of data between disparate environments.
Sudhir Gajre
Twitter: - @SudhirGajre
LinkedIn: Sudhir Gajre
Contact: http://www.dbbest.com/blog/author/sudhir/
Sudhir has over 20 years of experience in the Data Management and the Analytics field. He spent the last 14 years at Microsoft where he was a Data Architect and later a Principal Technologist. He has authored SQL Server performance tuning whitepapers, designed VLDB and Highly Scalable SQL Server Architectures, and led technical teams. He is a frequent speaker at conferences and SQLSaturdays and is a recognized expert in the Data Management field. He is a Director with DB Best Technologies.
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.
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.
KC SQLSaturday
test
Brandon Reno
LinkedIn: Brandon Reno
I#39;ve been obsessed with data for most of my life; from sampling data from video games to figure out their underlying formulas to designing and implementing large data warehouses as an adult. I#39;ve been working with MS SQL Server since 2003, and have worked with nearly every aspect of it, from administration to development in both transactional and analytical environments.
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.
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.
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.
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.
KC SQLSaturday
test
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.
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.
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.
John Deardurff
Twitter: - SQLMCT
LinkedIn: John Deardurff
Contact: https://www.sqlmct.com
John has been a Microsoft Certified Trainer (MCT) for over 20 years teaching Azure, SQL Server, Exchange Server, and Windows Server networking courses. He is currently a SQL Premier Field Engineer for Microsoft. He is an MCT Regional Lead for the Eastern United States and a former Data Platform MVP.
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.
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.
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.
Bill Graziano
Twitter: - @billgraziano
LinkedIn: Bill Graziano
Contact: http://billg.sqlteam.com/
Bill is a SQL Server consultant focusing on availability, performance, security, and developer support. He has nearly 20 years for experience supporting a wide variety of SQL Server installations.
He is a former President of PASS where he served on the Board for ten years. Bill was a SQL Server MVP for the previous thirteen years. He is the publisher of SQLTeam.com where his SQL Server articles have been read by DBA’s and developers all around the globe.
Bill is the author of two popular free SQL Server utilities: ClearTrace for analyzing SQL Server performance traces and Is It SQL? that provides simple SQL Server monitoring.
Sponsors
The following is a list of sponsors that helped fund the event: