SQLSaturday #584 - Colorado Springs 2017

Event Date: 03/25/2017 00:00:00

Event Location:

  • Colorado Technical University
  • 4435 North Chestnut Street
  • Colorado Springs, Colorado

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: Mobile, Paginated, KPIs, and Power BI, Oh My! SSRS 2016 Reporting

Abstract: SQL Server Reporting Services (SSRS) 2016 is getting the biggest update since SQL Server 2005! This session will define and demo each of the SSRS report types are and how they are developed and supported: Mobile (previously DataZen reports), Paginated (SSRS RDL reports), KPIs (new standalone Key Performance Indicators), and Power BI (now Power BI can be managed in SSRS for an on-premises solution). All of these report types can now be managed in SSRS for a single reporting solution.

We will also look at the new SSRS Web Portal (replacement for Report Manager) and how the development environment will change as well. Sometime will also be spent on how to support all of these report types and the impact it will have on IT. If you have been curious about what has changed with SSRS in SQL Server 2016 and you want to be ahead of the curve, this is the session for you!


  • Steve Wake

Track and Room: BI Information Delivery - 2

Title: Accelerating DevOps and TDM Using Data Virtualization

Abstract: DevOps is the merger of app development, testing, and IT ops. All tasks from coding to testing to operations must be automated so that new features and fixes can be continuously delivered.

Test Data Management (TDM) is the optimization of the process of software quality, ensuring that applications properly work according to their specifications.

Constraining both DevOps and TDM is data, which has grown enormous and complex. “Storage is cheap” is not merely a lie, but beside the point. It takes a lot of time to push terabytes around from place to place, and time is expensive.

Provisioning a full environment for each developer or tester on each task of each project seems unrealistic, when each might require terabytes of storage. So, everyone is limited to working in a small shared dev/test environments that are refreshed only every few months, and code quality suffers, and the pace of delivery fails to live up to requirements.

Data virtualization is the solution. Come learn.


  • Tim Gorman

Track and Room: Enterprise Database Administration Deployment - 3

Title: Seeking the Perfect Hybrid: On-Prem Data with Reports and Dashboards in Power BI

Abstract: For many new Power BI implementations, initial self-service and team objectives are soon met, and the natural evolution of Power BI turns to an organizational focus. In other scenarios, the enterprise seeks to preserve its investments in “classic BI” by integrating Power BI with Analysis Services and the underlying data warehouse.

In this session, Data Platform (SQL Server / BI) MVP and SSAS Maestro Bill Pearson explores the construction of organizational BI solutions, wedding the “traditional” solutions with the reporting and analysis power of Power BI. We’ll focus upon the components of a “traditional” solution, up to the semantic model (with SQL Server Analysis Services as an example), and then explore paths to the implementation of an end-to-end enterprise solution that uses Power BI as the presentation layer. This session applies, in most respects, to Analysis Services 2012 and above.


  • William E Pearson III

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

Title: The Next Frontier- Opportunities When Migrating to the Cloud with Virtualization

Abstract: Cloud is everywhere and the database administrator is caught in the middle. How do you know where to start and what to migrate first? How do you perform consolidation planning and ensure data security? This session builds on a full demonstration, along with tips and tricks to show how the DBA can secure their environment to allow a self-service option so they no longer are the constraints to projects! The attendee will leave with a clear understanding of:

  • Principles of virtualization and why it’s the answer to so many challenges we face today.
  • How easy it is to secure data in the cloud using data masking features.
  • The ease of connecting to the cloud and migrating environments.
  • How to troubleshoot when issues arise and the tools available to diagnose issues.


  • Kellyn Pot’Vin-Gorman

Track and Room: Enterprise Database Administration Deployment - 2

Title: Power BI on Azure Analysis Services

Abstract: The level of effort to integrate a tabular SQL Server Analysis Services (SSAS) cube with Power BI became significantly easier with the release of Azure Analysis Services. Setup, configuration and maintenance of an On Premise gateway for direct query and scheduled data refreshes is no longer required. Leveraging the default Azure Analysis Services integration with Power BI, developers can focus on modeling cubes and creating beautiful dashboards and reports. In this session, we will explore the setup of an Azure Analysis Services as compared to the use of as an On Premise Analysis Services data source for Power BI.

We will discuss modeling security patterns in Analysis Services in conjunction with Power BI. We will also demonstrate a direct query connection of On Premise and Azure Analysis Services cubes to Power BI. Additionally, we will highlight leveraging Power BI functionality including reports, dashboards, and QA of an Analysis Services data set.


  • Patrick Geselbracht

Track and Room: BI Information Delivery - 2

Title: Data Integration: the neglected hero of your information environment

Abstract: Every organization struggles to ensure data is up to date and consistent across multiple systems. Often this results in the development of layers of system to system data integrations or repetitive and manual processes intended to support operational and reporting needs.

Enterprise Data Warehouses and Marts are often the only stores that provide single point access to data sourced from multiple systems - but these stores can be expensive and complicated to build and maintain and tend to lag behind business need.

Data Lakes offer the promise of fast inexpensive data acquisition but without specialized tools lack the structure that makes their data accessible and useful to the business.

A managed Data Integration platform can provide both efficient data management across systems and a shared, single point, store of data sourced from all participating systems. A Data Integration platform solution is not technology or tool specific and can provide immediate and continuing value.


  • Scot Reagin

Track and Room: Information Delivery - 3

Title: Get Into the Goldilocks Zone: Managing SQL Transaction Log VLF Growth

Abstract: Are your transaction logs ballooning? Are the VLF numbers out of control? What can you do about it?

Let’s start with “what’s a VLF and why do I care?” and move forward into learning how to shrink VLFs (a temporary solution) and how to resize SQL Server transaction log files (a more permanent solution) for greater server stability, better performance during server startup, backups, and restores, and to minimize storage space requirements.

The SQL Server transaction log is a critical piece of SQL Server’s ability to ensure that data is maintained exactly as the user input or modified the data. The transaction log must, at times, grow in size in order to do its job. When a transaction log’s growth gets out of control (too large, too many segments), then SQL Server’s ability to perform as it should is negatively impacted. Too-large transaction log files cause longer database start up, backup and restore times, and will require more storage space on disk. Learn how to control VLF gro


  • Michelle Poolet

Track and Room: Strategy and Architecture - 5

Title: Statistics and New Cardinality Estimator Model

Abstract: Statistics in SQL Server plays a major role creating execution plan which essentially decides server performance. If you get a good execution plan the server performance is good otherwise it will impact negatively on the server performance. SQL Server 2014 introduced new Cardinality Estimation (CE) model to improve the quality of the execution plans via quality estimates of row counts. The new CE model is a major redesign to the Query Optimizer since SQL Server 7.0. In this session, I’m going to talk about how statistics is used to generate the execution plan, how execution plan changes with new CE model with demos.


  • Susantha Bathige

Track and Room: Enterprise Database Administration Deployment - 4

Title: Introduction To Azure DocumentDB

Abstract: Developers are interested in consuming and processing very large amounts of data as quickly as possible. Microsoft Azure DocumentDB is a NoSQL document database service designed for modern mobile and web applications which require fast reads and writes of unstructured data feeds. Azure DocumentDB natively supports JSON documents which is a key performance feature.

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. Finally, I will compare performance and feature difference between SQL Server 2016 and Azure DocumentDB.


  • Jeff Renz

Track and Room: Application Database Development - 6

Title: Disaster Recovery Where to Begin

Abstract: So you have a good backup strategy in place, but now you have to think about a disaster recovery. Where do you start and what are your options? SQL Server offers several options, but then how do you choose the right one to meet your business requirements? In this session, we will go over some of the common DR options including log shipping, replication, mirroring, clustering, and AlwaysOn. Then we will talk about how to choose the best one to meet your business needs.


  • Tracy Boggiano

Track and Room: Strategy and Architecture - 5

Title: Weird Stuff I Saw While … Working With Heaps

Abstract: We’ve all been told at some point that heaps are usually bad for select, update, and delete performance. But how bad are they really? Can they also be problematic for inserts? Are they ever a good idea? For this installment of Rick’s “Weird Stuff” series we will take a closer look at why heaps can cause issues and maybe see a deadlock or two.


  • Rick Lowe

Track and Room: Application Database Development - 6

Title: How to Use Analytics (and Data Science) to Get a Promotion

Abstract: Who has difficulty communicating the value of databases across their organization? Who wants to make more of a difference using database systems? Who is dissatisfied with their job and feels under-appreciated?

Welcome to my world. I’ve worked for years as a consultant, and I started in this situation, but I began making a living helping folks crawl their way out. Along the way, I got my Microsoft MVP, and I’ve helped many organizations make millions of more dollars through my consulting efforts. I’d like to help you, too.


  • David Brown

Track and Room: Advanced Analysis Techniques - 1

Title: Introduction to Data Science with R

Abstract: Data Science is the gaining popularity but what does it really mean? Discovering useful patterns and insight in the enterprise has become more challenging without a new set of tools. Big data has taken center stage in the data warehouse community and with data sets so large and complex that traditional data processing applications are becoming inadequate. Learn about the R language that is at the center of most advanced analytics conversations. R is an open source statistical language that is rapidly gaining popularity due to a robust set of machine learning functionality and a never-ending set of R packages that are used to increase functionality of the core R language. In this session, we will introduce the R language and review some of the features of the highly interactive environment that are available with just the base install. We will also review some of the upcoming features in the SQL Server 2016.


  • Reeves Smith

Track and Room: Analytics and Visualization - 2

Title: Up Close and Personal with the Tabular SSAS DMVs

Abstract: Did you know that we got new Dynamic Management Views (DMVs) for the SQL 2016 SSAS Tabular models that also work with Power BI? They can be used to monitor the health of your database as well as to retrieve useful metadata. In this session, you’ll learn how to access and query SSAS DMVs as well as important data points found in the DMVs. Then I’ll demonstrate my Tabular Model Documenter based upon the DMVs and explain how I built it. You’ll walk away with a tool that automatically documents your tabular model, saving you from tedious manual documentation.


  • Meagan Longoria

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

Title: Test Automation: Agile Enablement for DW and BI Teams

Abstract: Test automation is one of several key technical enablement practices that allows teams to be more successful in their agile journeys. While there are lots of test practices and automation tools out there for software development teams to leverage, very few are targeted to data-related development and testing. Agile analytics practitioner Lynn Winterboer and DW/BI architect and developer Cher Fox will share essential agile test foundations and data-focused test automation technologies to help data warehousing and business intelligence teams get a leg up on this important agile practice, including a demo of how this works!


  • Cher Fox

Track and Room: Other - 5

Title: So you want to launch a software company

Abstract: You love working with people and you love delivering solutions, and you want to be your own boss. You think you have a great idea and you’re ready to jump. The startup space is a completely different world. MVP means Minimum Viable Product. I took that plunge and converted my SQL MPV to a startup MVP. In this lesson I’ll pass on as much as possible about launching a software startup - beginning with the Business Model Canvass. (note: I’m also the chair of Colorado Springs Startup Week and on the board of Peak Startup)


  • Paul Nielsen

Track and Room: Professional Development - 4

Title: Isolation Levels – Understanding Transaction Temper Tantrums

Abstract: In this session we will review Isolation levels and how they affect applications that run on SQL Server. We will explore what happens when multiple applications accessing the same data use different isolation levels, and how that effects the server as a whole. We will also explore different ways to relieve these tantrums, and make your applications play nice together.


  • Adam Koehler

Track and Room: Enterprise Database Administration Deployment - 3

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 - 5

Title: Getting Started with Databases on Amazon Web Services

Abstract: Are you looking to understand what IaaS or PaaS really mean? Perhaps you are not sure of virtual, high available relational or NoSQL databases. Get started with the basics of managed services and platforms for running databases on AWS. Hear how to use managed relational databases such as MS SQL Server with minimal administration. Also discover other cloud options such as managed NoSQL or scaling your own instances with resizable elastic compute cloud. Take home an introduction from in-memory cache to petabyte-scale data warehouse databases in the Amazon cloud.


  • Gabriel Villa

Track and Room: Cloud Application Development Deployment - 6

Title: Introduction to SQL

Abstract: A fast and furious overview of the fundamentals of SQL (Structured Query Language), its history, language fundamentals of the data definition, data manipulation, data control, and transaction control language aspects.


  • Thane Schaffer

Track and Room: Application Database Development - 5

Title: Even I Can Power BI!

Abstract: Power BI Desktop is so intuitive when it comes to creating reports that even a 13 year old can do it. In fact I’m 13 and I can do it! Don’t believe me? Come to my session as I demonstrate how to import data, create dashboards, and publish them to the Power BI service.


  • Julia Renz

Track and Room: Analytics and Visualization - 1

Title: On the Doorsteps - Women in Technology

Abstract: Women make up over half of the workforce, and yet there are still discrepancies in pay and in the number of women in certain industries. Technology is one of the industries where women are drastically underrepresented. What factors in industry and society have contributed to these outcomes?

In this session, we will discuss the effects of trends in industry such as college graduation of women in technology fields, and women currently in tech or in positions of leadership. And, even important to us, how the contributions of women in PASS affect our community. This will be an open discussion with input from the audience encouraged.


  • Michelle Haarhues

Track and Room: Professional Development - 4

Title: Bringing DevOps to the Database

Abstract: DevOps is a hot topic in today’s software development world. However most of the knowledge and experience with DevOps is based around application software and ignores the database. We will examine how the concepts and principles of DevOps can be applied to database development by looking at both automated comparison analysis as well as migration script management. Automated building, testing, and deployment of database changes will be shown.


  • Steve Jones

Track and Room: Strategy and Architecture - 3

Title: Finding root cause for unexplained Availability Group failover

Abstract: In this session, we will walk you step by step showing how we determine root cause analysis of an unexplained failure in an Availability Group. Whether the databases simply became unavailable, synchronization stopped, or there was an unexplained failover. We will show you specifically what we look for in the OS Cluster logs, SQL error logs, Extended Events and other sources of information.


  • Trayce Jordan

Track and Room: Enterprise Database Administration Deployment - 4

Title: Branding Yourself for a Dream Job

Abstract: Everyone wants a dream job that they enjoy going to each week. However finding that job, and getting yourself hired can be hard for most people. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself, how to get the attention of employers, and help improve the chances that the job you want will get offered to you. Learn about networking, blogging, and more.


  • Steve Jones

Track and Room: Professional Development - 3

Title: Visualize Your Transaction Log

Abstract: The SQL transaction log can be a mystery to many DBAs. We live in the age of visualizations, so let#39;s visualize the log! In this session, we will examine the purpose and organization of the transaction log and will explore the log through a unique visualization tool. We will consider common performance issues that are related to the logging mechanism and how to overcome these problems. Finally, we will discuss some techniques to monitor the log so that potential performance problems can be addressed pro-actively.


  • Brian Hansen

Track and Room: Enterprise Database Administration Deployment - 6

Title: SQL Performance Best Practices

Abstract: Learn tip and tricks for configuring SQL Server for maximum performance, including: metrics, configurations, disk layout, virtualization considerations, and infrastructure.


  • Craig Allen

Track and Room: Enterprise Database Administration Deployment - 3

Title: My Top 10 Favorite Replication Tricks

Abstract: Replication can be intimidating and a bit confusing. I will show you my ten favorite tricks for working with replication that will show you how you can replicate from multiple sources to multiple destinations, chose the appropriate method of replication and, if desired, put the data in a different schema with a different collation at the destination than it was at the source. I will also cover various methods of managing your publications, agent properties and distribution schedules. This presentation assumes a basic knowledge of configuring distribution and creating a basic publication and subscription.


  • Marcus Hopfinger

Track and Room: Enterprise Database Administration Deployment - 4

Title: Intro to Azure SQL Databases

Abstract: Azure SQL Databases are still something that is new and not completely understood by many data professionals. There is a definite shift from installing SQL Server on a machine to creating and using a Microsoft’s Platform-as-a-Service database. This session will cover the basics of what an Azure SQL Database is, how we create one, and what it takes to access and use this database. After attending this session, you will have a solid understanding of what Azure SQL Database is, how to configure it, and how to use in your own environment.


  • Michael Fal

Track and Room: Cloud Application Development Deployment - 6

Title: Business Intelligence in the Cloud

Abstract: Is it time to move some of your Business Intelligence framework to the cloud? With so many cloud-enabled tools and platforms available today, including Azure Data Warehouse, Azure Analysis Services, Azure Data Lake, PowerBI, and many more, it has become a choice to consider for data architects. In addition to live demonstrations, Carlos will discuss data architectures and strategies that would benefit by using these new technologies. Come see some of these new features in action, allowing you to determine if it’s right for you and your architecture.


  • Carlos Bossy

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

Title: Introduction to Azure Machine Learning

Abstract: We will discuss what is Azure Machine Learning, how it works, what it can do, and why would you use it. This session includes demonstration and use case scenarios. The goal of this session it to provide an understand of what Azure ML can do and how it may apply to business use cases.


  • Warren Sifre

Track and Room: Advanced Analysis Techniques - 1


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

Warren Sifre

Twitter: - WAS_SQL

LinkedIn: Warren Sifre

Contact: http://www.broadstrokeconsulting.com/blog/, http://www.allegient.com

Warren Sifre has been in the IT community since 1998 and has worked in a variety of industries deploying solutions utilizing MS SQL Server in one capacity or another. In 2003, he decided to make SQL Server his mastery and has since developed skills in most defined disciplines of MS SQL. Currently he is a Principal Consultant and Technology Leader with Moser Consulting. He is responsible for BI Solution Architecture and the mentorship of team members. He has been a SQLSaturday Speaker since 2012, Azure Global Bootcamp, and many user groups in 2015 alone. He has a passion for knowledge transfer and solutions architecture, with a keen interested in Info Security.

Carlos Bossy

Twitter: - @carlosbossy

LinkedIn: Carlos Bossy

Contact: http://www.carlosbossy.com

Carlos Bossy (MCTS, MCP BI, CBIP) is a data and cloud analytics architect with 25 years of experience in software and database development. As a principal of Datalere, Carlos focuses on developing BI, Data Science, and Advanced Analytics solutions, including modeling data warehouses and delivering predictive models, integration, and visualization. He has developed warehouses and BI solutions for a variety of industries and state agencies, including health insurance, solar energy, foster care, telecom, and manufacturing.

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.

Steve Jones

Twitter: - way0utwest

LinkedIn: Steve Jones

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

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

William E Pearson III

Twitter: - @Bill_Pearson

LinkedIn: William E Pearson III

Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E

Bill Pearson created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill#39;s background as a CPA, Internal Auditor, Management Accountant, and SQL Server MVP (BI) enables him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies and focuses his practice upon the integrated Microsoft Business Intelligence

Thane Schaffer

Twitter: - @thaneschaffer

LinkedIn: Thane Schaffer

Contact: http://sqlambassador.blogspot.com/ http://viserpdev.blogspot.com/

Thane has over 25 years of IT experience focusing on software development during much of his career. In recent years has focused on database development, architect/design, modeling, administration, and ETO/MTO focused ERP systems. His current position, as a DBA at Transcore in Albuquerque NM, provides opportunities to do much of everything that a database generalist would enjoy doing.

Steve Jones

Twitter: - way0utwest

LinkedIn: Steve Jones

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

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

Tracy Boggiano

Twitter: - TracyBoggiano

LinkedIn: Tracy Boggiano

Contact: http://databasesuperhero.com

Tracy Boggiano is a Senior Database Administrator for DocuSIgn. She has spent over 20 years in IT, using SQL Server since 1999, and is currently certified as an MCSE Data Platform. Tracy has worked on SQL Server since 6.5. She has spoken at local user groups and numerous SQLSaturdays. She is currently a co-leader of a TriPASS Local Group in Raleigh, NC.

Tracy also tinkered with databases in middle school to keep her sports card collection organized. She blogs at databasesuperhero.com.

Her passion outside of SQL Server is volunteering with foster children as their advocate in court through volunteerforgal.org and being a mental health advocate as part of the PAIMI NC Advisory Council.

David Brown

LinkedIn: David Brown

David Brown is a huge data nerd. His technical focus is on ambitiously lazy development. He leads the local Seattle Modern Excel user group, and helps local data junkies solve their problems using simple BI technologies. His current focus is on machine learning amp; predictive analytics, and he#39;s helped many companies implement predictive analytics on top of SQL server technology within their organization as a consultant. If you want to figure out how to drive consensus and implement predictive analytics in your organization, he can help.

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.

Cher Fox

Twitter: - TheDatanista

LinkedIn: Cher Fox

Contact: http://foxconsulting.co

Cher Fox has 30 years of programming experience, including 25 years in analytics technical writing, and 15 years specializing in DW BI in multiple industries. She has held the corporate positions of Customer Services Manager for an international SW development group, IT Manager for a national risk management company, is currently the CEO/Principal Consultant of Fox Consulting, a Denver based firm specializing in high level management process re-engineering, DW BI consulting.

Ms. Fox is passionate about reverse engineering BI challenges to improve data quality reliability, improving performance in DW/BI processes as well as automating clients out of spreadsheet madness time consuming manual processes.

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

Marcus Hopfinger

Twitter: - DakotaDataWrang

LinkedIn: Marcus Hopfinger

Contact: http://dakotadatawrangler.blogspot.com/

Marcus has been with Daktronics, Inc. since 2001 where he started doing ColdFusion development and some SQL Server 7 database administration. In late 2003 he was activated and deployed in early 2004 to Iraq with the South Dakota Army National Guard. During this time, he served as a Battalion Communications Officer where he was responsible for redundant voice and data networks including satellite internet and secure internet routing protocol networks. Upon returning to Daktronics in 2005 he moved in into a fulltime database administration position where he gets to work on SQL Server instances on three continents. He is also a Sci-Fi Fan, History buff, Amateur Radio Operator (call sign KA0SQL), but most importantly husband and father.

Susantha Bathige

Twitter: - @sbathige

LinkedIn: Susantha Bathige

Contact: http://www.sqlservertorque.net

Susantha Bathige (MSc, MCITP) is a Microsoft Certified Database Professional specialized in relational database product, MS SQL Server. Having more than 16 years of IT experience including more than 9 years in database development and administration in non-production and production environments. He has experience of other databases systems such Cassandra and MongoDB as well.

Julia Renz

Twitter: - @jmr0323

Julia is a student of technology with a passion for learning new things. She loves math, computers and science. Julia has a passion for dance and softball in her spare time.

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.

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.

Kellyn Pot’Vin-Gorman

Twitter: - DBAKevlar

LinkedIn: Kellyn Pot’Vin-Gorman

Contact: http://dbakevlar.com

Kellyn Pot’Vin-Gorman is a member of the Oak Table Network and an Idera ACE and Oracle ACE Director alumnus. She is a Data Platform Architect in Power BI with AI in the EdTech group at Microsoft. Kellyn is known for her extensive work with multi-database platforms, DevOps, cloud migrations, virtualization, visualizations, scripting, environment optimization tuning, automation, and architecture design.

Kellyn has spoken at numerous technical conferences for Oracle, Big Data, DevOps, testing, and SQL Server. Her blog (http://dbakevlar.com) and social media activity under her handle, DBAKevlar, is well respected for her insight and content.

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.

Patrick Geselbracht

LinkedIn: Patrick Geselbracht

Patrick Geselbracht is a Solution Principal with Slalom Consulting. His expertise is in Data Warehousing, ETL, Master Data Management, Meta Data Management, Data Governance, Cubes, Reports, Dashboards Mobile BI. He specializes on the Microsoft SQL Server Business Intelligence tool suite including SSIS, SSRS, SSAS (multidimensional and tabular), SSRS, DQS, MDS, and Power BI. As a consultant, Patrick has Industry Experience in Oil Gas, Healthcare, Telecommunication, Insurance, Restaurant, Media, Automotive.

Paul Nielsen

Twitter: - @PaulNielsen

LinkedIn: Paul Nielsen

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

Paul is the founder of Tejon Technologies, inc, a software company offering a configurable, object/relational graph database solution built on the enterprise power of Microsoft SQL Server. Previously, Paul wrote the SQL Server Bible series, edited the MVP Deep Dives Vol 1 book, presented seminars in database design, and developed SQL Server courseware for Microsoft Learning. He was a Data Platform MVP from 2004 - 2016. IN the Startup Community he serves on the board of Peak Startup and is the chair of the annual Colorado Springs Startup Week.

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.

Michael Fal

Twitter: - @Mike_Fal

LinkedIn: Michael Fal

Contact: http://mikefal.net

Mike is a specialist in data management technologies. As a community advocate, public speaker, and blogger, Mike is a practicing thought leader for data and automation. He is passionate about DevOps and data, building platforms to optimize, protect, and use data efficiently.

Since 1999, Mike has been working in the database field, focusing primarily on SQL Server and specializes in automating data solutions to improve the reliability and efficiency of his environments. He has been caught playing trombone in public on more than one occasion.

Gabriel Villa

Twitter: - @extofer

LinkedIn: Gabriel Villa

Contact: https://extofer.wordpress.com/

Gabriel is a skilled leader, architect, and technical expert focusing primarily on Microsoft technologies and is passionate about open-source technologies for integration, automation, and development. Gabriel’s versatility extends from systems, data and development and leverages hybrid/SaaS/Cloud integration, proven software engineering platforms, and best-of-breed data management and business intelligence solutions.

Originally from El Paso, Texas, Gabriel lives in Colorado Springs with his wife and kids, where he is an Architect for RevGen Partners, volunteers in the tech community and enjoys the Colorado outdoors.

Craig Allen

Twitter: - @msftdude

LinkedIn: Craig Allen

Contact: http://www.msftdude.com

Craig Allen is a Dell EMC mSpecialist (Microsoft Specialist). His role as a technical consultant is to help customers in understanding Dell EMC’s products for the Microsoft platform. Craig can assist in the initial planning and evaluation of Dell EMC’s Proven Solutions for Microsoft, including requirements gathering, architectural guidance, and integration considerations.   Craig is located in Dallas, TX and comes to Dell EMC with 25 years of experience in IT.

Trayce Jordan

Working with SQL Server for almost 20 years, Trayce is one of the first certified masters, holding an MCM for SQL 2005 and has been working at Microsoft since 2006. Prior to joining Microsoft, he worked for a major online travel company as well as financial institutions and has served as a consultant working with companies in many different industries. His specialties include database performance tuning, operations management and support, high availability and disaster recovery.

Scot Reagin

Twitter: - @SDIScot

LinkedIn: Scot Reagin

Contact: http://sensibledataintegrations.com/blog/

TDWI Certified Business Intelligence Professional Certified Data Vault Data Modeler

More than thirty years of technology experience serving in a wide variety of roles including: Software Designer, Solution Architect, and Operations and General Manager. Experience designing and implementing complete analytic solutions for organizations of many sizes and in diverse industries.

Business intelligence specific experience encompasses all aspects of Enterprise Information solutions including: Information Quality, Enterprise Data Warehousing, Business Analysis Data Marts, and comprehensive visualization applications.

Michelle Poolet

Twitter: - #SQLinTheCloud

LinkedIn: Michelle Poolet

Contact: http://mountvernondatasystems.com/blog.html

Michelle Poolet, MCIS and Zachman Certified Enterprise Architect(tm), has been working with Microsoft SQL Server(tm) since version 6.0. She has authored many articles for SQLMag(tm). She created and delivered classes in Database Design, Theory amp; Programming at University of Denver. A founder of Mount Vernon Data Systems, Michelle is currently focusing on SQL Server database administration, OLTP engine performance/tuning, database architecture, and data modeling.

Tim Gorman

Twitter: - @TimGormanTech

LinkedIn: Tim Gorman

Contact: http://evdbt.com

Tim Gorman is a senior technical consultant for Delphix who securely enables masked data virtualization to increase the agility of IT development and testing while ending decades of security risk in SDLC.

Tim has co-authored six books on data warehousing and database administration, has performed technical review on eight more books, and has an author#39;s page on Amazon.com (http://www.amazon.com/Tim-Gorman/e/B00BKCTO5E).

Rick Lowe

Twitter: - DataFLowe

LinkedIn: Rick Lowe

Contact: http://dataflowe.wordpress.com/

Rick is a Microsoft Certified Master with more than 20 years of SQL Server experience in a variety of roles. He currently lives in Washington state and works as an independent consultant providing remote performance DBA and performance tuning services for clients in the USA and Canada. His first exposure to SQL Server was as a database developer, but over time he became more and more interested in how the database engine operated… eventually specializing more on performance issues than code.

Rick will work with all things relational, but most enjoys helping smaller companies get better performance from MSSQL, as well as smoothing over relationships between DBA and development teams.

Michelle Haarhues

Twitter: - @mhaarhues

Contact: https://witsociety.wordpress.com/

Michelle is a database administrator and has been working with SQL Server for over 15 years. She started as a SQL Server developer and is currently a Database Administrator for Denver Health. In many of her positions over the years, she was the lone SQL DBA\Developer so she loves talking about SQL Server to anyone who will listen.


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

Back to the SQLSaturday Event List

Back to the home page