Post image

Microsoft presents: MySQL and PostgreSQL?

For the longest time, MySQL has been the recommended database platform for blogs and other websites. It’s free. It’s available on every version of Linux, which is the most common web server platform. If you need something more complex but still free, there’s PostgreSQL. But there’s a lot going on beyond that word “free”. Because
-> Continue reading Microsoft presents: MySQL and PostgreSQL?

Post image

A look back, and a look forward

Time flies. My father used to wear a t-shirt that claimed, “When you’re over the hill, you pick up speed.” I’m turning 40 in a few days. I still feel like a teenager in many respects. SQL Server, released in 1989, is 27 years old now. It’s about the same age I was when a
-> Continue reading A look back, and a look forward

Post image

Look, Ma, No Surprises

Last week I demonstrated at least 30% performance improvement by switching to memory optimised table-valued parameters on SQL Server 2016. This week I will demonstrate the same test using Azure SQL Database, on the Premium tier, where In-Memory OLTP is supported. My test harness is the same. I will create a temp table and a
-> Continue reading Look, Ma, No Surprises

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.
-> Continue reading Should I upgrade SQL Server 2008 / R2, or migrate to Azure?

Post image

Temporal Tables in Azure SQL Database

In the latest Microsoft Azure newsletter I received last week was this most excellent news: Azure SQL Database Temporal Tables generally available Temporal Tables let customers track the full history of data changes in Azure SQL Database without custom coding. Customers can focus data analysis on a specific point in time and use a declarative
-> Continue reading Temporal Tables in Azure SQL Database

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

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