Azure CosmosDB

 Goto Azure Home Azure has built a highly scalable, high Available, high performance and globally distributed DB called Cosmos DB (Formerly known as document DB) which is driven only in Azure cloud as a PAAS Service. Although the document database is here for last few years and I am assuming many of you very well knows about it,...

Backup and Restore in Azure SQLDB

 Goto Azure Home One of the most important reasons to prefer Azure SQL Database over SQL Server is Database Backups. In Azure SQL Database the Backups are automated and the user need not worry about the Database or maintenance. In this article we would see the Backup and Restore options available in Azure SQL DB as...

SQL Managed Instance in Azure

 Goto Azure Home SQL  Managed Instance is the next giant leap for SQL Server Databases in Azure. SQL  Managed Instance almost Providing 99 percent features comparing to SQL Server Instance. Migration from On Premise\IAAS SQl server instance to Azure PAAS would be much easier and flexible or even we can say much possible now after introducing...

Azure SQL Database Deployment using ARM template

 Goto Azure Home In one of the earlier article we have seen how to Create Azure VM using ARM template(Click here to Navigate). The procedure to create any resource\service using ARM template is quite same. To create a ARM Template you shall use the Automation feature available in Azure Try to configure a Database in Azure...

Elastic pool in Azure DB

 Goto Azure Home In Our earlier articles we have seen what DTU is and how to configure Azure Database based on DTU. In this article we would see what Elastic Pool is and how to configure database in elastic Pool. SQL Elastic Databases are more accurately described as SQL Elastic Database Pools. The idea is that...

Connect, Query and Explore Azure SQL Database

 Goto Azure Home We would be able to Query Azure SQL Database either using portal or SSMS. SSMS is a standard way to Connect and Query Azure Database. Query Editor in Portal is an Additional feature to Query the database. Let us See them in brief. This Article will provide details on Query Editor Database Connection...

Creating SQL Database in Azure

 Goto Azure Home In this article, you learn how to use the Azure portal to create Azure SQL PAAS Database Select SQL Database Service in Azure Portal Select Add to add a New database. Give the Database Name, Subscription. For New Database Select Source as Blank database. Server selection  is the Logical Server. That is unlike...

Service Tiers in Azure SQL Database Purchase model

 Goto Azure Home When you create a SQL Database for the first time, you will bump into a required setting: the service tier. The first impression is that a “Service Tier” is related to price, and so the natural urge will be to choose the cheapest one. Resist the urge! A service tier is more than...

Purchasing Model for Azure PAAS SQL Database

 Goto Azure Home Before taking you through Configuring Azure Database, I would like to explain about purchasing model available in Azure to configure database. Azure SQL Database enables you to easily purchase PaaS database engine that fits your performance and cost needs. Depending on the deployment model of Azure SQL Database, you can select the purchasing...

SQL Server Database in Azure

 Goto Azure Home Database Cloud offering as PAAS is one of the giant leap in database world.  There are three ways you can have a SQL Server database as PAAS solution in Azure.                Azure SQL Database                Azure Database in Elastic Pool  ...