Stéphane Savorgnano

Striim, real-time data integration

In my first blog-post about Striim, I showed you how to create an Initial Load from an on-premise database to an Azure SQL DB. In this second blog post I will create an application which will stream Data(…)

Striim, first step

In this blog-post I will discuss about my first test with Striim. Striim is a data integration platform which can ingest real-time data from a variety of sources (SQL Server, Oracle, Kafka, Hadoop…) and quickly deliver it to Cloud(…)

How to solve Stored Procedure parameter sniffing problems

Since Tuesday, I have the chance to follow the SQLBits 2022 conference. Sadly, I have to do it remotely this year but I promise next time I will come in-person 😉 SQLBits is one of the largest(…)

Automate restore from Rubrik with PowerShell (part 2)

As promised during my last Rubrik blog post I’m writing a second one to explain how to: log your different steps in a file add an integrity check after the restore and also improve my first scripting I will(…)

Automate restore from Rubrik with PowerShell

One of our customer uses Rubrik as a solution to recover, manage, and secure all their data. In this context, Rubrik is used to backup and restore all the SQL Server instances. We need to run restore tests(…)

Azure Migrate: how to assess on-premises servers for a future Azure migration

Azure Migrate provides a set of tools to assess and migrate on-premise infrastructure like Hyper-V or VMware virtual machines, physical servers as well as SQL and other Databases, web application… The Azure Migrate overview page resumes the different key(…)

Use MABS to protect Hyper-V on-premises VMs workload

During my last blog post I explained how to installed a MABS. Now that your infrastructure is setup you will be able to protect the workload of your Hyper-V Virtual Machines. You have first to create a new protection(…)

How to install MABS (Microsoft Azure Backup Server) and use it to protect on-premise virtual machines

During my last blog-posts I tested the MARS (Microsoft Azure Recovery Service) through Windows Admin Center and how to use Azure Backup to recover files/folders or System State for protected servers. To continue my Azure protection possibilities overview I(…)

Recover data from Azure backup

During my last blog-post I experienced to use Azure backup to protect an on-premise Windows server. To recover data from Azure backup we need to use the Microsoft Azure Recovery Services console (MARS). This service and its management(…)

How Windows Admin Center can backup on Azure

To be honest I never used before Windows Admin Center but after some hours of utilization I’m still convinced. As SQL Server Management Studio is a great tool to manage our SQL Server instances with a CMS (Centralized Management Server),(…)