SQL Server 2008 and 2008 R2 is end of life on 9 July 2019

Next month, Microsoft is ending five years of extended support on SQL Server 2008 and SQL Server 2008 R2. This follows five years of mainstream support before that. You really should be upgrading to SQL Server 2017 at the very least, with some serious consideration to the unreleased SQL Server 2019. My reasoning for suggesting
-> Continue reading SQL Server 2008 and 2008 R2 is end of life on 9 July 2019

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
-> Continue reading Should I move my on-premises database to Azure SQL Database?

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
-> Continue reading An Introduction to Azure SQL Database

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
-> Continue reading The Resilience of the Log Backup Chain

Post image

Career Limiting Moves – Saying No

IT departments get a lot of flak because members are accused of saying no to what staff think are perfectly reasonable requests. In this second post of my series about career limiting moves, I’m going to tell you about the time I told someone no and immediately regretted it. My second full-time job, after working
-> Continue reading Career Limiting Moves – Saying No

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
-> Continue reading End of Life for Microsoft Windows XP and Server 2003: Six-One or Up