Southern New England SQL Server Users Group  < Official PASS Chapter as of January 2007 >
Home Membership Directions About Us Mission Leadership Cool Thoughts	The Southern New England SQL Server User Group (SNESSUG) was created to provide a local forum in the Southern New England area for SQL Server professionals to educate, network, and share information with one another. We meet on the second Wednesday of every month at the New England Institute of Technology in Warwick, Rhode Island from 6:00PM to 9:00PM. If you are planning on attending a meeting, please RSVP. Click here to become a member. Upcoming Meetings and Announcements Congratulations are in order: Grant Fritchey has had his abstract entitled “Deploying DB Pro to Multiple Environments” accepted for the PASS 2008 Summit being held in Seattle this November. Well done Grant!!! Grant has kindly agreed to do a “dry run” at the October 2008 SNESSUG meeting. Remember that you saw it FIRST at a SNESSUG meeting J October 08, 2008 6:00PM - 9:00PM, Hall of Fame Room at New England Tech (Directions) Speaker: Grant Fritchey of FM Global. Topic: Deploying DB Pro to Multiple Environments [ RSVP ] This session will show attendees a series of TSQL scripts, command line scripts and various Visual Studio settings and configurations that will enable the attendee to use Visual Studio DB Pro to deploy to multiple environments. It's extremely easy to configure DB Pro to deploy to a single environment. However, when multiple developers or DBA's have to deploy the same project to various disparate environments, the tool becomes more difficult to use. This session will introduce concepts to make this task easier. To begin, attendees will be introduced to project properties that need to be configured to allow for multiple environments. This will also introduce the concept of variables within the DB Pro environment. Visual Studio Configuration Manager will be covered as a method for establishing different settings for different environments. The session will move on to show how the Pre and Post deployment scripts can be manipulated to deal with the requirements of different environments with an emphasis on file placement and security. Command line builds using parameters will be shown. These make all of the previous concepts available for automation. Finally, a method for saving all this information and sharing it with multiple users through source code management (TFS or VSS) will be shown. All the methods and approaches demonstrated are currently in use in a live environment. Attendees will learn mechanisms that allow them to create their own build process that will be repeatable and can be automated. Downloads · Download Rob Walter’s slides on Using Reporting Services in SQL Server 2008 from the June 2008 meeting. · Download Steve Simon’s slides on Reporting from SQL Server 2005 OLAP Cubes with WebFOCUS from the May 2008 meeting. · Download Grant Fritchey’s slides on execution plans from the March 2008 meeting. · Download Andrew Kelly's Slides and Sample Code on Automating Trace and Perfmon from the January 2008 meeting. · Download Steve Simon's Slides on Using CLR Assemblies with Microsoft SQL Server Stored Procedures from the November 2007 Meeting. E-mail Us for Member Code Discount **Interested in speaking at our user group meeting? Contact us at contact@snessug.com!**	ADDITIONAL SPONSORS
Copyright 2007-2008 Southern New England SQL Server User Group Contact Us