SQL Server Backups to Azure Part 4: Managed Backups

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

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

SQL Server Backups to Azure Part 2: Setting up the Storage Account

This is the second part of a 4 part blog post series about backing up SQL Server to Azure. If you’re wondering why you’d like to backup data to Azure in the first place, please read the Part 1 of this series that explains some of the benefits of using Azure for backups.

In this post we’ll look at how to setup your very own Storage Account and how to use some of the nice security features in it.

(more…)

SQL Server Backups to Azure, Part 1: Introduction

Gone to Cloud!

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 Azure perspective. Why cloud perspective you might as? For one simple reason. Even if you’re not (yet) running your SQL Server workloads in Azure, it doesn’t mean that you can’t make use of it for other purposes, such as backups. And while the idea of placing your data into Azure, or into any other cloud platform, might still seem scary to some, I want to help put your minds at ease. To do this, I’ll just point you to this fine piece of documentation describing the Azure infrastructure security. I think you’ll find it quite satisfying.

As there’s quite a few topics to cover with database backups to Azure, I have split the details into 4 separate posts. You’re now reading Part 1, the introduction.

(more…)

PASS Summit 2015: Conference day 1

The first day of the actual conference was exciting. The Day 1 Keynote by Joseph Siroshi (Microsoft Corporate Vice President, Data Group) was something that I found especially interesting as the examples of data strategy were derived from the healthcare industry, which happens to be the same industry I’m involved with. The funny thing was that we were discussing how technology will shape the future of healthcare industry during the breakfast. And then, less than hour later we’re shown how analytics provided by the Microsoft Data Platform can analyze decoded human genome to provide list of possible health problems. How crazy is that?

(more…)

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 really optional, you can do a test environment without it but I prefer test environments that mimic the production.

(more…)