• Adam Thurgar

Oncology App - Deployment


One of the learnings from this application development was the use of deployment tools and source control.

Everything was under source control including the database, which meant that everything had to be scripted.

All of these scripts (application and database) were deployed using Octopus.

https://octopus.com/

What this meant from a database perspective was that there were two Power hell scripts that did everything.

The first installed and configured SQL Server (Enterprise or Developer edition, developer was the default but Enterprise could be passed as a parameter instead).

The second created the application database (default was the usual name, but a parameter could be passed to create a database of a different name if required).

By using Powershell and some looping additional scripts could be easily added and the database recreated within a few hours, complete with sample/test data.


2 views

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