Infrastructure at your Service

Tag

SQL Server 2016 Archives - Page 7 of 9 - Blog dbi services

Stéphane Haby

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

By | Database Administration & Monitoring, Technology Survey | No Comments

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.

Read More
Microsoft Team

SQL Server 2016 query store

By | Database Administration & Monitoring, Development & Performance | 2 Comments

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 case a couple of months ago where I was involved in a database migration project…

Read More
Stéphane Savorgnano

SQL Server 2016: New possibilities for Index Maintenance Task

By | Database Administration & Monitoring | No Comments

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 tasks, Reorganize Index and Rebuild Index were not enough detailed and DBA’s preferred to create…

Read More
Stéphane Haby

How to be sure that tempdb size is good to run a DBCC CHECKDB?

By | Database Administration & Monitoring, Database management | No Comments

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 between SQL server 2008, 2012 and 2014…and 2016, the result of this query changed! 😕

Read More
Microsoft Team

SQL Server 2016 : tempdb database enhancements in CTP 2.4

By | Database Administration & Monitoring | 2 Comments

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 number of data files according to the number of existing CPUs and the best practices…

Read More
Stéphane Haby

Row Level Security (RLS) is also coming to MS SQL Server

By | Database Administration & Monitoring, Technology Survey | No Comments

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 access. The best way to understand is with a little sample and I use Daniel’s…

Read More
Stéphane Savorgnano

SQL Server 2016: Transaction Performance Analysis Overview & In-Memory OLTP Migration Checklists

By | Database Administration & Monitoring | No Comments

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 for this configuration and an article on SQL Magazine here) With SQL Server 2016, actually…

Read More
Microsoft Team

SQL Server 2016 : availability groups with no domain dependencies

By | Database Administration & Monitoring | No Comments

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 you remember, Microsoft had introduced Active Directory-Detached Cluster feature with Windows 2012 but the dependency…

Read More
Microsoft Team

SQL Saturday Paris le 05 septembre 2015 – Slides

By | Technology Survey | No Comments

La 3ème édition du SQL Saturday à Paris est terminée et je ne peux qu’être enthousiaste à la vue du nombre de personnes que cet événement attire à chaque fois et ceci un samedi (à peu près 150 personnes). Comme à chaque fois, cela a été une bonne expérience pour ma part et je la renouvellerai à coup sûr l’année prochaine dans la mesure du possible. Vous trouverez les slides des sessions que j’ai (co)animées avec Christophe Laporte et Sarah…

Read More