by George Chrysovaladis Grammatikos | Jan 1, 2024 | App Service, Azure, Azure SQL Database, Compute, Databases
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...
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 relational...
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...