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 Containers: Migration

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,… 

Windows Container: installation and utilization

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… 

Windows Server 2016: Containers

One of the new feature which will come with Windows Server 2016 is the Containers. Microsoft made available its fourth technical preview of his Windows Server 2016 platform  some days ago. This new Technical Preview brings with it and for the first time Hyper-V Containers as the Technical Preview three came with the first release of Windows Server Containers. I… 

SQL Server 2016 CTP3.0: Stretch Database enhancements

Some months ago, my colleague Nathan explained you the bases of the new Stretch Database functionality via two blogs here and here. With the new SQL Server 2016 CTP 3.0, Stretch Database now includes new features and enhancements that I will sow you in this blog.   In previous versions of SQL Server 2016 CTP 2.x, before to be allowed… 

SQL Server 2016: New possibilities for Index Maintenance Task

The new CTP 2.4 has been released some weeks ago by Microsoft. My colleagues and I have already blogged about some new functionalities. I will focus in this blog about the new possibility of Index Maintenance Tasks regarding Indexes. Until SQL Server 2016, DBAs didn’t use often the Maintenance Plan provided by SQL Server for indexes. In fact, those two… 

SQL Server 2016: Upgrade Advisor

During the read of a blog of my colleague Nathan Courtine about Stretch database, I installed the version of SQL Server 2016 Upgrade Advisor and Oh surprise! it looks really NEW! “A new generation of advisor tool for SQL Server” aka Microsoft. To download and install it, click here. This new version has a dual role: Check the compatibility of… 

SQL Server 2016: In-Memory OLTP enhancement

The CTP2.1 has been released for some weeks and it is time to check which interesting enhancements have been already deployed for the In-Memory OLTP feature. I will first have a look to the memory optimized table. Memory Optimized table I have a Memory Optimized table named command_queue_HK and I will add a column to this table. This table is… 

How to solve accent sensitive problems?

Some days ago, one of my customer claimed that searching for “Muller” doesn’t return “Mueller” and “Müller” as well! This is typically an issue due to the collation of the SQL Server database, but how to resolve this problem? The collation of the database is Latin1_General_CI_AS, so a case insensitive and accent sensitive collation. If a run the following query:… 

SQL Server 2014: Analysis, Migrate and Report (AMR) – a powerful In-Memory migration tool

An important new functionality of Microsoft SQL Server 2014 is the In-Memory OLTP engine, which enable you to load Tables and also Stored Procedures In-Memory for a very fast response time. The goal is not to load all the database In-Memory but just Tables with critical performances and Stored Procedures with complex logical calculations. To identify which Tables or Stored… 

SQL Server 2014: First Service pack (SP1) is available

May 14th, Microsoft has released the first Service Pack (SP1) for SQL Server 2014. It is more than thirteen months after the RTM version. SQL Server 2014 Service Pack 1 includes all of the CU from 1 to 5. Which issues are fixed in this SP1 There are 29 hotfixes: 19 for the Engine 6 for SSRS 3 for SSAS… 

In-Memory OLTP: Hash and Range indexes

Since SQL Server 2014 CTP2, Microsoft has introduced a new kind of index which is the Range index. We have now two ways for indexing an In-Memory table: using either an Hash index or a Range index. These two indexes are slightly different. In fact, a Hash index is a set of buckets, 8-bytes memory pointers, which points to the…