Post image

Azure Storage Throughput

Hot on the heels of DTUs from earlier this week, today we’re going to switch focus a little, while staying with Azure, and have a quick look at storage speeds on SQL Server running on Azure Virtual Machines (Infrastructure-as-a-Service). Microsoft recently lowered their prices for more popular VMs, which is making this an attractive solution for
-> Continue reading Azure Storage Throughput

Post image

Importing a BACPAC into Azure SQL Database

In our final look at migrating a database to Azure SQL Database, we will import a BACPAC file. From previous weeks we know that a BACPAC file contains the full schema, as well as the data (in BCP format), of the database we are migrating. It is based on the structure of a DACPAC file, which
-> Continue reading Importing a BACPAC into Azure SQL Database

Post image

Moving a database to Azure SQL Database

This week we will actually move a database into Azure SQL Database, using the first of two of Microsoft’s recommended methods. The main thing to keep in mind is that SQL Server (on-premises, or “earthed”) and Azure SQL Database (“cloud”) are not the same product. They support the same schemas and data, and allow the
-> Continue reading Moving a database to Azure SQL Database

Post image

What is physical storage anyway?

My friend Jason asked me about his MySQL database export file last week, whether it was sufficient to create a new database. I replied saying that he would have to set up the database separately, because the physical files are allocated in a particular way depending on the web host. What is a physical file,
-> Continue reading What is physical storage anyway?

Post image

AzCopy 101 – Copying SQL Server backup files to Azure Blob Storage

SQL Server 2016, released last month, now lets us back up our database files to two locations simultaneously. This is very good news if we’re running the latest and greatest (and it really is a good upgrade). For everyone else, the bad news is that we are targeting an on-site destination for our backups (local network,
-> Continue reading AzCopy 101 – Copying SQL Server backup files to Azure Blob Storage

Post image

Forecast: Azure Skies Over the Amazon

Microsoft Azure and Amazon Web Services are taking over. Last week, a client approached me to migrate their complex environment in two phases from two physical data centers, first to Azure VMs, and ultimately to an Azure SQL Database, doing away with logical servers completely. In my mind, this trend is only going to accelerate.
-> Continue reading Forecast: Azure Skies Over the Amazon

Post image

Update to Azure Blob Storage Sync and Restore

Blob Storage Sync tool updated During a SQL Server migration this month, I found some inconsistencies in my Azure Blob Storage Sync tool, so I made several improvements, and fixed an outstanding bug. As you know, it relies on the naming convention provided in Ola Hallengren’s Maintenance Solution and comes in two parts: the AzureBlobStorageSync command-line application, and
-> Continue reading Update to Azure Blob Storage Sync and Restore

Post image

Pre-Announcement Announcement

On Saturday, 27 June 2015, I will be presenting at SQLSaturday #407 in Vancouver BC. The session is titled “Restoring a SQL Server Database from Azure Blob Storage”. I will be releasing some new content and code at the same time as my talk, which will be available from this site, assuming WordPress plays along.
-> Continue reading Pre-Announcement Announcement