Microsoft SQL Server 2012 Vs. Oracle: Customers Voting - InformationWeek
Software // Information Management
09:43 AM
Connect Directly
[Cybersecurity] New Methods for Managing the Skills Shortage
Jun 06, 2017
In this webinar, security experts discuss methods for doing better security with fewer people, inc ...Read More>>

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.)

2 of 2
Comment  | 
Print  | 
More Insights
Threaded  |  Newest First  |  Oldest First
D. Henschen
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
How Enterprises Are Attacking the IT Security Enterprise
How Enterprises Are Attacking the IT Security Enterprise
To learn more about what organizations are doing to tackle attacks and threats we surveyed a group of 300 IT and infosec professionals to find out what their biggest IT security challenges are and what they're doing to defend against today's threats. Download the report to see what they're saying.
Register for InformationWeek Newsletters
White Papers
Current Issue
2017 State of Data and Analytics
Today's companies are differentiating themselves using data analytics, but the journey requires adjustments to people, processes, technology, and culture. 
Twitter Feed
InformationWeek Radio
Archived InformationWeek Radio
Join us for a roundup of the top stories on for the week of November 6, 2016. We'll be talking with the editors and correspondents who brought you the top stories of the week to get the "story behind the story."
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.
Flash Poll