SQL Server 2012 Gets First Service Pack

Upgrades include improved business intelligence capabilities, Reporting Services support for SharePoint.

Service Pack 1 for SQL Server 2012 is now available.

The news was delivered in a keynote kickoff presentation at the PASS event, which is being held this week in Seattle. Ted Kummert, corporate vice president of Microsoft's Business Platform Group, introduced a number of demos showcasing existing and new technologies at work. He also gave an overview of Microsoft's overall direction in addressing business needs with its flagship relational database management system.

Key themes of the talk included access to self-service business intelligence (BI) through the use of user-friendly Excel-based tools, the use of "in-memory" technologies and the ability of organizations to tap unstructured data sources to gain business insights. Kummert said that Microsoft has "fully integrated Power View and PowerPivot into Excel 2013." According to Microsoft's self-service BI conception, knowledge workers can use those familiar tools to glean business insights from piles of data without bothering IT too much.

The keynote talk with the demos can be accessed on-demand here. However, IT pros likely will want to get their hands on Service Pack 1 of SQL Server 2012. The new service pack can be downloaded at this page.

SP1 for SQL Server 2012 adds some important capabilities that Microsoft had previously touted when it released the server back in April. For instance, the service pack enables "self-service BI as a natural part of users' day-to-day activities in Excel 2013." It adds the ability of users to mash up data from various sources using Excel's PowerPivot or create visualizations from data using Power View. It allows users to use Microsoft's xVelocity column store index to work with "hundreds of millions of rows of data." SQL Server Reporting Services improvements to support SharePoint 2013 also are available from this service pack.

SP1 supports cross-cluster migration of AlwaysOn availability groups. It adds a "selective XML index" capability, which is designed to improve querying XML data. Microsoft also added a way for IT pros to install SQL Server 2012 using a "prebuilt slipstream image," which simplifies the setup process. More SP1 improvements are listed in this TechNet library article.

Parallel Data Warehouse Arriving in 2013
Also announced at the keynote was the forthcoming availability of SQL Server 2012 Parallel Data Warehouse product, which Microsoft indicated would happen sometime in "the first half of 2013." This product will include a new "PolyBase" data processing engine, which is used to query Hadoop data, either from relational or nonrelational data sources.

Christian Kleinerman, a principal group program manager at Microsoft, showed a demo illustrating PolyBase. He said that if you know how to use T-SQL, then you just need to learn one new concept to tap the power of the PolyBase engine. IT pros need to create what's called "an external table." He ran a query that enjoins forms column table data with data from an order table.

"It's just another datasource for the query engineā€¦. That's PolyBase," Kleinerman said.

He also showed speed improvements in Microsoft's current xVelocity column store index in-memory solution. In past demos, Microsoft clocked the counting of rows in wide tables at about 100 terabytes of data in two minutes. During today's demo, with a row count of 294 billion, SQL Server 2012 delivered 1 petabyte of data in one second. The speed improvement is because of Microsoft's xVelocity technology, according to Kleinerman. The xVelocity technology also provides storage savings. It can shrink the space needed by up to ten times, Kleinerman claimed.

Future "Hekaton" In-Memory Technology
Microsoft's "next major version of SQL Server" will include a new in-memory transactional technology called "Hekaton." If an organization has applications that need to run faster, then Hekaton can provide a solution, said Shawn Bice, director of program management of the Database Systems Group at Microsoft. Hekaton converts tables so they run in memory. Hekaton will be built into the next SQL Server and it won't require hardware or software upgrades to run, according to Microsoft. The Hekaton solution is currently being testing by online gambling company bwin. It's only available in a "private technology review with a small set of customers," according to a blog post by Kummert.

Also demonstrated during the keynote was the use of Microsoft's BI tools to gain insight from unstructured data. Amir Netz, a Technical Fellow on the Microsoft BI team, showed how to gain insights about movie star branding using unstructured Twitter data. He used Microsoft's new HDInsight connector solution to collect 12 million Twitter tweets about movie stars and charted it according to the publicity associated with the Academy Awards. Some stars, like Brad Pitt, did not have big spikes of interest by the time of the Academy Awards because he's generally popular, according to Netz's analysis of the data. He used Power View, part of SharePoint Services, to chart the information over time.

Microsoft previously announced previews of HDInsight Server for Windows and the Windows Azure HDInsight Service last month. HDInsight uses a bidirectional connector, which allows data to be moved between Hadoop and SQL Server 2012 or SQL Server 2012 Parallel Data Warehouse in order to analyze structured data.

About the Author

Kurt Mackie is senior news producer for 1105 Media's Converge360 group.

comments powered by Disqus


  • Death of the Dev Machine?

    Here's a takeaway from this week's Ignite 2020 event: An advanced Azure cloud portends the death of the traditional, high-powered dev machine packed with computing, memory and storage components.

  • COVID-19 Is Ignite 2020's Elephant in the Room: 'Frankly, It Sucks'

    As in all things of our new reality, there was no escaping the drastic changes in routine caused by the COVID-19 pandemic during Microsoft's big Ignite 2020 developer/IT pro conference, this week shifted to an online-only event after drawing tens of thousands of in-person attendees in years past.

  • Visual Studio 2019 v16.8 Preview Update Adds Codespaces

    To coincide with the Microsoft Ignite 2020 IT pro/developer event, the Visual Studio dev team shipped a new update, Visual Studio 2019 v16.8 Preview 3.1, with the main attraction being support for cloud-hosted Codespaces, now in a limited beta.

  • Speed Lines Graphic

    New for Blazor: Azure Static Web Apps Support

    With Blazor taking the .NET web development world by storm, one of the first announcements during Microsoft's Ignite 2020 developer/IT event was its new support in Azure Static Web Apps.

  • Entity Framework Core 5 RC1 Is Feature Complete, Ready for Production

    The first release candidate for Entity Framework 5 -- Microsoft's object-database mapper for .NET -- has shipped with a go live license, ready for production.

Upcoming Events