• Adam Thurgar

The Oncology Application Story

The next couple of blogs all relate to an oncology application and the changes required for a more Enterprise approach for the application. This also formed a lot of the information and testing for the eight blogs on Availability Groups back in 2012.

The application was originally written by a Doctor who taught herself to program and write this application in VB. It was a very good small system for use in chemotherapy units working out protocols, dosing, subscribing and reporting.

It ended up being used in quite a few well known hospitals and their cancer units. But it was not an enterprise ready application for full hospital use. It did everything required from it, including auditing and reporting all from within the application.

Over time the system had grown and been redeveloped, but then they landed a multi million dollar contract to be the provider for a new cancer hospital and now the application had to start to be ready for that future.

The next couple of blogs are some technical changes that were made to meet the higher standard of requirements and also give insight into how hard it is to change.


Recent Posts

See All

Cardinality estimator

Recently I was asked by a software vendor to review a particular query that ran in under a second on a SQL Server 2014 installation at a compatibility level of 110 (SQL Server 2012), but when run unde

Index fragmentation

A law firm client, occasionally has issues with their legal software, that is provided by the global leader in this field. The response from the software provider is always the same - you have index f

Deleting large amounts of data

I had a client call me about wanting to delete a large amount of data from their database. They knew what tables they wanted to delete from. They also knew that deleting large amounts of data causes t