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...
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...
To connect to a Virtual Network with VPN you need to create a virtual network gateway. There are several types of VPN you can deploy to Azure, these are Point-to-site(P2S), Site-to-Site(S2S), VNet-to-Vnet and Express Route circuit. In this post, I describe how a P2S...