Denver SQLSaturday
Saturday, September 20th at University of Denver campus! Details/Register at
3 Pre-cons on Friday, 9/19 see site for details!

PASS Summit 2014
November 4 - 7 in Seattle, Washington! Details/Register at
Use discount code UNSUMF59 for $150 off!

Next Meeting




Denver SQL Server User Group - August Meeting

  • In-Person @ 10150 E. Belleview Avenue, Englewood, Colorado, United States (map)
  • 17:30 - 20:00 Mountain Daylight Time
  • Language: English

Note location change for August meeting below!

As usual, we will make time for question and answer sessions, networking, and eating. Prizes will be awarded at the conclusion of the meeting.

Cherry Creek Presbyterian
10150 E. Belleview Ave. 
Englewood, CO 80111 

Meeting Agenda:
17:30 - 18:00 - Food / Socializing
18:00 - 18:15 - User Group Business
18:15 - 18:30 - Open Panel/Questions & Answers
18:30 - 19:00 - Warmup presentation
19:00 - 20:00 - Main presentation
Give Away / Wrap-Up to follow

Pass it on:
If you feel that a friend or colleague would benefit from our user group, please feel free to forward on this notice. If you received this notice from a friend or colleague, please consider becoming a member of our user group. There are no dues to membership but you will have the added benefits of receiving event reminders and attendance to members only meetings. Becoming a member is quick and painless, simply go to the user group web site and register. That's it!

Featured Presentation:

Date Dimension in 30 Minutes or Less

Steven Wake, Consultant RevGen Partners

All data warehouses need a date dimension to enable proper analysis across dates. Most Data Warehouse designers will just use one provided by tools or whip it up in Excel, but what if you need to set up custom holidays or want different calendars, such as Fiscal or Julian? You can have any date dimension you need by using a single SQL script that can be modified and rerun as necessary. Learn what it takes to design a date dimension that does all of the calculations and formatting up-front so the reports can be easier to create. Sample script will be provided that creates the date dimension and can be reused as often as necessary without breaking your data warehouse and it only takes seconds to run!

About Steven:
Steve Wake is a Consultant at RevGen Partners with more than 20 years of experience in various IT organizations. Steve has experience in manufacturing, retail, charities, telecommunications and financial services organizations and switched to consulting to share/expand/teach on his experiences with Microsoft Business Intelligence. Steve is also very involved in the SQL community, speaking at events across the country, blogging at, and is currently President of the Denver SQL Server UG

Get testing with tSQLt - practical examples and automation

Steve Jones, Editor

tSQLt is a testing framework that is designed to help you write repeatable, isolated tests against your database code. In this session we will briefly examine the goals of testing, where it can be used in an automated deployment pipeline, and introduce you to the tSQLt framework. We'll show you how to design and write tests to enforce standards, check calculations and other DML operations as well as check exception handling. You will see how a real world refactoring task can be tested in a repeatable manner. Learn how you can incrementally write tests that help you build higher quality code and minimize the introduction of errors against your existing objects.

About Steve:
Steve Jones has been working with SQL Server since 1991 and has been a DBA in a variety of large and small companies and industries. In 2001, Steve founded 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.



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 your co-workers.  Through our sponsors, we provide food and refreshments.

We meet the third Thursday of each Month at Microsoft.

The address is:

7595 Technology Way, Suite 400
Denver, CO 80237

A typical meeting agenda is as follows:

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 - Warmup Presentation
7:00 - 8:00 - Main Presentation

Give Away / Wrap-Up to follow presentations

Our meeting location

  7595 Technology Way, Suite 400
Denver, CO 80237
(720) 528-1700

View Larger Map

Follow us on the various social media sites:

LinkedIn     Twitter     Facebook     Google+