I write this article because it is very interesting to see that the upgrade advisor has evolved… Recently (February 11, 2016), a new version is available: Microsoft® SQL Server 2016® Upgrade Advisor Preview 1.4 The msi package is 10 MB and is named SqlAdvisor. Run the msi and follow the steps like every time… After the installation, it is easy…
In SQL Server 2016 CTP 3.0, temporal tables with In-Memory OLTP is supported. 🙂 At the JSS2015 (Journée SQL Server 2015), I have presented a little demo about temporal table with a table In-Memory. This article is a complement of my presentation and a good add to my series of Temporal Table. My first step is to create the temporal…
This blog post will probably not concern customers where either password policy change rules are not defined for service accounts or Kerberos authentication is not used. But I’m sure that the number of these customers has decreased over at least the last decade. By the way, this is what I can notice at different customer places. But before beginning with…
Avant de partir pour des vacances bien méritées et une année pleine d’aventures sur SQL Server, je fais un dernier petit article pour vous informer que nos sessions des Journées SQL Server 2015 sont disponible sur SlideShare et Youtube. Un grand merci à l’équipe du GUSS pour l’organisation et leur confiance en nous. N’hésitez pas à aller également évaluer nos…
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 domain is COMPRESS and DECOMPRESS. Through a GZIP algorithm, you can compress and decompress an argument for nvarchar, varchar, varbinary, char and binary data…
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 demonstration into a blog. I – Enabling the feature at the instance level First, you need to enable the “Remote…
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 enhancements that I will sow you in this blog. In previous versions of SQL Server 2016 CTP 2.x, before to be allowed…
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 à notre stand. Effectivement, comme l’année passée, nous sommes heureux d’être à nouveau sponsors GOLD de l’événement et seront placés comme le schéma ci-dessous vous le montre. N’hésitez pas…
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 just for 2 drop commands(See List of available objects below): one for a table one for a column in a…
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 wrote some weeks ago, a blog about JSON Support in SQL Server 2016: SQL Server 2016: native support for JSON With this new CTP version, JSON support…
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 que dbi services sera de la partie cette année encore en tant que speaker et sponsor de l’événement. Pour ma part j’aurai le plaisir de vous…
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 with the db_owner role –> No masking sql login u2 with the db_datareader role –> masking The Data Types used are: xml, date, datetime and varbinary. I run this query…
