Stéphane Haby

One-day workshop with Slava Oks for SQL Server on Linux

Few weeks ago, David Barbarin and I went to the Tugar IT  in Lisbon to follow the workshop from Slava Oks: Bringing SQL Server to Linux: Experience(…)

Migration to SQL Server 2016 with deprecated data types and Full-Text

A few weeks ago, I prepared a migration from SQL Server 2008 to SQL server 2016, I came across a case with deprecated data types and a Full-Text activated on these columns. To simulate this scenario, I downloaded and(…)

SQL Server 2016: patching CU with R Services

As a good DBA, I begin to be up to date with all Cumulative Update (CU) by my customers. It is the first time that I run an update for SQL Server 2016 with the CU 3. I(…)

SQL Server 2017: Python server

After my article SQL Server 2017: first steps with Python Service, I write this article about my first test with the Python Server feature in SQL Server 2017. The installation(…)

SQL Server 2017: first steps with Python Service

Last year, I written blogs about SQL Server 2016 and his integration from the R language. Just for information, you can find these blogs about SQL Server 2016 R Services here: SQL(…)

SQL Server 2016: Does Dynamic Data Masking works with INSERT INTO and SELECT INTO commands?

I wonder how works Dynamic Data Masking (DDM) with these two commands INSERT INTO  and SELECT INTO. First, I create a table and add some “sensitive data”: USE [DDM_TEST] GO CREATE TABLE [dbo].[Confidential]( [ID] [int] IDENTITY(1,1) NOT NULL PRIMARY KEY(…)

SQL Server 2016: Does Dynamic Data Masking work with Temporal Table?

In the last IT Tagen 2016, I presented the Dynamic Data Masking (DDM) and how it worked. To add a little fun, I applied the DDM to a temporal table to see if the history table inherits also from(…)

IT-Tage 2016 Informatik aktuell: feedback

Today, to finish the year, I post a brief personal impression of the IT-Tage 2016 in Frankfurt at the Hotel Maritim, where I was also be a speaker. I presented 2 sessions on SQL Server: “SQL Server Errorlog(…)

SQL Server on Linux in Azure

I’m pleased to announce that Microsoft gives now the opportunity to choose Linux as a new operating system for SQL Server. To try this new version, you can find in the Cloud Azure a new template in the marketplace. In(…)

SQL Server 2016 – R Services Tips: How to find installed packages using T-SQL?

If you have restricted access to the server and you do not know if your packages are installed on the SQL Server with the R Services, you have the possibility to do it by T-SQL. The R command/function to(…)