construction

The cloud is not just someone else’s computer

A year ago, I wrote in a post that cloud computing is just someone else’s data center. I was wrong. Whether we like it or not, the cloud is more than just a bunch of 1s and 0s hosted on someone’s hardware. The problem with my statement was the word “just”. I’ve presented several times on[…]

SQL Server 2017 Administration Inside Out

For the last five months or so, I have been helping some really smart people put words on paper, both the physical and electronic kind, which is hopefully going to culminate in an actual technical book that I can point to and say “Yes, that’s the name I invented for myself when we moved to[…]

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[…]

Post image

Should I upgrade SQL Server 2008 / R2, or migrate to Azure?

[Last updated July 13, 2018] 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. In October 2016 I noticed something interesting: if you’re running SQL Server 2008 or 2008 R2, Microsoft’s extended support for it ends on 9 July 2019.[…]

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[…]

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[…]

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[…]

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[…]