Git flow, closing a release branch and associated Azure Devops tasks for deployment

  1. Pull release branch
  2. Pull master branch
  3. Merge release branch into master
  4. Add tag, e.g. if release 1.xx.0 – git tag -a v1.xx.0 -m “Release description”
  5. git push –tags
  6. git push
  7. The builds will happen
  8. The releases will be ready to deploy (you may need to cancel previous releases until the release you want is deployable)
  9. Deploy those builds to environment
  10. API Management updates (for each API you’ve deployed)
  11. Delete release branches if not automatically deleted
  12. Merge master into develop (and any existing release branches that follow the one you’ve just deployed)

HTTP Error 500.30 – ANCM In-Process Start Failure

You’ve created a website or API using .NetCore and it all runs well locally. You deploy to an Azure App Service and it fails to start but the only error you see is that below.

HTTP Error 500.30 - ANCM In-Process Start Failure
Common causes of this issue:
The application failed to start
The application started but then stopped
The application started but threw an exception during startup
Troubleshooting steps:
Check the system event log for error messages
Enable logging the application process' stdout messages
Attach a debugger to the application process and inspect
For more information visit: https://go.microsoft.com/fwlink/?LinkID=2028265
Continue reading “HTTP Error 500.30 – ANCM In-Process Start Failure”

Passing Tables to Stored Procedures

Sometimes we need to pass a table as a parameter to the sproc – For some reason I always forget how, so here it is…

DECLARE @temptable AS UserDefinedTableTypeOrTable
INSERT INTO @temptable ([ColumnName]) VALUES ('MyValue')

EXEC   [dbo].[SprocName]
             @Parameter1 = @temptable,
             @Parameter2 = null,
             @Parameter3 = 0
             
GO