Automation

Run Custom Database Scripts With PowerShell and Octopus Deploy

Posted on

We are using model-based deployments using Visual Studio database projects and Octopus Deploy. One of the things you can’t do when performing DacPac deployments is include a pre-deployment scrip to disable replication prior to running the deployment (although you can re-enable it in a post-deployment script). The solution is to change the “disable replication” script […]

Programming

Query Optimisation Is Still Alive

Posted on

When I was working on SQL 2000 databases back in the day, the ordering of your joins and where clauses could make an insane difference to query performance. I was working on a reconciliation system that grew by a million records a month – so a simple re-order of a where clause would blast a […]