I had a requirement to show the top 3 of news listing on the home page with the option of having these links open up in a new window. First read these 2 good articles http://blogs.msdn.com/ecm/archive/2006/10/25/configuring-and-customizing-the-content-query-web-part.aspx ... [More]

Row Constructors in SQL 2008 Let us delve into using Row Constructors Two basic tables for test purposes -- Customer IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Customer]') AND type in (N'U')) DROP TABLE [dbo].[Customer] ... [More]

Developer centric SQL 2008 Features: I am giving a walk through on developer centric features in SQL 2008. If you are interested to learn more about the new SQL 2008 features available for developers like Row constructors, HierarchyID and more, you can register on the link shown below:  ... [More]

Once TFS installed, the quickest way to validate it is working well is by creating a test Team project. You can use any existing templates (Agile/CMMI). Once the process is completed, try to view the Team project portal. Check SQL Reporting services for any errors. After the intial steps are done... [More]

When you try to connect to TFS from VS 2008 after the initial setup, you may get the error message TF31002: Unable to connect to this Team Foundation Server.  To fix the issue, check the Project Security settings on TFS Server. You need to ensure the domain acco... [More]

When you try to create a new migration profile in MOSS 2007 which connects to MCMS 2002, you may get a sql connection issue. This is due to the fact that SQL Server 2000 was not set to Mixed Mode. If it uses windows authentication mode only, the migration assistant in MOSS 2007 w... [More]