Infrastructure at your Service

SQL Server Archives - Page 3 of 20 - Blog dbi services

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
David Barbarin

Prochaine édition des 24 HOP 2017 francophone

By | Technology Survey | No Comments

La prochaine édition du 24 Hours of PASS 2017 edition francophone se déroulera les 29-30 juin prochain. Pour rappel le format est simple: 24 webinars gratuits répartis sur 2 jours de 07:00 à 18h00 GMT et en Français. La seule obligation: s’inscrire aux sessions auxquelles vous assisterez. Cela vous permettra également de récupérer l’enregistrement vidéo si vous voulez la visionner à nouveau par la suite. Cette année il y en aura encore pour tous les goûts. Du…

 
Read More
David Barbarin

SQL Server 2017 on Linux and some log shipping scenarios

By | Database Administration & Monitoring | No Comments

In this blog let’s talk a little bit about the log-shipping feature from the SQL Server CTP 2.0. First of all, let’s say that as a Windows version, it is possible to create our own solution based on Linux (and cron jobs for example). You may find out different pointers on the internet that deal with this topic. But getting the built-in log-shipping feature from SQL Server presents some advantages. Indeed, this is basically the…

 
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
David Barbarin

Speaking at the next SQL Nexus at Copenhagen 2017

By | Database Administration & Monitoring | No Comments

On May 2nd, I will have the chance to speak during the next SQL Nexus event in Copenhagen (1 -3 may) about SQL Server 2016 and availability groups and if I have enough time, you will see what is coming with the SQL Server vNext. This is also a good opportunity to attend to other sessions held by well-known people in the industry like David Klee, Edwin M Sarmiento, Wolfgang Strasser and Uwe Ricken  to name a…

 
Read More
David Barbarin

Introducing AlwaysOn availability groups on Linux

By | Database Administration & Monitoring | No Comments

A couple of days ago, Microsoft has rolled out the SQL Server vNext CTP 1.3 which includes very nice features and the one that interested me in the supportability of AlwaysOn availability groups on Linux. That is definitely a good news because we may benefit from new ways of architecting high-availability. There are a lot of new cool enhancements, which we’ll try to study when writing new blog posts. In this first blog, let’s learn…

 
Read More
David Barbarin

Introducing high-availability with SQL Server on Linux

By | Database Administration & Monitoring, Database management | One Comment

A couple of months ago, I did my first installation of SQL Server on Linux. I wrote about it in this blog post. So now it’s time to start the new year by talking about high availability on Linux with SQL Server vNext. Running standalone instances will be suitable for scenarios but I guess introducing high-availability with critical environments still remain mandatory.Currently, the CTP1 supports installing a SQL Server Failover Cluster Instance on the top…

 
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