by George 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 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 Grammatikos | May 26, 2018 | Azure, Azure SQL Database, 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... 
by George Grammatikos | May 26, 2018 | Azure, Azure SQL Database
SQL Managed instance is at Preview and after you accept the terms and send the mail, you will receive a confirmation email from Microsoft Managed Instance Team. Create Managed Instance So, if you are able to see the next image then your request has been approved. You... 
by George Grammatikos | May 26, 2018 | Azure, Azure SQL Database, VNet
One of the most important elements of Azure SQL Managed Instance is the Virtual Network. The following steps are required for VNet configuration for Managed Instances. Create a Virtual Network Create a Route Table, this will enable communication with Azure services.... 
by George Grammatikos | May 25, 2018 | Azure, Azure SQL Database
Azure SQL database Managed Instance is a fully managed SQL Server instance hosted in Azure Cloud with full communication with the company’s LAN and provides most SQL Server 2017 features. Benefits SQL Database Managed Instance has plenty of benefits: Security:...
