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.

Register at http://ssig200806.eventbrite.com/

SQL Server Integration Services (SSIS) is a powerful and flexible data integration tool included with SQL Server 2005 Standard and above. As with most powerful and flexible tools, it is easy to hurt yourself with until you know a few tips and tricks coupled with a good toolkit. In this presentation you will learn some tips and tricks for making your SSIS projects go more smoothly, scale better, document themselves (almost), and learn a few time and butt saving tools to help you out.

Agenda

6:00 – 6:30 Pizza and Networking
6:00 – 6:45 Announcements
6:45 – 8:15 Paul S. Waters - SQL Server Integration Services (SSIS) Tools, Tips and Tricks
8:15 – 8:30 Closing remarks and give-a-ways

Our last few presentations have been more focused on Business Intelligence then the SQL Server DBA .  Well that streak is about to end.   For our April 1st meeting Ram Garipalli from TiBA Solutions will be teaching us how to use database partitioning and Dynamic Management Views .

 Agenda

6:00 – 6:30 Pizza and Networking

6:00 – 6:45 Announcements

6:45 – 8:15 Ram Garipalli - Data partitioning and Dynamic Management Views

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

Here is what the VPC has installed and ready to use:

• Microsoft Windows Server 2003 R2 Service Pack 2
• Internet Explorer 7
• Microsoft Office Enterprise 2007
• Microsoft Office Visio 2007
• Microsoft Office Project 2007
• Microsoft Office SharePoint Designer 2007
• Microsoft SharePoint Portal Server 2007
• Microsoft Visual Studio 2005 w/ Service Pack 1
• Microsoft SQL Server 2005 w/ Service Pack 2 (w/ SSIS, SSAS, SSRS)
• Microsoft SQL Server 2005 Data Mining Add-ins
• Microsoft SQL Server 2005 SharePoint Integration Add-in
• ProClarity Analytics Server 6.3
• ProClarity Dashboard Server 6.3
• ProClarity Desktop Professional 6.3
• ProClarity Web Professional 6.3
• Microsoft PerformancePoint Planning Server 2007
• Microsoft PerformancePoint Monitoring Server 2007
• Microsoft PerformancePoint Dashboard Designer
• Microsoft PerformancePoint Planning Add-In for Excel
• Microsoft PerformancePoint Planning Business Modeler
• Project REAL Reference Implementation
• SoftArtisans OfficeWriter 3.8.1 and Designer
• BI Demo Files
• Microsoft SQL Server 2005 Samples
• Microsoft SQL Server BI Metadata Samples
• Performance Point Planning Samples/Labs
• Visual Studio 2005 Tools for Office Second Edition

There are two parts to the VPC and here are the links.