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 →
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 →
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 →
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 →
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 →
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 →
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 →
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 →
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 →
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 →
Just when you thought you got a handle on SQL Server 2012, here comes the next version! SQL Server 2014 was announced yesterday during the TechEd North America 2013 Day 1 Keynote. It is due to be released in early 2014, shortly … Continue reading →