In this post, I will show how we can migrate a local sql server database to Azure SQL Database service using the Azure Migrate Service. Prerequisites: An active Azure subscription SQL Server (On-Premises) An Azure SQL Database A few words about Microsoft Azure...
In this post, we will see how to set up the Failover Group on Azure SQL Databases. What Failover Group does is to create a second database replica in the same or another region. Prerequisites Active Azure Subscription Azure SQL Database Server(s) + database(s) ...
By reading this post, you will be able to compare and choose the right one service for our database deployments (SQL or NoSQL). Definition SQL: A relational database management system (RDBMS) is a program that lets you create, update, and administer a relational...
In this post we will make a brief mention to the latest updates in the Azure SQL service and we see how someone can migrate a database to Azure SQL from an on-premise infrastructure.Before we begin the procedure we must know what Azure Database Services offer. ...
In this post we will see how we can easily restore database in Azure SQL ManagedInstance. There are two ways to do this, using T-SQL and Powershell. Using Powershel Before executing the following Powershell Script to restore the database we must be sure for the...
Azure SQL Database is a DaaS (Database As A Service) cloud offering by Microsoft. This service has specific characteristics. Azure is responsible for database common administration tasks, hypervisors, networking, bare metal hardware etc. The users pay according to...