How to determine Azure SQL Database Tier

Recently, I got lot of questions on how to determine tier and performance level for Azure SQL Database. Therefore, I decided to write my next post about this topic. To determine correct tier for specific workload, you have to take into account multiple parameters. First, let us talk about Azure SQL database tiers. Azure SQL…

Schedule MS SQL database backup to Azure storage

As I promised in one of previous posts, I’ll write about scheduling MS SQL database to Azure Storage Account. We’ll start with creating new Storage Account. Go to Azure Portal and click ‘New’. Select ‘Storage’ and ‘Storage account’. Enter parameters for your Storage account. Enter name, deployment model must be ‘Classic'(as ARM will not be visible…

Azure Basics Part 5 – Azure SQL Administration

In last post I wrote about creating new Azure SQL database. At the end of post, I mentioned that features available from SSMS when connected to Azure SQL are very poor when compared to full MS SQL Server. When we compare these two, we can see that in Azure SQL we are missing Server objects,…

Azure Basics Part 4 – SQL PaaS

Next few posts will be about one of my favorite subjects – SQL. When we talk about databases in Azure there is lot of options, depending on what you need. If you need more services that traditional MS SQL Server offered on premise, best way is to use IaaS, VM with MS SQL Server installed….