Microsoft

Control-M Application Integrator verwaltet Microsoft PowerShell Code & Credentials

Welche Vorteile hat “Control-M Application Integrator”? Bei einem Kunden, der Control-M im Einsatz hat, habe ich auf einem Windows Server ganz viele Windows und PowerShell Scripts angetroffen. Unter diesen Scripts waren einige die nach einem bestimmten Keyword in einem Log-File(…)

Journées SQL Server (JSS) 2015 à Paris – Sessions & Sponsoring

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

SQL Server 2016: IF EXISTS is included in the DROP command

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

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