SQL Server 2012 SP1 CTP4 is released

September 30th, 2012 by Stephen Jones Leave a reply »

SQL Server 2012 SP1 CTP4

  • AlwaysOn Availability Group OS Upgrade: With the release of SQL Server 2012 RTM the operating system upgrade story for AlwaysOn customers without taking significant downtime to perform a data migration does not exist. Windows Server 2008 and Windows Server 2008 R2 do not support an upgrade of clustered servers from previous versions, because of incompatibilities between the cluster versions. SQL Server 2012 SP1 provides a compatibility solution to do Availability Group migration from a lower version of Windows Cluster to a higher version of Windows Cluster. It can help when upgrading Windows Cluster operating systems.
  • Selective XML Index Performance Update: Selective XML Index solves a longstanding  performance issue by allowing users to promote certain paths from their XML documents that will be indexed. The update introduces a new type of XML index to SQL Server in addition to Primary XML Index (PXI). The new indexing will improve querying performance over data stored as XML in SQL Server, thus allow for much faster indexing of large XML data workloads and improve on scalability by reducing storage costs of the index itself.
  • SSMS Complete in Express: SQL Server 2012 SP1 Express Editions (SQL Server Express With Tools, SQL Server Express COMP, SQL Server Express with Advanced Services and SQL Server Management Studio Express) will now ship the SSMS feature with functionalities that existed with the SSMS from Full Editions of SQL Server.
  • SlipStream Full installation: The SlipStream deployment/packaging capability provides  a pre-built “Slipstream image” consisting of a compressed self-extracting .exe and a ‘.box’ payload file that contains a SQL Server 2012 RTM image (Setup.exe, MSI’s, etc.) along with the most recent Service Pack. Previously this capability was only provided with the Express SP packages. As with Express Slipstream, users can exercise the .exe just as they would Setup.exe.
  •  SQL Server 2012 SP1 CTP4 also contains a number of security updates and fixes released in SQL Server 2012 CU1 & CU2.

For a complete list of changes in SQL Server 2012 SP1 CTP4 read the What’s new document and KB article 2674317.


Leave a Reply

You must be logged in to post a comment.