Essential Guide

SQL 2014: Investigating Microsoft's latest database release

With the release of SQL Server 2014, database administrators have a wealth of new business intelligence and processing capabilities to exploit. But is the time right to upgrade? Get helpful tips and insights here.

Introduction

Less than two years after the release of SQL Server 2012, Microsoft is offering SQL Server 2014, an improved database with numerous enhancements compared with previous versions. SQL 2014  features include increased availability and scalability, streamlined cloud integration, and columnar indexes. Many in the industry are touting its expanded in-memory capabilities, previously codenamed Hekaton, which dramatically boost transaction speeds.

Yet many database administrators may find it challenging to justify another costly upgrade. Others who are still using an older version may not be sure which upgrade is the best fit for their organizations. And how much training will be involved? Some analysts question why Microsoft chose not to offer SQL Server 2012 R2, and instead went ahead with SQL 2014.

This guide presents insights into these changes and concerns, and offers news, tips and features that provide an in-depth examination of the many new enhancements that come with SQL Server 2014.

1Key features-

What's new in SQL Server 2014

Developers and administrators began dabbling in the new functions of SQL 2014 back in June 2013, and with the full release, these enhancements have become available to everyone. In the articles in this section, peruse the key features of SQL 2014, including added security, in-memory online transaction processing (OLTP), columnar storage and more.

Tip

Unraveling SQL Server 2014 encryption features

Transparent Data Encryption and backup encryption are examples of the encryption features and enhancements available in SQL Server 2014. Continue Reading

Tip

SQL Server 2014 extends the buffer pool and implements clustered columnar indexes

Contributor Robert Sheldon explores important new features of SQL 2014: an extended buffer pool and columnar indexes. Continue Reading

Tip

SQL Server 2014 offers new Windows Azure integration features

In this tip, learn how SQL 2014 functions as a hybrid cloud platform that offers increased integration with Windows Azure. Continue Reading

Tip

Partitioned indexes and memory optimized tables: More from SQL 2014

Learn more about partitioned indexes and memory optimized tables in this second part of a series on SQL 2014 features. Continue Reading

Feature

In-memory and cloud integration features included in SQL Server 2014

This article discusses the in-memory and cloud integration aspects of the SQL 2014 database release. Continue Reading

Feature

More on SQL Server 2014: Availability and scalability features

In this second part of an overview of SQL 2014, the author explores the improved availability and scalability offered in this release. Continue Reading

2In-memory OLTP-

A closer look at in-memory processing in SQL 2014

The addition of in-memory online transaction processing to SQL Server 2014 is arguably the most talked-about architectural enhancement to SQL database performance. In the following articles, learn about how it works, what benefits it offers and where it falls short.

Tip

In-memory OLTP leads the list of features in SQL Server 2014

This article highlights eight key items offered in SQL 2014, including in-memory OLTP and columnar storage. Continue Reading

Tip

How to get started with SQL Server 2014 in-memory OLTP

Database administrators and others should know about the benefits of SQL 2014 in-memory OLTP. This tip explains how to set it up. Continue Reading

News

Upgrading SQL Server? Learn more about in-memory analytics, cloud

Microsoft's Mark Kromer discusses the in-memory analytics, cloud and big data offerings of SQL Server 2014 in this issue of SQL in Five. Continue Reading

News

In-memory OLTP stands out in SQL Server 2014 release

Explore the in-memory capability for OLTP, as well as other news surrounding this release. Continue Reading

Podcast

With in-memory features, SQL Server 2014 remains competitive

Learn what Ovum analyst Tony Baer has to say about SQL 2014 and its move toward in-memory processing functions. Continue Reading

3Expert commentary-

Commentary on SQL Server releases

With the ongoing releases of SQL Server come shifts in the functions and capabilities of related technologies. Experts and users give their feedback on these changes and the bigger picture surrounding SQL Server upgrades in the articles that follow.

Feature

Deciphering the release of SQL Server 2014

Get expert insight into the changes and misconceptions associated with SQL 2014 from consultant Denny Cherry. Continue Reading

Tip

With SQL 2014, SQL Server AlwaysOn AvailabilityGroups makes strides

In this tip, learn how AlwaysOn AvailabilityGroups gets a boost in SQL Server 2014. Continue Reading

Feature

How to keep up with frequent releases of SQL Server versions

With Microsoft releasing new SQL Server versions at an ever-faster pace, many organizations need tips on how to adapt. Continue Reading

Feature

SQL Server Reporting Services enable interactive reports

Read about SQL Server Reporting Services and their capabilities from expert Brian Larson in this interview. Continue Reading

News

Users evaluate SQL Server 2014 with CTP 2

Read how the last Community Technology Preview (CTP) for SQL 2014 gives users a sense of what this release has to offer. Continue Reading

Feature

Expert makes predictions for SQL Server in the new year

SQL Server expert Denny Cherry discusses new developments and his wishlist for SQL Server trends to come. Continue Reading

4Glossary-

Glossary of terms related to SQL Server upgrades

Learn and review definitions of terms commonly associated with SQL Server in this glossary.