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.
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值