DenverSQL Archives - DawaBI

DenverSQL

February – Colorado SQL Events

Please register soon as seating is limited, and let friends and colleagues know about the event. Most events are free, however a nominal fee may be charged so that lunch may be provided (not pizza).

Date Group Info
Tuesday, February 4, 2014 Denver SQL Lunch
Tuesday, February 18, 2014 Boulder SQL Server Performance
Monday, February 17, 2014 Northern Colorado Performance Tuning

Colorado SQL Events : December 2013

Colorado Springs SQL

Date: Wednesday, December 18th

Time: 5:30 – ?

Main Presentation: Holiday Party – Family Welcome!

Meeting Location
Old Chicago (Austin Bluffs and Academy)
4110 North Academy Boulevard
Colorado Springs, CO

View Larger Map

BoulderSQL

Date: Tuesday, December 10th

Main Presentation: Holiday Networking & Social

Time: 5:30 pm – 8:00 pm

Appetizers and the first round of drinks will be provided! This will be a great opportunity to hob nob with other SQL savvy professionals from the area. Hope you can make it!

Meeting Location
Dave & Buster’s
10667 Westminster Blvd
Westminster, CO 80020
http://www.daveandbusters.com
phone: 303-438-1500

View Larger Map

By |December 4th, 2013|Uncategorized|

Colorado SQL Events : November 2013

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.

Northern Colorado SQL Server User Group Meeting

Date: Monday, November 18th

Time: 5:30 – 8:30 pm

Main Presentation: TBA

Presenter: TBA

Meeting Location
UNC Loveland Center at Centerra
2915 Rocky Mountain Ave.
Loveland, CO 80538
Breckenridge Conference Room 2nd Floor

View Larger Map

Colorado Springs SQL

Date: Wednesday, November 20th

Time: 5:30 – 8:00 pm

Main Presentation: TBA

Presenter: TBA

Meeting Location
Hyatt Place – Colorado Springs
503 Garden of the Gods Rd W,
Colorado Springs, CO

View Larger Map

BoulderSQL

Date: Tuesday, November 19th

Main Presentation: Ready, Set, Build a Cube:

Are you ready to do something different? Are you stuck in a rut? Let’s get out of that rut and find out what else we can do with the data we have in from of us. Let’s take the data and help others make better decisions. We have all had to learn something new. Let see what it takes to get data from an OLTP database to a cube..

Presenter: Tom Norman

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.

Meeting Agenda
5:30 6:00 Food / Socializing
6:00 6:15 User Group Business
6:15 6:45 First Presentation
6:45 8:00 Main presentation
8:00 8:30 Questions/Answers, general SQL discussions

Meeting Location
Confio Software in Boulder
4772 Walnut Street
Suite 100
Boulder, CO 80301

View Larger Map

DenverSQL
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: Thursday, November 21st

Time: 5:30 – 8:00 pm

Main Presentation: Write Once, Build Many – Metadata Driven SSIS with Biml

Biml is gaining traction as a viable method for programming SSIS. In this demo rich presentation you will be introduced to Biml and see the basics of using Biml to develop SSIS packages. We will also dive into examples of how you can leverage the power of Biml to create many packages from a single Biml script using a Metadata approach to your development.
Presenter: Write Once, Build Many – Metadata Driven SSIS with Biml

Andy Vold, a SQL Server MCTS and MCITP, is an Architect with RevGen Partners working primarily in business intelligence, SSIS/ETL, and database development. He enjoys helping clients by building database and business intelligence solutions to solve their complex business needs. Andy is a past board member of the Denver SQL Server Users Group.

Meeting Location
Microsoft
7595 Technology Way, Suite 400
Denver, CO 80237

View Larger Map

By |November 18th, 2013|Uncategorized|

Colorado SQL Events : October 2013

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.


Northern Colorado SQL Server User Group Meeting

Date: Monday, October 21st

Time: 5:30 – 8:30 pm

Main Presentation: “Introduction to Graph Databases”

 

Presenter: Dave Loftis

 

Meeting Location

UNC Loveland Center at Centerra

2915 Rocky Mountain Ave.

Loveland, CO 80538

Breckenridge Conference Room 2nd Floor

 

 


View Larger Map


Colorado Springs SQL

 

Date: Wednesday, October 23rd

Time: 5:30 – 8:00 pm

Main Presentation: TBA

 

Presenter: TBA

 

Meeting Location

Hyatt Place – Colorado Springs

503 Garden of the Gods Rd W,

Colorado Springs, CO

 

 


View Larger Map


BoulderSQL

 

Date: Tuesday, October 15th

Main Presentation: OLAP in Your Organization:

Explore how OLAP can fit into your overall information delivery architecture. As business has seen repeated successes in data-based decision making and Big Data is all the buzz, there is momentum behind exposing data to the business in more inventive ways. We’ll discuss strategies for exposing information to internal clients and how BI tools have decreased the one-off report workload for Mike’s team. Then we’ll build a cube from scratch and talk about what you need to learn to make these tools work for you.

 

 

Presenter: Mike White

Mike White has been focused on database development and administration since 1992 and is a co-author of the SQL Server 2008 Bible and the SQL Server 2005 Bible. He has concentrated on Microsoft’s Business Intelligence (BI) tools and applications since 2000, and has architected and implemented several warehousing and Analysis Services applications, as well as non-traditional applications of BI tools. After many years in corporate IT and consulting, Mike currently works as a data architect for AmerisourceBergen Specialty Group. He is a strong advocate for the underused BI toolset and Microsoft SQL Server in general.

 

Meeting Agenda

5:30 6:00 Food / Socializing
6:00 6:15 User Group Business
6:15 6:45 First Presentation
6:45 8:00 Main presentation
8:00 8:30 Questions/Answers, general SQL discussions

 

Meeting Location

Confio Software in Boulder

4772 Walnut Street

Suite 100

Boulder, CO 80301

 

 


View Larger Map


DenverSQL

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: Thursday, October 24th

Time: 5:30 – 8:00 pm

Main Presentation: TBA

Presenter: Steve Jones

 

Meeting Location

Microsoft
7595 Technology Way, Suite 400
Denver, CO 80237

 

 


View Larger Map

By |October 13th, 2013|Uncategorized|

Colorado SQL Events : September 2013

 

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.


Northern Colorado SQL Server User Group Meeting

Date: Monday, September 16th

Time: 5:30 – 8:30 pm

Main Presentation: TBA

 

Presenter: TBA

 

Meeting Location

UNC Loveland Center at Centerra

2915 Rocky Mountain Ave.

Loveland, CO 80538

Breckenridge Conference Room 2nd Floor

 

 


View Larger Map


Colorado Springs SQL

 

Date: Wednesday, September 18th

Time: 5:30 – 8:00 pm

Main Presentation: TBA

 

Presenter: TBA

 

Meeting Location

Hyatt Place – Colorado Springs

503 Garden of the Gods Rd W,

Colorado Springs, CO

 

 


View Larger Map


BoulderSQL

 

Date: Tuesday, September 24th (4th Tuesday)

Main Presentation: Introduction to Extended Events

 

Come find out about extended events, the future successor to Profiler. We’ll dig into what extended events are and how to use them in real-world scenarios to see what’s going on inside of SQL Server. We’ll compare and contrast extended events with Profiler and see why you will want to add them to your collection of SQL tools.

 

Presenter: Eric Peterson

Eric Peterson has been designing databases, architecting solutions and generally involved with SQL Server since its release. He works as a consultant, focusing on SQL Server and also teaches SQL classes for a major tech education company.

 

Meeting Agenda

5:30 6:00 Food / Socializing
6:00 6:15 User Group Business
6:15 6:45 First Presentation
6:45 8:00 Main presentation
8:00 8:30 Questions/Answers, general SQL discussions

 

Meeting Location

Confio Software in Boulder

4772 Walnut Street

Suite 100

Boulder, CO 80301

 

 


View Larger Map


DenverSQL

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: Thursday, September 19th

Time: 5:30 – 8:00 pm

Main Presentation: What Are We Waiting For?

Presenter: Kimberly Hathaway

 

Meeting Location

Microsoft
7595 Technology Way, Suite 400
Denver, CO 80237

 

 


View Larger Map

By |September 12th, 2013|Uncategorized|

Colorado SQL Events : August 2013

 

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.


Northern Colorado SQL Server User Group Meeting

Date: Wednesday, August 19th

Time: 5:30 – 8:30 pm

Main Presentation: What Every DBA Should Know About NoSQL

 

NoSQL is one of the buzzwords you hear going around in the developer world lately. As Database Professionals inevitably someone will come to us for help, advice, or possibly choosing a NoSQL solution. This session aims to give you a basic understanding in order to best answer those questions for your organization.

 

Presenter: Kelly Martinez

Kelly is a Application Developer and Database Administrator currently working in municipal government. With over 15 years of I.T. experience he has previously worked as a Web Developer in the Open Source space and as a System Administrator on both *nix and Windows. He holds a bachelors in Interactive Multimedia & Programming from Columbia College in Chicago. Additionally he is a certified Unix System Administrator, MCDBA/MCITP in SQL Server, and Xamarin Mobile Developer. When not thinking about databases and code he enjoys spending time with his family, traveling, working on the board of the Colorado chapter of GiveCamp (coding for charity), and reading a good fantasy novel.

 

Meeting Location

UNC Loveland Center at Centerra

2915 Rocky Mountain Ave.

Loveland, CO 80538

Breckenridge Conference Room 2nd Floor

 

 


View Larger Map


Colorado Springs SQL

 

Date: Wednesday, August 21st

Time: 5:30 – 8:00 pm

Main Presentation: Policy Based Management

 

Policy Based Management, what is this? What can it do for me? Do I really need it? How do I install and configure it? How can it help me to pass audits? You mean each server can really be configured the same. Let’s explore Policy Based Management and what it has to offer us in better management of our Sql Servers.

 

Presenter: Tom Norman

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.

 

Meeting Location

Hyatt Place – Colorado Springs

503 Garden of the Gods Rd W,

Colorado Springs, CO

 

 


View Larger Map


BoulderSQL

 

Date: Tuesday, August 20th

Main Presentation: Data Vault

 

Data vault is a compelling architecture for an enterprise data warehouse using SQL Server 2012. A well designed data vault data warehouse facilitates fast, efficient and maintainable data integration across business systems. In this session Jeff will review the basics about enterprise data warehouse design, introduce you to the data vault architecture and discuss how you can leverage new features of SQL Server 2012 to help make your data warehouse solution provide maximum value to your users.

 

Presenter: Jeff Renz

Jeff Renz has been working in the IT industry for 14 years, the last 10 of which has been focused on designing and implementing data collection and reporting solutions.  Jeff is certified by the Genesee Academy as a Certified Data Vault Data Modeler.  He is currently working as a consultant for Revgen Partners in the Business Intelligence Solutions team.

 

Meeting Agenda

5:30 6:00 Food / Socializing
6:00 6:15 User Group Business
6:15 6:45 First Presentation
6:45 8:00 Main presentation
8:00 8:30 Questions/Answers, general SQL discussions

 

Meeting Location

Confio Software in Boulder

4772 Walnut Street

Suite 100

Boulder, CO 80301

 

 


View Larger Map


DenverSQL

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: Thursday, August 15th

Time: 5:30 – 8:00 pm

Main Presentation: How Flash Storage Modernizes Databases

Presenter: Matt Henderson

Highly accomplished business intelligence (BI) professional with practical experience in both development and management roles. Skilled in performing technical BI design and development activities including the implementation of database solutions, extraction transformation load (ETL) systems, reporting systems and data collection interfaces. Leadership experience in managing both technical projects and programs. Knowledge in establishing organizational structure, standards and best practices across reporting organizations.

 

Meeting Location

Microsoft
7595 Technology Way, Suite 400
Denver, CO 80237

 

 


View Larger Map

 

By |August 10th, 2013|Uncategorized|

Colorado SQL Events : July 2013

 

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.


Northern Colorado SQL Server User Group Meeting

No meeting for July


Colorado Springs SQL

 

Date: Wednesday, July 17th

Time: 5:30 – 8:00 pm

Main Presentation: Data Vault Data Warehouse Architecture

 

Data vault is a compelling architecture for an enterprise data warehouse using SQL Server 2012. A well designed data vault data warehouse facilitates fast, efficient and maintainable data integration across business systems. In this session I will review the basics about enterprise data warehouse design, introduce you to the data vault architecture and discuss how you can leverage new features of SQL Server 2012 help make your data warehouse solution provide maximum value to your users.

 

Presenter: Jeff Renz and Leslie Weed

Jeff Renz has been working in the IT industry for 14 years, the last 10 of which has been focused on designing and implementing data collection and reporting solutions.  Jeff is certified by the Genesee Academy as a Certified Data Vault Data Modeler.  He is currently working as a consultant for Revgen Partners in the Business Intelligence Solutions team.

 

Leslie Weed is currently a Consultant with RevGen Partners in Denver, CO. She has been working with SQL Server for over 13 years in various industries including manufacturing, finance and retail. Leslie strongly believes the best SQL goes hand in hand with a good cup o’ joe.

 

Meeting Location

Hyatt Place – Colorado Springs

503 Garden of the Gods Rd W,

Colorado Springs, CO


View Larger Map


BoulderSQL

 

Date: Tuesday, July 16th

Main Presentation:

Understanding SQL Server In-memory technologies in SQL Server 14 (Hekaton)

Microsoft’s SQL Server 14 will include a new memory optimization feature code-named Hekaton, with the potential for huge performance gains provided your data fits in RAM.

 

Presenter: Mike Wilmot, Microsoft

is a SQL Server MVP, and he has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS, which proves that he likes to take tests. His expertise includes DMVs, high availability, hardware selection, full text search, and SQL Azure.  He is also an Adjunct Faculty member at University College – University of Denver, where has been teaching since 2000. He recently completed the Master Teacher Program at Denver University – University College. He is the author of two chapters in the book SQL Server MVP Deep Dives, and blogs regularly at http://sqlserverperformance.wordpress.com.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.

 

Meeting Agenda

5:30 6:00 Food / Socializing
6:00 6:15 User Group Business
6:15 6:45 First Presentation
6:45 8:00 Main presentation
8:00 8:30 Questions/Answers, general SQL discussions

 

Meeting Location

Confio Software in Boulder

4772 Walnut Street

Suite 100

Boulder, CO 80301

 


View Larger Map


DenverSQL

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: Thursday, July 18th

Time: 5:30 – 8:00 pm

Main Presentation: Real-Time Data Warehouse and Reporting Solutions

Presenter: Carlos Bossy, MCTS SQL Server

Carlos Bossy is a MCTS SQL Server 2008 BI Consultant and Certified Business Intelligence Professional (CBIP) with 25 years of experience in software and database development. Carlos is an independent consultant and focuses on developing Business Intelligence solutions including data warehouses, predictive analytics, data integration and reporting. He has been working with SQL Server for 10 years and is very enthusiastic about its powerful features. Carlos has developed warehouses and BI solutions for a variety of industries and state agencies.

 

Meeting Location

Microsoft
7595 Technology Way, Suite 400
Denver, CO 80237


View Larger Map

 

By |July 14th, 2013|Uncategorized|

Colorado SQL Events : June 2013

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.


Northern Colorado SQL Server User Group Meeting

Date: Monday, June 17th

Main Presentation:

How NOT to Migrate to SQL Server 2012

Do you want to avoid a potential train wreck when migrating to SQL Server 2012? Todd has just finished up a successful side-by-side migration going from SQL2005 to SQL2012. The project began last summer and launched on 6/8/2013. The system in question is a mission-critical OLTP hosting multi-terabyte databases and is used by the company’s website and many internal applications. The system is a FCI+AG running on three cluster nodes, each 384GB, 2P8C. We will look at several challenges to the project and how they could have been better managed or avoided. Shortcomings to discuss (lack of): data leadership, communication, budget, physical servers, virtual machines, disk space, technical expertise, application testing, and disaster recovery. Why you don’t upgrade other database systems on the same day that have dual-dependencies. We will also look at tools and documentation which assisted in the migration.

 

Presenter: Todd Kleinhans, Senior SQL Server DBA

Todd Kleinhans has been working with SQL Server since 1999. He has worked as a dba, developer, data architect, manager, and consultant. He is currently a Senior SQL Server DBA consultant at Datavail. Todd is also the current VP of Marketing for the Denver SQL Server User Group. He has presented at user groups, SQL Saturdays, and the Rocky Mountain Trifecta.

 

Meeting Location

UNC Loveland Center at Centerra

2915 Rocky Mountain Ave.
Loveland, CO 80538
Silverton Conference Room 2nd Floor


View Larger Map


Colorado Springs SQL

 

Date: Wednesday, June 19th

Main Presentation:

What every DBA should know about NoSQL

NoSQL is one of the buzzwords you hear going around in the developer world. As DBAs inevitably someone will come to us for help or advice on (or possibly choosing) a NoSQL solution. This session aims to give you a basic understanding in order to best answer those questions for your organization.

 

This presentation will cover: What exactly NoSQL is (and is not), introductions to some of the common NoSQL flavors, dispel some common misconceptions about NoSQL, and we will look at when you might (or might not) want to leverage it for a solution.

 

Presenter: Kelly Martinez, Developer / DBA

Kelly Martinez is a Developer/DBA currently working in municipal government. With over 15 years of I.T. experience he has also worked as a Web Developer in the Open Source space and as a System Administrator on both Linux and Windows.

 

Meeting Location

Hyatt Place – Colorado Springs

503 Garden of the Gods Rd W,

Colorado Springs, CO


View Larger Map


BoulderSQL

 

Date: Tuesday, June 18th

Main Presentation:

Hardware 201: Selecting and Sizing Database Hardware for OLTP Performances

The foundation of database performance is the underlying server hardware and storage subsystem. Even the best designed and optimized database application can be crippled by an inadequate hardware and storage infrastructure. Recent advances in new processors and chipsets, along with improvements in magnetic and SSD storage have dramatically changed the evaluation and selection process compared to the past. Many database professionals struggle to keep up with new technology and often simply let someone else make their hardware selection and sizing decisions. Unfortunately, the DBA usually gets the blame for any performance issues that crop up later. Don’t let this happen to you! This session covers current and upcoming hardware from both Intel and AMD and gives you the tools and resources to make better hardware selection decisions to support SQL Server OLTP workloads.

 

 

Presenter: Glenn Berry, SQL Server MVP

is a SQL Server MVP, and he has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS, which proves that he likes to take tests. His expertise includes DMVs, high availability, hardware selection, full text search, and SQL Azure.  He is also an Adjunct Faculty member at University College – University of Denver, where has been teaching since 2000. He recently completed the Master Teacher Program at Denver University – University College. He is the author of two chapters in the book SQL Server MVP Deep Dives, and blogs regularly at http://sqlserverperformance.wordpress.com.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.

 

Meeting Location

Confio Software in Boulder

4772 Walnut Street

Suite 100

Boulder, CO 80301

 


View Larger Map


DenverSQL

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: Thursday, June 20th

Time: 5:30 – 8:30 pm

Main Presentation: Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance

Presenter: Glenn Berry, SQL Server MVP

Glenn Berry is a SQL Server MVP, and he has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS, which proves that he likes to take tests. His expertise includes DMVs, high availability, hardware selection, full text search, and SQL Azure.  He is also an Adjunct Faculty member at University College – University of Denver, where has been teaching since 2000. He recently completed the Master Teacher Program at Denver University – University College. He is the author of two chapters in the book SQL Server MVP Deep Dives, and blogs regularly at http://sqlserverperformance.wordpress.com.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.

 

Meeting Location

Microsoft
7595 Technology Way, Suite 400
Denver, CO 80237


View Larger Map

 

By |June 14th, 2013|Uncategorized|

Colorado SQL Events : May 2013

 

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

 

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


DenverSQL

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
Map/Directions
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

 

By |April 30th, 2013|Uncategorized|

Colorado SQL – September 2012

COLORADO SPRINGS SQL

September 19, 2012 at 5:30 p.m.

Meeting Location:  Hyatt Place – Garden of the Gods, 503 West Garden of the Gods Road, Colorado Springs, CO  80909

 

101:  “Are triggers good or evil and when should they be used?”

During the first few minutes of the meeting we will discuss “Are triggers good or evil and when should they be used?” rather than doing a 101 session.

 

Main Session:  “Contained Databases in SQL 2012” with Steve Jones

The idea of keeping all of a databases relevant information inside the database can ease the work of developing for and administering databases.  Partially contained databases in SQL Server 2012 are covered in this talk.

 

Presenter Bio:  In 2001, Steve founded SQLServerCentral.com with Brian Knight, Andy Warren, and three other partners that were bought out the next year.  In 2002, Steve left his job with Peoplesoft to manage SQLServerCentral full time as editor, publisher, and writer.  Andy, Brian, and Steve continued to manage and grow SQLServerCentral until 2007 when it was sold to Red Gate Software along with Database Weekly (then Database Daily).  At the time Steve went to work for Red Gate and has continued his work with SQLServerCentral and Red Gate since that time.

 

DENVER SQL

 

September 20, 2012 at 5:30 p.m.

Meeting Location:  Microsoft (Denver) – 7595 Technology Way, Suite 400, Denver, CO  80237

 

Using TSQL to Manage SSIS 2012 with Mike Davis

SSIS 2012 added the ability to manage most functions of SSIS 2012 using TSQL.  In this session you will see how you can manage SSIS 2012 packages and projects along with Parameters and Environments, all using TSQL

 

Presenter Bio:  Mike Davis, MCITP, is the Managing Project Lead at Pragmatic Works.  He is an author of several Business intelligence books.  Mike is an experienced speaker and has presented at many events such as several SQL Server User Groups, Code Camps, SQL Server Launches, and SQL Saturday events:  Mike is an active member at his local user group (JSSUG) in Jacksonville, Florida.  His blog can be found at http://www.MikeDavisSQL.com.

 

Ninja Data Moves with Office 2012 with Brian Knight

Office 2013 brings with it some amazing business intelligence and data visualization enhancements.  Watch how you can improve data cleansing with Excel 2013 and some of the new features integrated into Excel and the other Office tools to visualize data better than ever before.

 

Presenter Bio:  Brian Knight, SQL Server MVP, MCITP, MCSE, MCDBA, is the owner  and founder of Pragmatic Works.  He is also the co-founder ofSQLServerCentral.comBIDN.com and SQLShare.com.  He runs the local SQL Server users group in Jacksonville (JSSUG).  Brian is a contributing columnist at several technical magazines and does regular webcasts at PragmaticWorks.com.  He is the author of more than a dozen SQL Server books.  Brian has spoken at conferences like PASS, SQL Connections and TechEd and many Code Camps.  His blog can be found at http://www.bidn.com.

 

By |September 10th, 2012|Uncategorized|