Compañero Conference and SQL Modernization Roadshow

October is a busy month for me. I am flying all over the US and Canada for speaking engagements to share some thoughts about migrating your SQL Server environment to the cloud (specifically Azure). Compañero Conference I will be presenting at the Compañero Conference, which takes place over two days, October 4 – 5 (that’s
-> Continue reading Compañero Conference and SQL Modernization Roadshow

Post image

Should I upgrade SQL Server 2012, or migrate to Azure?

[Last updated February 27, 2020] Brent Ozar Unlimited runs a website called SQL Server Updates which comes in really handy for keeping your on-premises SQL Server up to date. Of interest is that extended support for SQL Server 2012 ends on 12 July 2022, just two years from now. As we know, SQL Server 2019
-> Continue reading Should I upgrade SQL Server 2012, or migrate to Azure?

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

Database Throughput Units

Last time we briefly touched on the metric that Microsoft uses to keep your Azure SQL Database in check: the DTU, or database throughput unit. It uses a combination of CPU, I/O and log flushes/second, using a special algorithm, to calculate a single unit. The reason for this is simple: Our databases don’t use the same resources
-> Continue reading Database Throughput Units

Post image

Azure SQL Database Limits

Let’s talk briefly about resource limits with Azure SQL Database. Because we have to share resources with other users, and because Microsoft doesn’t want us affecting others dramatically, they have implemented some limits. If for some reason our database does get overeager, the operations relating to CPU, RAM and I/O will be queued up by
-> Continue reading Azure SQL Database Limits

Post image

Planning matters

It’s the 2016 PASS Summit at the end of this month, and I’ll be attending for my third year. Because I’m a glutton for punishment, I’ll also be writing bonus posts for the month of October to celebrate Summit. Fortunately, because I’m the luckiest person in the world, I am attending the Pet Shop Boys
-> Continue reading Planning matters

Post image

The Data Migration Assistant

I’ve written quite a lot about Azure SQL Database recently, but that doesn’t mean I’ve forgotten about the on-premises version of SQL Server. What could be better than Microsoft announcing a new tool for upgrading to SQL Server 2016? The Data Migration Assistant (DMA) for SQL Server was announced on 26 August 2016. Data Migration Assistant
-> Continue reading The Data Migration Assistant

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

Should I move my on-premises database to Azure SQL Database?

This week is a shorter post than last week, but it answers a very important question: Should I move my on-premises database to Azure SQL Database? The short answer is: It depends. Firstly, why do you want to move your database to the cloud? Is it a business requirement? A better way to ask this
-> Continue reading Should I move my on-premises database to Azure SQL Database?