Category Archives: SQL Server 2014

SQL Server 2014 released April 1st!

SQL Server 2014 has been released to manufacturers (RTM) and will be generally available April 1.  Here is the official announcement.  Here are my blog posts about some of the new features. More info: SQL Server 2014 RTM Announced for … Continue reading

Posted in SQL Server 2014, SQLServerPedia Syndication | Leave a comment

SQL Server 2014 In-Memory OLTP (Hekaton) Limitations

One of the biggest new features in SQL Server 2014 is SQL Server In-Memory OLTP, known mostly by its code name of Hekaton (see SQL Server 2014: In-memory OLTP Engine, code-name: Hekaton).  Basically, this puts tables in memory, giving a potentially … Continue reading

Posted in SQL Server 2014, SQLServerPedia Syndication | 3 Comments

SQL Server Data Tools for SQL Server 2014 CTP2 now available

From Microsoft, SSDT is now available for SQL Server 2014: We’d like to announce the availability of SSDT that supports SQL Server 2014 databases.  SQL Server Data Tools for SQL Server 2014 CTP2 is pre-release software, does not support upgrade … Continue reading

Posted in SQL Server 2014, SQLServerPedia Syndication, SSDT/Juneau | 2 Comments

Microsoft releases SQL Server 2014 CTP2

Microsoft has released SQL Server 2014 CTP2 (download): What’s new in SQL Server 2014 CTP2? New Mission Critical Capabilities and Enhancements Enhanced In-Memory OLTP, including new tools which will help you identify and migrate the tables and stored procedures will … Continue reading

Posted in SQL Server 2014, SQLServerPedia Syndication | 4 Comments

SQL Server 2014: Partition Improvements

SQL Server 2014 has enhancements to two common database maintenance operations:Partition Switching and Online Index Rebuild.  This will greatly increase enterprise application availability by reducing maintenance downtime impact. The two new features are: Managed Lock Priority: This allows you to manage the … Continue reading

Posted in SQL Server 2014, SQLServerPedia Syndication | Leave a comment

SQL Server 2014: AlwaysOn

AlwaysOn was introduced in SQL Server 2012, and there are some enhancements in SQL Server 2014: 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 … Continue reading

Posted in SQL Server 2014, SQLServerPedia Syndication | Leave a comment

SQL Server 2014: Columnstore Index improvements

In SQL Server 2012, a new feature was added called Columnstore Indexes that resulted in huge query performance improvements.  In SQL Server 2014, there have been two major improvements on this feature: Clustered: They have enhanced the columnstore to be a pure … Continue reading

Posted in SQL Server 2014, SQLServerPedia Syndication | 2 Comments

TechEd Europe 2013 videos online

Microsoft has posted ALL the session videos for TechEd Europe 2013 and they are available for free!  Some great videos on the latest products and versions.  Check them out here.  There are four videos on SQL Server 2014: Microsoft SQL Server … Continue reading

Posted in SQL Server, SQL Server 2014, SQLServerPedia Syndication, Videos | Leave a comment

SQL Server 2014: In-memory OLTP Engine, code-name: Hekaton

What looks to be the biggest and best new feature in SQL Server 2014 is called the “In-memory OLTP Engine”, code-name: Hekaton.  In short, Hekaton is a SQL Server In-memory OLTP Engine.  Hekaton provides in-memory OLTP capabilities built into core … Continue reading

Posted in SQL Server 2014, SQLServerPedia Syndication | 3 Comments

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 … Continue reading

Posted in SQL Server 2014, SQLServerPedia Syndication | 1 Comment