Microsoft SQL Server 2014 introduced important improvements especially in-memory OLTP.However,as might one expect after such a short release cycle, not every subsystem is updated, no large changes in SQL Server Integration Services (SSIS) Service replication services SQL Server or SQL Server Reporting (SSRS). However, there are many significant improvements. Here are 10 new features SQL Server 2014.
1. in-Memory OLTP Engine
SQL Server 2014 enables the optimization of the memory of the selected tables and stored procedures. Engine OLTP memory is designed for competition and uses a new mechanism of optimistic concurrency control to eliminate delays lock. Microsoft says customers can expect performance is 20 times better than SQL Server 2012 when you use this new feature. For more information, see Rev Up OLTP applications with performance in-memory engine.
2. Always On Enhancements
Microsoft has improved integration always expanding the maximum number of secondary replicas of four to eight. Readable secondary replicas are now available for workloads reading, even when the primary replica is unavailable. In addition, SQL Server 2014 provides the new replica Azure Wizard, which allows you to create secondary replicas asynchronous Windows Azure Add.
3. Buffer Pool Extension
SQL Server 2014 provides a new Solid State Disk (SSD) capacity of integration that allows you to use SSDs to extend SQL Server 2014 Buffer pool of non-volatile RAM (NVRAM) memory. With the new extensions have buffer pool; you can use the SSD to expand the pool of buffer systems that have reached the limit of their memory. Buffer pool Extensions can provide performance improvements for OLTP workloads heavy reading.
4. Update-able Column store Indexes
When Microsoft introduced torn index columns in SQL Server 2012, has provided an improved method for data storage applications performance. For some queries, the column store indexes provide a tenfold performance improvement. However, to use the column index of the bag, the underlying table must be read-only. SQL Server 2014 removes this restriction with the new store in the index of the combined column. Store the index column SQL Server 2014 to use all the columns in the table and cannot be combined with other indices.
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
The energy is Office 365 BI solution June business intelligence cited in the cloud (BI) who provides capabilities for navigation and visualization of data. BI 365 Office Supply pay request assimilate (formerly called Data Explorer in the code), mapping power (codename Geoflow before) and Power Pivot View. You can learn more about the power output BI at the site to pay Microsoft Office 365.
8. SQL Server Data Tools for Business Intelligence
New tools for database SQL Server BI (SSDT-BI) is used to create SQL Server Analysis Services (SSAS) models, SSRS reports, SSIS packages. The new SSDT-BI SSAS and SSRS support for SQL Server 2014 and earlier, but SSIS projects are limited to SQL Server 2014. In the per-release version of SQL Server 2014, SQL Server installation does not install SSDT-BI. Instead, you must download SSDT-BI separately from the Microsoft Download Center.
9. Backup Encryption
A welcome addition to SQL Server 2014 is the ability to encrypt backups of databases for protecting data at rest. SQL Server 2014 supports multiple encryption algorithms, including Advanced Encryption Standard (AES) 128, AES 192, AES 256, and Triple DES. You must use a certificate or an asymmetric crypto-key for SQL Server 2014 backups.
10. SQL Server Managed Backup to Windows Azure
Native SQL Server 2014 backup supports the integration of Windows Azure. Although I’m not entirely convinced that would depend on an internet connection to restore my backups of SQL Server 2014 site and the Windows Azure virtual machine (VM) instances supports backup of Windows Azure storage. Integrating backup Windows Azure is also fully integrated into SQL Server Management Studio (SSMS).