San Francisco, California
London, United Kingdom
Note location change for August meeting below!
Date Dimension in 30 Minutes or Less
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!
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 & 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 wakebi.com, and is currently President of the Denver SQL Server UG.
Get testing with tSQLt - practical examples and automation
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.
Steve Jones 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.
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
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. http://denversql.org/ That's it!
When & Where
Denver SQL Server User Group
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 every third Thursday of each Month at Microsoft DTC (7595 Technology Way, Suite 400, Denver, CO 80237).
Visit http://denversql.org for more information and to create a free account.