SQL Server Magazine May 08' Cover Story: Does SQL Server 2008 BI Merit Upgrade?

Long time no blog!

I authored this month's (May 08') cover story on an interesting topic...Does SQL Server 2008 BI enhancements warrant an upgrade? It is quite the question and to be honest I dont think a 'one size fits all' reply would do the question justice AT ALL! For example, the scalability/performance enhancements found in the relational engine (ie Partioned Table Parallelism & Star Join Query Optimizations) are not applicable for a BI/SQL Server environment if the current cube processing/queries to the underlying schema are performing very well as is! If you do not perform any data profiling nor have any intention to than the new SSIS Data Profiling Task will obviously not be of much use to you or your client organization either! You could counter every new enhancement in the SQL Server 2008 BI stack with a reason why you do not need to upgrade...atleast as of today!

What do you think??? Is there ever such a thing as a 'gotta have' feature found in our beloved SQL Server product? In the context of BI I would say SQL Server 2005 defenitly brought about several close such features but even then (and now) folks are still running SQL Server 2000 based BI systems/environments just fine! So what do you think?

Cheers

Derek Comingore

Print | posted on Wednesday, April 30, 2008 12:31 AM

Feedback

# re: SQL Server Magazine May 08' Cover Story: Does SQL Server 2008 BI Merit Upgrade?

Left by Frank Anson at 5/27/2008 12:14 AM
Gravatar Table-type input/output UDF function/stored procedure parameters that actually work.

# re: SQL Server Magazine May 08' Cover Story: Does SQL Server 2008 BI Merit Upgrade?

Left by columbia jackets at 10/21/2010 4:33 PM
Gravatar I would say SQL Server 2005 defenitly brought about several close such features but even then (and now) folks are still running SQL Server 2000 based BI systems/environments just fine! So what do you think?

snow boots for women | columbia sportswear outlet | cheap mac makeup | the north face jackets

womens snow boots | columbia sportswear | cheap makeup | cheap north face jackets
Comments have been closed on this topic.

Copyright © Derek Comingore

Design by Bartosz Brzezinski

Design by Phil Haack Based On A Design By Bartosz Brzezinski