SQL Server Sprawl leading to high SQL Server License Costs

Our client had a business that was growing organically and through acquisitions of smaller businesses.

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 from running on unsupported as well as unpatched software vulnerabilities.

Migrating financial data to a new accounting system

Finance has to be to the penny and we would not have it any other way. We were tasked with migrating financial data of a £70 million turnover company's accounts into a much larger billion turnover business due to a recent acquisition.

It needed to be completed accurately and quickly to coincide with group reporting dates. The migration was between two accounting packages - the source was Sage 200 and the destination was OpenAccounts. They needed an expert data management company with experience and a solid data migration methodology to accurately complete the migration.

SQL Processes overrunning process window

Process run times had started to increase and this inevitably happens with increased data loads over time. Spreading out the job start times had worked in the past but this was no longer possible due to the increased processing time needed to execute the jobs.

Something else needed to give and there were only two options - increase the specifications of the server at increased cost or optimise and re-write the code. Digital Samurai worked with the client to remedy their problem by optimising their code, saving the client's time and money.

SQL Server estate required patching

Getting stuck on an old version of SQL leaves you at risk to potential security vulnerabilities. The longer you leave it, the harder it can be to finally make that move to the current version. Patching SQL can be stressful if you do not have an adequate roll back plan and the skills to implement it.

As a result, the update gets pushed back further and further until there are so many updates to apply you fear doing it at all. Luckily, Digital Samurai can help by run updates, migrate data to new versions of SQL and ensure that your SQL Server is running perfectly.