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
I've previously written about how we handle zero downtime deployments with Entity Framework and Migrations but the post lacked an important piece of the puzzle: how to drop a column.
When practising continuous deployment, in order to drop a column, you need to follow the drop column shuffle:
- Ensure that
TLDR; Close the "Manage Bluetooth Devices" screen.
I must have been good this year because Santa put a pair of the Bose QC35 wireless, noise cancelling headphones under my tree for Christmas! While the headphones are truly excellent, especially the noise cancelling, they're not the subject of this post.
A common way to put a website into 'maintenance mode' is to have another, separate, website whose only purpose is to return an informative message along with a HTTP Service Unavailable (503) response code, regardless of the request sent to it. This way, if a site becomes unavailable, we can
We've managed to get past the roadblock described below and are now able to drop columns with EF Migrations in a CD world. More information can be found here.
We've hit a roadblock with Entity Framework Migrations and our Continuous Deployment strategy and it doesn't
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 by deploying