New Features in SQL Server 2016 – Always encrypted

2015-11-02 20_28_22-sql server 2016 - Google-SucheThere are many new features in SQL Server 2016, but the one we will focus on in this post is:

  • Always encrypted

A feature many companies and developers have been waiting, is now finally being implemented in SQL Server. The feature is called Always Encrypted, the main purpose of this feature is to secure your data. Your data will only be visible to the ones logged into an application consuming the data, and will never be transferred from application to database unencrypted.

http://www.sqlshack.com/new-features-in-sql-server-2016-always-encrypted/

New Features in SQL Server 2016 – Temporal Data Tables

2015-11-02 20_28_22-sql server 2016 - Google-SucheThere are many new features in SQL Server 2016, but the one we will focus on in this post is:

  • Temporal Database Tables

One of the many new features in SQL server 2016 is the built-in support for temporal data tables. This is a feature that many developers have been urging to have as a “out of the box feature” – and therefore many have developed their own ways of implementing the capability to store information about how data looked in a certain period of time.

http://www.sqlshack.com/new-features-in-sql-server-2016-temporal-data-tables/

Using SQL Server 2016 CTP3 in Azure

n00035882-bAs the time of the release of the next version of SQL Server is closing in, the cycle of Community Technical Preview (CTP) releases is shorter and shorter – we are now at CTP3 and the product seems very much mature for release. There is a handful of features not yet implemented, that was on the roadmap – but I bet you the SQL Team will go an extra length to get the features ready for the final release.

This post will show you how to get started with testing/using the newest version of the CTP.

– See more at: http://www.sqlshack.com/using-sql-server-2016-ctp3-in-azure/#sthash.UbgoxGVS.dpuf

Dynamic Data Masking in SQL 2016

2015-07-23 10_51_06-sqlserver2016ctp2technicallevel300deck-150706223653-lva1-app6892.pptx - PowerPoiNew blog post on SQLShack this time i am walking through the new feature Dynamic Data Masking in SQL 2016

This feature enables you to mask data dynamically for your applications, and other data consumers, which should not be allowed to have full access to all data. Continue reading →