Stéphane Savorgnano

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

Windows Server 2012 R2: solving .NET Framework 3.5 installation problems

I faced a problem at a customer site last week when I tried to install the .NET Framework 3.5 – a prerequisite for installing SQL Server 2012 on a Windows Server 2012 R2. I opened the Server Manager and then(…)

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

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

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

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

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

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

Microsoft TechEd Madrid: Windows Server 2012 R2, High Availability, SQL Server Data Tools

Let’s talk about my third day at TechEd 2013. I started with a session about: Windows Server 2012 R2 and High Availability The goal of High Availability is to deal with possible points of failure in your infrastructure.

Microsoft TechEd Madrid: Optimizing T-SQL & SQL Server 2014 Futures and Features

Today, I am beginning my second TechDay by a session about Optimizing T-SQL. You need to know about this if you are using SQL Database or Microsoft SQL Server 2012. Tobias Ternström, Lead Program Manager, was the speaker of(…)