Architecture, Cloud, SQL Server, EPM and .NET Geek

Technical Stuff on Architecture, Cloud, SQL Server, Enterprise Project Management and .NET.

Microsoft Project & Project Server 2010 Service Pack 1 - On Target

Today, the Office Division announced additional details of the upcoming Service Pack 1 (SP1) here....

Author: Gaurav-MSFT Date: 05/16/2011

Fast Track and PDW

Recently I attended a SQL Server Parallel Data Warehouse (PDW) appliance and FasTrack 3.0 workshop....

Author: Gaurav-MSFT Date: 05/10/2011

NOW AVAILABLE: Windows Azure Toolkit for iOS

As the next step in this process, today we're pleased to announce the release of the Windows Azure...

Author: Gaurav-MSFT Date: 05/09/2011

EPM 2010 Learning Resources

Wanted to share the EPM 2010 learning resoruces Upcoming webcast on May 2011 Software update...

Author: Gaurav-MSFT Date: 05/09/2011

SQL Server Compression Estimator tool

Bob finally released the SQL Server Compression Estimator tool to https://ssce.codeplex.com/ SQL...

Author: Gaurav-MSFT Date: 05/09/2011

Microsoft Makes Strategic Changes in Technology and Business Practices to Expand Interoperability

Microsoft announced a set of broad-reaching changes to its technology and business practices to...

Author: gauravagg Date: 02/25/2008

Latest on EPM 2007

Single reference point for some of the latest stuff on EPM 2007 and other useful stuff for EPM 2007...

Author: gauravagg Date: 01/02/2008

RML Utilities for SQL Server 2005

Most awaited tool for SQL Server DBA and experts (heard of ReadTrace!). Till sometime back these...

Author: gauravagg Date: 01/02/2008

Office Hours: How Bill Gates uses Office

Intresting read - https://office.microsoft.com/en-us/help/HA102402071033.aspx

Author: gauravagg Date: 01/02/2008

Watch Out: Portfolio Server 2007 - Special Characters in Project Name in Portfolio Server 2007

First one in "Watch Out: Portfolio Server 2007" Portfolio Server 2007 has no check for special...

Author: gauravagg Date: 12/28/2007

Visual Studio Team Foundation Server – Project Server 2007 Connector

Finally the much awaited missing link between EPM 2007 and Visual Studio Team Foundation Server is...

Author: gauravagg Date: 06/11/2007

Mapping Custom Fields between Project Server and Portfolio Server 2007

EPM 2007 provides "Project Server Gateway" for mapping the data between Portfolio Server 2007 and...

Author: gauravagg Date: 06/10/2007

Deploying Multiple Instances of Portfolio Server 2007 on single server

From official support perspective running multiple instances of Portfolio Server 2007 on single...

Author: gauravagg Date: 06/10/2007

Synchronizing the Schedule Information between PS 2007 and PPS 2007

One of the common query that I have seen is how to synchronize the schedule information between...

Author: gauravagg Date: 06/10/2007

Sorting values in attribute in Portfolio Server 2007

One of the common ask - how can we sort the list of values displayed in the Portfolio Server 2007...

Author: gauravagg Date: 06/10/2007

Project Conference 2007

One of the most important event for EPM community is around the corner. The session list for the...

Author: gauravagg Date: 06/10/2007

Getting into the world of EPM 2007

Adding another series to my blog list - EPM 2007. I would be posting tips and tricks, announcements...

Author: gauravagg Date: 06/10/2007

Latest Certification for SQL Server 2005

Microsoft has finally launched the public version of "Microsoft Certified Architect : Database"...

Author: gauravagg Date: 06/06/2007

Latest addition to the best practice series. I highly recommend the same for DBA and architects !...

Author: gauravagg Date: 06/05/2007

Latest development on ADO.NET front – Part 2

At Mix 07, the ADO.NET team announced an incubation project that they have been working on, Project...

Author: gauravagg Date: 06/05/2007

Latest development on ADO.NET front – Part 1

Few weeks back at Mix 07 Microsoft announced “Jasper”, an ADO.NET incubation project for building...

Author: gauravagg Date: 06/05/2007

Not sure which SQL Server edition is running!

Quick one – How to check the version of SQL Server product running in production ! SELECT...

Author: gauravagg Date: 06/05/2007

SQL Server 2005 Rocks - another Step to prove enterprise scalability - Latest TPC-H Results

Another step to prove the enterprise scalability of SQL Server 2005. The results are in— Microsoft...

Author: gauravagg Date: 06/05/2007

Peek into future version of SQL (Katmai = SQL Server 2008)

SQL Server Product Team signed off on SQL Server “Katmai” CTP3 (externally known as “June CTP”)....

Author: gauravagg Date: 06/05/2007

New Best Practice Articles

Good reading for weekend for techies!! Implementing Application Failover with Database Mirroring...

Author: gauravagg Date: 05/04/2007

Jargons - GDR and QFE release?

Another quick one for the day – for a frequent query – what is the difference between GDR, QFE and...

Author: gauravagg Date: 04/27/2007

Stored procedure vs. SQL Query

One of the common questions that I face while reviewing the applications at customer site is if SQL...

Author: gauravagg Date: 04/27/2007

SQL Server Standard Edition to Enterprise Edition

Another common query – How can I upgrade from SQL Server Standard Edition to Enterprise Edition Use...

Author: gauravagg Date: 04/27/2007

Windows 2003 SP2 and Performance gains for SQL Server 2005

Faced a question couple of time “What are the performance gains in Win 2003 SP2 for SQL Server 2005...

Author: gauravagg Date: 04/27/2007

Must read for SQL Guys

As a consultant I face a common question where can I find useful whitepapers and reading material on...

Author: gauravagg Date: 04/27/2007

A must for DBA: SQL Server 2005 Performance Dashboard

Microsoft recently released a free download - SQL Server 2005 Performance Dashboard reports. Joint...

Author: gauravagg Date: 04/27/2007

To apply SQL Server 2005 SP2 or not?

A common question from customers; should we apply SP2 or wait. There is no Golden answer; I would...

Author: gauravagg Date: 04/27/2007

Post SQL Server 2005 SP2 Fix

Microsoft recently released an critical updated for post SQL Server SP2 Fix related to issues...

Author: gauravagg Date: 03/07/2007

Another DST Update

Just a quick update to the DST impact on SQL Server Compact Edition before rushing in for routine...

Author: gauravagg Date: 03/05/2007

Don’t miss on – current goodies with SQL Server 2005

Recently Microsoft has release the much awaited SP2 for SQL Server 2005. Guys go and grab it – it...

Author: gauravagg Date: 02/26/2007

Daylight Saving Time (DST) and SQL server puzzle

I am back after a long break. I went into shell to take some deep dive with BizTalk Server 2006,...

Author: gauravagg Date: 02/26/2007

Use the power of .NET in legacy Visual Basic Apps

Microsoft recently released two Visual Basic 2005 Power Packs. Visual Basic 2005 Power Packs are...

Author: gauravagg Date: 09/21/2006

Migrating from SQL 2000 to SQL 2005 - Look for common catch

Recently I was involved in a migration exercice from SQL Server 2000 to SQL Server 2005 and...

Author: gauravagg Date: 09/14/2006

My first Blog entry

Stay tuned for deep .NET and SQL stuff

Author: gauravagg Date: 09/14/2006