Home > Business Intelligence > Different Combinations of Microsoft Products for DW/BI solutions: The hide and seek game never ends.

Different Combinations of Microsoft Products for DW/BI solutions: The hide and seek game never ends.


It has never quite reached its steady state for DW/BI profesionals since Microsoft released Visual Studio 2008.

1. Visual Studio 2008 worked well with Sql Server 2008, it had support for BIDS (Business Intelligence Development Studio which is essentially SSIS, SSAS and SSRS), but it missed support for SQL Server 2008 Database Projects. It only supported SQL Server 2005 Database projects.

2. So Visual Studio 2008 Service Pack 1 came and nothing changed for DW/BI professionals.

3. And then came  Visual Studio 2008 GDR R2. It fixed all the problems, but it was too late and SQL Server 2008 R2 was ready to kick out Sql Server 2008.

4. Visual Studio 2008 GDR R2 didn’t like Sql Server 2008 R2 for database projects and life was back to mix and match of products; lose some gain some.

5. Visual Studio 2010 came and started working well with Sql Server 2008 R2 database projects. Guess what it stopped supporting BIDS 🙂 They had to do it.

So I now hoping that that Visual Studio vNext will support the upcoming SQL Server 2011 (code named DENALI) and it will also have support for BIDS.

These days, I work on Visual Studio 2008 SP1 GDR2 to be able to connect to SQL Server 2008 R2 for BIDS projects. And I use Visual Studio 2010 for working on the SQL Server 2008 R2 database projects.

So much so for all this product versions from Microsoft.

Advertisements
  1. July 8, 2012 at 6:03 pm

    Update: With a combination of Visual Studio 2010 SP1, SQL Server 2012 and Visual Studio Data Tools, Microsoft seems to have finally got it right. Sharepoint 2010 along with Office 365 has added to the charm.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: