SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

SQL Server 2014 CTP1 is here!

As I mentioned in my blog post describing the new features in the next version of SQL Server (see SQL Server 2014!), the CTP1 was to be released in June, and that time has come.

Download it here, or it is available for download through a MSDN or Technet subscription.  Note you can also get it on Azure (see Getting Started With SQL Server 2014 the Easy Way).  Be aware that installing side-by-side with other versions of SQL Server is NOT supported, so you should install this on a VM.  Also, in this SQL Server 2014 CTP1 release, SQL Server Setup no longer installs SSDT-BI (see SQL 2014 CTP1, where is my BIDS?).  The Visual Studio 2012 version of SSDT-BI is available as a separate web download from the Microsoft Download center.

The version that displays is: Microsoft SQL Server 2014 (CTP1) – 11.0.9120.5 (X64).

Key features in this release is:

  • Project code-named “Hekaton”: “Hekaton” provides in-memory OLTP capabilities built into core SQL Server database to significantly improve the performance of your database application.  “Hekaton” is installed with the SQL Server 2014 Engine without requiring any additional actions and allows in-memory performance benefits without rewriting your database application. You can also increase performance of existing SQL Server applications without having to refresh your hardware.  “Hekaton” is easy to deploy and allows you to access the other rich features in SQL Server, while taking advantage of in-memory performance.
  • xVelocity ColumnStore:  xVelocity ColumnStore provides in-memory capabilities for data warehousing workloads that result in dramatic improvement for query performance, load speed, and scan rate, while significantly reducing resource utilization (i.e., I/O, disk and memory footprint).  The new ColumnStore complements the existing xVelocity ColumnStore Index, providing higher compression, richer query support and updateability of the ColumnStore giving you the 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. Finally, various supportability enhancements make AlwaysOn easier to use.
    • Improved Online Database Operations: includes single partition online index rebuild and managing lock priority for table partition switch, greatly increasing enterprise application availability by reducing maintenance downtime impact.

More info:

Books Online for SQL Server 2014

What’s New (Database Engine)

SQL Server 2014 CTP 1 download now available!

List of new programmability features/T-SQL enhancements in SQL Server besides Hekaton

TechEd Europe Announcement : SQL Server 2014 – Public CTP Now Available ! Download , Learn & Share

SQL Server 2014 – Public CTP Now Available

SQL Server 2014 CTP1 native compiled Hekaton procedures are faster than regular procedures

New DMVs in SQL Server 2014 CTP1

SQL Server In-Memory OLTP Internals Overview for CTP1

First steps with Extreme Transaction Processing – Hekaton

SQL Server 2014 In-Memory Technologies: Blog Series Introduction

Getting Started with SQL Server 2014 In-Memory OLTP

Prepare a new VM for SQL Server 2014 CTP1

Non-Clustered Indexes on Table Variables in SQL Server 2014

What’s new in SQL SERVER 2014 Services – SQL SERVER

SQL Server 2014 CTP 1 Released BI Review Video

SQL Server 2014 all about big data, in-memory analytics and cloud

Hekaton data and code – where does that stuff actually live?

Improved Temp Table Caching in SQL Server 2014

SQL Server 2014 FCI Using a Cluster Shared Volume for Storage

SQL 2014 CTP1 Forum on MSDN

Buffer Pool Extension to SSDs in SQL Server 2014

James Serra's Blog

James is a big data and data warehousing technology specialist at Microsoft. He is a thought leader in the use and application of Big Data technologies, including MPP solutions involving hybrid technologies of relational data, Hadoop, and private and public cloud. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior SQL Server MVP with over 30 years of IT experience. James is a popular blogger (JamesSerra.com) and speaker, having presented at dozens of PASS events including the PASS Business Analytics conference and the PASS Summit. He is the author of the book “Reporting with Microsoft SQL Server 2012”. He received a Bachelor of Science degree in Computer Engineering from the University of Nevada-Las Vegas.


Leave a comment on the original post [www.jamesserra.com, opens in a new window]

Loading comments...