Introducing Microsoft SQL Server 2014

Introduction

Microsoft has announced SQL Server 2014 as a part of a wave of updates to our key enterprise products. Microsoft SQL Server 2014 builds on the mission-critical capabilities delivered within the previous release by providing breakthrough performance, availability and flexibility for your mission crucial applications. SQL Server 2014 provides new in-memory capabilities built into the core database for OLTP and data warehousing that support our existing in-memory data and figures warehousing and BI capabilities for the most comprehensive in-memory database solution in the market.

You can download SQL Server 2014 from Click Here For Download SQL Server 2014.

Hardware and Software requirements for installing SQL Server 2014

http://msdn.microsoft.com/en-us/library/ms143506(v=sql.120).aspx

The Power of SQL Server 2014 and the Data Platform

MISSION CRITICAL PERFORMANCE

In-Memory Built in

• In Memory OLTP
  
  Average 10 x and up to 50xx performance gains.
  
• Enhanced In-memory ColumnStore for DW
  
  Updatable, faster, better compression.
  
• In memory BI with PowerPivot
  
  Fast insights.
  
• Buffer Pool Extension to SSds
  
  Faster paging.
  
• Enhanced Query processing
  
  Faster performance without the app changes.

Enhanced Security and Scalability

• Redefined engineering security processes
  
  Least vulnerable DB
  
• CC certification at High Assurance Level
  
  Improved Compliance.
  
• Enhance separation of duty
  
  Improved Compliance and security.
  
• Transparent Data Encryption
  
  Better data protection.
  
• Encryption Key Management
  
  Store key on a separate server.
  
• Support for Windows Server Code
  
  Reduce surface area for attack.
  
• Resource Governor adds IO governance
  
  Predictable performance.
  
• SysPrep at cluster level
  
  Faster deployment.
  
• Windows Server 2012 R2
  
  Predictable performance with tiering of computer network and storege.

High Availability