Please register at http://ssig200906.eventbrite.com/

This is a different day then our normal date.  We will be back to the first Tuesday of the month for July. 

6:00 – 6:30 Pizza and Networking

6:30 - 6:40 Announcements

6:40 – 7:00 TBD

7:00 – 8:15 Andy Leonard: Database Development as part of the Application Lifecycle Management (ALM)

8:15 – 8:30 Closing remarks and give-a-ways

Database Development as part of the Application Lifecycle Management (ALM)

Based on the popular Example of Test-Driven Development series at SQL Server Central, this session focuses on Database Development as part of the Application Lifecycle Management (ALM) process. Examples demonstrate how to test, but the session focuses on the benefits of testing database scripts. T-SQL error trapping, database projects, test artifacts, and source control are also discussed.

About Andy Leonard

Andy Leonard is an Architect and manager with Unisys Corporation, SQL Server Database and Integration Services developer, SQL Server MVP, PASS Regional Mentor (Southeast US), and engineer. He is a co-author of Professional SQL Server 2005 Integration Services , Professional Software Testing with Visual Studio 2005 Team System: Tools for Software Developers and Test Engineers , and MCITP Self-Paced Training Kit (Exam 70-441): Designing Database Solutions by Using Microsoft SQL Server 2005 . Andy founded and manages VSTeamSystemCentral.com and maintains two blogs there: Applied Team System and Applied Business Intelligence . He also blogs for SQLBlog.com . Andy's background includes web application architecture and development, VB, and ASP; SQL Server Integration Services (SSIS); data warehouse development using SQL Server 2000, 2005, and 2008; and test-driven database development.

6:00 – 6:30 Pizza and Networking

6:30 - 6:40 Announcements

6:40 – 7:00 Ken McClaren : SQL Server Certification

7:00 – 8:15 John Welch : Doing More (ETL) with Less (Effort) by Automating SSIS

8:15 – 8:30 Closing remarks and give-a-ways

SSIS is a great tool for transferring data from one data source to another, and for implementing complex ETL processes. However, for simple, straightforward data transfer tasks, creating SSIS packages by hand can be time-consuming and repetitious. By attending this session, you'll learn how to automate data transfers from a source to a target using SSIS. You’ll see the steps necessary to create both the control flow and the data flow portions of an SSIS package using the API and C# code. You’ll also learn about altering existing packages programmatically. Specific attention will be given to the generation of data flows with the proper source and destination components. We’ll take a look at some of the open source solutions available for this, plus some “roll your own” options.

Takeaways:

1.       Generating Control Flow Tasks through the API

2.       Generating Data Flow Components through the API

3.       How to Alter Existing Packages Programmatically

John Welch is Chief Architect with Mariner, a consulting firm specializing in enterprise reporting & analytics, data warehousing and performance management solutions. John has been working with business intelligence and data warehousing technologies for 7 years, with a focus on Microsoft products in heterogeneous environments. He is a Microsoft Most Valued Professional (MVP), an award given due to his commitment to sharing his knowledge with the IT community.  John is an experienced speaker, having given presentations at Professional Association for SQL Server (PASS) conferences, the Microsoft Business Intelligence conference, Software Development West (SD West), Software Management Conference (ASM/SM), and others. He has also contributed to two recent books on SQL Server 2008, “Microsoft SQL Server 2008 Management and Administration” and "Smart Business Intelligence Solutions with Microsoft SQL Server 2008".

John writes a blog on business intelligence topics at http://agilebi.com/cs/blogs/bipartisan. He also writes one focused on SSIS topics at http://agilebi.com/CS/blogs/jwelch/. He is also active in open source projects that help ease the development process for Microsoft BI developers, including BIDS Helper (http://www.codeplex.com/bidshelper), an add-in for Business Intelligence Development Studio that adds commonly needed functionality to the environment. He is also the lead developer on ssisUnit (http://www.codeplex.com/ssisUnit), a unit testing framework for SSIS.

Please register here.
 
If you read the last email you might have notice I had the date for this meeting a month off. Sorry about that.

6:00 – 6:30 Pizza and Networking sponsored by MDI Group
6:30 – 6:40 Announcements
6:40 – 7:50 Ram Garipall :SQL Server Replication
7:50 – 8:15 Russ Jester: The new SSIG web site and NHibernate
8:15 – 8:30 Closing remarks and give-a-ways
 
Ram Garipall: SQL Server Replication
SQL Server Replication is a set of technologies for copying and distributing data and database objects from one database to another and then synchronizing between databases to maintain consistency. Using SQL Server replication data can be distributed over local and wide area networks, dial-up connections, wireless connections, and the Internet to different locations and remote or mobile users.
 
The presentation will have few slides and a demo of replication setup between a Server with enterprise edition and a client with SQL Express.
 
Ram Garipalli is a certified Oracle and SQL Server DBA working for TiBA solutions as Senior Database Administrator and Data Analyst. He is working with SQL server for more than 10 years and has experience with Reporting services, Integration Services, Analysis Services, and Replication.
 
Russ Jester:  The making of the new SSIG web site.
Russ will introduce us to our new web site, describe the technologies used and then elaborate on it use of  NHibernate.

 Please register here. 

 6:00 – 6:30 Pizza and Networking Sponsored by FGP

6:30 – 6:40 Announcements

6:40 – 7:00 Ken McClaren :  SQL Server 2008 Activity monitor

7:00 – 8:15 Paul S. Waters: Policy-Based Management

8:15 – 8:30 Closing remarks and give-a-ways

Paul S. Waters: Policy-Based Management

This presentation has a few slides and lots of demos.  We will be covering some of the most useful new features in SQL Server 2008; Policy-Based and multi-server management.  We will cover how to set up policy-based management, and a few use cases.  There are even some nice use cases for application developers.  Much of what will be presented can also be used against SQL Server 2000 and 2005 databases.

 In our last meeting with K. Brian Kelley he mentioned this as being a great new tool to help secure and understand your environment, so I thought this would be a great way to keep the momentum he got going in February going in March.

 Here are the slides and scripts from our meeting with K. Brian Kelley.  For anyone that uses Twitter his id is @kbriankelley.

PowerPoint 97-2003 format

PowerPoint 2007 format

SQL Scripts

Brian, thank you again for comeing up to Greenville to present to our group.  It was an excellent presentation.

Ken, much thanks to you as well.  Your presentaion was not only informative, but also an excellent excample of the 10-20min time slot.

Jason Hall from SQLSentry gave an excellent presentation in the new Resource Governor in SQL Server 2008.

Here in the presentation.

Thank you Jason and Peter.

Please register at http://ssig080902.eventbrite.com/

Agenda
6:00 – 6:30 Pizza and Networking
6:00 – 6:45 Announcements
6:45 – 8:15 , SQL Saturday, Dynamic Data, New T-SQL in SQL 2008
8:15 – 8:30 Closing remarks and give-a-ways
 
SQL Saturday
Saturday October 11th at ECPI we will be having a SQL Saturday. The event is free to all attendees and is organized and implemented by volunteers. Some of the volunteer positions take a good deal of time and effort, but most do not. A list of volunteer positions will be reviewed and anyone that will like to participate is welcome to volunteer.
We will have a discussion about to topics already being presented and taking suggestion for other topics.

Dynamic Data
A very high level, but practical use of the new ASP.NET Dynamic Data features in .net 3.5 SP1.

New T-SQL in SQL Server 2008

A few of the new T-SQL enhancements are quite useful and long over due. We will look at a few of these and discus there uses.