Showing archive results for 2006

Frank had a few questions about using SQL:P> Another useful set of guidelines would be SQL for dummies or at least for TFSers...I don't expect you to turn me into an SQL MVP, just give me the basics so I don't need to figure them out for myself. How to back up and restore, how to control which drive (or drives?) the data are stored on, other b...

Performing backups is an important component of managing your Team Foundation deployment. Implementing a well-planned backup and restore strategy protects your data against data loss due to damage caused by a variety of failures. Testing your strategy by restoring a set of backups and recovering your database prepares you to respond effectively to ...

Planning ahead is important for effective disaster recovery of a Team Foundation deployment. You should understand the size and scope of your Team Foundation deployment, know the maintenance and backup schedule for Team Foundation Server, and create a disaster recovery plan. You should also consider simulating a disaster recovery situation and step...

Creating a backup and restore plan is a critical part of any Team Foundation deployment. In order to create this plan, you need to understand the size and scope of your Team Foundation deployment, designate a person or a team of people to perform backups, determine a backup storage strategy, and consider what backup software might best meet the nee...

There are many aspects to consider when estimating your needs for a Team Foundation deployment. Understanding the size and scope of your current organization and understanding the requirements and limitations of Team Foundation Server deployment types will help you make the necessary planning decisions.Considerations When Estimating Current NeedsIn...

If the team project you are managing has completed a major iteration or milestone, and has grown too large or is not compatible with the desired workflow going forward, you can create a new team project based on the existing one. Moving a team project from one version to the next involves some combination of branching source code, copying items, an...

The data warehouse is a relational database organized in a star schema with an OLAP database derived from that database. The OLAP database allows the reporting tools to access the derived information without degrading the performance of the relational database that actually stores the real-time information from the clients.The warehouse stores seve...

Mike writes: "We need to configure the server to grant all users the ability to create a Team Project and manage the users of that specific project. However, a user must not be allowed to delete/modify/access a project which he or she does not belong to. Also, since users will belong to the Sharepoint administration group and SQL Server content man...

When you create a new project in Team Foundation Server, new project-level groups are created for that project, by default, and are assigned permissions to access resources appropriate to that group. To customize projects to better suit your business needs, you must understand what permissions are assigned to which users and groups by default, and ...

Authorization for user actions, such as workspace administration and project creation, are determined by permissions. When you create a project in Team Foundation Server, four default groups are created for that project regardless of your choice of process template. By default, each of these groups has a set of permissions defined for them that gov...