SQL Server 2014 Build List

A list of builds for SQL Server 2014, through CU4 for SP2 and CU11 for SP1.

TDE and In-Memory OLTP

SQL Database Migration: Lower to Higher Version

Database Migration - Lower version of Microsoft SQL Server to Higher version of SQL Server, with complete DBA Guide with Automated Scripts and Steps.

The Identity Limit

Maximum number of supported Partitions in SQL 2014

Plan Guides

Columnstore changes

Clustered Columnstore Index Gives "Unable to find index entry" Error

The Clustered columnstore index generates "unable to find index entry" error and a memory dump after few DMLs on the table

Implementing Azure Blob Storage (ABS) With SQL Server 2014

With any application organizations face consistent key challenges such as high efficiency and business value, complex configuration, and low total cost of ownership. Extending applications to the cloud in hybrid scenarios addresses many of these challenges, whether distributing SharePoint content across on-premises and Office 365 while leveraging search as a service (hybrid search) or externalizing data, extending it to the cloud with Remote Blob Storage or related technologies.

Natively Compiled Stored Procedures: What they are all about

What are natively compiled stored procedures? Why would we want to use them and what are the performance benefits of using them over classic disk-based stored procedures?