Do you still have SQL Server 2005 databases in your IT environment? Learn from SQL Server experts (Microsoft MVPs) why you should upgrade, options you have and what you should consider when upgrading to SQL Server 2014.
As I sit here typing this blog post in my home, we are 145 days or more accurately about 3480 hours until April 12, 2016. That is the date when Extended Support for SQL Server 2005 will be done. Over. Dunzo. Kaput. Yes, Microsoft can do Custom Support Agreements for large companies but it will cost you and you still will be stuck without all the sweet features that have been released in the last 7 years (since 2008 came out). So let’s face, it’s time to upgrade SQL Server 2005!
Let me just think of 5 new features (off the top of my head) that can dramatically improve your database:
1) Backup compression on all editions
2) Columnstore Indexes
3) Delayed Durability
4) Filestream and Filetable
5) Availability Groups
Some people say time flies, and it feels like yesterday when you realize the month of November 2015 marks the tenth year since SQL Server 2005 release to manufacturing. Quite a milestone, at least from the human prospective, it seems sure so. And this is true for so many reasons, SQL Server 2005 was definitely a landmark offering of a relation data management engine bundled with more not less significant components that saw light for the first time in it as SSAS, SSRS, SSIS and too many others to mention in a blog post. Continue reading
On April 12, 2016 Microsoft will no longer offer extended support for SQL Server 2005. This means no more security updates or hotfixes. However, the bigger reason to upgrade is the fantastic performance improvements offered in SQL 2014. SQL Server 2014 has been shown to be 13X faster than 2005, and that is before taking advantage of the in-memory OLTP. In addition there are features such as AlwaysOn availability groups, updateable columnstore indexes, T-SQL Intellisense and backups directly to the cloud, just to name a few. Continue reading
…I drive a classic 2005 Nissan XTrail. It’s the very first car I bought. It’s a mini-SUV with a 4-cylinder engine which is great when driving in the snow. And considering the fact that it is no longer available in Canada, I love driving it because there’s not a lot of them on the road.
Unlike my Nissan XTrail, some old cars are not built with quality in mind. That means owners spend so much on maintenance and repair costs. Couple that with the availability (or unavailability) of parts for an old car. But that’s not the only thing you need to consider. If you drive your car on a regular basis, you need to consider the time it takes to take your car to the mechanic, the time wasted while taking your car to the mechanic and waiting for it to be fixed, the hassle of getting a rental car if you really need to drive to and from work, etc. And have you ever counted the cost associated with the frustration of dealing with a problematic car? Add all of those up throughout the lifetime of your car and you’re probably better off getting a newer, more reliable one.
On 12 April 2011 it was Yuri’s Night — the night we space fans celebrate Yuri Gagarin’s 1961 history-setting flight into space. In 2011 we were celebrating 50 years of manned spaceflight. On that same day in 2011, we reached the end of support for SQL Server 2005 SP4. On 12 April 2016 we will reach the end of extended support for SQL Server 2005. That means no more hotfixes, no help from Microsoft and no love for your data still living in SQL 2005 databases. Continue reading
..For nostalgia's sake, you might want to review the details at What's New in SQL Server 2005, but here are a few notable enhancements brought to us in that release:
· Service Broker
· CLR integration
· The XML data type
· Ranking functions
· Common Table Expressions
· Pivot and Unpivot
· Database schemas
· New architecture for Integration Services and dtsx packages
· Reporting Services as a new feature
· Multiple enhancements for Analysis Services
· Replication enhancements including transactional, peer to peer and merge replication and support for heterogeneous environments