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.
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
Hyatt Place Garden of the Gods
503 West Garden of the Gods Road
Colorado Springs, CO 80919
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.