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.
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.
Contributor Robert Sheldon explores important new features of SQL 2014: an extended buffer pool and columnar indexes. Continue Reading
In this tip, learn how SQL 2014 functions as a hybrid cloud platform that offers increased integration with Windows Azure. Continue Reading
Learn more about partitioned indexes and memory optimized tables in this second part of a series on SQL 2014 features. Continue Reading
This article discusses the in-memory and cloud integration aspects of the SQL 2014 database release. Continue Reading
In this second part of an overview of SQL 2014, the author explores the improved availability and scalability offered in this release. Continue Reading
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.
This article highlights eight key items offered in SQL 2014, including in-memory OLTP and columnar storage. Continue Reading
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
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
Explore the in-memory capability for OLTP, as well as other news surrounding this release. Continue Reading
Learn what Ovum analyst Tony Baer has to say about SQL 2014 and its move toward in-memory processing functions. Continue Reading
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.
In this tip, learn how AlwaysOn AvailabilityGroups gets a boost in SQL Server 2014. Continue Reading
With Microsoft releasing new SQL Server versions at an ever-faster pace, many organizations need tips on how to adapt. Continue Reading
Read about SQL Server Reporting Services and their capabilities from expert Brian Larson in this interview. Continue Reading
SQL Server expert Denny Cherry discusses new developments and his wishlist for SQL Server trends to come. Continue Reading
Glossary of terms related to SQL Server upgrades
Learn and review definitions of terms commonly associated with SQL Server in this glossary.