Microsoft Data Platform Update: "In-memory Tech Built into SQL Server Next, SQL 2012 SP1, PDW, SDDT Power Tools November 2012" Announced

At Professional Association of SQL Server (PASS) Summit 2012 in Seattle, Microsoft's cvp, Ted Kummert, anounce new capabilities for the data platform that will help businesses accelerate their time to insights with any type of data.Project codenamed "Hekaton," is a new in-memory technology currently in private technology preview with a small set of customers will […]

At Professional Association of SQL Server (PASS) Summit 2012 in Seattle, Microsoft's cvp, Ted Kummert, anounce new capabilities for the data platform that will help businesses accelerate their time to insights with any type of data.

Project codenamed "Hekaton," is a new in-memory technology currently in private technology preview with a small set of customers will ship in the next major version of SQL Server. "Hekaton" will complete Microsoft's portfolio of in-memory capabilities across analytics and transactional scenarios and offer customers performance gains of up to 50 times.

"In-memory computing is a core element of Microsoft's strategy to deliver a data platform that enables customers to analyze all types of data while also accelerating time to insight. Because Microsoft's in-memory solutions are built into SQL Server, customers don't need to buy specialized hardware or software and can easily migrate existing applications to benefit from the dramatic performance gains," Microsoft posted.

"We've been delivering advanced in-memory technologies as part of SQL Server since 2010. Since then, we have shipped more than 1.5 million units to customers, making it the most pervasive data platform of its kind with in-memory technologies built in," Kummert added.

SQL Server 2012 Parallel Data Warehouse (PDW), available in the first half of 2013 -- is the next version of Microsoft's enterprise-class appliance "that will include a new data processing engine called PolyBase, which will enable queries across relational data and non-relational Hadoop data to drastically reduce time to insight with any data," Microsoft writes. Built to tackle customers' big data challenges, "SQL Server 2012 PDW will offer next-generation performance at scale and a redesigned architecture to reduce hardware footprint, all at the lowest total cost in the industry."

SQL Server 2012 Service Pack 1 (SP1), is now generally available as of today. "SQL Server 2012 SP1 supports Office 2013 by offering business users enhanced, new capabilities for self-service business intelligence using familiar tools such as Excel and SharePoint," informs Micorsoft.

Customers can "also now seamlessly scale out self-service business intelligence solutions in SharePoint 2013 with the breakthrough performance of scanning 20 billion rows of data per second."

The download cotains:

  • Microsoft SQL Server 2012 SP1 Update to be applied to existing SQL Server 2012 installations.
  • Microsoft SQL Server 2012 SP1 Slipstream package provides the capability to perform new SQL Server 2012 instance installations (or SQL Server 2008/SQL Server 2008 R2 Upgrades) culminating with Service Pack 1 pre-installed.

The SQL Server 2012 SP1 can be downloaded from Microsoft Download Center.

In addition, SQL Server Data Tools November 2012 released is available now. "SSDT - November 2012 is coordinated with the release of SQL Server 2012 Service Pack 1 and it chains in the latest SQL Server components," Microsoft stated.

"The November 2012 update of SSDT is only compatible with the latest SSDT Power Tools (v 1.4)," Microsoft added.

Please note "that if you have an existing version of SSDT Power Tools, it will need to be upgraded in order to work with SSDT - November 2012."

The SQL Data Tools (SSDT) can be downloaded using the following links: