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...

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...

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...

Azure Database Services

 Goto Azure Home Before starting about Database Services available in Azure, I would like to brief about the Service models available in Cloud. The Service models available are IAAS, PAAS, SAAS. How do they differ? The below diagram is self-explanatory. IaaS Means - Infrastructure-as-a-Service IaaS provides the infrastructure such as virtual machines and other resources like...