I’ve been experimenting and deploying Azure Stack PoC since TP1 was released. Since then, lot of things changed, first with Azure Stack TP2 and later with TP3. Idea of running Azure like environment in my datacenter was amazing to me and I tried to test it right away. Here are hardware requirements for Azure Stack…
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…
One of most interesting things last year was release of MS SQL Server for Linux. Like I said in some of my posts before, I wouldn’t have dreamt of it 5-6 years ago. But things changed very much in last few years and this is another big step Microsoft took toward OpenSource community. In this post I will…
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…
I did few sessions on Azure Server Management Tools but my friend Romeo Mlinar keeps missing them. So he asked me today when will I do ‘How to’ article on SMT and here we are. Server Management Tools is great tool that helps you manage your servers remotely in a browser. Almost any browser is supported,…
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 this post I’ll talk about syncing Azure Active Directory with local Windows Server AD. Like most of my latest ports, we’ll do it in new portal where Azure AD feature is still in preview. So we start with connecting to server that we’ll use for synchronization. Note that it’s not recommended to use your DC…
In my last post I mentioned ‘Deployment scripts’ and after that I got few comments and e-mails about this subject. So I decided to make it subject of my next post. Template deployment is one of the benefits of ARM (Azure Resource Manager). ARM enables you to bind different resources into resource group and view…
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….