Discover how we saved our client over £2,000,000 per year with SQL Consolidation.

Our client was growing rapidly by acquiring companies over several years. As a result, they had dozens of different SQL databases running on different versions of SQL Server. 

  • We identified several ways to consolidate our clients' databases into a single standardised database
  • We migrated our clients' data into a secure, optimised, and updated database that was in support
  • We used our tried-and-tested methodology for data management to migrate data without errors or issues

We can do the same for your business.

Contact Digital Samurai today to speak with one of our data experts.

The Situation

If there is one universal law about data, you will always have more data tomorrow than you have today. The modern data problem is that data means more than records in a table or documents in a document store.

With a software-defined infrastructure, data now covers servers stored as virtual disks on a SAN. These virtual servers can often grow into tens or even hundreds of Gigabytes. They still get backed up, patched and monitored, but after a while, no one asks why this server is even needed. Worse still, shadow IT can be such a problem that someone must remember these servers.

Large companies that grow by acquisition are especially vulnerable to exponential data growth. Suddenly, they have an entire extra company's worth of data to analyse and manage on top of other currently operating data stores. The additional data has made monitoring and controlling their databases much more challenging.

Before one company purchase has been properly merged and consolidated, the next is already halfway through, and a third acquisition is on the horizon. Each has less time to be completed, but the business continues adding system after system to the list of infrastructure being looked after by your static team resource.

The Problem

Our client had a business growing organically and through acquisition. The growth over the years had become large and scattered. The landscape covered various versions of the same software, SQL Server versions 7 to 2012. These versions were all old at the time, and a few were well out of support with the vendor (Microsoft), leaving their business at risk of data loss and unpatched software vulnerabilities.

Sometimes some systems were only known about by an employee who had long since retired. When the system inevitably fails, the company realises that the systems have never been backed up or that the backups had started failing years ago without any notification, as the only notice went to the person that left.

  • How do you manage it?
  • How do you maintain visibility? 
  • How do you scale your team's time to meet the increasing challenge of delivering 'more with less'?

The Solution

Sage 200 Data Migration

Our data consultants' outside view can quickly give you that perspective. We can find out everything you have, work out if your databases are being used optimally, begin to decommission any unused databases, migrate data onto the latest platforms and allow for older systems that are due to be replaced to have a timescale for deletion.

We analysed what our client had and found vital areas to improve. We reduced their SQL estate by 80% because of our tried and tested methodology for data management.

Digital Samurai's team of expert data consultants created and implemented a successful data management and data migration strategy:

  • We identified several ways to consolidate our clients' databases into a single standardised database
  • We migrated our clients' data into a secure, optimised, and updated database that was in support
  • We used our tried-and-tested methodology for data management to migrate data without errors or issues

By consolidating our clients' data into a single secure SQL database, Digital Samurai were able to save our client over £2,000,000 per year in SQL Server licencing costs.

Contact us today to book your free SQL consultation.

>