Category: Azure

School of Hard Knocks: SQL Server, Storage Spaces Direct and Cluster Shared Volumes edition

Posted on by Mika Sutinen in SQL Server Administration, SQL Server DBA, SQL Server, Windows Server Management, Azure, Windows Administration, Failover Clustering, Databases

While I work 100% with cloud based SQL Server deployments these days, my life is not all unicorns and PaaS services. Surprisingly (or not) enough, many of the environments in the cloud are still build on top of good, trusty virtual machines. Except that sometimes they’re not good or trusty. There are definitely some good reasons for deploying VM’s in the cloud, however some decisions on the architecture can prove to be a challenge in a long run.

In this post, I’ll share my experience from struggling with some of these decisions, and hopefully help some of you make better decisions out there. Let me share a woeful story about Storage Spaces Direct and Cluster Shared Volumes.

(more…)

Sometimes the VM in Azure is the best option for your SQL Server workloads

Posted on by Mika Sutinen in Azure, Databases, SQL Server Administration, SQL Server DBA

I have previously written quite a few post about how much I like the Platform-as-a-Service databases for SQL Server (and for databases in general), and I do like them quite a bit. But would I recommend them for all use cases and workloads? Heck no! At the moment there are some features and limitations in Azure SQL PaaS databases that, with some of hte SQL Server workloads I have seen, wouldn’t just work all that well.

Also when we look at Azure, there’s some really cool features available for VMs that you can start using today, which are making the good old VMs an interesting option.

(more…)

How to give everyone in Azure access to your database, the easy way

Posted on by Mika Sutinen in Azure, Databases, Security, SQL Server, SQL Server Administration

Sometimes I run into things in cloud that really just blow my mind away. Not that long ago I learned how you can give everyone in Azure, no matter what subscription or region they are in, an access to your database. And it was super easy too. It’s just one click to allow whole (Azure) world to start accessing your data.

Is this something I wanted to do, or would I recommend anyone to do it? No, not really. Also the documentation around this particular setting was less than great, so I decided to share what I learned.

(more…)

Platform-as-a-Service databases and the future of the DBA role

Posted on by Mika Sutinen in Azure, Career advice, Databases, SQL Server, SQL Server DBA

I just realized that it has been awhile since my last post, so I figured it’s time to do one before the end of the year. Last few months have been rather hectic with me migrating new workloads to Cloud as well as taking the time to visit PASS Summit 2019 to learn more about Microsoft Data Platform.

I also wanted to finish up my year of blogging by writing about a topic close to my heart, the evolution of the DBA role in the Cloud era. I did have a session about this topic in SQLSaturday Finland earlier this year and I will be doing a PASS Cloud Virtual Group presentation about it on January 16th.

In this post we’ll be looking at one of the Cloud technologies that have significant impact on the DBA role in the future, Platform-as-a-Service databases.

(more…)

Azure SQL Database SLA is awesome

Posted on by Mika Sutinen in Azure, Data Platform, Databases

Microsoft recently released their new SLA, RPO and RTO guarantees for Azure SQL Database and oh boy, those are really something else. In fact they are so much something else, that at the moment of me writing this, no other cloud provider has managed to promise the same level of business continuity for their Platform-as-a-Service database services.

Besides the highest SLA currently in the market Microsoft has gone one step further and is now guaranteeing also RPO and RTO for their service. Now this is very interesting approach because neither Google or AWS is giving any for their own services.

(more…)

SQL Server Backups to Azure Part 4: Managed Backups

Posted on by Mika Sutinen in Azure, SQL Server, SQL Server Administration, SQL Server DBA

You’re now reading the 4th and final post in my SQL Server Backups to Azure series. In previous posts I’ve described how to setup an Azure Storage Account, Blob Storage container an how to take SQL Server backups there. This time we’ll take a look at one more option that puts our backups on autopilot, with destination to cloud!

The feature I am writing about is Managed Backups, option that has been available since SQL Server 2014 but one that I have not seen often used. One reason for that maybe being, that there’s an unfixed feature that makes enabling it bit difficult if you’re not aware of the workaround.

Despite this shortcoming, if you have SQL Servers (on-premise or Cloud) but no DBA to care for them, I’d recommend that you take a look at this option.

(more…)

SQL Server Backups to Azure Part 3: Custom Backups

Posted on by Mika Sutinen in Azure, SQL Server, SQL Server Administration, SQL Server DBA

You are now reading the 3rd part of the 4 part series on backing up databases to Azure. In Part 1 we looked at some of the benefits of using Azure for your backups and in Part 2 we setup the Storage Account with the Block Blob storage container.

In this post we’ll take a look at how to use the freshly created Blob storage with our customized backup routines.

(more…)