VS 2005 TFS Power Tools Updated

Visual Studio 2005 Team Foundation Server Power Tools is a set of enhancements, tools and command-line utilities that improve the Team Foundation Server user experience.

This release includes everything from the previous Power Tools release and includes two great new tools, the Team Foundation Server Best Practices Analyzer and Work Item Templates.

Team Foundation Server Best Practices Analyzer
This release of the Team Foundation Power Tools includes the first release of the Team Foundation Server Best Practices Analyzer (Team Foundation Server BPA).

The Team Foundation Server BPA is a diagnostic tool that performs the following functions:

• Gathers configuration information from a Team Foundation Server deployment
• Performs specific tests on the Team Foundation Server deployment
• Analyzes the collected information according to specific rules and reports the findings as information, warning, or error messages
• Provides links to articles to resolve warning and error messages

You can use the Team Foundation Server BPA in either a pre-installation or a production Team Foundation Server environment. You can use the Team Foundation Server BPA to perform the following tasks:

• Proactively verify that the Team Foundation Server configuration is set according to recommended best practices
• Determine configurations that differ from default, recommended, or required settings
  Identify the source of problems in an unhealthy Team Foundation Server deployment

Work Item Templates
Team Foundation Power Tools installs a Work Item Templates feature that supports the ability to create, apply, capture, and set default work item templates. This feature adds additional menu items to the Team Work Item Templates menu.

You use work item templates to create or update work items. Work item templates automatically set field values. This feature conveniently reduces the number of steps to create or update work items. For example, you can create a task template that will set the area path, iteration path, and discipline whenever you use it to create or edit a task.

VSTS Web Access for TFS 2008 Updated

MS released a new version of VSTS Web Access.

This release is a Community Technology Preview (CTP) of what will ultimately be the 2008 version of the VSTS Web Access Power Tool.

This release (and the final 2008 release) can be used with either a TFS 2005 or a TFS 2008 server. In either case, you will need to install a TFS 2008 Team Explorer on the machine you install Web Access on.

Since TFS 2005 did not support build queuing, that functionality will not be available when this and future versions of Web Access are used with a 2005 server.

The only things left to do for the Final Web Access Power Tool release for VSTS 2008 are publishing some documentation, producing the localized builds and going through the final release process. The final version will be released about the same time VSTS 2008 is released.

The big advances in this update include:

• Built against the TFS 2008 object model - In previous versions of Web Access you had to install Team Explorer 2005 on any machine you were installing Web Access on. With this version, you will now be installing Team Explorer 2008 instead. In some future version, we hope to remove the requirement to install any version of Team Explorer.
• Custom control support - We've added support for web based work item custom controls and have included a folder of documentation and samples on how to create them.
• Build queuing - We added UI for the new TFS 2008 feature of build queuing. You can start new queued builds and view the build queue (in addition to the preexisting abilities - like viewing build details).
• Localization support - We've added support for localizing the web interface and are preparing to hand off our text to the localization team so they can begin preparing localized versions for the final 2008 Power Tool release.
• Bug fixes & Performance improvements - We've received a number of reports and done more testing ourselves on the last version of the Power Tool that we shipped and we have fixed everything we know of.

VSTS for DB Professionals SR1 Power Tools

VSTS for DB Professionals SR1 Power Tools is now available on MS

The Microsoft Visual Studio 2005 Team Edition for Database Professionals Power Tools is a set of enhancements and tools that compliment and improve the user experience of Team Edition for Database Professionals

This release includes 5 new refactoring types, a new dependency viewer, additional data generators and editors, 2 new MSBuild tasks for Schema and Data Compare as well as the introduction of the TSQL Static Code Analysis feature

TSQL Static Code Analysis

• Static Code Analysis - A precursor to the functionality that will be in future versions of VSTS that will allow you to perform Static Code Analysis on T-SQL code.

Refactoring

• “Move Schema” Refactoring - Allows a user to right click on an object and move it to a different but existing schema
• SP Rename Generation - Generate a new script that will contain sp_renames for all rename refactored objects that the user can then execute.
• Wildcard Expansion - Automatically expand the wildcard in a select to the appropriate columns.
• Fully-Qualified Name Support - Automatically inject fully-qualified names when absent in a script
• Refactoring extended to Dataset - Refactor into strongly typed dataset definitions

MSBuild Tasks

• Data / Schema Compare Build Tasks - MSBuild tasks that can generate scripts as if the user had run the Data / Schema compare UI

Schema View

• API Access to Schema View - Insert / Update / Delete to schema View and list schema objects and their associated files

Dependency Tool Window

• Dependency Tree - Show the dependencies ( incoming / outgoing ) for selected schema objects in a new tool window

Miscellaneous Tools

• Script Preprocessor - Expand SQLCMD variables and include files and command line version (sqlspp.exe) & an MSBuild version ( wraps the command line version )

Team System Web Access Power Tool Available!

Team System Web Access Power Tool is released the as the first "official" power tool release of Team System Web Access. It can be downloaded from here.

When Microsoft first acquired DevBiz, they provided v1.0 of TeamPlain for download. Based on customer demand, they uploaded a preview of TeamPlain 2.0. Neither were supported by Microsoft customer support but both were available for download by all TFS licensed users.

With the release of the Team System Web Access Power Tool, several things have changed.

This version is based on the TeamPlain 2.0 code base but a great deal of work has gone into it since March.

Although, it is still not yet an officially released Microsoft product it has taken some great strides, including:

• Microsoft Customer Support Services will now support it.
• The code has been run through the Microsoft release process which is an extensive gauntlet of checks that help ensure quality. Among the more important ones is a security review to make sure the code is not susceptible to attack.
• MS have tested it to a moderate degree (including internally dogfooding it for a couple of months).
• It contains numerous bug fixes beyond what was in the last available download. Some notable ones include:
• Because of dogfooding they have made substantial additional performance improvements - particularly on first page load and work item load and save.
• They have re-branded it as Microsoft Visual Studio Team System Web Access
• They have improved some of the graphics and visuals.
• They removed all of the old licensing code that required separate keys to be entered.
• Improved error logging and added Dr. Watson support so reports of any crashes you experience can be sent to MS for investigation.

It also includes most of the features originally on the TeamPlain 2.0 feature list, including:

General Improvements

• Better, faster and easier with the new Ajax user interface
• Dramatic performance improvements for large team projects with a lot of work items, queries, area paths, and people
• Theme support for the user interface (and a new Olive theme)
• Manage alerts, subscribe to custom alerts
• Home page customizations
• Many dialogs open in their own window now, such as the work item editor, report viewer, file viewer and build results

Work Item Tracking

• Ajax style design to avoid page reloads and to provide live feedback about the status of the work items
• Work item type icons
• Context sensitive menus for work items
• Improved web controls to handle large datasets better
• Improved query editor with grouping
• Edit multiple work items at once (bulk editing)
• Add related work item
• Create copy of a work item
• Send work items and query results as email
• Copy queries between team projects

Build

• There is a new "Build" tab in this release, allowing to manage team builds.
• View the list of builds, and apply filters
• Start a new build
• Monitor build progress live
• View build logs, errors or warnings
• Stop running builds
• Delete a build
• Change the quality of a build

Source Control

• Faster browsing
• Visual Diff for text files
• Annotate (a.k.a. Blame)
• Download the latest or a previous version of a file

Service Release 1 (SR1) Update for Visual Studio 2005 Team Edition for Database Professionals has shipped

SR1 update for VSTS for Database Professionals is now released and available on Microsoft

This service release addresses the top issues that were found through feedback from customers and partners.

This release includes the following features:

• Cross-database references
  Support is improved to enable you to reference objects in different databases by using database project references or referencing a database metafile (.dbmeta). This support will reduce or eliminate the cross database reference warnings within a database project.
• Improved file support within SQL Server file groups
  You may define files within file groups as database project properties instead of having to create files and file groups within the pre-deployment storage script.
• Variables
  A Variables page is added to the database properties. This new page enables you to define setvar variables for use in the deployment scripts. Additionally, SR1 supports the latest service pack release from Microsoft SQL Server 2005 (SP2). The SR1 also supports the Windows Vista operating system.

TFS V1 Integration to WSS 3.0 Revisited !

It was officially announced that TFS V1 will not support WSS 3.0 awhile ago and I had my own post on that, but since countless requests are being sent to MS for having that solved before Orcas' release, they managed to have that working using a great group of MCS consultants and VSTS team members that did much of the leg work to flesh out the solution and test it thoroughly

It's still not an easy process and it still involves some unusual steps but it can be checked out on http://blogs.msdn.com/briankel/archive/2007/04/14/Configuring-Visual-Studio-2005-Team-Foundation-Server-with-Windows-SharePoint-Services-3.0.aspx till it's officially released. It's still a "Pre-Release" so it's own your own risk still :)