SQL Server

7 Valuable Tips For Upgrading Your Microsoft SQL Server

By | SQL Server Tips
  Microsoft SQL Server 2008 is nearing the end of its extended service period. If you are still using 2008 or 2008 R2, it’s time to get off now. Or maybe you have 2012 or 2014, but want to take advantage of the most up to date processes and security features. It can be a daunting task to think about upgrading your SQL servers. There are so many pieces to juggle. If you’ve been putting it off, I don’t blame you. But with the speed of innovation, it’s important to stay up to date and ahead of trends. So today we’re talking about some things to keep in mind when you upgrade your SQL Server. Check Compatibility – If you are currently running SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 (11.x), SQL Server 2014 (12.x), or SQL Server 2016 (13.x) then you can upgrade directly to SQL Server 2017, assuming the same platform specifications. If you have 2005, then you will need to migrate first. Read more about migration here. Use Microsoft Data Migration Assistant – It’s important to read about which features will change from your current version to understand potential issues from depreciated or new (more…)