Tag: Azure Cloud VM
School of Hard Knocks: SQL Server, Storage Spaces Direct and Cluster Shared Volumes edition
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…
Sometimes the VM in Azure is the best option for your SQL Server workloads
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…
Platform-as-a-Service databases and the future of the DBA role
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…
SQL Server Backups to Azure, Part 1: Introduction
I’ve said it before, and I say it again: Understanding how database backups and restores work is one of the more important topics for DBAs to understand. This time we’ll approach the topic from the cloud, and more precisely, from the Azure perspective. Why cloud perspective, you might as? For one simple reason. Even if…
Part 3: Setting up your SQL Server!
At the final part of my three-part series on how to set up your own test environment into Azure, we’re joining our SQL Server into Active Directory and downloading a database to use for testing.
Part 2: Create Virtual Machines and Active Directory
In previous post, Part 1: Creating Azure Network and Storage, we set up your Azure account ready for two virtual machines that’ll be the backbone of your own testing environment. One of these servers will run the Active Directory and the other one will host your SQL Server 2012 instance. The Active Directory server is…
Part 1: Create Azure Network and Storage Account
Now that you’ve setup your Azure account we can get started on building the test environment. First thing you should do is to create a Virtual Azure Network, this will be used for connectivity between your servers. Creating a Network is quite straightforward business. Choose Networks and then Create A Virtual Network.