Technology Survey

SQL Server 2016: new T-SQL commands COMPRESS and DECOMPRESS

In live from the JSS2015 (Journée SQL Server 2015) in Paris, we saw that the CTP3.1 has been available in the night of these 2 days. One new feature available for this release in the T-SQL(…)

Windows Server 2016: Containers

One of the new feature which will come with Windows Server 2016 is the Containers. Microsoft made available its fourth technical preview of his Windows Server 2016 platform  some days ago. This new Technical Preview brings with it and for(…)

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(…)