We hold meetings on the 3rd Wednesday of every month at the Hyatt Place Garden of the Gods in Colorado Springs.

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

In an ongoing attempt to make the content presented useful to our members we start each meeting with a short Q&A session.

5:30 - 6:00 - Networking, Food
6:00 - 6:15 - Introductions, General Q&A session & Announcements
6:15 - 6:30 - 101 Session
6:45 - 7:45 - Presentation(s)
7:45 - ?? - Door prizes and Question & Answer session

If you cannot find us, please call Bill Hoenig @ 719-648-0556

Colorado Springs SQL Server User Group

Meeting Announcements

November 19th, 2014 Meeting

Agenda: (Add this meeting to your calendar)
5:30 - Food and Networking
6:00 - Announcements & 2015 Officer Election
6:15 - General Q & A
6:30 - Main Presentations
7:30 - Q & A on Presentation

Speaker: Steve Jones

Topic: The Encryption Primer

Description: SQL Server has a number of encryption features that allow you to better secure your data. This session will examine the basics of encryption and cover the various ways in which you can encode and decode your data to protect it from unauthorized access. Cell level encryption, Transparent Data Encryption, and backup encryption will all be discussed. This session is designed for those who want to learn the basics of how to protect their data.

Bio: Steve has been working with SQL Server since 1991 and been a DBA in a variety of large and small companies and industries. In 2001 Steve founded SQLServerCentral with two partners and has been publishing technical articles and facilitating discussions among SQL Server professionals ever since. He currently is the full time editor of SQLServerCentral, owned by Red Gate Software. Steve is a Microsoft SQL Server MVP and a D&B MVP.


October 15th, 2014 Meeting

101 Session

What Social Media Means To The SQL Server Professional
Twitter, Facebook, LinkedIn, Google+….In today’s frenzy of “Social Everything” it’s hard to determine what Social Media channels we should use and how to engage with the larger community. As a SQL Server professional there are many resources within the Social Media spectrum that can help us develop key relationships and harvest important information. During this talk we will discuss a few of the key Social Media channels, how they function and how we can place ourselves in the center of the SQL Community.

Session Level: Beginner

Speaker: Shane Williams  

Biography: Shane Williams started his career supporting biometric hardware and software systems that ran on the UNIX operating system. It was during his tenure at this position that he began working with shell programming which quickly became his primary interest. From there he began constructing websites in Classic ASP, then migrated to the ASP.NET[ASP.NET] primarily using C#. During one of his web projects he migrated data from one system to another and was introduced to Microsoft’s DTS tools under the SQL 8.0 platform. Since that time he has served in the roles of ETL/SSIS Developer, Team Lead, and Manager of Data Warehouse Development.


Main Presentation

Life Cycle of a Query in 3D
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.

Session Level: Beginner

Speaker: Todd Kleinhans  

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


Springs SQL Events