

Microsoft had given advance notice that SP2 was coming back in February, although it didn't say when it would arrive.

A list of all of the fixes in SP2 can be found in this Microsoft support article. Microsoft notes the highlights of the SP2 release in this blog post. Reporting Services now warns if a large HTML report will cause a performance hit. Microsoft added some performance fixes to the product's relational engine and storage engine. Integration Services, the data integration capability in the product, got a fix for a deadlock issue. Analysis services, the Online Analytical Processing (OLAP) tool in the product, got local cube creation support with SP2. Microsoft added some supportability and functionality fixes to AlwaysOn, which is its high-availability and disaster recovery capability in SQL Server 2012. SQL Server 2012 SP2 contains updates based on customer feedback since the last service pack and since the release of Cumulative Update 9. Also released this week are SQL Server 2012 SP2 Report Builder, which supports report publishing and data visualizations, and SQL Server 2012 SP2 Feature Pack, which provides the latest tools and add-ons for Microsoft's relational database management system. Microsoft is offering SP2 in 32-bit and 64-bit versions for SQL Server 2012, as well as the Management Studio and Express versions. SQL Server 2012 SP2 can be downloaded here, but it will arrive via the Microsoft Update service by the end of July. That's an old-fashioned Microsoft term suggesting that the software is ready for imaging on hardware by equipment providers - in other words, a commercial-ready release. The SP2 release goes by the "RTM" (release to manufacturing) nomenclature, according to Microsoft's announcement. Microsoft released SQL Server 2012 Service Pack 2 this week.
