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.
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.com, BIDN.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.