Download the Preview: Microsoft SQL Server 2014 Community Technology Preview 2 (CTP2)
Microsoft SQL Server 2014 brings to market new in-memory capabilities built into the core database, including in-memory OLTP, which complements our existing in-memory data warehousing and BI capabilities for the most comprehensive in-memory database solution in the market. SQL Server 2014 also provides new cloud capabilities to simplify cloud adoption for your SQL databases and help you unlock new hybrid scenarios.
Register, then download and install full-featured software for preview Evaluation expires on March 31, 2014.
Receive two (2) emails: resources to guide you and a notification of the next release.
GET STARTED NOW
ISO 64-bit and 32-bit CAB 64-bit and 32-bit SQL Server 2014 CTP2 on Windows Azure
English, Chinese (Traditional), German, Japanese, Spanish
Some components in this Community Technology Preview have certain Internet-enabled features, including the Customer Experience Improvement Program and Error and Usage Reporting component, enabled by default to help us identify and address issues that you may encounter while using SQL Server. For more information and instructions on how to disable these features, see the
Microsoft SQL Server 2014 CTP2 Privacy Statement.
In-Memory OLTP: Provides in-memory OLTP capabilities built into core SQL Server database to significantly improve the performance of your database application. In-Memory OLTP is installed with the SQL Server 2014 Engine without requiring any additional actions and allows in-memory performance benefits without rewriting your database application or refreshing your hardware. SQL Server 2014 CTP2 enhancements include AlwaysOn support, increased TSQL surface area, and ability to migrate existing objects to In-Memory OLTP.
In-Memory Updateable ColumnStore: Provides higher compression, richer query support and updateability of the existing ColumnStore for data warehousing workloads giving you even faster load speed, query performance, concurrency, and even lower price per terabyte.
Extending Memory to SSDs: Seamlessly and transparently integrates solid-state storage into SQL Server by using SSDs as an extension to the database buffer pool, allowing more in-memory processing and reducing disk IO.
Enhanced High Availability
New AlwaysOn features: Availability Groups now support up to 8 secondary replicas that remain available for reads at all times, even in the presence of network failures. Failover Cluster Instances now support Windows Cluster Shared Volumes, improving the utilization of shared storage and increasing failover resiliency.
Improved Online Database Operations: Includes single partition online index rebuild and managing lock priority for table partition switch, reducing maintenance downtime impact.
Encrypted Backup: Provides encryption support for backups, on-premise and in Windows Azure.
IO Resource Governance: Resource pools now support configuration of minimum and maximum IOPS per volume, enabling more comprehensive resource isolation controls.
Smart Backup: Provides management and automation of SQL Server backups (from on-premise and Windows Azure) to Windows Azure storage.
Add Azure Replica Wizard: Easily add replicas in Windows Azure to on-premise Availability Groups.
SQL XI (XStore Integration): Supports SQL Server Database files (from on-premise and Windows Azure) on Windows Azure Storage blobs.
Deployment Wizard: Easily deploy on-premise SQL Server databases to Windows Azure.
Things to Know
The Microsoft SQL Server 2014 CTP2 release is NOT supported by Microsoft Customer Services and Support (CSS).
The Microsoft SQL Server 2014 CTP 2 release is available for testing purposes only. The Microsoft SQL Server 2014 CTP 2 release should NOT be installed and used in production environments, including side-by-side with a production instance of SQL Server.
Upgrading from Microsoft SQL Server 2014 CTP1 to Microsoft SQL Server 2014 CTP2 is NOT supported.
Note: You must have administrative rights on the computer to install SQL Server 2014 CTP2.
There are three methods available to download and install Microsoft SQL Server 2014 CTP2:
SQL Server 2014 CTP2 DVD Image: You can use this ISO image to burn your own DVD.
Download the following .ISO file from the Evaluation Center:
Using your DVD-burning software, select the options to burn a DVD from an .ISO image. When you are prompted for a file to use, select the image file that you downloaded. After burning the DVD, locate and double-click Setup.exe on the DVD to begin the installation.
SQL Server 2014 CTP2 CAB file:
Download the following files from the Evaluation Center to a temporary directory on your device: