The crux of any possible SQL solution should be to mitigate risk. Before making any decisions regarding updating or migrating your SQL server, be sure go through a discovery process with your servers and databases. During this process, find all deployed SQL database servers and identify their license entitlements. Once the licensing environment is better understood, then reconcile the licensing positions of all SQL 2008 deployments. To reconcile licensing positions in an efficient way, define what your organization would consider the most optimized licensing state. It also may be helpful to consult a Microsoft advisory services expert to discern the complicated software environment. From there, it is vital to develop a comprehensive roadmap to help your organization plan and execute their chosen solution.
There are two primary solutions that organizations should consider when designing their roadmap. The first suggestion would be to upgrade to the latest version of SQL, SQL Server 2017. This usually is covered under Microsoft’s Software Assurance program, so this upgrade typically comes at no additional licensing cost. However, this does not mean that upgrading to SQL Server 2017 is free of any additional costs at all. Organizations must still stay vigilant with software compliance across their entire network environment, and a simple upgrade could potentially incur indirect and opportunity costs, as the compliance process will be quite labor intensive compared to the alternative.
The second suggestion is to migrate to Microsoft Azure. Microsoft Azure is a cloud computing environment that any organization should consider implementing. Azure will allow your organization to maintain their existing SQL 2008 environment for an additional three years, through 2022, without the need to pay for extended support. Azure can provide flexible hosting for your SQL environment, scaling its size and expenses depending on the size and power of your database demands. Due to Azure’s flexible pricing strategy, it is greatly beneficial to implement a tool such as PyraCloud. A considerable amount of insight and visibility is necessary to optimize cloud spending, and Pyracloud can help to provide this knowledge. Not only will a transition to Azure buy your organization precious time, it will also give your organization an opportunity to upgrade and modernize their database environment.