SQL 2016

Microsoft Announces General Availability Of SQL Server 2016

sql-server-2016Microsoft announces the general availability of SQL Server 2016, the world’s fastest and most price-performant database for HTAP (Hybrid Transactional and Analytical Processing) with updatable, in-memory columnstores and advanced analytics through deep integration with R Services. Software applications can now easily deploy sophisticated analytics and machine learning models in the database resulting in 100x or more speedup in time to insight, compared to deployments of such models outside of the database.

A new platform for intelligent applications

The majority of advanced analytic applications use a primitive approach of moving data from databases into the application tier to derive intelligence. This approach has been because of the high latency due to the data movement,and does not scale as data volumes grow,  and thus burden the application tier with the task of managing as well as maintaining the analytical models. The deep analytics on real-time transactions are quite impossible without a lot of heaving lifting.


6 Things You Should Know About SQL Server 2016 Always On Encryption

Always_Encrypted-graphic-e1432801397251The first public preview of SQL Server 2016 is now available for download. It is the biggest leap forward in Microsoft’s data platform history with real-time operational analytics, rich visualizations on mobile devices, built-in advanced analytics, new advanced security technology, and new hybrid cloud scenarios. SQL Server 2016 release promises many new features including a “Stretch” feature which allows you to automatically archive older data to the cloud, enhanced in-memory OLTP functionality, and several new enhancements in security.  One of the most interesting new security features is Always On Encryption.  Here are 6 things you should know about this feature.

  1. Data is encrypted at all times
    Okay, so this might seem obvious but lets look at what this really means.  In the diagram above you see that the data for one or more columns of a table is stored in an encrypted state.  When SQL Server acts on this data locally it acts only on the encrypted version.  It never decrypts it and so it’s encrypted in memory as well as on the wire as it transits the network (or Internet) on the way to the client.  SQL Server treats the encrypted data as if it were the raw field.  Only at the point where the data reaches the client is it decrypted for use in your applications.  This makes the encrypted data nearly impervious to man-in-the-middle attacks or file based decryption on the server.

SQL Create Backup

This topic describes how to create a full database backup in SQL Server 2016 by using Transact-SQL.

USE AdventureWorks2012;
BACKUP DATABASE AdventureWorks2012
TO DISK = 'Z:\SQLServerBackups\AdventureWorks2012.Bak'
      MEDIANAME = 'Z_SQLServerBackups',
      NAME = 'Full Backup of AdventureWorks2012';

Microsoft SQL Server 2016 – New features and enhancements

sql-server-2016This version of SQL Server is going to be a major release with new features and will also overcome some limitations of SQL Server 2014.

SQL Server 2016 delivers breakthrough mission-critical capabilities with in-memory performance and operational analytics built-in. Comprehensive security features like new Always Encrypted technology help protect your data at rest and in motion, and a world-class high availability and disaster recovery solution adds new enhancements to AlwaysOn technology.

New features and enhancements :