SQLSaturday #331 - Denver 2014
Event Date: 09/20/2014 00:00:00
Event Location:
- University of Denver-Driscoll Student Center
- 2055 East Evans Avenue
- Denver, Colorado
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: Get to Know HDInsight and Start Mining Big Data
Abstract: The adoption of Hadoop as a platform for mining big data has opened up a new world of analytic possibilites. Using HDInsight, the cloud-based service from Microsoft, you now have the ability to fire up Hadoop on demand to get the maximum value from large and unstructured data.
In this introductory session, you will learn the fundamentals of HDInsight and Hadoop, you’ll see how to provision your own cluster in minutes, and you’ll know how to put the cluster to work by the end of the session. Practical examples that show clustering techniques and text analysis of unstructured and semi-structured data will be shown allowing attendees to implement their own cluster with minimal administration overhead.
Speaker(s):
- Carlos Bossy
Track and Room: Track 2 - Business Intelligence - N/A
Title: Women in Tech Panel
Abstract: The definition of confidence is “belief in oneself and one’s powers or abilities” but the authors of the new book “The Confidence Code” define confidence as “the quality that turns thoughts into actions.” Traditionally men have been found to have much more confidence in themselves than do women. For example, in a study at Hewlett-Packard, men applied for a promotion when they thought they could meet 60% of the qualifications while women applied only when they thought they could meet 100%. Attend this WIT session to learn more about confidence and how it impacts your career and life. To prepare for the session, it is recommended that you complete The Confidence Quiz (http://theconfidencecode.com/confidence-quiz/)
Speaker(s):
- Denver WIT
Track and Room: Track 7 - Professional Dev - N/A
Title: Getting started with Dimensional Modeling
Abstract: Technology has revolutionized the way organizations run today. Rather than a few file cabinets, organizations use many different software packages and applications that are mission critical to running their business. These systems gather a large amount of valuable data that must be used in decision making to maintain a competitive advantage. However, we’ve all heard and likely been around when mission critical systems have been rendered useless due to long running reports. To solve this and a host of other source system reporting issues we have proven Data Warehousing techniques to store the data in a report friendly way. Dimensional modeling is one of the most widely used set of techniques that will provide source system relief for reporting. In this session, we will take a look at what Dimensional Modeling is along with some key terms and techniques.
Speaker(s):
- Marc Beacom
Track and Room: Track 1 - Modeling/ETL - N/A
Title: Are You Maintaining Your SQL Servers?
Abstract: Are you performing all of the regular maintenance you should on your servers?Do you not run CHECKDB because “it takes too long”? How about Index Maintenance - does that take too long?Do you really have the appropriate backups in place?Do you have benchmark numbers in place to compare when your server is “slow”?Come discuss the answers to these and other questions - we will discuss the free Maintenance Solution scripted tools from Ola Hallengren and how they can help you fix these and other problems with a little easy coding you can do yourself. We will also discuss other tips and tricks to help you maintain and troubleshoot your SQL Server instances.
Speaker(s):
- Andy Galbraith
Track and Room: Track 4 - DB Dev/DBA - N/A
Title: Get Testing with tSQLt
Abstract: tSQLt is a testing framework that is designed to help you write repeatable, isolated tests against your database code. In this session we will briefly examine the goals of testing, where it can be used in an automated deployment pipeline, and introduce you to the tSQLt framework. We’ll show you how to design and write tests to enforce standards, check calculations and other DML operations as well as check exception handling. You will see how a real world refactoring task can be tested in a repeatable manner. Learn how you can incrementally write tests that help you build higher quality code and minimize the introduction of errors against your existing objects.
Speaker(s):
- Steve Jones
Track and Room: Track 3 - T-SQL - N/A
Title: SQL Server Backups and Restores A to Z
Abstract: Have you become the de facto DBA? Have you been tasked with the responsibility of backing up your databases? Do you feel that your database maintenance plan is adequate, but may be lacking in what it can do? If these scenarios sound familiar, you’ll want to join this session, where Microsoft Certified Master (MCM) Keith Tate will walk you through the basics of backup and restore options. The session will begin with the reasons why databases must be backed up (hint: to restore them). Then, discuss the different recovery models and how they affect your backup strategy. Next, explore ways to automate backup and restore strategies, and review ways to improve the speed of your backups and restores. Finally, put it all together and you’ll be on your way to a disaster proof backup and restore strategy.
Speaker(s):
- Keith Tate
Track and Room: Track 6 - DBA 2 - N/A
Title: Scripting in SSIS
Abstract: SQL Server Integration Services is full of useful and versatile tasks, components, and containers that allow the ETL developer to easily handle most data movement and transformation issues. However, it’s not uncommon to run into ETL need that require more flexibility than what is offered in the native tools of SSIS. Fortunately, Integration Services comes with a couple of tools to overcome most any ETL challenge: the Script Task and the Script Component.
In this session, we will explore both the Script Task and Script Component tools within SSIS. We will discuss the reasons why one might need to include scripting as part of an ETL strategy, as well as examining some use cases where scripting is a good fit. We will follow up with several demonstrations of how to solve specific ETL challenges using the Script Task and Script Component in SSIS.
Speaker(s):
- Tim Mitchell
Track and Room: Track 1 - Modeling/ETL - N/A
Title: Choose Your Geospatial/Mapping Adventure
Abstract: You have geospatial data and you know that plotting it on a map will deliver insights. Or maybe you keep hearing “geospatial” as a current BI buzzword and you want to be informed about your options when you get to it. The Microsoft BI stack provides several options for visualizing location data. But how do you know which tool will best serve your purpose, or what factors are important in making this decision? We’ll identify factors to consider when choosing a tool to visualize your data in maps such as system requirements, availability and type of location data, required level of technical understanding, and more. You’ll leave the session confident in your ability to choose the best tool within Excel and SQL Server.
Speaker(s):
- Meagan Longoria
Track and Room: Track 2 - Business Intelligence - N/A
Title: The Life Cycle of a Query in 3D
Abstract: Have you ever wondered what really happens behind the scenes when you execute a query? In this unique demonstration, Todd will use a video game engine (Unreal Engine 4) and will dramatically show The Life Cycle of a Query in 3D. We will follow a query from beginning to end and “runthrough” the various SQL Server components all queries must use including the Protocol Layer, Relational Engine, Storage Engine, Buffer Pool and then back out to the client. A volunteer at the end will then don an Oculus Rift Virtual Reality Headset for 3D Gaming and then race through the sections in under a minute to win a prize. Participants will leave with a better understanding of the major components and with a conceptual framework to explore the components more in-depth.
Speaker(s):
- Todd Kleinhans
Track and Room: Track 4 - DB Dev/DBA - N/A
Title: Revenge: The SQL! - Director’s Cut
Abstract: Pop quiz DBA: Your developers are running rampant in production. Logic, reason, and threats have all failed. You’re on the edge. What do you do? WHAT DO YOU DO?
Hint: You attend Revenge: The SQL!
This session will show you how to “correct” all those bad practices. Everyone logging in as sa? Running huge cursors? Using SELECT * and ad-hoc SQL? Stop them dead, without actually killing them. Ever dropped a table, or database, or WHERE clause? You can prevent that! And if you’re tired of folks ignoring your naming conventions, make them behave with Unicode…and take your revenge!
Revenge: The SQL! is fun and educational and may even have some practical use, but you’ll want to attend simply to indulge your Dark Side. Revenge: The SQL! assumes no liability and is not available in all 50 states. Do not taunt Revenge: The SQL! or Happy Fun Ball.
Speaker(s):
- Rob Volk
Track and Room: Track 3 - T-SQL - N/A
Title: Table Vars Temp Tables - What you NEED to Know!
Abstract: Almost every SQL Developer is familiar with Table Variables and Temporary Tables. While each of these objects represent temporary storage, there are also substantial differences between them. Understanding the differences between Table Variables and Temporary Tables, and the ramifications that those differences cause, is essential to being able to properly select the appropriate object for use in your development tasks. In this code filled session, we’ll discover the differences and similarities of Temporary Tables and Table Variables, dispel some widespread myths about each, and answer the most important questions of them all, “When do I use one or the other and what are the various impacts of doing so?”
Speaker(s):
- Wayne Sheffield
Track and Room: Track 4 - DB Dev/DBA - N/A
Title: Introduction to Powershell for the SQL Server DBA
Abstract: Maybe you’ve only heard of Powershell. Maybe you’ve seen a little bit of Powershell code, but still don’t understand how it works. You’ve been telling yourself for months now that you need to learn it. Why wait? The time to get started with Powershell is now.
In this half day session, we will build the foundation for using Powershell as a database administrator. Three areas will be covered:
- Powershell fundamentals - How the language works and how to write it
- Powershell/SQL Server integration - Functionality written specifically for SQL Server
- Application of Powershell - Use cases and code examples that leverage Powershell for database management
This session is intended for database administrators of all levels who have minimal experience with Powershell. Attendees who participate in this session will leave with a solid foundation of Powershell and how to apply it in their own environments.
Speaker(s):
- Michael Fal
Track and Room: Track 8 - Half-Day - N/A
Title: How to Pass Microsoft MCSA exams in Three Weeks
Abstract: Rose will share how she studied and passed the Microsoft exams in three weeks. She will share not only how she passed the exams, but also how you can set your own goals to pass the exams. So if you have ever dreamed of obtaining your Microsoft certifications come hear how you can apply what she did so that you too can pass your certifications!
Speaker(s):
- Rose Zarling
Track and Room: Track 7 - Professional Dev - N/A
Title: Read Dirty to Me - Isolation Levels/User Impact
Abstract: Issue a “SELECT {data} FROM {myTable}” statement and users need to trust the data returned is accurate. What happens when multiple processes access the same data? What happens further if one of those process is an UPDATE or even a DELETE statement? How about if both processes will be updating that data? Understanding Isolation in SQL Server is paramount in ensuring data integrity in your system. We will cover the different levels of isolation and how they impact what a user views when accessing the data at a given point-in-time.
Speaker(s):
- Wendy Pastrick
Track and Room: Track 6 - DBA 2 - N/A
Title: Power BI – Cloud Self-Service BI
Abstract: Reporting has moved to the cloud with the introduction of Power BI. Get the Power with Power Query, Power Map, Power Pivot and Power View which you will learn about while finding out how they all work together with Microsoft Excel and Office 365 to create a Self-Service Business Intelligence application in the cloud.
Speaker(s):
- Ginger Grant
Track and Room: Track 2 - Business Intelligence - N/A
Title: SQL Server Virtualization 201
Abstract: So you have finally virtualized your SQL Servers. Now what? How can virtualization be embraced to simplify and streamline operations? What about making the systems more resilient to failure? How can it be used to improve uptime and simplify some of the more common architectures? High availability, disaster recovery, backups, and new server provisioning are discussed in this interactive session.
Speaker(s):
- David Klee
Track and Room: Track 6 - DBA 2 - N/A
Title: SSAS Design and Performance Best Practices
Abstract: A journey through a compilation of best practices accumulated over multiple business intelligence, data warehousing projects, and published content in relation to SQL Server Analysis Services. From dimension design to SSAS Engine internals this session will take you through steps to assists in getting your SSAS cubes better optimized to better match the needs of your end users.
Speaker(s):
- Alan Faulkner
Track and Room: Track 2 - Business Intelligence - N/A
Title: Write Once, Build Many - Metadata Driven SSIS with Biml
Abstract: Biml is gaining traction as a viable method for programming SSIS. In this demo rich presentation you will be introduced to Biml and see the basics of using Biml to develop SSIS packages. We will also dive into examples of how you can leverage the power of Biml to create many packages from a single Biml script using a metadata approach to your development.
Speaker(s):
- Andy Vold
Track and Room: Track 1 - Modeling/ETL - N/A
Title: Introduction to Execution Plans Query Tuning
Abstract: There are times when you are able to be proactive and tune existing queries. Sometimes, you will receive a phone call from your manager telling you that a certain web page or report is timing out and your users are furious. You need to quickly diagnose what the problem is. Where do you turn to first? When a query is under-performing, hogging resources or timing out, one of the first things you want to examine is the query execution plan. The Query Optimizer, Execution Plans Query Tuning are the three key topics covered. At the end of the session you will walk away with the confidence to diagnose and tune queries.
Speaker(s):
- Jason Kassay
Track and Room: Track 8 - Half-Day - N/A
Title: Dr. DMV’s Troubleshooting Toolkit
Abstract: Dynamic Management Views and functions allow you to easily see exactly what is happening inside your SQL Server instances and databases with a high level of detail. You can discover your top wait types, most CPU intensive stored procedures, find missing indexes, and identify unused indexes, to name just a few examples. This session presents, demonstrates and explains numerous DMV queries that you can quickly and easily use to detect and diagnose configuration and performance issues in your SQL Server instances and databases.
Speaker(s):
- Glenn Berry
Track and Room: Track 5 - DBA 1 - N/A
Title: Ten T-SQL Techniques with Tally Tables
Abstract: Chris Hyde has been working with the Microsoft SQL Server stack for over thirteen years and has completed certification exams in SQL versions 2012, 2008, 2005, and 2000. He is a Senior Consultant with Leidos Health specializing in the healthcare market, which he particularly enjoys as he gets to tackle different types of data problems at each client. He is currently on the board of the Albuquerque chapter of SQL PASS.
Speaker(s):
- Chris Hyde
Track and Room: Track 3 - T-SQL - N/A
Title: Cloudy with a Chance of SQL
Abstract: You have heard all of the buzzwords and hype surrounding Microsoft Azure and the Cloud but what is it really and more importantly how can you use it effectively to solve the most important problems facing your organization today. We will look at both Windows Azure SQL Databases and using Azure VM’s to host SQL Server. Let Microsoft Certified Master of SQL Server Jason Horner show you how to apply your existing DBA skills to leverage SQL Server in the cloud.
Speaker(s):
- Jason Horner
Track and Room: Track 4 - DB Dev/DBA - N/A
Title: ETL with Microsoft Power Query for Excel
Abstract: Power Query, a free add-in for Excel 2010 and 2013, will enhance the self-service business intelligence offering from Microsoft. With Power Query the business analysis along with the BI developer can combine and shape data from a wide variety of data sources in a quick and easy manner. This task can enable more time to be spent in analysis and discover and less time build ETL plumbing.
This session will demo the ease of the data extraction process in Power Query. We will explore multiple data sources and even modify the language to create a foundation for further exploration into Power Query.
Speaker(s):
- Reeves Smith
Track and Room: Track 1 - Modeling/ETL - N/A
Title: Writing Better T-SQL Queries with Window Functions
Abstract: SQL Server 2005 and later versions introduced several T-SQL features that are like power tools in the hands of T-SQL developers. If you aren’t using these features, you’re probably writing code that doesn’t perform as well as it could.
This session will teach you how to get great performance, avoid cursor solutions, and create simpler code by using the window functions that have been introduced between 2005 and 2012. You’ll learn how to use the new functions and how to apply them to several design patterns that are commonly found in the real world.
Speaker(s):
- Kathi Kellenberger
Track and Room: Track 3 - T-SQL - N/A
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: Track 3 - T-SQL - N/A
Title: SQL Injection
Abstract: Well, we have all heard about the horror stories of data loss due to SQL Injection and how costly (in many ways) they can be. This in-depth discussion covers various forms of SQL Injection attacks and offers some guidelines on how to avoid them. Lots of code examples in both .NET and TSQL. Watch me hack a website and retrieve user data in just 3 hits on an unprotected html page!
Speaker(s):
- Kevin Boles
Track and Room: Track 4 - DB Dev/DBA - N/A
Title: SQL 2012 AlwaysOn Quickstart
Abstract: In this presentation I’ll explain what the SQL Server AlwaysOn high availability and disaster recovery solution is all about. I’ll talk about the different levels of protection it provides through Windows Clustering, SQL Clustering, and Availability Groups. We’ll discuss how these three things come together to protect your databases. We’ll finish with a dive into availability group configuration, the new capabilities it gives us, and what’s new in SQL Server 2014.
Speaker(s):
- Ryan Adams
Track and Room: Track 5 - DBA 1 - N/A
Title: I’m New, Select Me!
Abstract: I have been new to something at some point in my life, new town, new job or new profession. Now, I am the new DBA! Feeling overwhelmed, not sure where to begin. I know I have data and maybe lots of it. I need a friend and mentor to help me discover my new role. Select wants to be my friend, in fact Select and I need to become best friends. For Select and I to become best friends, we need to learn about each other, our weaknesses and our strengths. Come along, Select wants to introduce you to all of Selects friends. Let’s meet Where, Join, Group By and more of Select friends. Come along, let’s discover Select and his friends.
Speaker(s):
- Thomas Norman
Track and Room: Track 6 - DBA 2 - N/A
Title: Fun with Availability Groups
Abstract: Follow along as we adventure through the vastness that is Availability Groups in SQL Server. In this beginners guys we show you how to make an Availability Group from scratch, the new system tables that go along with Availability Groups, and how to troubleshoot your Availability Group using the system tables and SSMS.
Speaker(s):
- Christopher Wolff
Track and Room: Track 6 - DBA 2 - N/A
Title: Cardinality Estimates in Microsoft SQL Server 2014
Abstract: SQL Server 2014 includes a new cardinality estimator. This feature allows for statistics to be updated more frequently than previous versions of SQL Server, resulting in better query performance. Attend this session and understand how, why, and when SQL Server uses statistics and how this new feature will help improve performance.
Speaker(s):
- Thomas LaRock
Track and Room: Track 6 - DBA 2 - N/A
Title: Data Modeling 101
Abstract: Covering the basics for the beginner and those that have been thrown into a modeling role and have been cowboy’n it like the Wild West. We’ll cover why you should bother with a conceptual model and invest some of your project time in the modeling task. We will go over some different modeling techniques around Normalized, Dimensional and Data Vault options. And lastly, considerations for scalability, sustainability and empowering you with a Data Access Layer so you stay in control of your architecture as opposed to the application beast. Yee-Haw!
Speaker(s):
- Leslie Weed
Track and Room: Track 1 - Modeling/ETL - N/A
Title: Service Broker: The Queue Continuum
Abstract: Pop quiz: How can SQL Server help developers build scalable, distributed, and asynchronous applications? Service Broker is the answer! In this presentation, I’ll show you what it is; talk about when and why you might want to use it in your applications; walk through an example of how to set it up; and share a few lessons learned from our successful implementations.
Speaker(s):
- Ed Leighton-Dick
Track and Room: Track 4 - DB Dev/DBA - N/A
Title: SQL 2012 Extended Events
Abstract: Extended Events were introduced in SQL Server 2008. With SQL 2012, we have seen a significant upgrade to this feature. Join me for a little adventure into what extended events are. We will discuss how to use extended events to aid in performance tuning and in day to day administration. We will also explore some background and the architecture of extended events.
Speaker(s):
- Jason Brimhall
Track and Room: Track 5 - DBA 1 - N/A
Title: The Lost Science of Set Theory
Abstract: Many database developers today do not have a Computer Science degree and may also have begun their career developing software using procedural programming languages (Java, C#, etc.). As a result, they may not have the background needed to conceptualize solutions in terms of sets of data and therefore may not be able to develop efficient set-based queries. In this session, we will review the basics of set theory and how it applies to database development to enable you to turn cursors, loops, and other procedural programming practices into efficient set-based operations that make the most use of a relational database engine.
Speaker(s):
- Aaron Cutshall
Track and Room: Track 3 - T-SQL - N/A
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.
Speaker(s):
- Steve Jones
Track and Room: Track 7 - Professional Dev - N/A
Title: Making the Leap from Developer to DBA
Abstract: You are a Developer (.NET, SQL or otherwise) but you have been doing some DBA work and have now decided that is all you want to do - how do you make the transition? What do you need to know? This session will cover this topic from first-hand experience.
Speaker(s):
- Amy Herold
Track and Room: Track 7 - Professional Dev - N/A
Title: Dashboards - More Than One Way To Visualize Data
Abstract: Presenting BI in a sophisticated look that is both user friendly and easy to use can be challenging. In this session I will review the three major types of dashboards (Operational, Strategic, and Analytical). Using Visio, SSRS, SharePoint and Pyramid Analytics I will demonstrate examples of each of the dashboard types.
Speaker(s):
- Jeff Renz
Track and Room: Track 2 - Business Intelligence - N/A
Title: Advanced Statistics Management: Setting Up SQL Server For Success
Abstract: The optimizer uses statistics to generate a cardinality estimate which, in turn, affects query plan decisions as well as system resources. In this session we’re going to step through the process of evaluating the statistics present (or not present) and present a methodology for analyzing the presence of skew, candidate filtered statistics, and their efficacy in an environment. Additionally, we’ll look at the impacts of the new Cardinality Estimator in SQL Server 2014 on plan generation This would, ultimately, be an excellent addition to any periodic SQL Server health check.
Speaker(s):
- Seth Washeck
Track and Room: Track 5 - DBA 1 - N/A
Title: VLDBs: Lessons Learned
Abstract: VLDBs (Very Large Databases) play in a different league: common maintenance operations can take much longer to run, and some settings and features that work well on smaller databases become much less effective. These downsides generally have a negative impact on users, however through some creativity and changes in our game plan we can have highly performant VLDBs. This session will cover a wide variety of tips and tricks assembled from years of working with databases up to 40TB in size.
Speaker(s):
- Bob Pusateri
Track and Room: Track 5 - DBA 1 - N/A
Title: SSIS Logging Reconsidered
Abstract: The advent of SQL Server 2012, SQL Server Data Tools and Integration Services Catalogs have significantly improved out of the box logging. Unfortunately, logging best practices have not evolved with the new logging tools. This talk will outline the logging available “out of the box” with SSIS and discuss the implications for “traditional” ETL logging. Logging best practices will vary by business, industry and regulatory environments. We will review examples from the most basic operational logging to the most sophisticated logging required for auditing and regulatory compliance.
Speaker(s):
- Michael Sexton
Track and Room: Track 1 - Modeling/ETL - N/A
Title: Reporting Services In An AlwaysOn World
Abstract: While we don’t always see SQL Server Reporting Services as a mission-critical function, reporting has become more and more important with the BI explosion. Reports are driving crucial business decisions and providing invaluable information to users on a daily basis. With the introduction of AlwaysOn in SQL Server 2012, it seemed like Reporting Services was forgotten when it comes to HA support. In this talk, we’ll look at possible HA solutions for the ReportServer databases along with application servers. We’ll also discuss some of the challenges that arise from it and how to navigate them as best possible.
Speaker(s):
- Brandon Tucker
Track and Room: Track 2 - Business Intelligence - N/A
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
David Klee
Twitter: - kleegeek
LinkedIn: David Klee
Contact: http://davidklee.net
David Klee is a Microsoft Data Platform MVP and VMware vExpert with a lifelong passion for technology. David spends his days focusing on the convergence of data and infrastructure as the Founder of Heraflux Technologies. His areas of expertise include cloud, virtualization, performance, and business continuity. David speaks at a number of national and regional technology related events, including PASS Summit, VMware VMworld, SQLBits, SQLSaturday events, and many SQL Server User Groups.
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.
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.
Tim Mitchell
Twitter: - @Tim_Mitchell
LinkedIn: Tim Mitchell
Contact: http://www.TimMitchell.net
Tim Mitchell is a business intelligence architect, author, and trainer. He has worked with SQL Server for over a decade, specializing in data warehousing, ETL/SSIS, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas AM at Commerce, and is recognized as a Microsoft Data Platform MVP. Tim is a business intelligence consultant and principal at Tyleris Data Solutions.
Tim is an active community speaker and volunteer, having spoken at over 100 events including the PASS Summit, SQLBits, Dev Connections, SQL Intersection, and scores of SQLSaturdays. He blogs at TimMitchell.net, and tweets at @Tim_Mitchell.
Thomas Norman
Twitter: - ArmorDba
LinkedIn: Thomas Norman
Contact: https://armordba.com/
Tom Norman is a Database Architect at KPA with a strong fervor to protect data. He works daily to review and improve data protection methodologies while reviewing governing laws affecting finance, healthcare, and personal data. His areas of expertise include encryption, auditing, data identification, and database object deployment. He is the current leader of the PASS Virtualization Group and Vice President of the TRIPASS user group. You can read his blog at https://armordba.com/ and reach him on twitter at @armordba. Tom speaks at a number of SQLSaturday events and SQL Server user groups.
Andy Vold
Twitter: - @volda2000
LinkedIn: Andy Vold
Andy Vold, a SQL Server MCSA, MCTS and MCITP, is an Architect with RevGen Partners working primarily in business intelligence, SSIS/ETL, and database development. He enjoys helping clients by building database and business intelligence solutions to solve their complex business needs. Andy is a past board member of the Denver SQL Server Users Group.
Ryan Adams
Twitter: - @ryanjadams
LinkedIn: Ryan Adams
Contact: http://www.ryanjadams.com
Ryan Adams is a Senior Premier Field Engineer for Microsoft. He works directly with customers to help them realize their business potential and accelerate their digital transformation on premises and in the cloud.
Previously, Ryan was a Microsoft Data Platform MVP and spent 19 years working for a fortune 100 company. His passion is the SQL Server Engine, High Availability, and Disaster Recovery. He also served on the Board of Directors for the North Texas SQL Server User Group, was President of the PASS Performance Virtual Chapter, was a PASS Regional Mentor, and served as a Director for the PASS organization.
Denver WIT
Contact: http://denverwit.sqlpass.org
Panel consisting of Wendy Pastrick, Kathi Kellenberger, Amy Herold, Ginger Grant, Meagan Longoria, Leslie Weed, and Windy Martin
Andy Galbraith
Twitter: - https://twitter.com/DBA_ANDY
LinkedIn: Andy Galbraith
Contact: http://nebraskasql.blogspot.com/
I’m a forty-something Microsoft SQL Server DBA of 18+ years, a devoted husband, and a father of three young boys (all aged eight and under!) I have been a DBA at a public university, at a major bank, at a healthcare system, and I now work as a consultant with customers across the United States. I write and speak primarily about the tips and tricks that I discover along my SQL Server journey.
Wayne Sheffield
Twitter: - @DBAWayne
LinkedIn: Wayne Sheffield
Contact: http://blog.waynesheffield.com/wayne
Wayne Sheffield, a Microsoft Certified Master in SQL Server and Microsoft Most Valuable Professional, started working with xBase databases in the late 80’s. With over 25 years in IT, he has worked with SQL Server (since 6.5 in the late 90’s) in various dev/admin roles, with an emphasis in performance tuning. He is the author of several articles at www.sqlservercentral.com, a co-author of “SQL Server T-SQL Recipes”, and enjoys sharing his knowledge by presenting at SQL events worldwide and blogging at http://blog.waynesheffield.com/wayne
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.
Michael Sexton
Twitter: - @sqlmountain
Contact: http://datamountain.sqlmountain.com/
Stunningly handsome, yet surprisingly humble, Mike Sexton spent the first ten years of his career as a public defender in New York. Upon learning the discrepancies between his salary and the salary of newly minted college graduates working in IT, he had an epiphany and immediately learned how to program database applications. He has designed and built database applications for 12 years in both SQL Server and Oracle based systems, he has been published in SQL Server Magazine and is one of the aut
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.
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.
Thomas LaRock
Twitter: - @SQLRockstar
LinkedIn: Thomas LaRock
Contact: http://thomaslarock.com
Thomas LaRock is a Head Geek at SolarWinds and a Microsoft Certified Master, Data Platform MVP, VMware vExpert, and a Microsoft Certified Trainer. He has over 15 years’ experience in the IT industry in roles including programmer, developer, analyst, and database administrator.
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.
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).
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.
Aaron Cutshall
Twitter: - sqlrv
LinkedIn: Aaron Cutshall
Contact: http://sqlrv.com
Aaron N. Cutshall is an Enterprise Data Architect with 20 years of experience in analysis, design and development for applications and databases in manufacturing and warehousing plus over 15 years in the Healthcare Informatics field. His primary focus is in designing and developing solutions for extremely large data sets that perform quite well in SQL Server. He is active in the SQL Server community and speaks at SQLSaturday sessions across the country.
Todd Kleinhans
Twitter: - @toddkleinhans
LinkedIn: Todd Kleinhans
Contact: https://toddkleinhans.wordpress.com/
Todd Kleinhans has been using SQL Server since the last millennium. He has served in different roles across many industries but he’s mainly been a DBA. When not in virtual reality, he likes to speak at PASS sponsored events and volunteers in various groups like PASS, DSSUG, Colorado Virtual Reality and is the President of Denver/Boulder Unreal Engine group. He is on Twitter: @toddkleinhans and blogs at https://toddkleinhans.wordpress.com/
Marc Beacom
Contact: http://dawabi.com/blog.aspx
Marc Beacom is President of DawaBI, a Data Warehouse and Business Intelligence Consultancy firm focusing on Making Data-Driven Decisions Possible. He has been working with SQL Server for over a decade delivering scalable solutions for organizations of all sizes. He has earned several industry certifications and degrees. Marc is an active member of the community and has volunteered for many organizations such as PASS, Denver SQL, Colorado GiveCamp, Camp To Belong, to name a few.
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.
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.
Bob Pusateri
Twitter: - @SQLBob
LinkedIn: Bob Pusateri
Contact: http://www.BobPusateri.com
Bob Pusateri is a Microsoft Certified Master, DBA, and systems architect with over 10 years of experience on SQL Server. His interests involve internals, performance optimization, and cloud technologies. He is an active member of two Chicago-area PASS Local Groups, a community speaker, and maintains a web presence through both Twitter (@SQLBob) and his blog (bobpusateri.com).
Amy Herold
Twitter: - @texasamy
LinkedIn: Amy Herold
Contact: http://www.sqlkitten.com/
Amy Herold is currently a Premier Field Engineer with Microsoft, specializing in APS. Prior to this, she was a Sr. Database Administrator, focusing on PowerShell and automation. She is also currently the Director of Programs for the North Texas SQL Server User Group (NTSSUG). She frequently speaks at SQLSaturday and user group events across the United States and has also participated in numerous Women in Technology sessions as a panelist. Amy currently blogs at sqlkitten.com.
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.
Alan Faulkner
Twitter: - #FalconTekNik
LinkedIn: Alan Faulkner
Contact: http://falconteksolutionscentral.com/
I am an IT professional with over 20+ years of progressive technical experience with managing, consulting, software development, data integration architecture, data warehousing, and business intelligence development projects. The focus of my work is to work closely with stakeholders to develop architecture frameworks that align with organizational strategy, processes, and IT assets. Specializing in Business Intelligence (BI), Data Warehousing, database architecture, design and implementation.
Jason Brimhall
Twitter: - sqlrnnr
LinkedIn: Jason Brimhall
Contact: http://jasonbrimhall.info
Jason Brimhall has more than 20 years of experience and has worked with SQL Server 6.5 through SQL Server 2019. He has experience in performance tuning, high transaction environments, and large environments. He is currently a consultant specializing in performance tuning, server analysis, and problem resolution. Jason is a Microsoft Certified Master (MCM) and a Data Platform MVP.
Rob Volk
Twitter: - sql_r
LinkedIn: Rob Volk
Contact: http://weblogs.sqlteam.com/robv/
Rob Volk is a SQL Server DBA in the Metro Atlanta area since 2001. He also moderates and answers the forums on SQLTeam.com. While an old-time cranky DBA, he no longer considers quot;business intelligencequot; an oxymoron or quot;the cloudquot; as merely atmospheric moisture, and is delightedly dipping his toes into both of these new oceans, and loves to do things in new and and unusual ways.
Glenn Berry
Twitter: - GlennAlanBerry
LinkedIn: Glenn Berry
Contact: https://glennsqlperformance.com/
Glenn works as a Principal Consultant for Dr. DMV, LLC in Elizabeth, CO. He was a Data Platform MVP from 2007-2017, and he has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS, which proves that he likes to take tests. His expertise includes DMVs, high availability, hardware selection, performance tuning, and Azure SQL Database. He is also an Adjunct Faculty member at University College - University of Denver, where has been teaching since 2000. He has completed the Master Teacher Program at Denver University - University College. He is heavily involved in the SQL Server community, and is a frequent speaker at user groups, SQLSaturdays, and the PASS Community Summit.
Kevin Boles
Twitter: - @TheSQLGuru
LinkedIn: Kevin Boles
Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.
Ginger Grant
Twitter: - desertislesql
LinkedIn: Ginger Grant
Contact: http://www.DesertIsleSQL.com
Ginger Grant manages the consultancy Desert Isle Group and shares what she has learned while working with data technology to people around the world. As a Microsoft MVP in Data Platform, Microsoft Certified Trainer and an instructor on DataCamp, she focuses on guiding clients to create solutions using the entire Microsoft Data Stack, which includes SQL Server, Power BI, and Azure Data Cloud components. When not working, she protypes the latest pre-release data technologies, maintains her blog http://www.desertislesql.com, and spends time on twitter @desertislesql.
Seth Washeck
Twitter: - @swasheck
LinkedIn: Seth Washeck
Contact: http://swasheck.wordpress.com
Seth Washeck, SentryOne senior solutions engineer, is a longtime SQL Server DBA, active member of the Denver SQL Server User Group, and frequent speaker at SentryOne events. He was formerly senior SQL Server DBA at OppenheimerFunds, and DBA of Baxter Healthcare.
Jason Kassay
Twitter: - @jasonkassay
LinkedIn: Jason Kassay
Contact: http://www.JasonKassay.com
Jason Kassay is a database administrator, software engineer amp; speaker from Colorado with over 12 years of experience. He is passionate about SQL Server, programming, release process, automation amp; performance tuning. Jason is an active member of the SQL Server community amp; volunteers/presents at events such as Colorado User Groups, SQLSaturday amp; Colorado GiveCamp. When not tuning databases or coding, Jason will most likely be found spending time with his family, playing hockey or running.
Brandon Tucker
LinkedIn: Brandon Tucker
Over the past 7 years, Brandon has explored SQL Server as a developer, admin, and consultant. After graduating school, he has translated his academic knowledge base into real-world scenarios in the financial, health insurance, and education industries. Brandon has presented at Code Camps/User Groups in multiple states and was elected as VP, Events for DSSUG in 2010. When not pounding away on a keyboard, Brandon can be found wandering the globe in search of great music, beers, and experiences.
Rose Zarling
Rose Zarling has over 10 years of IT experience in software analysis and development. Her background is in writing SQL ETLs mainly for business analysis needs. She has an uncanny ability to problem solve and translate business needs into technical specs. RoseZ loves to help others achieve more, whether it’s using data analysis to help companies make better business decisions or tutoring in math. She has recently earned her MCSA certification and is an active volunteer for Denver WIT group.
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.
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.
Chris Hyde
Twitter: - ChrisHyde325
LinkedIn: Chris Hyde
Chris Hyde is a Microsoft Data Platform MVP and Microsoft Certified Trainer based in Albuquerque, New Mexico. He works as an independent SQL Server BI and DBA consultant, and is the leader of the Albuquerque PASS local user group. He is also part of the Friends of Redgate program and was a member of the Idera ACE class of 2018. He loves loud music and cricket, but usually not at the same time.
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.
Sponsors
The following is a list of sponsors that helped fund the event: