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: sysname, char, nchar, nvarchar and varchar. I run this…
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: bit, tinyint, smallint, int, float & money. I run…
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 this new feature to my Oracle colleagues and I’m surprised that Oracle 12c has the same option known as Data Redaction. The principle is simple: for some users, data are masked…
One of the most new interesting features that will be introduced by SQL Server 2016 is certainly the query store that will complete the performance tuning toolbox of database administrators. Basically, the query store will track queries, their query plans and runtime statistics as well. It will be a great tool to detect regressing queries. I remember a real customer…
The new CTP 2.4 has been released some weeks ago by Microsoft. My colleagues and I have already blogged about some new functionalities. I will focus in this blog about the new possibility of Index Maintenance Tasks regarding Indexes. Until SQL Server 2016, DBAs didn’t use often the Maintenance Plan provided by SQL Server for indexes. In fact, those two…
In many blogs or forums, you can read that the answer is to use the option: WITH ESTIMATEONLY. With this option, you can easily have the space estimation needed to check the database in tempdb. But be careful, only since SQL Server 2014, this estimation has been good! See the PS from Paul Randal’s blog for this information, here But…
The new CTP 2.4 has been released and announced by Microsoft in its blog post a couple of days ago. During my investigation, I noticed some new installer capabilities about the tempdb database. As a reminder, you can read my first thoughts from my blog post here, but to be short, the installer was able to provide automatically the right…
Why “also” in my title? On 29 August, my colleague Daniel Westermann wrote an article about Row Level Security in the next version of PostgreSQL. Row Level Security called also RLS is a new feature in SQL Server 2016 and of course in SQL Azure. This new security in SQL Server returns only rows that the user has permission to…
To be able to define which Tables or Stored Procedures will us the best performance gain after migration to In-Memory OLTP, SQL Server 2014 provided a tool called AMR (Analysis Migration and Reporting). This tool was really interesting but we should have, before to use it, to create a Management Data Warehouse and so on… (I wrote a blog here…
Are you aware about the new features of the next Windows version? Currently we’re in TP3 and during my investigation, I was very happy to see the new features for Windows clustering (cf. this blog post from Microsoft). By reading this article we can see: Workgroup Clusters: Clusters with nodes which are member servers / workgroup (not domain joined) If…
During my investigation about the new AlwaysOn features, I wrote a blog post about the new SSISDB support for AlwaysOn. You can find it here: > SQL Server 2016 : availability groups and the new SSISDB support Just as a reminder, for those who have dealt with the SSISDB catalog in the previous version, some extra works were mandatory to…
During the read of a blog of my colleague Nathan Courtine about Stretch database, I installed the version of SQL Server 2016 Upgrade Advisor and Oh surprise! it looks really NEW! “A new generation of advisor tool for SQL Server” aka Microsoft. To download and install it, click here. This new version has a dual role: Check the compatibility of…
