What’s this? #

Microsoft Azure things.

Azure DevOps #

The current standard is to use yaml “Pipelines” only. Seems like “Releases” are no longer in favor. There is no yaml for “Releases”. To get a something similar to “Releases”, create 2 Pipelines.

Pipeline A: Build the solution, publish artifact.
Pipeline B: Deploy the artifact from existing build.
- should list Pipeline A as a resource like this: https://learn.microsoft.com/en-us/azure/devops/pipelines/process/resources?view=azure-devops&tabs=schema#define-a-pipelines-resource

Gotchas #

Azure variables must be named uniquely or else it will siliently overwrite an existing environment variable. Use a prefix or something.
Print out variables using a script:

    - task: PowerShell@2      
      displayName: Print Variables
      inputs:
        targetType: inline
        script: (gci  env:* | sort-object name)

Service Bus #

Renaming Topics #

Can’t rename a topic to a name that has already been used within the namespace. Even if that the topic with that name has already been deleted. It gives you a 500 error in from ServiceBusExplorer’s log from calling this operation: https://learn.microsoft.com/en-us/dotnet/api/microsoft.servicebus.namespacemanager.renametopicasync?view=azure-dotnet-legacy

Using a previously never used name results in success.

Azure SQL #

Database Copy #

Faster making a copy of a DB. Works across servers and subscriptions. See: https://docs.microsoft.com/en-us/azure/azure-sql/database/database-copy

-- This should be executed on the target server/master db
CREATE DATABASE [dbname_copy] AS COPY OF [servername].[dbname];
GO

If using a sql username/password the user has to be deleted and re-added for the login.

-- This should be executed on the target server/target db
DROP USER [username]
GO

CREATE USER [username] FOR LOGIN [usernamelogin] WITH DEFAULT_SCHEMA=[dbo]
GO