Hitesh Shah
15th October 2007, 13:21
Here is a good article on how existing user of a pure data warehouse only finds DW
capabilities of SQL 2k5 very interesting .
Do u need a data warehouse (http://www.sqlservercentral.com/articles/Design/doyouneedadatawarehouse/2460/)
There is good price comparision in favour of SQL 2k5 done in this link .
Flying high with BI (http://www.intelligententerprise.com/showArticle.jhtml?articleID=167100274&pgno=1)
Even Oracle too has OLAP DW features but are available only in its enterprise edition
whereas SQL 2005 offers good data warehousing capabilities in it's standard edition
itself . OLAP / BI capabilities of SQL 2k5 has been one reason for increasing dominance
of MSSQL in both database market (relational as well as multi-dimensional).
Increasing influence of large BI vendors (in comparision to pure play BI
vendors ) had been predicted by Gartner this year .
Business Intelligence market growth in 2007 (http://www.gartner.com/it/page.jsp?id=500680)
And its acknowledged in current year's magic quandrant.
Microsoft is Positioned in Leaders Quadrant of Latest Magic Quadrant for Data Warehousing (http://money.cnn.com/news/newsfeeds/articles/prnewswire/AQF021A12102007-1.htm)
Probably the increasing dominance of MS SQL can be a reason behind recent takeovers of hyperion
(by oracle ) and business objects (by SAP).
capabilities of SQL 2k5 very interesting .
Do u need a data warehouse (http://www.sqlservercentral.com/articles/Design/doyouneedadatawarehouse/2460/)
There is good price comparision in favour of SQL 2k5 done in this link .
Flying high with BI (http://www.intelligententerprise.com/showArticle.jhtml?articleID=167100274&pgno=1)
Even Oracle too has OLAP DW features but are available only in its enterprise edition
whereas SQL 2005 offers good data warehousing capabilities in it's standard edition
itself . OLAP / BI capabilities of SQL 2k5 has been one reason for increasing dominance
of MSSQL in both database market (relational as well as multi-dimensional).
Increasing influence of large BI vendors (in comparision to pure play BI
vendors ) had been predicted by Gartner this year .
Business Intelligence market growth in 2007 (http://www.gartner.com/it/page.jsp?id=500680)
And its acknowledged in current year's magic quandrant.
Microsoft is Positioned in Leaders Quadrant of Latest Magic Quadrant for Data Warehousing (http://money.cnn.com/news/newsfeeds/articles/prnewswire/AQF021A12102007-1.htm)
Probably the increasing dominance of MS SQL can be a reason behind recent takeovers of hyperion
(by oracle ) and business objects (by SAP).