.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Business Intelligence opinion on upgrade features

Posted By:      Posted Date: October 15, 2010    Points: 0   Category :Sql Server

I'm looking at upgrading some ( 13 including my DR site ) servers from 2005 to 2008 or 2008 R2.  I don't work for a huge shop ( in terms of SQL installations ).  I support primarily 3rd party applications on the servers, an increasing number of in-house applications.  I do have each server configured to do log shipping to a DR site via LiteSpeed logshipping - so the log shipping is really my only "different" factor.

I've verified with my 3rd party vendors that they ( almost ) all support 2008 R2 now - waiting on 1 more.

I'm just wondering - are there "smaller business" reasons to utilize the R2 release?  It looks to me like it's focussed more on larger scale installations.  Are there any significent performance enhancements in the engine that make it a more attractive upgrade than the initial 2008 release?

I'd welcome your input!


This is for BIDN, - // Upgrading from 2005 to 2008 (R2?)

View Complete Post

More Related Resource Links

Business Intelligence Development Studio



            I installed Visual studio 2008. I want to open Reports. I want to install Business Intelligence development studio for that.

May I know how to install that one. Is Business Intelligence development studio comes with Visual studio 2008.

Please tell me, I m new to this concept.


Business Intelligence Reports Project in Visual studio 2008 ?



I wonder how to add a project template called  Intelligence Reports, something like that, to Visual studio 2008. I have SQL 2008 installed. Do I need to install some updates to get Intelligence Reports template to Visual studio 2008 ?

Thank you..

Developer Training: Business Intelligence SharePoint 2010

SharePoint 2010 provides a flexible platform to expose business intelligence (BI) functionalities for end users by using platform capabilities, all through a familiar user interface. This training module shows how.

Video: What is Business Intelligence in SharePoint 2010?

Learn about the SharePoint 2010 Business Intelligence (BI) tools for bringing information together for analysis and collaboration to support business decisions. Available tools include status indicators; chart Web Parts, PerformancePoint Services, Excel Services, BI Search, and Visio Services. (Length: 11:51)

Video: SharePoint 2010 Business Intelligence (BI) Primer

If you are new to BI, this video will get you up to speed quickly. You will learn about some of the new BI features in SharePoint 2010, such as Excel Service and PerformancePoint Services. (Length: 11:51)

Video: Excel Services and SharePoint 2010 Business Intelligence

In this video you will learn how to create BI applications using Excel Services. (Length: 10:26)

Video: PerformancePoint Services and SharePoint 2010 Business Intelligence

PerformancePoint Services is all about surfacing data to users in a dashboard format to allow users to create business decisions based on the dashboard information. (Length: 11:51)

Time Dimension Enhancement with Business intelligence Issue

Hi all, I want to add a year over year growth using the BI wizard (Time diemsion enhancement) but when I try to add this enhancement via the wizard then this last one has the button next disabled with a waning that says   A time dimension is required to enable this functionality. Ensure that you have a dimension of type Time, that contains at least one hierarchy with a level flagged as a time period. Inspite of the fact that I added that time dimsension with one hierarchy Time hierarchy Calendar Year Calendar Semester Calendar Quarter Time Key(With namecolumn defined as a named calculation that repsents the day with this format  yyyy, dd mm ) Me personaly I have a doubt about the last condition of the warning (with a level flagged as a time period) but I dont know exactly 1. If my doubt is right 2. What shoud I do to enhance the cube in this context using the time dimension enhancement The complexity resides in the simplicity

Sharepoint 2010 Business Intelligence integration with datasources other than MS SQL Server

I want to Implement Business Intelligence by SharePoint 2010 on top of data sources other than MS SQL Server or MS Analytics Services ( cubes ), for example Oracle RDBMS and Oracle OLAP ( cube ) or Teradata. Quesiton : Is there any way to do this, if the is, how do I bring metadata to sharepoint BI or how do I make SharePoint BI to see other data source. I've looked at Busines Data Connectivity in Visual Studio, but that is more for two way integration and didn't seem like a good or easy way just to bring new data sources to SharePoint BI I found some tool from third party company "BDC Meta Man" which created metadata layer for Oracle RDBMS in SharePoint, but I thought there must be a way to do it by using Microsoft tools

Publishing reports from Business Intelligence to Sharepoint Services 2007

We currently have sharepoint services 2007 and SQL server 2005 installed (with reporting services) and Sharepoint SQl web part on a single box named 'king-sharepoint'.   We have sucessfully setup the reporting services from Native to integrated sharepoint with a db name of 'spkingsdb'. We are trying to publish reports to the sharepoint database using Visual Studio, as we are new to sharepoint we are confused as to how to achieve this.  We understand to publish it we need to know the path of the database (reportserver(spkingsdb)), the folder in which the reports will be published to (do we create this? If so then how?), and the server name (http://king-sharepoint/reportserver).  thanks

Comparison of Performance Point and Oracle Business Intelligence

Hello, Can someone provide me with an article that compares Oracle BI with Performance Point? Thanks in advance, Shelley

What is the latest version of Business Intelligence Development Studio (BIDS) 2005

When open BIDS 2005 and go to help ---> about i see the following: Microsoft Visual Studio 2005 Version 8.0.50727.42  (RTM.050727-4200) Microsoft .NET Framework Version 2.0.50727 SP2 Do I have the latest service pack installed for BIDS?

How to enable SSIS functions from MS SQL Server R2 Express Business Intelligence Studio Express


My MS SQL Server R2 Business Intelligence Studio Express can not support SSIS functions after I install MS SQL Server Full Evaluation instance and the SSIS service is running well on my Window 7 professional laptop. Is there anyway to enable the SSIS functionalities from the original Business Intelligence Studio Express? Thanks for your help.




Create and Deploy Charts using SQL Server Business Intelligence Development Studio 2005


Hi All,

Does any one have good blogs for creating different types of charts using SQL Server Business Intelligence Development Studio 2005 which pulls data from the sharepoint list and display in graphical format. iam new to SSRS.

Thanks in advance

HELP! Installed new MS Products, ate my Business Intelligence Studio



I'm completely stumped by this one.


Yesterday I installed Microsoft Visio Professional 2003 and Microsoft Project 2003.


Today when I open any of my SSIS packages I get this:

There were errors while the package was being loaded.

The package might be corrupted.

See the Error List for details.


The error list says: Unable to instantiate XML DOM document please verify that the MSXML binaries are properly installed and registered.


When I try to create a new integration services project I get the following modal message box:


Failed to save Package File C:\Documents and Settings\MyName\LocalSettings\Temp\tmp172.tmp with error 0x8002802B - Element Not Found


Yet I can create and run a small C# program no problem, and SQL Server Management Studio seems to be OK.


What do I need to de-install and buy a seperate computer for here?  Is it Visio or Project?


Thanks in advance

Microsoft SQL Server Business Intelligence tool


May I know when will next version of SQL Server 2008 R2 be released?

Just wanted to see on VS 2010 compatible version.

Business Intelligence Center Template Missing


Have installed SP 2010 on Windows Server 2000 and SQL Server 2008 R2.

Everything seems to be working fine.  I have gone to my top level site in my default web collection (Port 80) and under Page Laytou and Site Template Settings have allowed any subsite to use any site template.  In that list, I can definately see "Business Intelligence Center (All)".

However, when I go to create a new site and it asks me for a template, I don't see the "Busines Intelligence Center (All)" template.   Thinking this was a bug I deleted the web application and recreated it and a site collection and the same thing.  

So just for fun, I created a 2nd web appliction on Port 90 and created the same type of site collection and everything works fine.  I can add the BI template.

Am I missing something here?
My Ramblings @ http://alanwhitehouse.wordpress.com
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend