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

Post image

An Introduction 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 data, and sometimes we don’t want to worry about the hassle of maintenance and administration. Azure SQL Database takes the[…]

Post image

The Resilience of the Log Backup Chain

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 requires a database being in Full Recovery Mode and transaction log backups being taken at regular intervals. If the database is[…]

Post image

End of Life for Microsoft Windows XP and Server 2003: Six-One or Up

Five months from now, Microsoft will stop supporting Windows XP. As Tim Rains points out, running Windows XP after this date will effectively be an open invitation for attack. XP will, in his words, be “zero day forever”. As you know, Windows XP is the client version of Windows Server 2003, and includes much of[…]