Infrastructure at your Service

All Posts By

Stéphane Savorgnano

Stéphane Savorgnano

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

By | Cloud, Database Administration & Monitoring, Database management, SQL Server | No Comments

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 group. This group will contain one or more VMs which will share the same backup configuration for retention, synchronization and recovery. Protection is managed as follow: DPM create a copy of the selected data on the…

Read More
Stéphane Savorgnano

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

By | Cloud, Database Administration & Monitoring, SQL Server | No Comments

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 will today installed a MABS on one of my virtual on-premise server and uses it to protect my others virtual on-premises servers. To do so you go to your Azure Recovery Services vault. A vault is…

Read More
Stéphane Savorgnano

Recover data from Azure backup

By | Operation systems, Security, Technology Survey | No Comments

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 console have been installed during the setup of the Azure backup in the Windows Admin Center. When we open the Microsoft Azure Backup console, we directly visualize the jobs activity for the last 7 days in the…

Read More
Stéphane Savorgnano

How Windows Admin Center can backup on Azure

By | Database Administration & Monitoring, Operation systems, SQL Server | No Comments

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), Windows Admin Center is a great tool to centralize the management of our Physical, Virtual, on-premises…Windows Server. This browser-based tool is also a hybrid tool which is able to integrate your on-premises servers with Azure…

Read More
Stéphane Savorgnano

How to run Avamar backup on SQL Agent Job with PowerShell

By | Database Administration & Monitoring, Database management, SQL Server | No Comments

By one of our customer we use Avamar for the backup and restore solution. I was asked by this customer to find a solution to run Avamar backups for a group of databases on a specified instance. In fact, we currently try a database clone solution on some instances and clone’s databases must not be backed up, but the rest of the databases must be. After some discussions with my colleague I decided to use…

Read More
Stéphane Savorgnano

How to migrate from on-premise to an Azure SQL Database

By | Cloud, Database management | No Comments

As a SQL Server DBA we have the habit to migrate databases from an instance to another one or to a new environment. But migrate a database from on-premise to the Azure Cloud is an operation that we don’t deal with every day. As a reminder, Azure SQL Database is a relational database-as-a-service (DBaaS) which gives the ability to manage your databases directly from the Cloud with the performance of your choose, reliability, security and…

Read More
Stéphane Savorgnano

How to create an Azure SQL Database

By | Cloud, SQL Server | No Comments

Azure SQL Database is a relational database-as-a-service (DBaaS) which gives us the possibility to create application with a performant database without to take care of the relying infrastructure. Azure SQL Database is based on the latest stable version of Microsoft SQL Server Database Engine. We have the choose between 2 purchasing models: a vCore-based purchasing model and a DTU-based (Database Throughput Unit) purchasing model. 3 Deployment options possible: single database: has its own set of…

Read More
Stéphane Savorgnano

SQL Server Management Studio 17.4: Vulnerability Assessment

By | Database Administration & Monitoring | No Comments

SQL Server Management Studio is a well know integrated environment used to manage SQL Server infrastructure. This new version 17.4 can support SQL Server from 2008 up to 2017. It enhances existing features like Showplan, XE Profiler (complete list here) but also add an interesting one which is the Vulnerability Assessment. Vulnerability Assessment will scan a database in order to help you to track security holes and deviations. Rules to define those deviations are based…

Read More
Stéphane Savorgnano

Pass Summit 2017: how to bypass SQL Server security

By | Database Administration & Monitoring | No Comments

Last Friday I saw a very interesting session in Pass Summit 2017 about how to Bypass, or Ensure, SQL Server security by Matt Martin. Matt explained us how to bypass SQL Server security with the complicity of your SQL Server DBA. Msdb is the most powerful database to get stuff done: mail, jobs… so let’s have a look how to take the power within a SQL Server instance. Start a job under SQLAgentOperator role SQLAgentOperator…

Read More
Stéphane Savorgnano

Pass Summit 2017

By | Database Administration & Monitoring | No Comments

Today starts the Pass Summit 2017 taking place in Seattle. After a small fly over the Ocean, more than 10 hours… yesterday, and a nice jet lag which avoid me to sleep later than 4AM this morning, I arrived to the Convention Center in Seattle where the Pass takes place. I start this first day by the session of Itzik Ben-Gan: T-SQL Tips and Tricks. As part of the session, Itzik spoke about batch processing…

Read More