What’s New in SQL Server 2014 since SQL Server 2005
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 tiring of compute, network, and storage with Windows Server 2012 R2
o Data Compression with USC-2 Unicode support
o Backup Compression
HIGH AVAILABILITY
o SQL Server Always On
o Database Mirroring
o Failover Clustering
o Database Snapshots
o Delayed Durability
o Recovery Advisor
o Windows Server Core
o Live Migration
o Online Operations
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 Transparent Data Encryption
o Extensible Key Management
o Standards-based Encryption
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 Intelligence
DATA SUPPORT
o FILESTREAM data type
o File Table built on FILESTREAM
o Remote Blob Storage with SharePoint 2010
o Spatial data support
o Full Text Search for unstructured files
o Statistical Semantic Search
o Large user-defined data types
PROGRAMMABILITY SUPPORT
o Support for LINQ and ADO.NET Entity Framework
o CLR Integration and ADO.NET Object Services
MANAGEABILITY
o Distributed Replay
o Contained Database Authentication
o System Centre 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
o Multi-server Management with SQL Server Utility Control Point
o Data-Tier Application Component
o Policy-Based Management
o SQL Server Performance Data Collector
o Query enhancements
o SMTP mail for secure DB email w/o Outlook
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 Stream Insight
o BI Semantic Model
o SQL Server Data Tools
o BI Development Studio
o Microsoft Visual Studio-based report dev tools
o Change Data Capture for Oracle
ANALYSIS SERVICES
o Import PowerPivot models into Analysis Services
o Enhancements on productivity, performance
o Cube design tools, block computations, and write-back to MOLAP
REPORTING SERVICES
o Power View
o Configurable reporting alerts
o Reporting as SharePoint Shared Service
o Report Builder 3.0
o Report Designer
o Report Manager
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
o Persistent lookups
o High-performance connectors
o Data profiling tool
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 Always On 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
your valuable information and time. Please keep updating.
ReplyDeleteMsbi Online Course
Msbi Online Training
Thanks for your feedback
Delete