Microsoft SQL Server® is a market leading enterprise level database solution used by any a large number and variety of applications on which to host their databases and store their data. Microsoft SQL Server is an incredibly powerful, scalable and robust solution, however it is it’s robustness that often leads customers into a false sense of security.
As with anything in life, things can go wrong, and this is true with SQL Server. Your valuable data can be lost for a number of reasons such as hardware failure, theft, fire, flood, user error etc. and so it is worth planning for such events to make recovery as painless as possible.
27 July 2016
SQL has long been the go-to database platform providing market leading security and Business Intelligence (BI) capabilities. Now Microsoft have released SQL Server 2016, which is packed full of new features. As a company specialising in business management software (i.e. Microsoft Dynamics® NAV) with SQL databases at their core, our focus is on the real world benefits to people trying to manage their business systems. Here we will look at some of the key features.
The reality of The Internet of Things
As of the April 12th 2016, Extended support for Micrsoft SQL Server® 2005 ends. Of course, this does not mean it will just stop working, so what are the implications of running an unsupported version of SQL Server?
Let us first look at the 2 levels of support offered on by Microsoft in their Support Lifecycle – Mainstream Support and Extended Support.
This applies to the first 5 years (typically) of a products life, and inculdes:
This applies to the next 5 years (typically) of the products life and includes pretty much only security hotfixes and paid support.
When SQL Server 2005 leaves extended support, there will be no security or compliance updates, and no back up from Microsoft to your partner should there be an issue that the