Finally the much awaited missing link between EPM 2007 and Visual Studio Team Foundation Server is released to technical community. Latest release of Visual Studio Team Foundation Server – Project Server 2007 Connector which is available at http:/...

EPM 2007 provides "Project Server Gateway" for mapping the data between Portfolio Server 2007 and Project Server 2007. One of the common query that I have noticed is 'why attribute from project server is not gettign listed for mapping?. Well...

From official support perspective running multiple instances of Portfolio Server 2007 on single server is not a supported scenario. Even the setup program for the tool has no way to achieve the same. But from development and testing perspective...

One of the common query that I have seen is how to synchronize the schedule information between Project Server and Portfolio Server. Ideally once you setup and Project Server Gateway and export the project to Project Server 2007 - things should...

One of the common ask - how can we sort the list of values displayed in the Portfolio Server 2007 attribute. Well - This is kind of common feature but currently product does not support any such feature. Easiest way - Sort the list values in Microsoft...

One of the most important event for EPM community is around the corner. The session list for the Project 2007 Conference has been posted to the http://www.msprojectconference.com site.

Adding another series to my blog list - EPM 2007. I would be posting tips and tricks, announcements and technical content on Project Server 2007 and Portfolio Server 2007.

Microsoft has finally launched the public version of "Microsoft Certified Architect : Database" certification. The Database Architect program, the newest Technology Architect program under the Microsoft Certified Architect (MCA) umbrella, provides...

Latest addition to the best practice series. I highly recommend the same for DBA and architects ! SQL Server 2005 Predeployment I/O best practices http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/pdpliobp.mspx

At Mix 07, the ADO.NET team announced an incubation project that they have been working on, Project Codename "Astoria". What ’ s this “ Astoria ” now ! – hold on lets look at the goals and high level features The goal of Microsoft Codename "Astoria...

Few weeks back at Mix 07 Microsoft announced “Jasper”, an ADO.NET incubation project for building quick, clean and iterative applications. Jasper is latest steps to make the life of database driven application easier; using “Jasper”, developers...

Quick one – How to check the version of SQL Server product running in production ! SELECT SERVERPROPERTY ('Edition')

Another step to prove the enterprise scalability of SQL Server 2005. The results are in— Microsoft SQL Server 2005 delivers the #1 price/performance for 3TB TPC-H non-clustered benchmark. The recent TPC-H benchmark study with HP demonstrates Microsoft...

SQL Server Product Team signed off on SQL Server “ Katmai ” CTP3 (externally known as “June CTP”). This is the first public Katmai CTP that is being launched in this week’s TechED. Have a bang and participate in testing and evaluating SQL Server 2008...