SQL Server 2016

Manipulate Stretch database feature by script

On November 30th, I presented the Stretch Database feature in “Les Journées SQL Server 2015” in Paris. I explained how to manage by script this new feature in SQL Server 2016 CTP 3.0 I decided to share you my(…)

SQL Server 2016 CTP3.0: Stretch Database enhancements

Some months ago, my colleague Nathan explained you the bases of the new Stretch Database functionality via two blogs here and here. With the new SQL Server 2016 CTP 3.0, Stretch Database now includes new features and(…)

Journées SQL Server (JSS) 2015 à Paris – Sessions & Sponsoring

Faisant suite à la première annonce de David Barbarin sur les journées SQL Server du 30 novembre et 1er décembre, j’ai le plaisirs de vous inviter à venir nous voir également(…)

SQL Server 2016: IF EXISTS is included in the DROP command

With SQL Server 2016, I’m nicely surprised by the addition of IF EXISTS directly in the T-SQL command DROP. Before this new option, all queries are written with IF EXISTS (SELECT * FROM sys….) DROP object. I have quickly tested(…)

SQL Server 2016: JSON support updated with SQL Server 2016 CTP 3.0!

For last week, the SQL Server 2016 Community Technology Preview 3.0 has been available with a lot of enhancements on new features. All info about CTP3 are on SQL Server Blog here. I(…)

Journées SQL Server 2015 à Paris – 30 novembre et 1er décembre

Les journées SQL Server se dérouleront dans un mois à Paris dans les locaux de Microsoft. L’agenda n’a été qu’en parte dévoilé mais c’est avec plaisir que je peux dores et déjà vous annoncer(…)

SQL Server 2016 – Security: Dynamic Data Masking – Other Data Types

This blog is a part of the series "SQL Server 2016 - Security: Dynamic Data Masking". I remember you my different logins used to connect to AdventureWorks: sql login u1(…)

SQL Server 2016 – Security: Dynamic Data masking – String Data Types

This blog is a part of the series "SQL Server 2016 - Security: Dynamic Data Masking". I remember you my different logins used to connect to AdventureWorks: sql login(…)

SQL Server 2016 – Security: Dynamic Data masking – Numeric Data Types

This blog is a part of the series "SQL Server 2016 - Security: Dynamic Data masking". I remember you my different logins used to connect to AdventureWorks: sql login u1(…)

SQL Server 2016 – Security: Dynamic Data masking

After my first blog on Security with Row level Security, I test the second Security new feature in the next version of SQL Server: Dynamic Data Masking. I presented(…)