|
Southern New England SQL Server Users Group |
|||
|
|
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. 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) Topic: Deploying DB Pro to Multiple
Environments 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.
·
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.
|
||
|
Copyright 2007-2008
Southern New England SQL Server User Group |
|||