Why Is It A Bad Idea to Use Microsoft SQL Servers Post-2018

Microsoft SQL Server 2008 and Windows Server 2008 are undoubtedly one among the most popular database storage and management software out there. However, in 2018, Microsoft made an announcement making it clear that the end of an era is closer than we think.

Microsoft announced that they are going to end the support for Microsoft SQL Server 2008 and Windows Server 2008 on July 9, 2019, and January 14, 2020, respectively.

This brings in a major concern for anyone using the platform because of the fact that developers are already used to the platform. So, using something else or migrating towards a new platform has its risks. Convenience is one among the most important factor a developer sticks to a platform and the change of platform can cause internal delays due to the new learning curve.

What happens if you keep using Microsoft SQL Server 2008 and Windows Server 2008?

This is a valid question as if you don’t want to migrate to the new platform, it is certainly doable! But, you might want to reconsider this choice because of the following factors that will come into the effect upon the end of the support for Microsoft SQL Server 2008 and Windows Server 2008.

  • Microsoft will stop rolling out security fixes and patches
  • Users will have to buy custom support contracts if they want further support
  • Or they have to move to the newer Azure platform

Using the 2008 versions internally without an internet connection

Many companies have the misconception that they can keep Windows Server 2008 & SQL 2008 running internally without connecting to the internet.  This might make the Window 2008 Server platforms to run without any problems, but there are risks involved in doing so.

No more security patches

The major downside of using the servers internally is that it is devoid of the contact with Microsoft. Hence, the platform will not receive any security updates. Even if it cannot connect to the internet, a malware attack can come from the connected nodes. The SQL Slammer computer worm is an example of why security is important.

The physical disadvantages

Compared with the modern cloud-based platform, the disadvantages of having an internal SQL database is that the company must pay for the infrastructure required to maintain and run the servers. With an in-house physical server system, there is always the risk of physical damage or even theft.

Lack of new features

With online servers, the company will have access to the latest and greatest tech as soon as they are released. With internal servers, such amenities are not available due to the fact that there is no connection between the local servers and the Microsoft servers.

Microsoft isn’t taking away the Windows Server 2008 platform; it is just replacing them with something better – Azure. Microsoft has made the new cloud-hosted platform in such a way that it is effortless for developers to switch platforms. Contact PT Sarana Solusindo Informatika to know how your business can start using Azure today!

read more about Azure

Posted by / April 23, 2019
Posted in