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

• SQL Server 2014
  
  Enhanced Always on, 8 secondary's Replica Wizard
  
  greater HA, easier to mange and deploy
  
• Windows Server 2012 R2
  
  Clustered Shared volume support
  
  Enterprise HA with tiered storege.
  
• VHDX support
  
  Resize VM without downtime

FASTER INSIGHTS FROM ANY DATA

Easy Access to Data, Big and Small

• Project Code name "Data Explorer"
  
  Easy aceess to internal and external data.
  
• Windows Azure Market Place
  
  Enhance with 3rd party data.
  
• Windows Azure HDInsight Services and Microsoft HdInsight Server
  
  Access big data with the simplicity of windows..
  
• Parallel Data Warehouse with Ploybase
  
  Query big data with T-SQL.

Powerful Insight with Familiar Tools

• Excel in Office
  
  Faster insights.
  
• Project Codename
  
  Richer insights with 3D visulation.
  
• Data Mining Add-ins for Excel
  
  Predictive analytics.

Complete BI solution

• Stream Insight Data Quality Services
  
  Access streaming data in near real time.
  
• Data Quality Services
  
  Cleanse data.
  
• Master Data Services
  
  One source for the truth.
  
• BI Semantic Model
  
  Simplify BI model deployment.

PLATFORM FOR HYBRID CLOUD

Hybrid Cloud Solutions

• Simple Cloud Back-UP
  
  Reduce CAPEX and OPEX.
  
• Cloud Disaster recovery
  
  Reduce CAPEX and OPEX and improve business countinuity.
  
• Extended On-Premises app to the Cloud
  
  Gain cloud scale on demand.

Easy on Ramp to Cloud

• New Cloud Migration Wizard
  
  Easily move on-premises SQL Server to Windows Azure.
  
• SQL Server in a Window3 Azure Virtual Machine
  
  Reduce CAPEX and OPEX with full SQL Server functionality.
  
• Windows Azure SQL Database Services
  
  Develop new variable demand cloud apps quickly with HA built-in.

Starting Process Image of SQL Server 2014

The Evolution Of SQL Server

Image Ref- http://blogs.technet.com/