The Business Intelligence Blog

November 29, 2009

Change Management – BIAR vs CMS to CMS

Filed under: SAP Business Objects — Tags: , , , , , — Shahfaisal @ 1:20 pm

I have seen people asking this question time and time again – What’s the best way to deal with deployments – BIAR or CMS to CMS transfer?

BIAR is not meant for change management process and is certainly not the best way to deal with changes in your environment as it is very buggy. Refer to this post for more details. Always use CMS to CMS transfer for promotion purpose whenever you can. There isn’t technically anything that you can do with BIAR which is not possible using CMS to CMS. Of course, if your environments(Development, Test, Production) can’t talk to each other, meaning they are on different domains, then your only option is to use BIAR.


November 20, 2009

Building Subreport in Reporting Services

Filed under: SSRS — Tags: , , , — Shahfaisal @ 11:22 am

This blog post has been moved to

November 14, 2009

SQL Server 2005 Performance Troubleshooting and Tuning

Filed under: SQL Server webcasts — Tags: , , , , — Shahfaisal @ 5:14 pm

Part 1
TechNet Webcast: SQL Server 2005 Performance Troubleshooting and Tuning (Part 1 of 2) (Level 200)

Part 2
TebchNet Webcast: SQL Server 2005 Performance Troubleshooting and Tuning (Part 2 of 2) (Level 200)

November 13, 2009

MDX queries, concepts etc.

Filed under: SSAS webcasts — Tags: , — Shahfaisal @ 10:47 pm

MSDN Webcast: Creating Analytical Multidimensional Expression (MDX) Queries (Level 200)

November 12, 2009

SQL Server in-place vs side-by-side upgrade

Filed under: SQL Server Database — Tags: , , , , — Shahfaisal @ 11:46 pm

In an in-place upgrade, you stick in a CD, run the setup file and choose the upgrade option. The setup program will automatically upgrade older version of SQL Server to the new version and the older instance of SQL Server is replaced.

In a side-by-side upgrade, you install a separate instance of SQL Server(either on the same box or on a different one) and then move all the content(Databases, users/logins, etc) from the the older instance of SQL Server to the new instance.

What’s the best method to use for upgrade: Well, there is no “best” method, there is however, a “right” method. If you don’t have a separate hardware for a clean SQL Server 2008 install or if you can’t afford to install SQL Server 2008 as a separate instance on your current production box due to performance issues, your only option is to perform an in-place upgrade. Please note that an in-place upgrade is an all-or-nothing approach and so is more risky than a side-by-side upgrade. However, if you have a separate server, a separate clean install would always be better as it will not affect the current production instance (there by providing greater availability) and you will have plenty of time to test your stuff before going live with the new version.

Note: Regardless of which method you choose to upgrade, be sure to run Upgrade Adviser to find out the bottlenecks that might affect your upgrade. It also provides links to documentation that will help you resolve any issue that you might come across during upgrade. Download upgrade adviser here

Older Posts »

Blog at