This month we are pleased to welcome back to Charlotte a noted subject matter expert and renowned speaker - Brian Knight.

Managing SSIS in Denali by Brian Knight, SQL Server MVP

In this session, you’ll learn how to manage SSIS in SQL Server Denali. You’ll first see how the logging and auditing of your SSIS packages has changed in Denali. Then, you’ll learn how parameterization of packages has been overhauled in Denali to make a zero-touch deployment of your packages. In this demo-packed session, you’ll walk through the entire lifecycle of a package from deployment to longer-term management of the package.

Key takeaways:

1. SSIS logging and auditing in SQL Server Denali
2. Deploying packages in Denali
3. Parameterization of packages

Brian Knight, SQL Server MVP, MCITP, MCSE, MCDBA, is the owner and founder of Pragmatic Works. He is also the co-founder of SQLServerCentral.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 SQLShare.com. He is the author of 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.

Agenda:

5:30 PM Networking and Pizza

6:00 PM Stump the SQL Experts - open Q&A Forum with CSSUG Members

6:15 PM Main Presentation

7:30 PM Meeting End

7:45 PM Post-Meeting Social Hour - Join Us for Drinks at a venue TBA

Location:

The meeting is being held at the Microsoft Offices in AP1 - the left building as you drive onto the campus. 

Sponsors:

TEKsystems® has been a loyal sponsor of the Charlotte SQL Server Users Group. TEKsystems® provides technology staffing and services, helping businesses deploy high-caliber IT and communications expertise. With roots as the nation’s largest IT staffing firm, they’ve become a billion-dollar services company by blending superior client service with an unrivaled ability to source and manage talent to precise specifications, resulting in successful technology executions. Visit www.teksystems.com for more info.

SQL Sentry, Inc., is a Charlotte based company and a long time sponsor of the Charlotte SQL Server Users Group. SQL Sentry creates software products to optimize the performance of Microsoft® SQL Server® environments. SQL Sentry software provides unprecedented visibility and control that enables database administrators to monitor their database environment with confidence, and quickly diagnose and solve complex performance problems as they arise. Visit www.sqlsentry.net for more info.

The Pragmatic Works mission is to make businesses more intelligent by making technology simple to use, learn and accelerate. Whether by introducing the unemployed or underemployed to technology with the Pragmatic Works Foundation, developing software that democratizes the previously difficult project or by delivering the best consultants and trainers, each employee at Pragmatic Works is focused on the mission to grow your business and people. Visit pragmaticworks.com for more info

About Our Group:

Charlotte, NC has a dynamic, growing business environment filled with opportunities for SQL Server professionals. The goal of the Charlotte SQL Server User Group is to encourage and support the growth of that environment by providing a venue for user education and peer collaboration. Our group is a certified Chapter of PASS and we recommend all members join that organization.