SQLSaturday #680 - Kansas City 2017

Event Date: 10/07/2017 00:00:00

Event Location:

  • Rockhurst University
  • 1100 Rockhurst Road
  • 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: Make Power BI Your Own with the Power BI APIs

Abstract: Power BI makes accessing data from various sources and building advanced visualizations for analytics easy to do. Behind the scenes Power BI is built on standard technologies and APIs that allow it to be customized in multiple ways to fit in with your environment the way you need it to. In this session we will walk though samples and demos that show how you can extend Power BI with custom visualizations, access custom data sources, embed various Power BI elements in your applications, and be able to push your data into a Power BI report/dashboard. Each of these items take advantage of the Power BI APIs in different ways and we will discuss each and provide the code samples for you to take back and get a head start. This session will be showing code to access the Power BI REST API using C# and NodeJS along with some M for accessing and manipulating custom data sources.


  • Steve Wake

Track and Room: BI Platform Architecture, Development Administration - ARP 210

Title: Working with Temporal Data in SQL Server

Abstract: In many industries, it is necessary for data professionals to be able to show what a data set looked like at a previous point in time. Whether it’s calculating tax or insurance rates based on a contract date, quickly comparing data changes over time for trend analysis or just recovering from an accidental data change, it’s useful to be able to look back in time through our data. SQL Server has long offered solutions like Change Data Capture or trigger-based audit tables, though those aren’t always the best solutions for each situation. SQL Server 2016 introduces system-versioned tables, which track data through time with far less overhead than other solutions. In this session, you’ll learn how to work with tables for each kind of solution, how SQL Server manages data within those tables, and how to query data at a specific point in time using several real-world examples. Attendees will leave with a fundamental understanding of practical use cases for different types of temporal tables.


  • David Maxwell

Track and Room: Application Database Development - ARP 114

Title: Data Modeling for the Modern Enterprise

Abstract: This session is theoretical with a focus on the many ways that we can model data. We will discuss why we select one modeling technique over the other in different user scenarios. These different scenarios will vary by industry and company, two main scenarios include: purchasing a product and storing the data related to the sales transaction, or visualizing the total sales for a product, month over month, for the calendar year 2016. Diagrams will be used to explain these different models and try to bring a more tangible aspect to the theoretical aspects of the discussion. Demos using IDERA ER/Studio Data Architect will be used to conclude the presentation.

Why Model Data • Business Benefits and Value

Different Model Types • Enterprise Model • Conceptual Model • Logical Model • Physical Model • Dimensional Model

Different Modeling Techniques • Normal Form Modeling • Star Snow Flake Schema • Slowly Changing Dimensions • Many to Many Relationships


  • Ryan Casey

Track and Room: BI Platform Architecture, Development Administration - ARP 218

Title: Remote SQL Server Troubleshooting and Monitoring Using SSIS

Abstract: We have over 3500 remote installations of SQL Server and only 3 DBAs to find and resolve issues. While some installations need daily examination others operate for months without any attention at all. We needed a system to keep a light, revolving set of data that we could quickly pull back and analyze when issues were escalated to us. This system also had to be modular so we could add or remove queries, as needed, while always keeping the data fresh. In this session I’ll use Glenn Berry’s diagnostic queries and SSIS to show how we collect and store data on our remote systems. When problems arise we download the data and use Powershell to digest it into a simple report.


  • Don St. Cyr

Track and Room: BI Platform Architecture, Development Administration - ARP 224

Title: Don’t just code it—Generate It

Abstract: Code Generators are all the rage—BIML, JS frameworks, .NET scaffolding, even the humble templates provide by SSMS for views, stored procedures, functions. Table-driven applications allow one set of code to handle changing business needs. Metadata-driven code generation takes this a giant step further. If you can describe your code with an algorithm operating against a set of data, you can get a computer to produce the code.

  • Source to Target mapping documents can be used to generate the code to effect the mapping.
  • Service Broker activation stored procedures have a clearly defined structure. They can be mass-produced.
  • Standard CRUD stored procedures can be stamped out cookie-cutter fashion.
  • Business rules can be encoded in data and the code to implement them manufactured. Generated code has systematic errors. Fix the errors at the generator. All the code now works. If the code is so boring that a computer can produce it, why not spend your talent doing something interesting?


  • Kevin Mackey

Track and Room: Application Database Development - ARP 210

Title: How to Keep Your Databases Secure in Just Minutes a Day

Abstract: You’re busy. You don’t have time to check the security of your systems all the time, right? It’s not like anyone has added a user that you don’t know about. And no one would create a database and add all logins to the db_owner role. And of course, no one would ever think of setting the TRUSTWORTHY property on a database… right?

Things like that happen on a daily basis, poking holes in even the most well-secured database. Those holes are just waiting for someone to find them. That someone could be you, or it could be an attacker probing for a way to get data from your company.

In this session, we will explore how to create reports that are quick to review so you can find the holes before someone else does - without interfering with the rest of your day. Along the way, you’ll also learn where to find security-related information in SQL Server’s metadata and logs to allow you to customize and extend the reports to meet your company’s unique needs.


  • Ed Leighton-Dick

Track and Room: Enterprise Database Administration Deployment - ARP 218

Title: Dynamic SQL: Tables, Pivots, Parameters

Abstract: Dynamic SQL is a scripting language that helps you design flexibility into your code. It allows you to design solutions, pass parameters and allows you build a single query on values passed. Dynamic SQL has both pros and cons to it’s design, but can also be a helpful tool. This presentation will walk through the steps of building dynamic tables, aggregating data in a pivot format and give you the first steps of writing a Dynamic Query. There are hundreds of task that will benefit from the use of Dynamic SQL. From parameter based searches to building dynamic SELECT statements at run time.


  • Steven Tidwell

Track and Room: Application Database Development - ARP 210

Title: Hidden Power: Service Broker

Abstract: Service Broker is a robust asynchronous programming model that provides reliable messaging between SQL Server instances. Making life easier for developers creating sophisticated applications to communicate between databases and servers.

With focusing on your basic database to database asynchronous messaging to more advance messaging across multiple servers, we are positive you will walk away with new knowledge about Service Broker. And just as positive we will learn something new with you. As some of you may know, Service Broker never ceases to surprise.


  • Ankit Baria

Track and Room: Other - ARP 210

Title: Data Mining Techniques with R and Azure Batch Services

Abstract: One the unique challenges Data Science teams face is provisioning compute resources. High core counts are required for only short bursts and sit idle for long periods thereafter. A demonstration will show how one can overcome this using Azure Batch Services. After attending the session one will be familiar with the data mining workflow, data mining packages in R, as well as how to configure and use Azure VMs directly from an R session.


  • Matthew Sharkey

Track and Room: Advanced Analysis Techniques - ARP 212

Title: ORMs and the DBA: How to Make Both Happy

Abstract: Talk to any DBA about ORMs and you’ll quickly find out all the things you like about ORMs are what DBAs don’t like. Interestingly enough, most developers I’ve talked to have issues with their ORMs, too. In this session, we’ll explore why ORMs cause such trouble, some strategies for mitigating those troubles, and I’ll introduce some tools (and even yet another ORM) that help solve some of the worst of the problems we see in the database when using ORMs.


  • Dan Mallott

Track and Room: Application Database Development - ARP 224

Title: Source Control and Database Projects - Just Do It

Abstract: If you aren’t using database projects you should be and if you aren’t using any source control well….. NOW IS THE TIME. We’ll review basic functionality and purpose of both and walk through how they work together. Let’s talk about the type of foundation pieces you need to pay attention to and how to organize this into team and agile work. Lots of tips and tricks to remove the often experienced headaches that developers have experienced with implementing both of these items.


  • Leslie Weed

Track and Room: BI Platform Architecture, Development Administration - ARP 116

Title: Introduction to R

Abstract: You will learn R data structures such as vectors, matrices, lists and data frames; how to work with variables; common data transformations; and lastly how to leverage R’s graphical capabilities.


  • Jeff Renz

Track and Room: Analytics and Visualization - ARP 212

Title: SQL Unit Testing with T-SQLt

Abstract: Unit testing is an important part of application development and maintenance. Knowing that your latest change is not only providing the desired results but also is free from side-effects is critical to the rapid pace expected by your customers. This session will provide an introduction in to how you can easily create a library of unit tests around your database and its programmable objects.


  • Kevin Trojanowski

Track and Room: Application Database Development - ARP 114

Title: Continuous Deployments using SSDT

Abstract: Many of us feel pressure to deploy changes to our database more often and more reliably. SSDT gives us a number of options to set up continuous integration and eventually, continuous deployment. Learn how to create and customize DACPACs, Published Profiles, and SQLPackage.exe to automate your deployment process. Whether you want to update QA or smoothly get changes to production, this session will give you the tips and tricks you need to get started.


  • Christopher Wolff

Track and Room: Enterprise Database Administration Deployment - ARP 116

Title: The Junior Developer’s Handbook

Abstract: Boy Scouts, Role-Playing Gamers, Human Resources…they all have handbooks to help them navigate their roles. Now database developers have one too! In this session, we’ll cover the essentials for any T-SQL developer to succeed. Topics include a method for writing new queries, measuring query performance, the importance of date tables and window functions, and time-saving tricks you never knew were possible in Management Studio. In addition to these quick wins, we’ll cover some longer-term strategies to set you up for faster career growth. If you’re looking for the missing manual for developers in their first two years, this session is for you.


  • Doug Lane

Track and Room: Application Database Development - ARP 114

Title: Index Speed Demons - How To Turbo-Charge Your Text Based Queries Using Full-Text Indexing

Abstract: We all want to improve the speed of our databases to make sure they run optimally. In this session we will explore relational and full-text indexes, their internals and uses. We’ll take a look at some alternatives to full-text indexes and their pitfalls. We’ll also explore turbo-charging the performance of your text-based search criteria using full-text indexes.


  • Adam Koehler

Track and Room: Enterprise Database Administration Deployment - ARP 218

Title: Security Developers Need To Know

Abstract: In this session I will list the things that developers need to do to minimize the risk that a hacker can gain access to a database. I will discuss each in depth and provide examples of a good code and practices to keep hackers out. The list includes: protecting connection strings, using minimal database permissions, funneling all database code through central logging and injection testing filters, proper use of stored procedures, hashing passwords, and SQL injection prevention. I believe that when developers write a properly architected application, they can be confident that risks of database injection through the application is minimized.


  • Rob Kraft

Track and Room: Application Database Development - ARP 114

Title: Azure Machine Learning 101

Abstract: You have probably heard the buzz about Azure Machine Learning, aka Azure ML, over the past few years. It is a surprisingly easy to use predictive analytic tool that you can learn for free. Attend this session to learn how to get started with Azure ML.


  • Kathi Kellenberger

Track and Room: Analytics and Visualization - ARP 212

Title: Service Broker Empowering near Real-time Mainframe Analytics

Abstract: If you’ve learned the basics of Service Broker, this discussion will help you understand how to design a Service Broker architecture that allows for near real time message processing from external sources. In this case, see a system designed to handle 5 million varied messages an hour in less than 750 milliseconds across multiple, distributed commodity SQL Servers. Discussion of service broker design and optimization, conversation management, error handling and logging, and operational metrics.


  • Brendon Collier

Track and Room: Application Database Development - ARP 210

Title: Set Me Up: How to Think in Sets

Abstract: SQL Server is optimized to work in sets, but this is certainly a paradigm shift for someone accustomed to row-by-row operations.

We will look at T-SQL features that can break set-based processing – generally meaning poor performance – and gather empirical evidence to support that assertion. We’ll also look at some constructs to overcome these issues and make your T-SQL scripts run faster and use fewer resources.


  • Brian Hansen

Track and Room: Application Database Development - ARP 212

Title: LIVE SQL Server 2017 LINUX Availability Group buildout!

Abstract: Full LIVE buildout of an 2-node SQL Server 2017 CTP 2 Availability Group, on Linux! We’re going to start from scratch, and cover allocating VMs in Hyper-V, loading the OS, general configuration of the operating system, installing SQL Server, and finish with an controlled failover of SQL Server using native Linux utilities. We’ll talk about each step along the way


  • Dave Walden

Track and Room: Enterprise Database Administration Deployment - ARP 116

Title: Preparing to be Hacked

Abstract: They are going to get in. This session talks briefly about how they get in. But they are going to get in. It talks a little about security best practices. But one little mistake by anyone and they are in. How will you know they’re in? How will you know how they got in? What do they want? How will you know what they’re doing? How will you know if you’ve kicked them out? This session will focus on the type of logging and tripwires you’ll need to respond to a breach of your SQL Servers. It includes a mix of technical solution and process recommendations based on actual incidents.


  • Bill Graziano

Track and Room: Advanced Analysis Techniques - ARP 218

Title: Performance Monitoring AlwaysOn Availability Groups

Abstract: Have you deployed Availability Groups in your data center? Are you monitoring your Availability Groups to ensure you can meet your recovery objectives? If you haven’t this is the session for you. We will discuss the importance of monitoring and trending Availability Group Replication, how AGs move data between replicas and the impact replication latency can have on the availability of your systems. We’ll also give you the tools and techniques to go back to the office and get started monitoring and trending right away!


  • Anthony Nocentino

Track and Room: Enterprise Database Administration Deployment - ARP 116

Title: Cohesity

Abstract: Learn how Cohesity can help tame your data sprawl


  • KC SQLSaturday

Track and Room: Other - ARP 210

Title: Datrium

Abstract: Learn more about how Datrium is revolutionizing data storage


  • KC SQLSaturday

Track and Room: Other - ARP 212

Title: Quest

Abstract: Quest Software Update

  • Commitment to SQL Server Market
  • Solutions Overview
  • Monitoring and Workload Analysis
  • Historical Trending
  • Ensure Coordination From DEV to TEST to PROD
  • Backup, Compression, and Recovery


  • KC SQLSaturday

Track and Room: Other - ARP 218

Title: Tallgrass Consulting

Abstract: Learn more about how Tallgrass is your partner in achieving success. We provide expertise and ingenuity to solve your business challenges and enable execution for impactful results


  • KC SQLSaturday

Track and Room: Other - ARP 116

Title: SQL and BI Business Value

Abstract: Determining business value for SQL and BI in the enterprise. Establishing a business case, purpose of a business case, business case components, SQL and BI Value, value in the Cloud.

Have you been challenged determining value? Identifying the basic problem? Communicating the business benefit? This session is a great business introduction to these concepts! Helping IT leaders bridge the gap between IT and business!

Participants will learn about the basics of determining business value for a solution.


  • Matthew Bowers

Track and Room: Professional Development - ARP 224

Title: Transitioning from Integration Services to Azure Data Factory

Abstract: Although SQL Server Integration Services (SSIS) and Azure Data Factory (ADF) are both used for data management processes in the Microsoft Data Platform, they are rather different tools. SSIS performs data transformation and requires a SQL Agent job or another application to schedule and execute it. ADF is an orchestration tool rather than a data transformation tool, and it has built-in scheduling capabilities. I’ll explain the basics of Azure Data Factory, show how it is and isn’t like SSIS, and share lessons learned from ADF projects I have completed.


  • Meagan Longoria

Track and Room: BI Platform Architecture, Development Administration - ARP 116

Title: Rockhurst University – Business Intelligence Analytics Programs

Abstract: Rockhurst University – Business Intelligence Analytics Programs Come learn about Rockhurst University’s unique certificate and master’s degree programs in Business Intelligence and Analytics. Certain courses are now being offered online for the Spring semester.


  • KC SQLSaturday

Track and Room: Other - ARP 114


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

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

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

Ankit Baria

LinkedIn: Ankit Baria

Ankit has over 8 years of experience in Application Developer, Database, Database management, Business Systems Analyst and Software development which includes analysis, design, implementation and testing of web/windows based applications, client/server and relational database design using Oracle, Sybase, MySQL and MS-SQL Server with a Master’s degree focused in Computer Information Systems. He has designed and developed a SQL Server Broker Service for real time data movement between multiple SQL Server’s for maintaining reliability and improving the performance by keeping the data in sync across multiple platforms at the same time reducing the load on the servers.

Brendon Collier

LinkedIn: Brendon Collier

Spent the last couple years building out a high speed, low latency SQL Server code base to capture every transaction from a mainframe supporting 24/7 national operations (with a few other good teammates). @BillinKC says I should tell you… so here I am! Hope to see you there.

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.

Kevin Mackey

Twitter: - @kevinjmackey

LinkedIn: Kevin Mackey

Contact: https://kjmackey.wordpress.com

Kevin a software architect with a track record of creative and effective delivery of results for organizations who want to translate data into information.

With a background as a trainer Kevin can explain complex technologies and concepts in easy to understand language. By the same token, he can take complex business problems and express them in terms technology teams can use to derive solutions.

Kevin has a focus on automation of data movement, analysis, information delivery, and of the code to accomplish this.

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.

Anthony Nocentino

Twitter: - nocentino

LinkedIn: Anthony Nocentino

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

Anthony Nocentino is the founder and President of Centino Systems as well as a Pluralsight author, Microsoft Data Platform MVP, Linux expert, and corporate problem solver. Anthony designs solutions, deploys the technology, and provides expertise on business system performance, architecture, and security. Anthony has a Bachelors and Masters in Computer Science with research publications in high performance/low latency data access algorithms and spatial database systems.

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.

Dan Mallott

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

LinkedIn: Dan Mallott

Contact: https://www.danielmallott.com

Dan Mallott is a Chicago-based consultant for West Monroe Partners in their Technology Practice. His passion is for service-layer development, particularly database technologies, including Microsoft SQL Server and Apache Cassandra.

Recent projects have included designing a new integration architecture for a mid-sized health insurer, designing a full technical architecture for a large health insurer, building a new member portal for a healthcare-related association, and developing threat hunting software for use by West Monroe.

In his spare time, Dan can be found writing his own libraries instead of using package solutions, or on the ice as a hockey player and referee.

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.

Matthew Sharkey

LinkedIn: Matthew Sharkey

Contact: http://www.hinttank.com/

Matthew has ten years of IT experience, primarily working in IT Operations and Analytics. His specialties include T-SQL querying, performance optimization, data analysis, and data visualization. Matt has worked with all major features of the SQL Server Data Platform. Matt holds a Data Platform MCSE and two masters degrees.

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.

Adam Koehler

Twitter: - sql_geek

LinkedIn: Adam Koehler

Adam Koehler is the Senior Database Administrator for ScriptPro, LLC. He has worked with SQL Server from 7.0 to 2017 in various roles throughout his career with the last 14 years in a DBA role.

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.

Matthew Bowers

Twitter: - @mbowersmailctp

LinkedIn: Matthew Bowers

Partner, Senior Business Solutions Consultant, Client Engagement Manager and Senior Business Development Executive. Mr. Bowers specializes in applying contemporary technologies to solve business problems. Focus on helping businesses realize return on investment and value from their technology investments, as well as the application of disruptive technologies to achieve digital transformation Passionate about helping organizations make the connection between technology and realized business value. Passionate about helping IT leaders bridge the gaps between IT and business through enhanced business discussions. 12 years CTO / CIO Level experience in small to medium sized businesses.

MSFT VTSP / P-Seller

Steven Tidwell

Twitter: - @SQLCodeMonkey

LinkedIn: Steven Tidwell

Contact: https://www.sqlcodemonkey.com

I am currently the Technical Lead for Client custom projects. I have been writing SQL Code starting in SQL 7. Over the years I have put on many hats, DBA, Developer, Web Developer, C#, VB.NET, Cold Fusion and Java. But at the end of the day, I prefer to write SQL. Local Chapter Leader for the South Montgomery County SQL Server User Group in Montgomery County, Texas.

Kevin Trojanowski

IT Professional with over 25 years experience across a range of technologies, specializing in data and databases including SQL Server and Redis.

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.

KC SQLSaturday


KC SQLSaturday


KC SQLSaturday


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.

Meagan Longoria

Twitter: - mmarie

LinkedIn: Meagan Longoria

Contact: http://datasavvy.me

Meagan Longoria is a business intelligence consultant with Denny Cherry Associates, and lives in Denver, Colorado. She is a Microsoft Data Platform MVP. Meagan spends a lot of time thinking about how to use data integration, DAX, and data visualization techniques to make data useful for people. She enjoys sharing her knowledge and experiences at conferences and user group meetings, as well as through her blog (DataSavvy.me).

KC SQLSaturday


Don St. Cyr

Twitter: - @Machiavelli_too

LinkedIn: Don St. Cyr

I am originally from Maine but I have lived in the Midwest since ‘95. I am married with a son and daughter, 3 dogs, 2 bunnies and a horse. I have worked in IT for the last 20+ years in various roles such as technical trainer, computer tech, systems administrator and database administrator. I have worked in numerous fields such as education (for K-12 and post secondary), the military (for the U.S. Army and the Dept of Defense) and in healthcare. I am also a U.S. Army and Desert Storm veteran.

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.

KC SQLSaturday


Doug Lane

Twitter: - @thedouglane

LinkedIn: Doug Lane

Contact: http://www.sqltheater.com

Doug Lane is the founder of SQL Theater, a company specializing in helping junior developers and public speakers. Doug has over 15 years#39; experience in IT and holds a Bachelor of Arts degree in Media Production. In addition to presenting at conferences, SQLSaturdays, and user group meetings, Doug also blogs and produces video training courses.

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.

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.


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

Back to the SQLSaturday Event List

Back to the home page