Technical tidbits from the sysadmin world...
 

AzureDevops Self Hosted Agent in Kubernetes with Workload Identity or Application Registration

There is more than a few blog posts around about how to use the Azure DevOps agent in a container (and by extension Kubernetes), there are even a handful of examples for using an Entra Application Registrations or Workload Identies that miss out on a critical step – the ‘exit’ …

Errors with February 2018 SQL Connector for Azure Key Vault

Microsoft released an updated version of the SQL Server Connector for Microsoft Azure Key Vault on 26/2/2018 (version 15.0.300.96) which seemed to be unable to connect to the Key Vault on existing or new SQL Servers. Typically you run this first step in creating the Asymmetric Key CREATE ASYMMETRIC KEY SAM_TDE FROM …

Multi-site MSSQL Availability Group & Disaster Recovery

There is a lot of information scattered around different blogs and Microsoft documentation about running SQL Availability Groups across multiple sites for DR or reporting requirements, this post outlines how to get a 3 node cluster working again when you have to failover to your DR site.   Assumptions: Failover …