SQLSaturday #297 - Colorado Springs 2014

Event Date: 04/12/2014 00:00:00

Event Location:

  • 1628 West Bijou 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: Faster Leaner: Optimize DW Solution Delivery with Power Pivot and AS Tabular

Abstract: You may not see this in the marketing materials, but the reality is PowerPivot and AS Tabular together provide some powerful options for Data Warehousing professionals. This session is for DW dimensional modeling pros interested in streamlining optimizing the design delivery process for enterprise-quality data marts dimensional semantic models.

We’ll touch on Agile Lean disciplines, how they can be applied to DW solution delivery. Then we’ll walk through demos of practical applications in the form of PowerPivot POCs prototypes that can be promoted to AS Tabular models and refitted to the finished DW structures once delivered. We’ll focus on key DW challenges and how these technologies and techniques can be used to speed and improve effectiveness of requirements gathering and user testing, optimize sequencing of deliverables, minimize risk of rework and ultimately deliver quality DW solutions successfully.


  • Brent Greenwood

Track and Room: Track 3 - N/A

Title: SQL Server Murder Mystery Hour: Dead Reports Don’t Talk


Before a pivotal meeting to secure venture capital, a key report vanishes from the server without a trace, leaving Cromulent Technologies’ future in jeopardy. Our group must solve the crime. Time is critical as the CEO has promised to explain the matter to investors just sixty minutes from now. Only with your investigative skills, SQL Server knowledge, and teamwork can we find the missing report, bring the perpetrator to justice, and save Cromulent Technologies!

SQL Server Murder Mystery Hour is part technical presentation, part networking event. We’ll focus on Reporting Services administration in areas that are vital to business continuity: security roles, encryption keys, and backups. All attendees have a part to play.


  • Doug Lane

Track and Room: Track 3 - N/A

Title: Tabular Data Modeling and Visualizations

Abstract: In this session, we will look at Tabular Data modeling, the life cycle of Tabular Models, and visualization tools available in the Microsoft Business Intelligence Stack. We will build a tabular solution from scratch and discuss use cases and differences between Tabular and Multidimensional Data Models. Finally, we will take a look at the data visualization tools in the Microsoft BI Stack including: SharePoint Integration, Excel Services, and Power View. This demo heavy presentation will cover a wide variety of topics and tools equipping attendees with the knowledge to start developing Tabular Data models and understanding how to use Data Visualization tools to effectively empower users with self-service BI and drive efficiency across the organization.


  • Rob Schafer

Track and Room: Track 4 - N/A

Title: SMO Internals for High Performance PowerShell

Abstract: Ever wanted to know what happens behind the scenes in SQL Server when you use PowerShell and SMO to manage a SQL Server? How fast can your automation really go? I will take you through a few common objects in SMO and the internals of what happens when you use those objects. We will examine the TSQL that is generated, and learn techniques that lead to high efficiency. We will dive deep through the collections that make SMO the powerful tool it is. Combining the flexibility of PowerShell and SMO Internals is a recipe for awesome sauce. Come peek behing the curtain and squeeze the speed out of your automation scripts using PowerShell and SMO. You’ll be glad you did.


  • Ben Miller

Track and Room: Track 1 - N/A

Title: Capture Change and Apply it With Change Data Capture SSIS

Abstract: Whether you are trying to setup a new data warehouse, keep it updated, audit changes to your databases or quickly load changes to another database Change Data Capture (CDC) is a solution for all of these and can now be setup and supported easily with SQL Server SSIS 2012! Change Data Capture (CDC) has been around since SQL Server 2008, but has been underused because it was difficult to fully implement. SSIS 2012 now provides support for CDC with new components that make consuming the captured data very easy to apply. This session will define what CDC is and with live demos show how it is setup on your databases. Once it has been setup then you need to consume and apply those changes, this will be demonstrated with live demos using SSIS 2012 to create packages that apply the changes.


  • Steve Wake

Track and Room: Track 4 - N/A

Title: Getting Started with Execution Plans

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 underperforming, hogging resources or timing out, one of the first things you want to examine is the query execution plan. An execution plan provides a wealth of information that can help you quickly diagnose what is wrong. In this beginner level session you will learn what an execution plan is, how to find it, and how to interpret it to see what the query optimizer is doing and find the major pain points.


  • Jason Kassay

Track and Room: Track 4 - N/A

Title: Tabular Models

Abstract: Tabular modules allow developers to create models based upon different data sources; create hierarchies, perspectives, partitions and roles similar to traditional OLAP cubes. In this session will highlight the differences between traditional OLAP and tabular models and reasons for selecting one approach over another. I will demonstrate how to create a data model first in power pivot model and then import into an Analysis Services Tabular Project. Working with the imported data I will then create measures, KPIs, perspectives, and implement security. Finally I will deploy the model to an Analysis Server.


  • Jeff Renz

Track and Room: Track 2 - N/A

Title: I Don’t Know Which Queries Are Slow, Just Make All of Them Faster

Abstract: Shortly after learning how to troubleshoot a poorly performing queries it’s not unusual for a DBA to discover a nasty surprise - some (or perhaps most) of your users will not be able to actually tell you what query is performing poorly. The good news is that SQL Server does know! This session covers some of the basics of looking through the plan cache for slow queries, including some tips on spotting potential parameter sniffing issues when you don’t have the luxury of actual execution plans.


  • Rick Lowe

Track and Room: Track 4 - N/A

Title: Database Design: Size DOES Matter

Abstract: Great database performance starts with great database design. During the database design process it is important to select your datatypes wisely. The wrong choices will often lead to wasted space, increased response times, and less stability. Additionally you run the risk of having your design not scale as well as it should. Leave this session armed with the knowledge you need to help your databases perform at their peak efficiency.


  • Thomas LaRock

Track and Room: Track 4 - N/A

Title: Back the Truck Up

Abstract: Performance tuning backups? Yes. Performance tuning backups. As your data grows, so does your DR profile. In this session we’ll take a look at how different backup configuration options affect both the performance of your backups as well as the performance of your server during the backups. Of course, this is also sneaky way to introduce a real-world use of Extended Events during the process.


  • Seth Washeck

Track and Room: Track 2 - N/A

Title: Type More, Click Less: Programmatically build SSIS packages

Abstract: Developing repetitive strain injury (RSI) from all those mouse clicks in Business Intelligence Development Studio/SQL Server Data Tools? Longing to automate the tedium in SQL Server Integration Services package creation? In this session, we’ll explore the Integration Services object model and learn how to create rich packages without ever clicking our mouse. You’ll learn about the basic object model, the EzAPI wrapper for it, as well as using BIMLScript to build moderately complex packages.


  • Bill Fellows

Track and Room: Track 3 - 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.


  • Glenn Berry

Track and Room: Track 1 - N/A

Title: Managing Log File Obesity

Abstract: Have your efforts to trim a few pounds off your log file been met with frustration? Are you scratching your head on why that DBCC SHRINKFILE doesn’t seem to do anything? Log file obesity is a problem that can challenge DBAs of any level. This session will help you deal with your overweight database by covering how log files grow, why truncating the log is a bad idea, and what you can do to keep your files trim and fit.


  • Michael Fal

Track and Room: Track 2 - N/A

Title: Virtualizing our Environment

Abstract: This session will describe our journey to convert our cluttered, underutilized, power draining physical hosts to a sleek virtualized environment. This session will also provide some VMware high level architecture, terms and concepts, and a look at vSphere (VMware admin console). I’ll discuss the differences between virtual and physical host metrics and issues surrounding them. We’ll discuss some virtualization shortcomings and then show a little about Confio’s Ignite and how it can help DBAs achieve virtualization and not lose visibility of their physical layer.


  • Rob Mandeville

Track and Room: Track 2 - N/A

Title: SQL Server performance management

Abstract: discuss approaches to SQL Server performance management from both Resource and Wait State perspectives, and ways to use these approaches using both native utilities and Dell Software tools


  • Kat Long

Track and Room: Track 4 - N/A

Title: DBA Survival Guide: Daily Checklist and Server Monitoring

Abstract: You are responsible for the health and welfare of the servers, and the databases under your command. What should you check daily? How about weekly? Should you automate? We will discuss all these things, and how having a Daily Checklist, and monitoring your server will help you maintain balance in the galaxy.


  • AJ Mendo

Track and Room: Track 1 - N/A

Title: SQL Server Databaseology 201: A Study of Database Internals

Abstract: Did you take apart your Mom’s toaster or your Dad’s alarm clock just to see how it worked? Ever wonder how that database you built or support works behind the scenes at the record level? SQL Server Databaseology 201 is the science concerned with the study of SQL Server databases and their structures down to the very records themselves. This session will explore some of those deep inner workings of a SQL Server databases. The attendee will walk away with a better understanding of how SQL Server databases work which would allow them to build better and faster databases.


  • John Morehouse

Track and Room: Track 1 - N/A

Title: The Accidental Report Designer: Data Visualization Best Practices in SSRS

Abstract: Whether you are a DBA, a developer, or an analyst, there is a good chance that you will have to create reports for coworkers, company executives, or clients. As with any UI design, careful consideration should be given to your data visualization design to ensure you are effectively communicating the intended message and providing a good user experience. While the principles are applicable across reporting platforms and tools, this session will contain demos and examples implemented in Reporting Services using SQL Server Data Tools. Learn how to make information (not just data) the focus of your report and provide your audience with something better than just shiny!


  • Meagan Longoria

Track and Room: Track 3 - N/A

Title: Documentation – you know you love it

Abstract: We will discuss some of the most important things that you as a Data Professional can document to make your job much easier, ensure information consistency between groups, and better prepare your organizations for raising the bar on your day to day business. Think of this as a sort of Database Library that allows you to finally detail the processes you follow currently to perform repetitive tasks. This Library will also allow you to simply document your systems for your and others knowledge.


  • TJay Belt

Track and Room: Track 2 - N/A

Title: Master Data Services – 101

Abstract: Master Data Services (MDS) is a Master Data Management solution on the Microsoft Platform. This solution enables the management of non-transactional data (nouns) within the enterprise. Get a good business and technical understanding of how MDS can help your organization obtain better data governance. The demo will walk through the basics of getting started with Master Data Services 2012, including the Excel Add-in and some Integration Services packages.


  • Reeves Smith

Track and Room: Track 3 - N/A

Title: The Curious Case of Isolation Levels

Abstract: Have you ever seen or used “WITH (NOLOCK)” in T-SQL? Do you know what it does and its side effects? Is SQL Server optimistic or pessimistic when it comes to locking? Can it be both? In this session we will cover these questions and discuss how and why SQL Server takes locks and how that affects other users. We will go over alternatives for using NOLOCK and discuss when it is appropriate to use. In addition, we will discuss what are the ACID properties and how to monitor locks and blocks.


  • Keith Tate

Track and Room: Track 1 - N/A

Title: Managing SQL Server Performance with Extended Events

Abstract: One of a DBA’s primary responsibilities is managing the performance of a SQL Server environment. When performance problems arise, DBAs need to have the correct tools in place to be able to dig in and discover the issues that are occurring. Although it’s one of the newer tools in the DBA toolbox, Extended Events is one of the most powerful tools available. In this session, we will discuss performance management responsibilities for DBAs and provide a foundation, through Extended Events, to understand and resolve performance issues.


  • Jason Strate

Track and Room: Track 1 - N/A

Title: XPath - XQuery; I guess if I HAVE to

Abstract: I don’t know anyone who likes it. But the reality is sooner or later you’ll have to use XML in your database career. It appears in extended events, ring buffer queries, and more and more in stored procedures and columns. Attend this session to find out what you need to know to leverage xpath, xquery, and semi-structured data in administering databases.


  • Russ Thomas

Track and Room: Track 4 - N/A

Title: Advanced Spatial Analysis: Beyond Bubble Charts

Abstract: Are you finally ready to unlock the power in your spatial data? In this session, we will explore some advanced spatial analysis techniques, including clustering, binning, and the basic use of spatial statistics. We will then discuss several options for visualizing the results in SQL Server Reporting Services and PowerPivot. Get ready to go beyond bars and bubble charts!


  • Jason Horner

Track and Room: Track 3 - N/A

Title: Native File Streaming with SQL Server 2012

Abstract: In this dynamic session, Lenni will teach you the ins-and-outs of unstructured data storage and native file streaming with FILESTREAM (introduced in SQL Server 2008) and FileTable (new in SQL Server 2012). Learn how to program FILESTREAM using T-SQL and, for maximum performance, using the OpenSqlFileStream API in C#. We’ll also cover the hierarchyid data type, which casts a hierarchical structure over every FileTable, and wrap up with the full-text search improvements and new Statistical Semantic Search in SQL Server 2012 that you can leverage to get the most out of unstructured documents contained in your databases.


  • Leonard Lobel

Track and Room: Track 2 - 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.


  • Michael Sexton

Track and Room: Track 3 - N/A

Title: SQL Server Replication in Practice

Abstract: SQL Server Replication is an important tool that I’ve implemented many times for reliable data movement to support Business Intelligence architectures. This includes using replication to create databases that are used as sources for data warehouses, reporting systems, operational data stores, and historical audit trails. The key concepts to consider when setting up replication will be covered, including replication type, table selection, filters, indexing, and more. Live demonstrations will show how to implement transactional replication for high performance in a real-time environment.


  • Carlos Bossy

Track and Room: Track 1 - N/A

Title: The Encryption Primer

Abstract: Learn the options for encryption in SQL Server, covering hashing, symmetric keys, asymmetric keys, and encrypted communications.


  • Steve Jones

Track and Room: Track 2 - N/A


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

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

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.

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.

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.

John Morehouse

Twitter: - SQLrUs

LinkedIn: John Morehouse

Contact: http://www.sqlrus.com

John Morehouse is currently a Consultant with Denny Cherry Associates living in Louisville, Kentucky. With over 2 decades of technical experience in various industries, John now focuses on the Microsoft Data platform and specializes in Microsoft SQL Server. He is honored to be a Microsoft Data Platform MVP, VMWare vExpert, Friend of Red Gate, Sentry One PAC member Community Ambassador, and 2016 Idera Ace. John has a passion around speaking, teaching technical topics, and giving back to the technical community as much as possible. He is a user group leader, SQLSaturday organizer, and former PASS regional mentor. He is also a blogger, avid tweeter, and a frequent speaker at SQLSaturday’s as well as other conferences.

Leonard Lobel

Twitter: - @lennilobel

LinkedIn: Leonard Lobel

Contact: http://lennilobel.wordpress.com

Leonard Lobel (Microsoft MVP, Data Platform) is CTO and co-founder of Sleek Technologies, Inc., a New York-based development shop with an early adopter philosophy toward new technologies. He is also a principal consultant at Tallan, Inc., a Microsoft National Systems Integrator and Gold Competency Partner.

Programming since 1979, Lenni specializes in Microsoft-based solutions, with experience that spans a variety of business domains, including publishing, financial, wholesale/retail, health care, and e-commerce. Lenni has served as chief architect and lead developer for various organizations, ranging from small shops to high-profile clients. He is also a consultant, trainer, and frequent speaker at local usergroup meetings, VSLive, SQL PASS, and other industry conferences.

Lenni has also authored several MS Press books and Pluralsight courses on SQL Server programming.

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.

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.

Rick Lowe

Contact: http://www.lanl.gov

Rick is a MCM who has been working with SQL Server for almost 15 years, working with versions from 6.5 through 2012. He is a recovering developer who has transitioned from development towards administration over the course of his career. He is happiest when turning indexes and queries, but enjoys all things SQL.

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

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.

Brent Greenwood

Twitter: - @YoungMSQL

LinkedIn: Brent Greenwood

Contact: http://brentgreenwood.blogspot.com/

Brent Greenwood, MS, MCITP, CBIP, is a PowerPivot junkie and long-time Microsoft BI Pro with 13+ years of experience in the data analysis, data warehousing, and business intelligence crafts. He’s delivered solutions and worn lots of different hats in a variety of verticals, including Investment Management, Brokerage, Insurance Services, Healthcare, and Higher Education. Most importantly, Brent is a cycling enthusiast and loves riding and building prototypes with AdventureWorks cycling data.

Rob Mandeville

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

LinkedIn: Rob Mandeville

Rob Mandeville is a Senior DBA with over 20 years of broad experience in database technologies.
He’s served in many roles including production DBA, development DBA, and architect/data modeler on a variety of platforms.
Before coming to Solarwinds, Rob worked in the aerospace, global technology, and geospatial industries.
Rob also had the honor of teaching database related master level courses at Regis University.

TJay Belt

Twitter: - @tjaybelt

LinkedIn: TJay Belt

Contact: http://tjaybelt.blogspot.com

TJay Belt is an outdoorsman at heart who enjoys riding dirtbikes, waterskiing, boating, playing racquetball and spending time with his family. When he can’t be out playing, TJay loves to tinker with databases. TJay has been an IT professional for over a decade and a half. Currently serving as a Senior Database Administrator with Imagine Learning. TJay has progressed through several roles in his database career including developer, data guy, database developer, database analyst and DBA.

AJ Mendo

Twitter: - @SQLAJ

Contact: http://sqlaj.wordpress.com/

AJ has over 14 years of experience working with a variety of databases. He has worked for military, civilian, and federal government organizations supporting a wide variety of applications.

AJ is a frequent speaker at user groups, SQLSaturday#39;s, and PASS Virtual Chapters, and is a board member POSSE and CACTUSS. He is a PASS Programs Committee volunteer, and he loves being a part of the SQL Community.

Doug Lane

Contact: http://www.douglane.net

Doug Lane (MCITP, MCTS) is a consultant with Brent Ozar Unlimited and has over 14 years’ experience with SQL Server. He blogs about SQL Server with emphasis on Reporting Services and professional development.

Jason Strate

Twitter: - @stratesql

LinkedIn: Jason Strate

Contact: http://www.jasonstrate.com/

Jason Strate is a SQL Server Solutions Architect with Pragmatic Works. He is also a Microsoft SQL Server MVP and MCM. He has over 15 years of experience developing, architecting, and managing data platforms. Jason writes, blogs, and presents on SQL Server.

Kat Long

Twitter: - @KatSQL

LinkedIn: Kat Long

Contact: http://blogs.xtivia.com/

Kat has been working with SQL Server since 1998 starting with SQL Server 6.5 up to the latest and greatest. Over the years, Kat has worked in many different environments from manufacturing to dotcoms to military and government institutions, and is now back in the private sector. Currently, as a Senior DBA at Xtivia, she is focused on monitoring SQL Server installations and troubleshooting performance issues.

Rob Schafer

Contact: http://www.emc.com/services/emc-consulting.htm

Rob Schafer is a Senior Consultant for EMC focusing on the SQL Server Business Intelligence stack. For the past several years, Rob has been architecting, developing, and leading complex Business Intelligence projects spanning multiple industries that include: Financial, Insurance, Healthcare, Telecommunications, Aerospace and Defense, Legal, and Hospitality. He holds a Master’s degree from the University of Denver and also has his MCTS in Business Intelligence and Database Development.

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.

Ben Miller

Twitter: - DBAduck

LinkedIn: Ben Miller

Contact: https://dbaduck.com

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

Russ Thomas

Twitter: - @SQLJudo

LinkedIn: Russ Thomas

Contact: http://www.sqljudo.com

Prior to focusing full time on IT Management and Database Administration in the Denver Colorado financial sector, Russ spent several years in law enforcement including four as a training Sergeant and Washington CJTC Instructor specializing in Emergency Vehicle Driving at Portland Intl Raceway. An experienced public speaker and trainer, Russ also has two decades of hands on IT work and leadership experience. Russ is a SQL Server Data Platform MCSE and is active in the SQLSaturday community.

Bill Fellows

Twitter: - @billinkc

LinkedIn: Bill Fellows

Contact: http://blog.billfellows.net

Bill Fellows is a SQL Server MVP and has been a database developer for most of his career, with the past 15 years focused on ETL. He is the organizer of Kansas City’s eight SQLSaturdays and a speaker at many other SQLSaturdays, User Groups and the PASS Summit. Bill is the owner of Sterling Data Consulting where he gets to solve interesting data problems.

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

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.

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.

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.


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

Back to the SQLSaturday Event List

Back to the home page