Sharing knowledge is the key...

Query to get TFS 2008 Version Control folder sizes

2011-02-23T21:57:00Z

The query below can be used to retrieve the size of your TFS 2008 folders in Version Control for a team project. We are testing the TFS Integration Platform for migrating some of the projects to TFS 2010 instead of all at once using SQL backup and restore.

Use TFSVersionControl

select left(isnull(n.fullpath, '$\null\'), charindex('\', isnull(n.fullpath, '$\null\'), 3) - 1) as [Project],

str(sum(FileLength) / 1024. / 1024., 14, 3) + ' MB' as [UncompressedSize],

str(sum(CompressedLength) / 1024. / 1024., 14, 3) + ' MB' as [CompressedSize],

str(sum(case when n.IsLatest = 1then FileLength else 0 end) / 1024. / 1024., 14, 3) + ' MB' as [LatestUncompressedSize],

str(sum(case when n.IsLatest = 1 then CompressedLength else 0 end) / 1024. / 1024., 14, 3) + ' MB' as [LatestCompressedSize]

from tbl_File f with (nolock)

left join tbl_namespace n with (nolock)

on f.itemId = n.itemId

group by left(isnull(n.fullpath, '$\null\'), charindex('\', isnull(n.fullpath, '$\null\'), 3) - 1)

order by left(isnull(n.fullpath, '$\null\'), charindex('\', isnull(n.fullpath, '$\null\'), 3) - 1)

Here is a sample of the output:

Project Size (MB)	UncompressedSize	CompressedSize	LatestUncompressedSize	LatestCompressedSize
$\APManagement	953	154	928	151
$\APCMMI	4,060	1,106	3,893	1,089
$\BI	8,914	2,987	7,109	2,278
$\CEDSUI	223	104	200	85
$\CSC	196	84	182	83
$\DAS	12	4	12	4
$\Demo	264	84	201	71
$\Distribution	6,040	1,572	4,659	1,386
$\dotNET	2,324	1,782	803	601
$\EA	11	6	11	5
$\EAP	414	67	365	48
$\EAM	4,252	3,823	2,117	1,918
$\ETools	1,251	1,195	1,251	1,195

Azure Bootcamps - Webcasts and 2-day Workshops available

2010-12-03T21:59:00Z

Azure Bootcamps – the Webcast Series

- 11/29: Azure Boot Camp: Introduction to Cloud Computing and Windows Azure

- 12/06: Azure Boot Camp: Windows Azure and Web Roles

- 12/13: Azure Boot Camp: Worker Roles

- 01/03: Azure Boot Camp: Working with Messaging and Queues

- 01/10: Azure Boot Camp: Using Windows Azure Table

- 01/17: Azure Boot Camp: Diving into BLOB Storage

- 01/24: Azure Boot Camp: Diagnostics and Service Management

- 01/31: Azure Boot Camp: SQL Azure

- 02/07: Azure Boot Camp: Connecting with AppFabric

- 02/14: Azure Boot Camp: Cloud Computing Scenarios

Azure Bootcamps – In-person 2 day workshops

Date	WWE URL	Location
1/19/2011	https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032468989&Culture=en-US	Cleveland, OH
1/19/2011	https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032468991&Culture=en-US	Austin, TX
1/25/2011	https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032468992&Culture=en-US	Waukesha, WI
1/25/2011	https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032468993&Culture=en-US	Cincinnati, OH
2/1/2011	https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032468994&Culture=en-US	Chattanooga, TN
2/8/2011	https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032469000&Culture=en-US	Tulsa, OK
2/8/2011	https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032468995&Culture=en-US	Columbus, OH
2/15/2011	https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032468996&Culture=en-US	Grand Rapids, MI
2/16/2011	https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032468997&Culture=en-US	Dallas, TX
2/23/2011	https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032468998&Culture=en-US	Little Rock, AR
2/23/2011	https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032468999&Culture=en-US	Chicago, IL
3/9/2011	https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032469371&Culture=en-US	Minneapolis, MN
3/9/2011	https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032469372&Culture=en-US	Indianapolis, IN
3/16/2011	https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032469373&Culture=en-US	Houston, TX
3/23/2011	https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032469374&Culture=en-US	Memphis, TN
3/30/2011	https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032469375&Culture=en-US	Overland Park, KS
4/6/2011	https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032469376&Culture=en-US	Nashville, TN
4/13/2011	https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032469377&Culture=en-US	Southfield, MI
4/20/2011	https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032469378&Culture=en-US	Downers Grove, IL
4/26/2011	https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032469379&Culture=en-US	Des Moines, IA
5/4/2011	https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032469380&Culture=en-US	St. Louis, MO
5/9/2011	https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032471426&Culture=en-US	Bloomington, MN

Save when pre-ordering Visual Studio 2010 Professional

2010-03-11T15:37:00Z

Microsoft Visual Studio 2010 Professional will launch on April 12 but you can beat the rush and secure your copy today by pre-ordering at the affordable estimated retail price of $549, a saving of $250.

If you use a previous version of Visual Studio or any other development tool then you are eligible for this upgrade. Along with all the great new features in Visual Studio 2010 (see www.microsoft.com/visualstudio) Visual Studio 2010 Professional includes a 12-month MSDN Essentials subscription which gives you access to core Microsoft platforms: Windows 7 Ultimate, Windows Server 2008 R2 Enterprise, and Microsoft SQL Server 2008 R2 Datacenter.

So visit http://www.microsoft.com/visualstudio/en-us/pre-order-visual-studio-2010 to check out all the new features and sign up for this great offer.

Learn more about SQL Azure by having a direct connection to the development team for technical assistance and feedback

2009-12-05T17:17:00Z

To Sign up for SQL Azure Feedback Community Engagement:

· Step One: Please follow this link to complete your SQL Connect site registration (if you have not) by clicking on the “Your Profile” link in the upper right corner.

· Step Two: Once your registration is complete, click here and then click on "Respond to this Survey" to complete the profile.

Benefits to our Feedback Community Customers:

· In-depth knowledge on SQL Azure through presentations, direct QA/feedback sessions with our Dev team

· Closer technical relationship with our development team

· Access to information on future NDA-required SQL Azure Customer Programs

More information on SQL Azure:

· SQL Azure in Windows Azure Platform: http://www.microsoft.com/windowsazure/sqlazure/

· Microsoft PDC presentation on SQL Azure Databases: Present & Future: http://microsoftpdc.com/Sessions/SVC52

· All customers will have free access to SQL Azure until Feb. 1^st, 2010, when we will start the commercially available SQL Azure database service.

Microsoft Code Analysis Tool .NET (CAT.NET) v1 CTP - 32 bit

2009-10-22T15:18:00Z

CAT.NET is a binary code analysis tool that helps identify common variants of certain prevailing vulnerabilities that can give rise to common attack vectors such as Cross-Site Scripting (XSS), SQL Injection and XPath Injection. This also generates a nice report that you can use to see where the vulnerabilities are in your code.

Download from here:

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=0178e2ef-9da8-445e-9348-c93f24cc9f9d

Invoking an external program from the VSTS source control explorer for a given file extension

2009-09-09T06:45:00Z

This is handy to know...

Use powershell files as an example…add a ps1 file to a solution (just create an empty solution of any type), right click on the document in Solution Explorer and choose “Open with..”, browse and choose the Powershell GUI Editor program, the press Set as Default.

Live Framework CTP and several Live Services controls to be taken offline

2009-09-02T19:38:00Z

The Live Services Team recently announced the Live Framework CTP and several Live Services controls will be taken offline starting September 8^th, 2009. This is a friendly reminder to those of you using the Live Framework CTP to take appropriate action. Please see their recent blog post to learn more.

Starting September 8^th, 2009, the following services will be unavailable:

Live Framework CTP (Services, SDK & Tools)
The Live Framework will be integrated into the next release of Windows Live. Stay tuned to dev.live.com for more details in the future.
Contacts Control (JavaScript)
As an alternative, please use the UI Controls from Messenger Web Toolkit.
CTP Tools/ASP.NET Controls (Contacts, MessengerChat, IDLoginStatus, IDLoginView, SilverlightStreaming)
As alternatives use:
- The UI Controls from Messenger Web Toolkit for Contacts and Messenger Chat
- The Windows Live ID Web Authentication Service to replace the IDLoginStatus Control

Summary of patterns and practices releases in the last year

2009-09-02T00:22:00Z

· Enterprise Library v4.1 is a collection of reusable software components that help developers with common development needs such as logging, validation, data access, and exception handling. They can be used “as is” or extended or modified by developers as needed.

· Unity Application Block v1.2 is a lightweight extensible dependency injection container with support for constructor, property, and method call injection. It addresses the issues faced by developers engaged in component-based software engineering.

· Composite Application Guidance for WPF (“PRISM”) v1.0 and v2.0 helps developers build and evolve modular Windows Presentation Foundation and Silverlight client applications. These applications typically include multiple screens and role-determined behavior and are designed to change over time based on business requirements.

· Application Architecture Guide v2.0 provides design-level guidance for the architecture and design of applications built on the .NET Framework. It focuses on the most common types of applications, partitioning application functionality into layers, components, and services, and walks through their key design characteristics.

· ESB v2.0 helps developers leverage the Microsoft BizTalk Server platform to build a custom enterprise service bus (ESB) for their SOA implementations.

· SharePoint Development Guidance helps customers accelerate the construction of advanced applications. This guidance helps architects and developers in the following areas: Use SharePoint capabilities to make more powerful applications; Build applications that are easier to scale, maintain and extend; Improve application quality through testing; Improve and accelerate team productivity;

· Acceptance Testing Guide v1.0 (Beta 2) provides guidance on 1. How to Plan for Acceptance Testing;2. What Kinds of Acceptance Tests to Run; 3. How to Create and Run Acceptance Tests; 4. Defining What “Done” Means; and 5.How to Justify Your Approach;

· p&p Agile Showcase on MSDN patterns & practices has been using agile development techniques for the past five years. Customers and community asked us to share our experiences and learning. This page lists resources that we've used to make our teams more successful.

Using WCF to communicate between ASP.NET website server and app server using impersonation and delegation

2009-09-01T19:12:00Z

While at a client the past week, we spent a few days debugging the following scenario:

We have an ASP.NET web site with impersonation on hosted on web server A attempting to call a WCF service hosted on web server B (through IIS). When running the application locally on server A the application operates as expected, however if we attempt to access the web site remotely we have a strange socket exception with none of the code for the service being executed.

Our configuration: NetTCP or WSHTTP binding with impersonation is on in web.config and anonymous enabled in IIS. User needed to be properly impersonated by web server call for WCF calls to work properly.

Here is the error we were receiving:

The socket connection was aborted. This could be caused by an error processing your message or a receive timeout being exceeded by the remote host, or an underlying network resource issue. Local socket timeout was '00:00:30.7500000'.

We tried many different configurations recommended in the following links, but here is what worked for our implementation:

Created a domain user that can be trusted for delegation using the following instructions: http://technet.microsoft.com/en-us/library/cc739474(WS.10).aspx
Added the above domain user as the AppPool user for the IIS website and included it as the UserPrincipalName in the Identity section of the endpoint

<identity>
<userPrincipalName value="domain/user" />
</identity>

Below are some very helpful links that may help you setup your WCF configuration properly:

How to configure an ASP.NET application for a delegation scenario:

http://support.microsoft.com/kb/810572

Authentication delegation through Kerberos does not work in load-balanced architectures:

http://support.microsoft.com/kb/325608/

Whitepaper on Kerberos Authentication for Load Balanced Web Sites:

http://www.microsoft.com/downloads/details.aspx?familyid=035465F0-5090-4F9C-AC44-FC0500769BE9&displaylang=en

Preventing Anonymous Access blog post

http://blogs.msdn.com/drnick/archive/2007/03/23/preventing-anonymous-access.aspx

How to: Impersonate the Original Caller in WCF Calling from a Web Application:

http://msdn.microsoft.com/en-us/library/cc949013.aspx

SQL Azure Migration Wizard

2009-09-01T18:47:00Z

For those of you interested in Azure development, here is a tool that can help you get your SQL Scripts into SQL Azure database:

http://sqlazuremw.codeplex.com/

Description: The SQL Azure Migration Wizard helps you migrate your local SQL Server 2005 / 2008 and SQL Express databases into SQL Azure. The wizard walks you through the selection of your SQL objects, creates SQL scripts suitable for SQL Azure, and allows you to deploy to SQL Azure.