let’s talk about the Top New Features of SQL Server 2014
- In-Memory across Workloads Built-in
- Scalability Enhancement and Availability
- Power BI For Office 365
- Backup Encryption
- Microsoft Azure Integration
In-Memory across Workloads Built-in
It’s allows you to create memory-optimized database objects that enable more efficient data access **Remember select only Highly Utilized tables to be In-Memory**
that’s will improve performance by as much as 10 times, and improves scalability by 2-5 times.
It does this be minimizing the latency it takes to retrieve data.
This feature will be great for applications that need performance, have relatively short transactions, have a high degree of concurrent transactions with many connections
Scalability Enhancement and Availability
The number of logical processors has been increased to 640 and memory up to 4 TBs.
If SQL Server running in a virtual environment it’s up to 64 virtual processors and 1TB of memory
If you have a clustered SQL Server environment it’s will support up to 64 different nodes.
ABOUT High Availability the number of secondary Replica maximum from four to eight.
Power BI For Office 365
It’s a cloud-based business intelligence (BI) solution which provides data navigation and visualization capabilities
Power BI for Office 365 includes Power Query , Power Map , Powerpivot, and Power View
It’s the ability to encrypt database backups. SQL Server 2014 supports several encryption algorithms; including Advanced Encryption Standard You must use a certificate or an asymmetric key to perform encryption for SQL Server 2014 backups.
More info about Backup Encryption https://helmymo7amed.wordpress.com/2014/07/14/sql-server-2014-backup/
Microsoft Azure Integration
It’s the Ability to Automatic/Manual Backup to Azure Environment and Working with Azure Secondary Replica and storage. we can set an Availability Group resides in Azure when the Primary Replica Failure happens we can switch Manual but we can still working and Report to/from database