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… Azure SQL Database Limits
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… Planning matters
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… The Data Migration Assistant
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… Importing a BACPAC into 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”)… Moving a 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… Should I move my on-premises database to Azure SQL Database?
It’s the second half of 2016, and Azure is the new hotness. I’ve raved about Blob Storage, virtual machines, AzCopy, and all those good things. When the dust settles, though, this blog is about managing… An Introduction to Azure SQL Database
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 Transaction Log Is Very Resilient
Much has been written about the log backup chain in SQL Server, where we are able to restore a database to a point in time using a combination of full, differential and transaction log backups. This… The Resilience of the Log Backup Chain
SQL Server 2005 will no longer be supported by Microsoft as of 12 April 2016. One of the services I offer my customers is an upgrade from any* version of SQL Server to the latest… What is your SQL Server 2005 Upgrade Plan?
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… Forecast: Azure Skies Over the Amazon
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… Update to Azure Blob Storage Sync and Restore
This is the second post in my four part series for the #SQLNewBlogger Challenge. You can read the first part here. On Saturday, 28 March 2015, I moved three servers and various networking equipment from… The Art of Improvisation
Today at the clinic, we did the second of three phases of network reorganisation. In the first phase, which we completed a week ago, our new server was set up with the EMR software, all… What I did today