Defining VSS Roles and Processes

Here are some key decisions that the development team needs to make before the VSS administrator installs VSS and the development team begins a new project.

Determine who will be the VSS project leader, and the roles and permissions you need to configure. At a minimum, you need an administrator role and a developer role. The VSS administrator manages the VSS database, VSS users, and VSS file tasks such as archiving. A developer creates and updates files and checks them in and out of a Project. Other roles that you might include are supporting developers, code reviewers, technical writers, software testers, and project managers.

Establish a process for using VSS. Items to consider are: what objects will be checked in to VSS, how often developers should check in their source code to the repository, the appropriate procedure for releasing code to production, and the process for retiring the code base when an application in no longer live.

Decide what level of logon security is required at your enterprise. Is network authentication enough or should a separate authentication be required for logging on to the VSS database? This decision will determine how you configure the settings under the General tab (discussed later in this article).

From the Blogs

Don’t let bad data sneak up on you when and where you least expect it. Ferret out bad data with Melissa Data’s newest Profiling Component for SSIS. Learn how to take control of your data using knowledge-base-driven metadata. The truth shall set you free!...More

Now that we’ve outlined the process to let servers in a SQL Server AlwaysOn Availability Group "talk to each other" by means of setting up linked servers, it’s possible to set up some additional or improved checks on Availability Group Health....More

In my previous post, I provided a high-level outline of the core logic (and rationale behind that logic) that would be needed to set up regular synchronization checks on SQL Server Agent Jobs for servers where AlwaysOn Availability Groups have been deployed. In this post, I’ll walk through the steps--and the code--needed to setup those checks....More