10 new
features in SQL Server 2014.
1.
In-Memory OLTP Engine
SQL
Server 2014 enables memory optimization of selected tables and stored
procedures. The In-Memory OLTP engine is designed for high concurrency and uses
a new optimistic concurrency control mechanism to eliminate locking
delays. Microsoft states that customers can expect performance to be up to 20
times better than with SQL Server 2012 when using this new feature.
2.
AlwaysOn Enhancements
Microsoft
has enhanced AlwaysOn integration by expanding the maximum number of secondary
replicas from four to eight. Readable secondary replicas are now also available
for read workloads, even when the primary replica is unavailable. In addition,
SQL Server 2014 provides the new Add Azure Replica Wizard, which helps you
create asynchronous secondary replicas in Windows Azure.
3.
Buffer Pool Extension
SQL
Server 2014 provides a new solid state disk (SSD) integration capability that
lets you use SSDs to expand the SQL Server 2014 Buffer Pool as nonvolatile RAM
(NvRAM). With the new Buffer Pool Extensions feature, you can use SSD drives to
expand the buffer pool in systems that have maxed out their memory. Buffer Pool
Extensions can provide performance gains for read-heavy OLTP workloads.
4.
Updateable Columnstore Indexes
When
Microsoft introduced the columnstore index in SQL Server 2012, it provided
improved performance for data warehousing queries. For some queries, the
columnstore indexes provided a tenfold performance improvement. However, to
utilize the columnstore index, the underlying table had to be read-only. SQL
Server 2014 eliminates this restriction with the new updateable Columnstore
Index. The SQL Server 2014 Columnstore Index must use all the columns in the
table and can’t be combined with other indexes.
5.
Storage I/O control
The
Resource Governor lets you limit the amount of CPU and memory that a given
workload can consume. SQL Server 2014 extends the reach of the Resource
Governor to manage storage I/O usage as well. The SQL Server 2014 Resource
Governor can limit the physical I/Os issued for user threads in a given
resource pool.
6.
Power View for Multidimensional Models
Power
View used to be limited to tabular data. However, with SQL Server 2014, Power
View can now be used with multidimensional models (OLAP cubes) and can create a
variety of data visualizations including tables, matrices, bubble charts, and
geographical maps. Power View multidimensional models also support queries
using Data Analysis Expressions (DAX).
7.
Power BI for Office 365 Integration
Power
BI for Office 365 is a cloud-based business intelligence (BI) solution that
provides data navigation and visualization capabilities. Power BI for Office
365 includes Power Query, Power Map, Power Pivot, and Power View.
8. SQL
Server Data Tools for Business Intelligence
The new
SQL Server Data Tools for BI (SSDT-BI) is used to create SSAS models, SSRS
reports, and SSIS packages. The new SSDT-BI supports SSAS and SSRS for SQL
Server 2014 and earlier, but SSIS projects are limited to SQL Server 2014
9.
Backup Encryption
SQL
Server 2014 supports several encryption algorithms, including Advanced
Encryption Standard (AES) 128, AES 192, AES 256, and Triple DES. You must use a
certificate or an asymmetric key to perform encryption for SQL Server 2014
backups.
10. SQL
Server Managed Backup to Windows Azure
SQL
Server 2014’s native backup supports Windows Azure integration. The Windows
Azure backup integration is also fully built into SQL Server Management Studio
(SSMS).
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.