Software // Information Management
News
4/9/2012
09:43 AM
Connect Directly
LinkedIn
Twitter
Google+
RSS
E-Mail
50%
50%

Microsoft SQL Server 2012 Vs. Oracle: Customers Voting

Despite licensing cost increases, early-mover customers give upgrade to Microsoft's flagship database the nod on affordability compared to Oracle and IBM offerings.

SQL Server 2012 As BI Platform

We didn't break out our database satisfaction scores by brand, but by all accounts Microsoft SQL Server has gained share in recent years on the strength of its competitive cost. That's particularly true for data warehousing and business intelligence deployments, where SQL Server's build-in Integration Services, Reporting Services, and Analysis Services, along with front-end options including SharePoint and Office Excel, have helped fuel market share gains in recent years.

When digital ad services firm Havas Media started planning a BI deployment two years ago, the promise of employee and customer self-service is what clinched the choice of SQL Server over BI alternatives from MicroStrategy and Oracle, according to Tony Jaskeran, head of BI at the London-based firm. In particular, he says, the combination of Microsoft's PowerPivot in-memory add-in for Excel and Excel Services lets the firm share analyses and reports with customers through the SharePoint portal.

"We don't have a large information services team, so we wanted a technology that would give our business users ownership of the data with an ability to build their own reports," Jaskeran explained.

Havas initially deployed on SQL Server 2008 R2 early last year, but by fall it was testing SQL Server 2012, hoping to exploit new column-store compression capabilities. Havas completed a three-month migration of its production data warehouse to SQL Server 2012 in March.

The Havas deployment, which is used to track search and impression clickstream data, is big and destined to get bigger, as it's currently analyzing data from only two of 10 ad servers. The database already holds 100 terabytes of data, and the firm is adding 300 million new rows of data each day. That's an impressive scale that would have been hard to sustain on 2008 R2. Jaskeran says SQL Server 2012 upgrades including columnar compression have contributed to a 25% improvement in ETL (data loading) and query performance, compared to Havas' 2008 R2 deployment.

Havas also plans to exploit Power View, an in-memory data visualization interface introduced in SQL Server 2012, but the firm has just started to experiment with dashboards based on the technology.

To get all 10 ad servers online and handle long-term growth, Jaskeran says Havas will likely need to upgrade to the SQL Server 2012 Parallel Data Warehouse (PDW) edition, but that's not in the plan or the budget for this year, he said. PDW provides an option to scale out by exploiting massively parallel processing.

One SQL Server 2012 migration caveat from Balitsky: check the database compatibility of your third-party apps before assuming you can migrate. Virginia Beach wants to take advantage of SQL Server 2012 AlwaysOn high-availability features with as many applications as possible, but Balitsky said most of the city's third-party applications that run on SQL Server have yet to be certified on new database.

We're only one week into the general availability of Microsoft SQL Server 2012. It could be a year before an anticipated wave of migrations really gets rolling.

Our State Of Storage 2012 report highlights promising new technologies that aren't yet on most respondents' radar and offers advice as you plan your 2012 storage strategy. (Free registration required.)

Previous
2 of 2
Next
Comment  | 
Print  | 
More Insights
Comments
Newest First  |  Oldest First  |  Threaded View
D. Henschen
50%
50%
D. Henschen,
User Rank: Author
4/9/2012 | 5:15:29 PM
re: Microsoft SQL Server 2012 Vs. Oracle: Customers Voting
I've revised this article to remove "double-digit annual" from the description of Microsoft's BI market share gains. Indeed, Microsoft has seen double-digit gains in BI marketshare over the last five years, but it has not seen such gains every year. In 2009, for instance, Microsoft had a 8.1% market share gain, the largest of any vendor that year, according to IDC figures. But in the very latest data available, Gartner numbers for 2011 published just last week (April 2) show Microsoft BI market share was flat from 2010 to 2011 at 8.7%. Thus, Microsoft held steady as the fifth-largest BI vendor (in terms of revenue) after SAP, Oracle, SAS, and IBM, respectively. -- Doug Henschen
The Agile Archive
The Agile Archive
When it comes to managing data, donít look at backup and archiving systems as burdens and cost centers. A well-designed archive can enhance data protection and restores, ease search and e-discovery efforts, and save money by intelligently moving data from expensive primary storage systems.
Register for InformationWeek Newsletters
White Papers
Current Issue
InformationWeek Tech Digest, Nov. 10, 2014
Just 30% of respondents to our new survey say their companies are very or extremely effective at identifying critical data and analyzing it to make decisions, down from 42% in 2013. What gives?
Video
Slideshows
Twitter Feed
InformationWeek Radio
Sponsored Live Streaming Video
Everything You've Been Told About Mobility Is Wrong
Attend this video symposium with Sean Wisdom, Global Director of Mobility Solutions, and learn about how you can harness powerful new products to mobilize your business potential.