Infrastructure at your Service

Microsoft Archives - Blog dbi services

Stéphane Haby

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

By | Technology Survey | No Comments

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 It was a deep dive into the code of SQL Server and Slava shows us how they achieve a universal platform regardless the operating system. On my mind, the challenge was how to deal with the Windows operating system dependencies that include all Win32/ NT Kernel calls and…

 
Read More
Stéphane Haby

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

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

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 installed the Data Migration Assistant(DMA). Make sure that the .Net Framework 4.5 is installed on your machine before starting the installation of the DMA. After the installation, you start the application which is very simple to…

 
Read More
Stéphane Haby

SQL Server 2016: patching CU with R Services

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

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 download the CU on Microsoft website and I begin my patching campaign on all SQL server 2016 instances. The first one is quick & successful. The second one, with R Services, is a little bit different. After,…

 
Read More
Stéphane Haby

SQL Server 2017: Python server

By | Technology Survey | No Comments

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 is very simple, in the features Selection window, you have in the Shared Features, you have a Machine Learning Server (Standalone) with R and Python. I check Python to install the Python Server and here we go. Like for the Python services, you need to…

 
Read More
Stéphane Haby

SQL Server 2017: first steps with Python Service

By | Development & Performance, Technology Survey | No Comments

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 Server 2016: R Services SQL Server 2016 – R Services Tips: How to find installed packages using T-SQL? Now, the next version of SQL Server, named officially SQL Server 2017 integrate also the language Python. The first step is to install the Python…

 
Read More
Stéphane Haby

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

By | Database Administration & Monitoring | No Comments

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 CLUSTERED, [Name] [nvarchar](70)NULL, [CreditCard] [nvarchar](16)NULL, [Salary] [int] NULL, [Email] [nvarchar](60)NULL) insert into [dbo].[Confidential]([Name],[CreditCard],[Salary],[Email]) values (N’Stephane’,N’3546748598467584′,113459,N’sts@dbi-services.com’) insert into [dbo].[Confidential]([Name],[CreditCard],[Salary],[Email]) values (N’David’,N’3546746598450989′,143576,’dab@dbi-services.com’) insert into [dbo].[Confidential]([Name],[CreditCard],[Salary],[Email]) values (N’Nathan’,N’3890098321457893′,118900,’nac@dbi-services.com’) insert into [dbo].[Confidential]([Name],[CreditCard],[Salary],[Email]) values (N’Olivier’,N’3564890234785612′,98000,’olt@dbi-services.com’) insert into [dbo].[Confidential]([Name],[CreditCard],[Salary],[Email]) values (N’Alain’,N’9897436900989342′,85900,’ala@dbi-services.com’)…

 
Read More
Stéphane Haby

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

By | Database Administration & Monitoring | No Comments

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 DDM’s rules. In this blog, I explain all the different steps to reproduce my last demo. Step 1: Create the table and the temporal table in the database DDM_TEST USE [DDM_TEST] GO CREATE TABLE [dbo].[Confidential]( [ID]…

 
Read More
Stéphane Haby

IT-Tage 2016 Informatik aktuell: feedback

By | Technology Survey | No Comments

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 Entmystifizierung” & “SQL Server 2016: Neue Sicherheitsfunktionen”. I wasn’t the only one from dbi services who spoke at that conference: David Barbarin with also 2 sessions: “SQL Server – Locks, latches and spinlocks” & “SQL Server 2016…

 
Read More
Stéphane Haby

Live from SQL Saturday Slovenia 2016!

By | Technology Survey | No Comments

After a little trip, just 1-hour flying from Zürich to Ljubljana yesterday, the SQL Saturday Slovenia 2016 begins this morning at the Faculty of Computer and Information Science of the University of Ljubljana… I needed to wake up very fast because my session was the first of the day at 9:00 AM. I also very happy to meet and to share my expertise with Slovenian and other SQL Server experts. My session was about the…

 
Read More
Stéphane Haby

SQL Server on Linux in Azure

By | Technology Survey | No Comments

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 the search bar, tape “SQL Server vnext” and you’ll find the “SQL Server vNext on Red Hat Enterprise Linux 7.2”. Follow all “classic” steps to create your new VM SQL Server on Linux: First step,…

 
Read More