SQL Saturday #190 Denver


Welcome to SQL Saturday Denver #190

SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held 9/28/2013 at

Cherry Creek Presbyterian Church - Community Life Center,

10150 E. Belleview Avenue,

Englewood, CO 80111

SQL Saturday training is free on the day, with a lunch fee of $10.00. This year, SQL Saturday Denver has a number of Pre-Conference sessions available to choose from. There is one free SQL in the City session running from 12:30 - 5:00pm, with training provided by Steve Jones.

Pre Conference Sessions

SQL in the City Session Agenda

Venue: Denver Marriott Tech Center

4900 S. Syracuse Street

Denver, Colorado 80237

12:30PM – 12:45PM ~ Attendee registration & networking~

12:45PM - Welcome & Seminar introduction

Team-based Database Development with Version Control, Steve Jones

An efficient development process requires that all of your team members coordinate their efforts. This session shows how a version control system and standard development practices help improve the speed and quality of your development process.

Break 1 ~ Demo with refreshments ~

Automated Build and Test, Steve Jones

Automated build and test processes such as continuous integration are essential to achieve the short feedback cycles that an agile development lifecycle requires. This session will demonstrate how checking in a database change with SQL Source Control can tell you whether your database business logic will remain functional and whether the upgrade process will succeed. You'll also see how a successful build will leave you with a database package that can be used in your deployment process. 

Break 2 ~ Discussions and demos with refreshments ~

Session 3 – Best Practices for Database Deployment, Steve Jones

The easiest part of any deployment is running the deployment script on production. But what have you done to prepare that script for production? Was the script tested? Is the script tightly coupled with the application code? The difference between a successful deployment and a failed or problematic deployment is all the preparation work you've done to ensure that you're deploying the right script, the right way to your production environment. This session will explore best practices that you can implement to ensure that your deployments are as successful as they can be. 

4.30PM – 5.30PM ~ Q & A, Happy hour & continued chat with Steve Jones and the Red Gaters (Drinks on Red Gate) ~

Register now to confirm your place at this exclusive event, where space is limited.

Real World SSIS: A Survival Guide

This session presented by Tim Mitchell will take place in the same venue as SQL Saturday Denver.

Moving and transforming data can be a difficult job. Connecting to various endpoints, applying complex transformations, performing validation checks, creating an appropriate audit trail, and other tasks can make the ETL developer feel like he/she is spinning plates. Even with powerful tools such SQL Server Integration Services, designing and maintaining a proper and well-performing extraction/transformation/loading (ETL) infrastructure is a significant undertaking.

In this full-day seminar, we'll explore some common (and a few uncommon) challenges facing ETL developers, followed by practical solutions and recommended practices from the field using SQL Server Integration Services. Presented by business intelligence consultant and SQL Server MVP Tim Mitchell, this seminar brings together his 9 years of professional data management experience into 7+ hours of condensed real-world approaches to ETL challenges. Though we'll spend some time covering the academic portion of the concepts presented, most of our time will be spent in demos to give you more than just a theoretical exploration of these methods.

Session Fee: $125.00.

Register here for Tim Mitchell's session.

SQL Server Internals from the Practical Angle

This session presented by Dmitri Korotkevitch will take place in the same venue as SQL Saturday Denver.

There are plenty of the books and resources about SQL Server internals. While they provide the great overview of how product works, they often lack the practical angle and don’t explain how to apply that knowledge to real-life scenarios. That pre-con helps to close that gap. It shows how various aspects of SQL Server Internals affect the systems and what needs to be taken into consideration during design and implementation stages.

The pre-con covers how SQL Server stores the data and works with indexes; how to design efficient indexing strategies; how different database objects types implemented internally and what are pros and cons of them; explains why do we have locking and blocking in the system and how to deal with concurrency issues and, finally, shows a few methods that can help with performance troubleshooting of the system.

Session Fee: $125.00.

Register here for Dmitri Korotkevitch's session.

Predictive Analytics in the Enterprise

This session presented by Carlos Bossy will take place in the same venue as SQL Saturday Denver.

Data Science is a red-hot subject, but what does that mean for SQL Server DBAs and developers? The Data Mining algorithms in Analysis Services provide capabilities to achieve predictive analytics and modeling with your SQL Server data and any other data you have access to. In this session you’ll get the chance to cover the data mining process from start to end. By the end of the day, you’ll have a practical understanding of how to develop predictive models for your data. The session includes a brief overview of data mining followed by an opportunity to complete actual predictive modeling exercises. You’ll see how to fine-tune and compare the results using various algorithms, and how to make the best use of the models in your enterprise. With Predictive Analytics having achieved the Plateau of Productivity in Gartner’s Hype Cycle for Emerging Technologies, now is a good time to learn what these powerful tools can do for you.

Session Fee: $125.00.

Register here for Carlos Bossy's session.