Please join us on February 3, at 10:00 am PST for a webinar on upgrading and migrating from SQL Server 2005 BI features to SQL Server 2014 and 2016 with guest speaker Paul Turley, SolidQ Mentor and MVP. The following is a post from Paul on why this is such an important topic. Register here and join us on Wednesday to learn more.
If you’re still on SQL Server 2005, there are some important things to be aware of. First and foremost is that you are missing out on innumerable capabilities in more recent versions of the SQL Server platform, in the relational engine and the BI stack. Secondly, Microsoft will no longer support SQL Server 2005 after mid-April of this year. This is not a marketing ploy to upsell customers but simply the normal retirement cycle of a ten-year-old, outdated product. Yet, for some organizations managing critical systems, it’s a disaster waiting to happen.
Considering performance and security alone, the differences between SQL Server 2005 and recent versions are quantum. We frequently see cases where performance improvements on a typical workload improve by multiples of two, ten and more, making the ROI math pretty simple. Improvements to the core BI feature set (Reporting Services, Analysis Services and Integration Services) are also vast, with improved reliability, ease of design and usability. These are some of the topics I’ll discuss in this free presentation.
An upgrade of your SQL Server Business Intelligence solution brings with it the challenge of understanding how to apply new features to your BI workload, but it also opens up tremendous opportunity for business impact. In this session we’ll talk about business benefits to upgrading your BI solution, costs to upgrade now vs. the costs of waiting, and current trends in corporate upgrade strategies. For those impacted by the end of extended support for SQL Server 2005 on 04/12/2016, we will discuss enhancements to the SQL Server platform and examples of how to take advantage of the latest features. We’ll touch on workload-specific upgrade benefits to modernizing your SSAS, SSRS, and SSIS environments, then wrap up with how upgrade can improve users’ reporting experience using the latest in mobile BI.
Speaker: Paul Turley, Solid Q Mentor and MVP