Stéphane Savorgnano

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(…)

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(…)

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?(…)

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(…)

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.

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(…)

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(…)

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

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(…)

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(…)