Computing Visual Studio Code Metrics during Builds

January 31, 2011

Microsoft have just released a new command line tool for computing the same code metrics that Visual Studio provides.  These include Maintainability Index, Cyclomatic Complexity, Class Coupling, Depth of Inheritance, and Lines of Code. The tool is named Metrics.exe and can be downloaded here.

The results will be placed in an XML file whose schema matches the provided MetricsReport.xsd.  Jakob Ehn has already documented how to integrate this with TFS 2010 Build.  All that’s needed is an XSL file to integrate with CruiseControl.NET.

Thanks to Cameron Skinner for the announcement of the tool.

Update (1 Feb 2011): Please note that .NET Framework 4.0 is required for this tool.  Also it requires version 10.0.0.0 of Microsoft.VisualStudio.CodeAnalysis.Common so you should have Visual Studio 2010 installed.

-Krip

2 Comments | Team Foundation Server | Tagged: , | Permalink
Posted by Krip

How to speed up SQL Server Management Studio

January 21, 2011

In some cases you will find SQL Server Management Studio (SSMS) slow to start up (could take up to a minute).

To resolve the issue uncheck the “Check for publisher’s certificate revocation” box in the Security section of Internet Explorer’s Options.  This disables a lookup on the Internet that could account for the time.  Note that this affects all managed applications (.NET).

Thanks to Euan Garden for the tip.

-Krip

Leave a Comment » | SQL Server | Tagged: | Permalink
Posted by Krip

SQL Azure Database Backups

January 20, 2011

While Microsoft has always ensured that your SQL Azure database is replicated multiple times for reliability, there is now a way to perform your own ad-hoc backup.  This is known as copying.  You can copy to the same server or to a different one.  The process is asynchronous.  Full details including the T-SQL syntax (CREATE DATABASE…AS COPY OF) can be found here.

-Krip

Leave a Comment » | SQL Server, Windows Azure | Tagged: , | Permalink
Posted by Krip

Follow

Get every new post delivered to your Inbox.