What’s New in SQL Server 2014 since SQL Server 2008 R2


PERFORMANCE & SCALE

o        In-Memory OLTP

o        Enhanced In-Memory ColumnStore for DW

o        Support for 640 logical proc. & 4 TB memory

o        Support to 15,000 partitions

o        Resource Governor IO governance

o        Buffer Pool Extension to SSDs

o        Query optimization enhancements

o        SysPrep at cluster level

o        Predictable performance with tiering of compute, network, and storage with Windows Server 2012 R2

HIGH AVAILABILITY

o        SQL Server AlwaysOn

o        Delayed Durability

o        Recovery Advisor

o        Windows Server Core

o        Live Migration

o        Online Operations enhancements

o        Clustered Shared Volume support, VHDX support (Windows Server 2012 R2)

o        Manage on-premises and cloud apps (System Center 2012 R2)

SECURITY

o        User-Defined Server Roles

o        Default Schema for Groups

o        SQL Server Audit

o        SQL Server Fine-grained Auditing

o        Enhanced separation of duty

o        CC certification at High Assurance Level

o        Backup encryption support

PROGRAMMABILITY

o        SQL Server Data Tools

o        Local DB runtime (Express)

o        Data-tier Application Component project template

o        Data-Tier Application Framework (DAC Fx)

o        Query optimization enhancements

o        Interoperability support (ADO.NET, ODBC, JDBC, PDO, ADO APIs and .NET C/C++, Java, Linux, and PHP platforms)

T-SQL ENHANCEMENTS

o        Enhanced support for ANSI SQL standards

o        Transact-SQL Static Code Analysis tools

o        Transact-SQL code snippets

o        Intellisense

o        Unstructured & Complex Data Support

o        FileTable built on FILESTREAM

o        Remote Blob Storage with SharePoint 2010

o        Statistical Semantic Search

o        Spatial features, including Full Globe & arcs

o        Large user-defined data types

MANAGEABILITY

o        Distributed Replay

o        Contained Database Authentication

o        System Center Management Pack for SQL Server 2012

o        Windows PowerShell 2.0 support

o        Multi-server Management with SQL Server Utility Control Point

o        Data-Tier Application Component



ACCESS ANY DATA

o        Power Query

o        Windows Azure HDInsight Service

o        Analytics Platform System (PDW V2)

o        Mash up data from different sources, such as Oracle & Hadoop

INSIGHTS WITH FAMILIAR TOOLS

o        Power BI in Office 365

o        Power Map for Excel

o        Mobile interfaces for Power BI

COMPLETE BI SOLUTION

o        SQL Server BI Edition

o        HA for StreamInsight, complex event processing

o        BI Semantic Model

o        SQL Server Data Tools support for BI

o        Change Data Capture for Oracle

ANALYSIS SERVICES

o        Import PowerPivot models into Analysis Services

o        Enhancements on productivity, performance

REPORTING SERVICES

o        Power View

o        Configurable reporting alerts

o        Reporting as SharePoint Shared Service

o        Report Builder 3.0

DATA QUALITY SERVICES

o        Build organizational knowledge base

o        Connect to 3rd party data cleansing providers

MASTER DATA SERVICES

o        Master Data Hub

o        Master Data Services Add-in for Microsoft Excel

INTEGRATION SERVICES

o        Graphical tools in SSIS

o        Extensible object model

o        SSIS as a Server

o        Broader data integration with more sources; DB vendors, cloud, Hadoop

o        Pipeline improvements

HYBRID CLOUD SOLUTIONS

o        Simplified backup to Windows Azure

o        Support for backup of previous versions of SQL Server to Windows Azure

o        Cloud back-up encryption support

o        Simplified cloud Disaster Recovery with AlwaysOn replicas in Windows Azure VMs

EASY ON-RAMP TO THE CLOUD

o        New Windows Azure Deployment UI for SQL Server

o        Larger SQL Server VMs and memory sizes now available in Windows Azure

o        DAC enhancements: Import/export with Windows Azure SQL Database

COMPLETE AND CONSISTENT FROM ON-PREM TO CLOUD

o        SQL Server Data Tools

o        License Mobility (with SA)

o        Resource Governor enhancements

o        Snapshot backups to Windows Azure via SQL Server Management Studio

Comments

  1. Great article,This blog looks great content with Excellent Information.
    Thank You...

    Power BI Course

    ReplyDelete
  2. It 's an amazing and awesome blog. Thanks for sharing
    Msbi Training
    Msbi Online Course

    ReplyDelete
  3. Thank you for sharing such a nice and interesting blog and really very helpful article. UnoGeeks Offers the best Oracle Fusion Financials Training in the market today. If you want to become Expert Fusion Financials Consultant, Enrol in the Oracle Fusion Financials Online Training offered by UnoGeeks.

    ReplyDelete
  4. Thank you for sharing such a nice and interesting blog and really very helpful article.
    Remote Consulting Group (RCG) provides Best In Class IT Consulting, Support and Staffing Services.

    ReplyDelete
  5. Thank you for sharing such a nice and interesting blog and really very helpful article.
    PrimeGeekz provides Best In Class IT Consulting, Support and Staffing Services.

    ReplyDelete
  6. Thank you for sharing such a nice and interesting article.
    PrimeGeekz provides Best In Class IT Consulting, Support and Staffing Services.

    ReplyDelete

Post a Comment

Hi User,
Thanks for visiting My Blog and please provide your valuable feedback and subscribe for more updates. Please don't post any spam content or comments.
Thank You

Popular Posts

Failed to execute the package or element. Build errors were encountered

Exception deserializing the package "The process cannot access the file because it is being used by another process."

Temporary enable and disable SSRS subscriptions