Skip to content
SQL Server
Industry: Energy

SQL Server Data Platform Modernisation for an Oil & Gas company

Discover how DSP supported an oil and gas company with SQL Server Data Platform Modernisation to reduce licensing footprint 

SQL Server Modernisation


Our Oil and Gas customer is an independent exploration and production company and one of the largest producers of hydrocarbons in the UK which required support in modernising their existing SQL Server data platform.


The Challenge

The client conducted their own internal Microsoft licensing audit before their annual 'true-up'. This indicated a licensing shortfall, requiring £500,000 of additional licensing purchases to remedy.

At this point, DSP suggested a data platform modernisation exercise to examine the current set-up and find ways the consolidate the footprint, rather than purchasing additional licenses.

The Solution

We approached this project by starting with a 7-day discovery exercise utilising the MAP tool kit. This established the details required to make appropriate recommendations and alongside workshops with application owners, we determine how to group together the 50+ SQL server instances and databases to make the required license saving, based on service level and version compatibility. As a result of our investigations, DSP presented a design document and a conservative estimate in savings of £250,000 in licenses. The consolidation into AAG clusters also helped with maintenance moving forwards for patching and upgrades, as the SQL sprawl had been dramatically reduced.

The Result

At the conclusion of this project, it transpired that we were able to reduce the cost of new licenses required by £285,000 - a considerable saving on what originally seemed to be a half million pound shortfall. 

Added Value


In addition to upgrading their estate and consolidating it to save them £250,000 in licence costs, we worked with them to develop data solutions that also introduced scalability and decreased downtime.


Why DSP?

  • Our Microsoft SQL Server experts provide a stable database platform for SQL Server, as well as help you save time and money on hardware and licencing purchases
  • We manage SQL Server upgrade projects of all sizes and have experience working with all versions

Want to see what we can do for your business? 

Get in touch with our specialists today and start your modernisation journey with industry experts.