SQL server 2005 will become the new SQL server 2000


SQL server 2005 will become the new SQL server 2000


Many years ago Microsoft released SQL server 2005. This was an important SQL server update after SQL server 2000. Today, a decade later, Microsoft is about to stop the extended support on SQL server 2005 on April 12th 2016. It is end of life, no more updates will be released. When running SQL server 2005 you will be exposed to potential bugs and security threats.


Since the release of SQL server 2005, technology has changed dramatically. Many new features have been introduced in a more recent SQL server update.

Not only technology changed dramatically, also the way business operates has changed. Data is becoming the new gold in companies. One of the most important assets when running a business. It is therefore that Microsoft has put a lot of effort to create a database platform that support all those needs.

With SQL server 2014 we are able to increase the throughput and performance thanks to the ‘In memory OLTP engine’. A revolutionary concept to store data in memory and to abandon the traditional disk based approach.

Because data becomes so important, we need to guarantee a highly available environment. Within SQL server 2014 we are able to use AlwaysOn High Availability, which ensures high availability and disaster recovery to the cloud in case of failures of mission critical applications.

There are a lot of new features to gain more knowledge in your business’ data. New BI tools are available that allow you to gain deeper insights in your data.

One of the most important topics when considering upgrading is security. SQL server 2014 allows you to store your data more secure. Because SQL server 2014 is still actively under support, patches and security updates are released on a regular base. This makes your environment more robust and prepared for malicious attempt to gain access to your data. SQL server 2005 does no longer receive security updates or patches, leaving holes in your security.


SQL server 2014 and in the near future SQL server 2016 is the product that will lift your business to a higher level.

You should consider upgrading now. Kohera can assist you with this assessment. Together with you and proven technology tools we create a roadmap. With this you can upgrade your business with minimal impact for your end users.

Database specific security in SQL Server
There are many different ways to secure your database. In this blog post we will give most of them a...
SQL Server security on server level
In this blog, we’re going to look at the options we have for server level security. In SQL Server we...
Microsoft SQL Server history
Since its inception in 1989, Microsoft SQL Server is a critical component of many organizations' data infrastructure. As data has...
Power BI Desktop is een prachtige tool om snel data-analyses te kunnen uitvoeren. Je connecteert op een databron, importeert en...
dba image
DBA is not that scary
Often when talking to people who are looking for a career path in the data world I feel like there...
How do you link an SCD Type 2 table in Power Query?
This article uses a simple example to demonstrate how to link an SCD Type 2 table in Power Query to...