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

The Transaction Log Is Very Resilient

Last week I wondered whether a log backup chain would survive a database migration. Unsurprisingly, the answer is “yes”. I also asked if a log backup taken on the new instance would be usable on the old instance, if the need arose to fail back to the original environment. Unsurprisingly, the answer is “it depends”.[…]

Post image

Career Limiting Moves – Dropping a Table

In this new series, I will share some things that took place early in my career that could have resulted in my looking for new work—but didn’t! This post is also evidence that I haven’t always worked with SQL Server. I used to work with a PeopleSoft implementation partner, sometime last century. One morning I[…]