Thursday, January 31, 2008

Default Build Quality In Team Foundation Build 2008

I wanted to define my default build quality at one of my Team Build Types in TFS 2008. In Team Build 2005 we could define the default build quality. However, in Team Build 2008, the default build quality notion was removed.

Note: The default value for the build quality of a new build in TFS 2008 is null, not empty string.

So, how can we set the build quality? Use the SetBuildProperties task. Read about it here;

Data Dude: How To Ignore Collation in Schema Compare

Do you want to configure the data dude's schema compare tool to ignore the collation when comparing 2 schemas?

To configure it go to:

Tools > Options > Database Tools > Schema Compare > Ignore Collation Order

Monday, January 21, 2008

How To Create Computed Column In Data Dude

In order to create computed column in data dude you have to define it in the CREATE TABLE command.

Example:

CREATE TABLE [dbo].[Products]
(
ProductId int NOT NULL,
ProductNumber nchar(20) NULL,
ComputedProductNumber AS CASE WHEN ProductNumber
IS NULL THEN CONVERT(nchar(20),ProductId)
ELSE ProductNumber
END
);

Saturday, January 19, 2008

.NET Framework Source Code Available

It's here and you can give it a try now! To step through .NET Framework Source code, here's what you need to do.

  1. Install the Visual Studio 2008 QFE.  This Hotfix just updates a DLL that's part of the Visual Studio debugger that fetches the source files, more details on the download page. (64-bit users: read the description as there is a single manual step for 64-bit)
  2. Go into Tools > Options > Debugging > General and turn off "Enable Just My Code" and turn on "Enable Source Server"
  3. Go to Symbols and add this URL http://referencesource.microsoft.com/symbols and a local cache path. Make sure "search only when symbols are loaded manually" is checked.

That's it.

Great post by Shawn gives you more detail.

Note: This functionality is not available on the Express versions of the Visual Studio 2008 products.