I manage a PGP encryption library call PGPCore and have recently been making some changes to try and move some of the deployment overhead into a git pipleline. The library is strongly named and as part of the work I’ve been trying to move the signing of the package into Read more…
You can deploy WordPress onto an Azure Web App by copying the files directly to the FTP site behind it but the easiest option is to clone it directly from the offical WordPress Github repository. This can be done by adding it as an external Git repository in the Deployment Read more…
When serializing object to JSON using Newtonsoft it’s possible to change the naming of the properties by updating the serializer naming conventions as detailed here. It’s also possible to create your own custom naming strategy if none of the inbuild ones do the dop. This can be done by inheriting Read more…
If you want to debug an app that accesses Azure resources using Managed Service Identity (MSI) in Visual Studio or VS Code then you may well find yourself getting an error similar to that below. Although the error message is pretty clear, it’s not obvious what you can do about Read more…
If you need to whitelist/blacklist an IP address for a client sometimes they’ll give you a subnet range rather than a list of IP addresses. If the site is being hosted in Azure then this is simple to do but if you need to check the IP address against the Read more…
Since I wrote the post Azure Active Directory Authentication for React I discovered that the library used (react-aad-msal) is being depreciated as Microsoft are now providing their own offical library (@azure/msal-react) for these purposes. There’s good documentation of the msal-react library available on the package page as well as samples Read more…
In SQL you can use the HASHBYTES function to generate the hash of an input, the output is the binary represention of the hash. If you want to get this as a unicode value then you can use the below code. This gives a result of ba7816bf8f01cfea414140de5dae2223b00361a396177a9cb410ff61f20015ad which can be Read more…
Usually when I build a website it’s an ASP.NET Core Razor site created from Visual Studio but I’ve recently started to try to get to grips with the React framework (again within Visual Studio). This means I’m having to relearn a few of the things that I’d previously taken for Read more…
Extension methods for adding a BlobServiceClient are provided by Microsoft as previously mentioned, however there’s no equivlent for adding access for Table (or Cosmos DB) storage. The below extension allows CloudTable and CloudTableClients to be injected. Though as Table storage doesn’t yet work with Managed Service Identity the relevant SAS Read more…
When importing a flat file provided by a client into a SQL table the data in the file is often a bit of a mess and it can be easier to import all the columns as long strings into a loading table and to then try and figurre out the Read more…