Access your Pro+ Content below.
Cost, proliferation power rise of SQL Server data warehousing
This article is part of the December 2011, Vol. 8 issue of SQL Server Insider
Data warehousing technology has been filtering down from large companies to small lately, as businesses across the corporate landscape scramble to take advantage of business intelligence (BI) reporting and analytics. With a strong product and lower costs, Microsoft SQL Server has positioned itself as a serious contender for the midmarket data warehousing business and -- increasingly -- the data warehousing market as a whole, analysts say. “Ever since SQL Server 2005 came out, Microsoft has been capable of supporting data warehouses,” said Donald Feinberg, an analyst at research firm Gartner Inc. in Stamford, Conn. “Because SQL Server is generally less expensive than most other databases, its rise to prominence should be no surprise.” SQL Server 2008 R2 brought more features to the party, particularly ones that supported both data warehousing and business intelligence. As Microsoft’s flagship relational database management system, SQL Server has long suffered from a market perception that it’s best for handling smaller databases ...
Features in this issue
Microsoft is forever tinkering with SQL Server stored procedures to give queries more thrust. Find out what’s new in SQL Server 2008, 2008 R2 and the next-generation 2012 release.
News in this issue
With tool sets still evolving, developers face stiff challenges in integrating data in hybrid SQL Server-SQL Azure environments.
SQL Server data warehousing may have seemed a misnomer a few years ago. But many Microsoft shops with growing data needs are seeing the benefits of native products.