Infrastructure at your Service

All posts by Stéphane Savorgnano

Stéphane Savorgnano
Consultant

Stéphane Savorgnano has more than fifteen years of experience in Microsoft software development and in SQL Server database solutions. He is specialized in SQL Server installation, performance analysis, best practices, etc. Stéphane Savorgnano is Microsoft Certified Solutions Associate (MCSA) and Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. Prior to joining dbi services, he was software engineer at Ciba Specialty Chemicals in Basel. Stéphane Savorgnano holds a Master of Informatics from Mulhouse University (F). His branch-related experience covers Banking / Financial Services, Chemicals & Pharmaceuticals, etc.
Stéphane Savorgnano

SQL Server 2017 on RHEL first installation

By | Database Administration & Monitoring | No Comments

Beginning of last week Microsoft announced the general availability of SQL Server 2017 for today, the second of October. In the same time, but in a more marketing side, Microsoft announced a SQL Server on Red Hat Enterprise Linux offer, more information here. It looked for me like the good time to do my first installation of SQL Server 2017 on Linux. My first concern was to download an ISO of the Red Hat Enterprise…

 
Read More
Stéphane Savorgnano

Windows Server 2016 RTM and Docker

By | Technology Survey | No Comments

I wrote some months ago several blog posts about the new Container feature of Windows Server 2016. Here is the list: Windows Server 2016: Containers Windows Containers: Migration Windows Container: installation and utilization Today, I will install the Container feature, install Docker and deploy a container. First of all, I need to enable the Container and the Hyper-V feature, take care if you use VirtualBox because after having enable Hyper-V this won’t work anymore. Windows…

 
Read More
Stéphane Savorgnano

SQL Server 2016: Dynamic Data Masking and database role

By | Database Administration & Monitoring, Technology Survey | 3 Comments

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 questions concerning the new functionality Dynamic Data Masking were asked. In fact data are masked for some roles and not for some others. Let’s try to clarify that. I will use the same script I used…

 
Read More
Stéphane Savorgnano

SQL Server 2016: Always Encrypted – part 2

By | Database Administration & Monitoring, Technology Survey | No Comments

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 a security server to avoid that certificate will be available for all users and break the segregation. Let’s see how to build those environment. In my security server named SQL2016-2, I first create a Self-signed certificate…

 
Read More
Stéphane Savorgnano

SQL Server 2016: Always Encrypted

By | Database Administration & Monitoring, Technology Survey | One Comment

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 persons who own the data and person who manage it. Only persons who own the data can see plain text data and person like DBAs, sys admins or privilege logins cannot have access to the…

 
Read More
Stéphane Savorgnano

SCOM: schedule group maintenance task with PowerShell

By | Database Administration & Monitoring, Operation systems, Technology Survey | No Comments

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 maintenance window of our different servers. Let’s see how we can do that with PowerShell script. First, I try to use the cmdlet Register-ScheduledTask, which can be used to register a scheduled task definition on a…

 
Read More
Stéphane Savorgnano

SCOM: change group state to maintenance mode with PowerShell

By | Database Administration & Monitoring, Database management, Operation systems, Technology Survey | No Comments

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 like an update, a patching, …, we don’t want to be spoiled by lots of alerts. To avoid those unexpected Emails, we need to place our group and so, objects contained in this group, in maintenance…

 
Read More
Stéphane Savorgnano

SCOM: Creation of a group in order to subscribe to alerts

By | Database Administration & Monitoring, Technology Survey | No Comments

I am currently managing at one of my customer a monitoring project that concerns SQL Server instances and SCOM (System Center Operation Manager). The project includes many instances, more or less 50, divided in two environment (Production and Test) and different versions of SQL Server as 2008, 2012 and 2014. The defined target was to create two groups of instances, respectively Production and Test, in order to manage differently the alert’s subscription. Let’s see how…

 
Read More
Stéphane Savorgnano

Windows Containers: Migration

By | Database Administration & Monitoring | No Comments

In my last blog post (here), I explained how to configure a host for Windows Container as well as how to use some Windows Container cmdlets. Finally I demonstrated how to create a container with a SQL Server 2014 instance. In this blog post, I will continue by explaining how to migrate the container I just created. First of all, let’s remind the context: I have a Container named Test that runs on the top…

 
Read More
Stéphane Savorgnano

Windows Container: installation and utilization

By | Database Administration & Monitoring | No Comments

Some weeks ago, I did a general presentation about Windows Server 2016 and the new Container feature (here). Today, I will go through the installation and utilization of Windows Containers. I will use a Virtual Machine, under Hyper-V, during this blog. First of all, I have to set the environment to be able to use Windows Containers as it requires the Container OS Base Images. Microsoft has prepared a script in order to configure a…

 
Read More