From researching this subject there are many blogs, reviews and pages giving information on SQL Servers and the end of support. As well as the many different options out there to replace the 2005 version. Much of which washes over my head and confuses me more. I am sure the same could be said for many people out there. When I write our blogs, my aim is to make a subject simple and easy to understand. Thankfully I am not at MPR for my tech expertise, I leave that to our helpdesk and engineers. That’s their speciality, they have it down to a fine art of understanding and reviewing all products on the market. So here is what I have learnt about SQL servers in normal simple terms that you & I will probably understand.
Microsoft SQL server is a database server developed by the Microsoft Corporation back in the 90’s and has progressed as with many things over time with various new releases. The time has now come that Microsoft will stop providing updates and support for this particular version, as with many of their older systems. We have previously experienced the end of support for various Windows operating systems, such as Windows 2003 server in July 2015.
In basic terms a SQL server is mainly used to fetch the data requested by any other software from the data stored in the server itself. The software, which requests the data from the server, could be on the same computer or either could be located away on a different computer connected remotely via the internet.
Microsoft SQL 2005 a.k.a. Yukon was launched in October 2005 by the Microsoft Corporation. At the time of its launch, it consisted of some advanced and extra features which the preceding version didn’t have. The same is for the new launch of any new product. Since its launch there have been further versions released as time has gone on that have been more advanced and effective.
From 12 April 2016, if you are running the 2005 version you will no longer receive any security updates from Microsoft and so could be at risk to attack or loss of your data. Microsoft are now recommending that you upgrade your SQL Server 2005 to either SQL Server 2014 or to Azure SQL Server to maintain security and compliance.
Our team at MPR can help you make the decision between all the options available based on your business needs and help to plan the upgrade and roll out to your business with minimal disruption. There are many different variables to help make the choice between SQL servers, whether cloud based (Azure SQL Server) or on-site (SQL Server 2014) MPR will investigate which of the options are most suited to your business. Additionally giving you the peace of mind that the upgrade has been carried out professionally along with any additional support you may require.
Please contact the team at MPR if you are running SQL Server 2005 or if you are unsure of the SQL Server version you are operating to discuss your options.Read more