Importing Data into an Azure SQL Database with BCP

Importing data from a flat file into a Azure SQL Database is definitely not as easy as I thought it would be. After a bit of Googling, BCP seemed to be the easiest solution but the tool itself is very difficult to work with and the documentation, while plentiful, is…

Zero Downtime Deploys with Entity Framework Migrations

At Moneybox, we've implemented a continuous delivery pipeline using TeamCity, Octopus Deploy and Azure WebApps. Taking this a bit further, by making use of the deployment slot functionality of Azure WebApps, we were able to implement one click, zero downtime deployments with minimal effort. In summary, this works…

Reverting Azure Sql Databases

Once in a while, you may find that you need to roll your Azure Sql Database back to a previous state. Unfortunately, even though Azure takes care of backups for you, there isn't a lot of information on how to restore a database to an earlier state. For…