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.

BoulderSQL

Third Tuesday

Market Force

248 Centennial Parkway
Louisville, CO 80027

Presentation 1:

Title: The SQL Family Connection 

Using social media to get technical support, and also to promote your career.

Presenter: Mike Fal ( blog )

Mike Fal is a musician turned SQL Server DBA, with 10+ years of experience as a database administrator. He has worked for several different industries, including healthcare, software development, marketing, and manufacturing and has experience supporting databases from 1 GB to 4 TB in size. Mike received his a Bachelor's Degree from the University of Colorado at Boulder in 1996 and has been caught playing trombone in public on more than one occasion.

Presentation 2:

Title: Introduction to Data Warehousing

Just starting or thinking of starting a data warehousing project but not sure where to begin. Or still not sure if your organization needs a data warehouse. This discussion is geared towards answering the what and why (or why not) of data warehousing.

Presenter: Marc Beacom ( blog | twitter )  & Jeff Renz ( twitter )

Marc Beacom, MCTS - SQL Server 2008 BI and Development, has over 15 years of technical and business experience. He is currently Principal Architect and Owner of DawaBI focusing on Making Data-Driven Decisions Possible by delivering user friendly and scalable data warehouse and business intelligence solutions. Marc is an active volunteer within the community and currently co-organizer of the Colorado GiveCamp and Advisory Board Member for Camp To Belong Colorado.  Marc has also volunteered for other organizations such as the Denver SQL Server UG, Colorado Springs SQL Server UG and spent a year as a regional mentor for PASS.

Jeff Renz: Currently working for Abound Solar as the lead architect implementing a solar panel field performance data warehouse.
Developed global manufacturing and supply chain data collection and reporting solutions since 1999.  Bachelors degree in computer science and a masters degree in operations research from the Colorado School of Mines.  Certified by the Genesee Academy as a Certified Data Vault Data Modeler.

SpringsSQL

Third Wednesday

Hyatt Place – Garden of the Gods

503 West Garden of the Gods Road
Colorado Springs, CO 80919

Presentation 1:

Title:

What’s new in T-SQL for SQL Server 2012 – Part 1

SQL Server 2012 has many new T-SQL enhancements that will simplify your code…and life.  We’ll roll up our sleeves and dive in.

Presenter: Marc Beacom ( blog | twitter )

Marc Beacom, MCTS - SQL Server 2008 BI and Development, has over 15 years of technical and business experience. He is currently Principal Architect and Owner of DawaBI focusing on Making Data-Driven Decisions Possible by delivering user friendly and scalable data warehouse and business intelligence solutions. Marc is an active volunteer within the community and currently co-organizer of the Colorado GiveCamp and Advisory Board Member for Camp To Belong Colorado.  Marc has also volunteered for other organizations such as the Denver SQL Server UG, Colorado Springs SQL Server UG and spent a year as a regional mentor for PASS.

Presentation 2:

Title: Develop a Quick and Dirty Web Interface to your Database: for the DBA and other non-developers

So you want to develop to your database? Do you have your own tools to check performance? Does Chris Shaw's Utility Database sound like a tool you have and want a web interface, but don’t want to write a lot of code? I will demonstrate how a simple ASP.Net MVC site can be developed and deployed against your database. See firsthand how easy we can use Shaw's utility database and access across the web over a mobile device so you may manage performance online whilst zipping your drink of choice.

Presenter: Gabe Villa ( blog | twitter )

Bio: Originally from El Paso, Texas, Gabriel has over 10 years’ professional developer experience using Microsoft technologies. Gabriel is an MCPD, ASP.NET Developer and an MCTS in SQL Server 2008 Database Development. He has developed desktop, web and database systems for the medical, retail, imports distributors, and automotive industries. Gabriel recently moved with his wife and three kids to Colorado Springs, where he works for a small ISV developing software for the big-ticket retail industry.

DenverSQL

Third Thursday

Microsoft DTC Office

7579 Technology Way, Suite 400
Denver, CO 80237

Presentation 1:

Title: Exposing the Core: Intro to SQL Server 2012 on Server Core

Everything that's old is new again. With SQL 2012, we can now run our SQL Servers on Server Core, a version of the Windows OS that is smaller and more secure. This presentation will introduce you to Server Core, how to prepare it for a SQL installation, and how to actually install SQL 2012 on to it.

Presenter: Mike Fal ( blog )

Mike Fal is a musician turned SQL Server DBA, with 10+ years of experience as a database administrator. He has worked for several different industries, including healthcare, software development, marketing, and manufacturing and has experience supporting databases from 1 GB to 4 TB in size. Mike received his a Bachelor's Degree from the University of Colorado at Boulder in 1996 and has been caught playing trombone in public on more than one occasion.

Presentation 2:

Title: ETL as Master Data Management

The worst customer service I have ever personally experienced was directly tied to a company’s failure to have an effective Master Data Management (MDM) system.
Most companies have multiple data sources that track the exact same data. Retail operations have multiple point of sale systems (internet, phone, bricks and mortar); health care providers have multiple applications for specialties (Radiology, oncology, etc.); finance companies have multiple systems based on products (mortgages, other loans, checking and savings accounts). These systems track the same or similar data (e.g. all systems track customers) and can maintain completely different information about the same thing. This arises from human data entries and failure to manage the critical nouns for the company and a lack of effective MDM solutions in the market.
ETL solutions in the BI stack are perfectly positioned to manage this data, reconcile the differences and maintain consistency across an enterprise. I will speak about what I consider to be the four main jobs of any MDM system and how to incorporate these into an ETL system:

• Identify data inconsistencies
• Reconcile those differences (programmatically if possible)
• Synchronize reconciled data with source systems
• Send any un-reconciled data to humans for resolution

Presenter: Mike Sexton ( blog | twitter )

Stunningly handsome yet surprisingly humble, Mike Sexton spent the first ten years of his career as a public defender in New York. Realizing he could make far more money as a junior programmer than as a lawyer with 10 years’ experience, he had a revelation, the words of which that are not appropriate for a family publication. Since then Mike has traveled the lands taming errant database applications, publishing and blogging at www.sqlmountain.com. He recently published Applied Architecture Patterns on the Microsoft Platform, which may be found at finer bookstores. Mike can be found living the high life in Colorado with a hot blonde on his arm.
Marc Beacom  ...