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...
by George Chrysovaladis 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 Chrysovaladis Grammatikos | May 26, 2018 | Azure, Azure SQL Database, Networking, 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 Chrysovaladis 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:...
by George Chrysovaladis Grammatikos | May 21, 2018 | Azure, Azure SQL Database, SQL Server
In this post, you will read about the differences between index tuning in SQL Server (on-premises) and SQL Azure (cloud). But what is an index? Consider an index as a contents page. When comparing a SQL database index and a Contents page in a physical book, you note...
by George Chrysovaladis Grammatikos | Apr 16, 2018 | Azure, Azure SQL Database
In this post, you can see a demonstration of Azure SQL Database. Login to Azure Portal Login to Azure Portal by clicking here Create Resource Group Create Azure SQL Database Create Server Complete the Server Configuration as follows in the example: Choose Pricing Tier...