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…
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…
One of most used Azure service is backup. Storage is very cheap in Azure and it gives us option of creating backup very far away from our on-prem environment. In this post I will cover basics on how to create MS SQL database backup to Azure Storage. Note that for using this option you need…
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,…
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….