Colorado SQL Events for May 2014 – DawaBI

Colorado SQL Events for June 2014

All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend so bring a co-worker¦or two. These events provide for great learning opportunities as well as networking with other local SQL Server professionals.


June 18th

Confio Software in Boulder
4772 Walnut Street, Suite 100
Boulder, CO 80301


The Life Cycle of a Query

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 Development Kit) and will dramatically show The Life Cycle of a Query in 3D. We will follow a query from beginning to end and “run through” 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.


Todd Kleinhans  has been working with SQL Server since 1999. He has worked as a dba, developer, data architect, manager, and consultant. Todd has served in the past on the board of the Denver SQL Server User Group and is the current VP of Marketing. He enjoys presenting at user groups, virtual groups, and SQL Saturday events


Third Wednesday

Hyatt Place Garden of the Gods
503 West Garden of the Gods Road
Colorado Springs, CO 80919



Third Thursday

Microsoft DTC Office
7579 Technology Way, Suite 400
Denver, CO 80237


SQL 2014 In-Memory OLTP What, Why, and How

In-Memory OLTP is one of the most significant new features in the SQL Server 2014 release. In this session we will learn about the benefits of this new feature and how it works inside the SQL engine. We will touch on when it makes sense to use it, and most importantly learn how you can implement this new feature should you see the need in your environment.

Presenter: Andy Vold, Architect RevGen Partners

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.

Northern Colorado

UNC Loveland Center at Centerra
2915 Rocky Mountain Ave.
Loveland, CO. 80538
Breckenridge Conference Room 2nd floor

Colorado SQL Events for May 2014

SQL Meetings are training events for SQL Server professionals and those wanting to learn about SQL Server.

Date Group Info
Tuesday, May 6, 2014 Denver SQL Lunch
Wednesday, May 21, 2014 Boulder Policy-Based Management by Tom Norman
Tuesday, May 20, 2014 Northern Colorado Evening Meeting
Wednesday, May 21, 2014 Colorado Springs Evening Meeting