Skip to content

Stéphane Savorgnano

Stéphane Savorgnano has more than 20 years of experience in Microsoft software development and SQL Server database solutions, specializing in SQL Server installation, performance analysis, and best practices. He holds Microsoft Certified Solutions Associate (MCSA) and Expert (MCSE) for SQL Server 2012 through 2017, MCTS, MCITP for SQL Server 2008, and ITIL V3 Foundation certifications. Prior to dbi services, he was a software engineer at Ciba Specialty Chemicals in Basel. He holds a Master's degree in Informatics from the University of Mulhouse. His industry experience covers banking and financial services, chemicals, and pharmaceuticals.

75 posts since November 2012

Windows Server Next, AKA Windows Server 2016!

The first technical preview of the future version of Windows Server was, since last October, available (here) and a second one with more new features should be available in May. The final version which should be normally released in 2015 has been recently postponed to 2016. It will be the first time that the client and server releases will be… 

SQL Server: Change Data Capture for Oracle

This new feature has been introduced in SQL Server 2012 and needs an Enterprise Edition. It uses a Windows Service which scans Oracle Logs and tracks DML changes from Oracle tables into SQL Server change tables. In other words, Change data capture records Insert, Update and Delete activities that is applied to Oracle tables. Let’s see how it works. Prerequisites… 

SQL Server monitoring with nagios: utilisation

We saw in my last blog how to install the SQL Server plugin for Nagios. In this new blog, I will explain: how to create a wrapper to avoid the unset of the PERLLIB variable how to create and configure a configuration file by monitoring instance how to create an SQL Login for nagios How to subscribe to an alert… 

SQL Server monitoring with nagios: installation

Nagios is an IT Infrastructure monitoring solution which is able to monitor SQL Server instances with a specific plugin. I have installed this plugin to test those functionalities and I will explain here how to do it. Prerequisites installation FreeTDS installation FreeTDS is a set of libraries for Unix and Linux that allows your programs to natively talk to Microsoft… 

SCOM: don’t forget to set the license key!

During some client testing operations I installed some months ago a version of System Center Operation Manager 2012 on a Virtual Machine. Today I try to open this version of SCOM to perform some new tests and I had the surprise to receive a beautiful error message: In fact, I never thought to verify that my version was licensed or… 

How to avoid Failover Cluster with PowerShell scripting

One of my colleague asked me some days ago if I could create a PowerShell script to get rid from Windows Server Failover Cluster. The reason is that it has, in some specific cases, the bad habit to failover a resource or a service even when we don’t want it. To be honest, I use a lot the Failover Cluster… 

SQL Server 2014: Readable Secondary with In-Memory objects

In-Memory OLTP is one of the best new functionalities of SQL Server 2014 as it was the case with AlwaysOn and SQL Server 2012. In-Memory OLTP is fully integrated with AlwaysOn and also with AlwaysOn Availability Group. During my test with AlwaysOn Availability Group under SQL Server 2014 CTP2, I discovered that a Readable Secondary Replica was not able to… 

SQL Server 2014 CTP2: In-Memory Advisor for Tables and Stored Procedures

One of the best new functionalities of Microsoft SQL Server 2014 is the In-Memory part, which gives you the possibility to load tables and also Stored Procedures in-memory for a very fast response time. The Community Technology Preview 2 from Microsoft SQL Server 2014 went out some days ago with two new Advisors. These Advisors will help you manage the… 

SQL Server 2012 SP1: Sixth Cumulative Update (CU6) available

Some days ago, Microsoft published the sixth Cumulative Update (CU6) for Microsoft SQL Server 2012 Service Pack one, two months after the fifth one. As usual, if this Cumulative Update solves an issue you are facing, install it quickly – otherwise, do not install it and just have a look at it. Which issues are covered by this CU6? It… 

SQL Server 2012 SP1: Fifth Cumulative Update (CU5) available

On 16 July, Microsoft published the fifth Cumulative Update (CU5) for Microsoft SQL Server 2012 Service Pack One. As usual, if this Cumulative Update solves an issue you are facing, install it quickly – otherwise, do not install it. Which issues are covered by this CU5? This Cumulative Update contains 29 Hotfixes: 20 for the Engine 5 for SSRS 2 for… 

High availability and disaster recovery on Windows Azure VMs

To be honest, I am not a specialist of Windows Azure. In order to learn a little bit more about this subject, I decided to follow a TechEd Europe 2013 session about High Availability and Desaster Recovery on Windows Azure Virtual Machines. Overview of Windows Azure Windows Azure is Microsoft’s application platform for the public cloud. You have the possibility…