If you’re setting up a WordPress site in an Azure Web App then an easy option for hosting the required MySQL database is to use the MySQL in app option of the Web App rather than setting up a new MySQL server. Though it’s worth noting that this isn’t very Read more
If you have a blob in Azure Storage that you want to have a look at first before deciding whether to download it or not you can open up a stream from it and use a StreamReader to read as many rows as you want from it. In my case Read more
Azure Table storage is a way of storing structured NoSQL data in the cloud, as such it’s more geared towards rapid read access rather than manipulation of data in the table. If you want to perform any operations such as updates or deletes on data in your table then the Read more
I’ve recently started trying to get my head around unit testing (I probably should have learnt this a while ago) and part of this has involved trying to figure out the best way to integrate them with Azure DevOps. In my case I wanted to have a pipeline which built Read more
If you want to generate URLs for use in an MVC webpage for actions in your controller then the UrlHelper Action method is pretty handy. This can be embedded into your cshtml page and will generate a URL at runtime for the specified action which will be relative to where Read more
I use the Hestia theme for this site which I think looks pretty good. One problem with it however is that uses v4 syntax for Font Awesome icons but includes v5 of Font Awesome in its assets. The change from v4 to v5 of Font Awesome was quite a large Read more
Below is a SQL query for getting database sizes borrowed from this post. Unfortunately it doesn’t work on Azure SQL databases unless you’ve been granted VIEW_DATABASE_STATE permissions.
I hadn’t really thought about this before as I’d just assumed that any code that I posted would be freely available for anyone else to use as they saw fit but it turns out that I actually implicitly retain the copyright if no license is provided. I have now added Read more
If for whatever reason you can’t just use a nice jQuery plugin like js-cookie then the below Javascript will serve as a basic method of setting and getting cookies.
I use Serilog for logging in most of my console applications as specified here, however the AddConsole and AddDebug extension methods are now obsolete in .NET Core 2.2 giving the below errors. ‘ConsoleLoggerExtensions.AddConsole(ILoggerFactory)’ is obsolete: ‘This method is obsolete and will be removed in a future version. The recommended alternative Read more