Windows Server 2008 and SQL Server 2008 were Microsoft’s most popular server and database management operating systems to date. Now, they are encroaching the tail-end of their 10-year lifecycle. Security updates will end on July 9, 2019 for SQL Server 2008, and on Jan. 14, 2020 for Windows Server 2008. This article covers a few upgrading and migration options for organizations looking to move to a newer platform.
Upgrade and migration options
Update to a newer version of Windows Server and SQL server
For applications that need to remain on-premise, installing a newer version of Windows Server/SQL server may be the best option. Out of all the installation choices, upgrading is the easiest way to preserve system settings.
Unfortunately, there isn’t a direct upgrade path from Windows Server 2008 directly to Server 2016 without performing a clean install. If you want to preserve your settings, the server must be upgraded to Windows Server 2012 before installing Windows server 2016 and newer. Before committing to any software change, back up the existing environment and ensure both the hardware and software vendors fully support the new OS.
Enroll in the Extended Security Update program
Upgrading or migrating all the servers at once may be impossible for larger clusters. For scenarios where only a portion of the hardware can be updated at a time, Microsoft offers the new Extended Security Update program.
Extended Security Update is the replacement for the old Premium Assurance program. Whereas Premium Assurance once offered six years of support, Extended Security Update offers three years at a reduced cost. The license can be purchased on a per-device basis to cover only machines that need the added protection.
Each Extended Security Update license can be purchased for 75 per cent of the full license cost of the latest version of SQL Server or Windows Server. The service is billed annually and can be canceled at any time.
Migrate to Azure Cloud
If network bandwidth isn’t a concern and applications do not to be kept on-premise, then migrating to the cloud stands as a solid option.
The most immediate choice is Microsoft Azure. As with all cloud computing platforms, Azure offers a vast array of performance plans. Initial operating system setup is nearly instantaneous, enabling devs to set up quick developer test environments. High-redundancy and high-availability make Azure (and most major cloud computing platforms) perfect for disaster recovery and backup as well.
Azure isn’t the only cloud computing platform available, Amazon Web Services and Google Cloud Platform are equally capable options and have their own advantages. With that said, Azure distinguishes itself by offering Extended Security Update for free. In the context of this article, Azure is the best choice for cost saving.
Even for organizations that must have on-premise hardware, extending certain workload onto cloud have tangible benefits. A few good use cases include deploying developer test environments, exapnding the mail server, and improve backup redundancy.
Microsoft will be releasing SQL Database Managed Instance to help users transfer SQL databases on Azure. In its upgrade guide, Microsoft promises zero-downtime migration for existing SQL servers.
Alternatives and where to host them
Microsoft’s dominance in the enterprise market is significant, but many other Linux-based operating systems exist outside of it. Notable distributions include Debian, SUSE, CentOS, Fedora, Red Hat, Ubuntu, and Amazon Linux just to name a few.
Linux enterprise operating systems provide a number of advantages. First is stability. Linux is known for being reliable and has fewer unexpected failures. This truth applies to all Linux machines from desktop to large-scale servers.
One of Linux’s key principles is to have many specialized modular components that each does one thing very well. Its modularity makes them exceptionally pliant. Users can configure it to build them to have only the feature they need while keeping the option of attaching additional functions later on. This not only translates to cost savings, but also reduces attack surface and increases performance.
Then there’s license cost. Linux itself is open source, which means that anyone can use the code to create their own Linux version. Due to this, enterprise operating systems based on Linux are often far cheaper, with most of the money going towards maintenance and support. On the topic of support, many Linux distros have grown to carry extensive support. Companies like Red Hat, SUSE, and Ubuntu all offer frequent patches, feature enhancements, and security updates.
The caveat to all of this that because of their flexible nature, they’re harder to operate and maintain. Though cloud computing service vendors provide hardware maintenance, on-premise personnel could be just as costly as Microsoft Server admins.
Also, Microsoft’s overwhelming presence in the server is not unjust. For organizations already well-versed with Windows, transitioning to a newer version requires minimal training. Setup is fast and easy, and the OS is fully equipped to service immediately after deployment. It’s also extremely feature-rich, simple to operate, and have exhaustive documentation.
Hosting options are abundant. Most established cloud computing platforms can either directly install or virtualize nearly all major Linux distributions. AWS, Microsoft Azure, and Google Cloud all have extensive support for operating systems including Amazon Linux, CentOS, Debian, Kali, Red Hat, SUSE, and Ubuntu.