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

sql-server-2014.jpg 

 

The Evolution Of SQL Server

evalution-of-sql-server-2014.jpg 

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

Up Next
    Ebook Download
    View all
    Learn
    View all