Lesson Learned #39: Best Practices using BCP in Azure SQL Database

In multiple support cases our customers asked questions about what are the best practices to avoid fill up the transaction log or temporal database when they are importing a high number of rows using BCP. In this new video in Spanish and English you could find these best practices, also, how to check the compatibility…


Export Azure SQL Database to local path

We noticed a few requests come to our support queue asking for a feasibility to export Azure SQL Database to local path directly, so following steps below to build  PowerShell script that can do that job to copy Azure SQL Database to another db for consistency, then export Azure SQL Database to blob storage, later…


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…