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
Thanks for your feedback
ReplyDelete