What’s New in SQL Server 2014 since SQL Server 2008
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
o Data
Compression with USC-2 Unicode support
o Backup
Compression
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
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
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