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
Great article,This blog looks great content with Excellent Information.
ReplyDeleteThank You...
Power BI Course
Thank you for your valuable feedback
Deleteyour valuable information and time. Please keep updating.
ReplyDeleteBest Msbi Online Training
Msbi Online Training in Hyderabad
Thanks for your feedback
DeleteThanks for your feedback
ReplyDeleteThanks for your feedback
ReplyDeleteThank 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.
ReplyDeleteThanks for your feedback
DeleteThank you for sharing such a nice and interesting blog and really very helpful article.
ReplyDeleteRemote Consulting Group (RCG) provides Best In Class IT Consulting, Support and Staffing Services.
Thanks for your feedback
DeleteThank you for sharing such a nice and interesting blog and really very helpful article.
ReplyDeletePrimeGeekz provides Best In Class IT Consulting, Support and Staffing Services.
Thanks for your feedback
DeleteThank you for sharing such a nice and interesting article.
ReplyDeletePrimeGeekz provides Best In Class IT Consulting, Support and Staffing Services.
Thanks for your feedback.
Delete