by George Chrysovaladis Grammatikos | Jan 16, 2020 | Azure, Azure SQL Database
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 George Chrysovaladis Grammatikos | Dec 22, 2019 | Azure, Azure SQL Database, NoSQL
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...
by George Chrysovaladis Grammatikos | Feb 19, 2019 | Azure, Azure SQL Database
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. ...
by George Chrysovaladis Grammatikos | Jan 8, 2019 | Azure, Azure SQL Database
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...
by George Chrysovaladis Grammatikos | Jun 22, 2018 | Azure, Azure SQL Database
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...
by George Chrysovaladis Grammatikos | May 26, 2018 | Azure, Azure SQL Database, Networking, VNet
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...