Microsoft

SQL Server Collation for System Center Products

A customer asks me, what is the collation for System Center products? Do we have a general collation for all products? And what is the BP for Tempdb? And how work the licencing for SQL Server in(…)

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

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

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

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

SSISDB is too big and it is not every time the retention period’s fault!

In all blogs that I read, the solution is just to change the retention period to a reasonable value. Yes, it is true but in some case you need to go deeper in the analysis… Like you, I(…)

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

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

SQL Server AlwaysOn and availability groups : how to isolate the replication traffic from other networks?

A couple of days ago, I was involved in a project about implementing availability groups with SQL Server 2014. My customer wanted to isolate the replication traffic from the public network. The idea behind was to get a better control(…)