MySQL In-app

Databases were always big part of my work and I did use MySQL in Azure before. However, I did not have time to try MySQL In-app until last week. It was nice surprise that it works quite fine (once you figure where to go) and it makes management easier as it is under same blade…

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…

Install SQL on Linux VM

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…

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

Microsoft + OpenSource

Last few days a lot of people shared link Announcing SQL Server on Linux . And this might be big WOW and surprise for a lot of people but is it really such a surprise? Well yes, if you look at Microsoft few years back while under CEO Steve Ballmer. But since Satya Nadella took over, Microsoft…

P-Seller for SQL Server

It’s official now, I’ve been nominated and accepted as Microsoft P-Seller for SQL Server. It’s been official for couple of weeks but I didn’t get to write about it because of other commitments, work and preparing for new certification. Anyway, I’m greatly honored to be presented with such opportunity and to be selected among MS community…

SQL Server Slow execution after migration to new server

So my last post got me thinking what was also big problem that I spent days trying to resolve. And then I remembered. We were doing migration of database and application from old server to new one. Everything went smoothly, everything was up and running untill couple of days later. One of procedures was taking forever to…