How to change Azure SQL DB LTR Recovery Service Vault ?

Received a comment saying ‘Can’t Change the server Recovery Service Vault’, took a breathe and start a new Lab on Azure Portal trying to find out how it can be changed, after a lot of tries unfortunately I realized that it can’t be done through the portal, so what is our best friend Solution ?……

0

REST API Sample for exporting a database

While working on an Azure SQL Database support case, I needed to provide a REST API sample for exporting a database. I struggled a bit to get it to work, as the syntax is not really intuitive and requires creating an Azure AD application. To save you from the same struggle, here is the sample…


ARM template outputs for Azure SQL Database

Azure Resource Manager (ARM) templates are a common way to deploy Azure Resources. One of the less often used features is the output. You may want to use this with linked templates to pass variables between templates, or if you like to print out some information. Here I describe how you can display Azure SQL…


Elastic Database Jobs: Sample for Running T-SQL Code in Multiple Databases

Introduction: After moving from on-premise SQL Server to Azure SQL Database, the SQL Server Agent service is no longer available to you. Administrators are therefore missing the ability to run recurring jobs, in order to execute T-SQL scripts and Stored Procedures on a schedule. Elastic Database Jobs are one way of implementing a scheduled execution on…


Lesson Learned #8: Monitoring the geo-replicated databases.

We received multiple requests in order to have answered the following questions: Is there needed a maintenance plan for geo-replicated databases? How to monitor the geo-replicated databases Answering the question: “Is it needed a maintenance plan for geo-replicated databases?”, No, there is not needed because is you have a maintenance plan for rebuilding indexes and update statistics…