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.



Date: Tuesday, May 21st.

Main Presentation:

Converting Unreliable Deployments Into Consistent Releases

Level 100/200

The deployment process is frustrating; an object is missing, an object is deployed in the wrong order or the incorrect version. Each database is made up of a lot of objects in different environments.  When you create an object like a table or stored procedure, you need to get this object deployed into each environment.  Together we will discover how to separate each object for proper order deployment while releasing only objects which have changed. Deployments can cause you trouble but we will provide a reliable deployment and version control process.



Presenter: Tom Norman, Database Architect / DBA, KPA.

In 1998, Tom changed his career focus to begin working with Sql Server. He has worked in all aspects of Sql Server including Administration, Database Development, BI and Reporting Services. He has worked in the Finance and Car Dealership industry.  His experience has included International deployments. Tom is the co-leader of the PASS Virtualization chapter and the past President of the Denver Sql Server User Group.


Tom Norman’s LinkedIn Profile


The Denver SQL Server User Group is organized to bring professionals of all career levels that work with Microsoft’s SQL Server, together to learn and network with others. There is no charge to attend, and you are encouraged to bring guests. Food and refreshments are provided by event sponsors.


Date: Tuesday, May 16th

Time: 5:30 – 8:30 pm

Main Presentation: Capture Change and Apply it With Change Data Capture & SSIS

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.



Presenter: Steve Wake, Sr. BI Consultant

Steve Wake is a Sr. BI Consultant at Pragmatic Works with more than 20 years of experience in various IT organizations. Steve has experience in Manufacturing, Retail, Charities, Telecommunications and Financial Services organizations & switched to Consulting to share/expand/teach on his experiences with Microsoft Business Intelligence. Steve is also very involved in the local community, speaking at events across the country and is currently President of the Denver SQL Server User Group.


Steve Wake’s LinkedIn Profile

Follow @SteveWake on Twitter



Start Date/Time: Thursday, May 16, 2013 5:30 PM
End Date/Time: Thursday, May 16, 2013 8:00 PM
Location: 7595 Technology Way, Suite 400
Denver, CO 80237
Description: 5:30 – 6:00 – Food / Socializing

6:00 – 6:10 – User Group Business

6:10 – 6:30 – Open Panel/Q & A

——————6:30 – 7:30 – Main Presentation

6:30 – 7:00 – Warm-up Presentation
7:00 – 8:00 – Main Presentation

Give Away / Wrap-Up to follow presentations