SQL Server 2014 top New Features

let’s talk about the Top New Features of SQL Server 2014 SQL14

  1. In-Memory across Workloads Built-in
  2. Scalability Enhancement and Availability
  3. Power BI For Office 365
  4. Backup Encryption
  5. 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.Per

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 connectionsIn-Memory

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.

AG

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 ViewBI

Backup Encryption

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.0572.1

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 databaseAzure

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s