Technology Survey

Run SQL Server everywhere!

Running SQL Server everywhere is not a dream anymore!  Microsoft has just announced the first release of SQL Server CTP1 on Linux today! But that’s not all! SQL Server Vnext is also available on Windows,(…)

SQL Server 2016: Dynamic Data Masking and database role

Last week, dbi services organized an event named “SQL Server 2016: what’s new?” in Lausanne, Basel and Zurich. I would take the opportunity to say again a big thank you to everyone which joined us. During my session some(…)

Les 24 heures du PASS (24HOP) – édition francophone

Je n’ai pas encore blogué sur le sujet mais il est temps de le faire. Cette année, aura lieu la première édition francophone des 24h du PASS  les 20 et 21 septembre(…)

Neue Datenbank Konsole Befehle (DBCC) CLONEDATABASE

Sie haben es vielleicht noch nicht gesehen, aber mit den Service Pack 2 von SQL Server 2014 gibt es einen neuen DBCC Befehl: CLONEDATABASE. „DBCC CLONEDATABASE sollte Kopien eines Schemas und den Statistiken einer Produktionsdatenbank erstellen, um bei Leistungsproblemen Abfragen(…)

SQL Server 2016: Always Encrypted – part 2

In my last blog post about SQL Server 2016 Always Encrypted, here, I showed how to use this new functionality but also that you have to separate the different execution context with an Application server, a database server and(…)

SQL Server 2016 – Query Store: retrieve query that doesn’t appear!

For our event SQL Server 2016 in September, I am studying the new functionality Query Store. My colleague David Barbarin have written few months ago about Query(…)

Trace Flag 4199 or not in SQL Server 2016?

Some Trace Flag like T1117 and T1118 are no more needed as you can read on David’s blog. But that’s not all, you have also the T4199… What’ does the Trace Flag T4199? This Trace Flag(…)

SQL Server 2016: Always Encrypted

One of the top new features of SQL Server 2016 is the Always Encrypted functionality. Always Encrypted provides that data, store in a database, remains encrypted the all times there are in the database. There is a complete separation between(…)

SCOM: schedule group maintenance task with PowerShell

In my last blog post, here, I spoke about how to place SCOM group in maintenance mode. This script is really interesting with an integration in Windows Task Scheduler. At the end, the main purpose is to plan a(…)

SCOM: change group state to maintenance mode with PowerShell

Some weeks ago, I wrote a blog post about the creation of SCOM groups in order to subscribe to alerts. Subscribe to alert is mandatory, of course, to be able to receive alerts concerning our group. But during operations(…)