When we install a Windows Failover Cluster on Windows Server and we want to have automatic failover, we need to define a Witness. Witness's job is to communicate with both sites and in case any… read more
How to migrate a SQL Server database to Azure using Data Migration Assistant
Many times we will need to migrate databases to a newer version or move them to Azure. In such a transfer there is a possibility that some components are not compatible and need corrections before we start the migration. The tool… read more
How we create a failover group in Azure Managed Instance
In a Managed Instance with multiple databases in Azure we can have high availability. More specifically, we can have an asynchronous second read-only Managed instance in the same or in a different region. We can at any time do… read more
How do we add a purchased domain to Azure Active Directory
In the article we will see how we add to Azure Active Directory a custom domain that we can purchase from any provider. What is the use of When we create a Tenant / Azure Active Directory is automatically created… read more
How we can schedule jobs on Azure SQL Databases using Elastic Database Jobs
As we know in Azure SQL Databases there is no SQL Server Agent, which means we cannot run scheduled tasks through it. However, in Azure SQL Databases we can schedule jobs in many other ways such as using Azure Data... read more
How can we schedule a Job in Azure SQL Database using Logic App
Let's say that every day we would like to send by email a report from the result of a query in a database. This process in SQL Server is done using SQL Server Agent and Database… read more
How to online migrate an instance from on-premise to Azure Managed Instance in the Cloud (Azure Database Migration Service)
In this article we will analyze how we can do online migration of a SQL Server Instance from on-premise to Azure Managed Instance. To be able to do it online, with near zero downtime, we will use Azure Database... read more
How we create a SQL Managed Instance in Azure
One of the possibilities we have in the Azure Cloud is to provide us with an entire Instance of SQL Server without having access to a Virtual Machine. You call this service Azure SQL Managed Instance. What are the advantages of… read more
How we create a simple database in Azure SQL Database
In a previous article we saw what an Azure SQL Database is and the differences between SQL managed instances and SQL elastic pools. In the article we will analyze how to create a Simple Azure SQL Database step by step and... read more