SQL Server 2014新特性

微软今年年底之前将要发布SQL Server 2014，Sql server 2014具有以下新特性：

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 Windows 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.