General rantings about .NET, Linux, Biztalk and the odd hardware fun
Automating things using bicep for Azure deployment can be hard.
While it is trivially easy to find out how to configure maintenance windows for an SQL database using the Azure Portal directly, it is equally hard to find out how to set it using bicep deployment
No direct search gives any relevant links (apart from saying the the maintenanceConfigurationId in the bicep-file must a “string”)
Continue reading “Azure Bicep Deployment – Maintenance Windows for sql-databases”
In my case, I am using gogs on an Azure VM, which has a not-large main drive, but a rather large drive that only exists as long as the VM is running.
Given that the gogs backup is rather disk hungry, I found the need to move its use away from /tmp and onto the temporary disk.
# Since "resource" is owned by root, make a subfolder and make it world-usable
sudo mkdir /mnt/resource/TEMP && sudo chmod 777 /mnt/resource/TEMP
# Verify
ls -ld /mnt/resource/TEMP
# while TMP and TEMP did not affect gogs, TMPDIR DID, indicating that gogs uses mktemp
TMPDIR=/mnt/resource/TEMP ./gogs backup
To my extremely great surprise, Microsoft has finally fixed a very annoying feature in Excel.
When importing CSV-files to Excel that contained (what could look like) a number, Excel would without fail convert that to a number during import and, if it was large enough like 1000000000001234567, convert it to Scientific Notation (1.000E+18) and in the process remove precision in the number. Even if you later forced it back to text or similar, it had forever lost the precision (1000000000001234000) and was hence utterly useless.
That is happily a feature in the past for Office 365. Now you can disable this impressively stupid behaviour in “Options”
Continue reading “Excel : No more conversion of large numbers to Scientific Notation”
After a power-loss, my Hue Dimmer Switch would suddenly not communicate with the Hue Bridge anymore. Nothing was changed (that I could see). A restart of the bridge made no change whatsoever. The bridge said it was "reachable":false
The battery inside is labeled:
It seems to be glued in place
It can be a pain to return json-responses from a Function App, when you also want the proper Content-Type HTTP header to be returned, which it of course should.
If you do it the straight-forward way (works the same with OkObjectResult) –
return new BadRequestObjectResult(jsonResponse);
if response contains a json string, it will be returned ok, but the Content-Type will be “text/plain”
BadRequestObjectResult resp = new BadRequestObjectResult(jsonResponse);
resp.ContentTypes.Add(MediaTypeHeaderValue.Parse("application/json"));
resp.Value = jsonResponse;
return resp;
if response contains a json string, the special characters (like “) will be escaped, and it will no longer return valid json, but the Content-Type is ok (application/json)
If the content-type is not set in above example, the special characters are not escaped
Continue reading “Returning Json response from Azure Function v3+”
If you need to interact directly with the Java keystore (cacerts) that Boomi uses, then the default password for this is “changeit”
It does not seem to be documented anywhere – but it is included in a few of the example keytool commands that can be found in Boomi Community – for instance the one below.
https://community.boomi.com/s/article/Connecting-to-an-IFS-Applications-server-using-a-self-signed-certificate
Everything that you develop in Boomi (processes, maps, connectors, profiles, etc.) is a component and a component in Boomi is always represented (behind the pretty GUI) as a XML document.
This means, that if you have made any change in a Boomi component, and wants to verify which change that you made, you can determine this by comparing two revisions of the ComponentXML for the changed component. This will be a text-comparison and not a GUI-one, but with a little practice, it is easy enough to interpret.
Continue reading “How to compare two revisions of a Boomi component”
If you open Excel files from Sharepoint, they by default open in Edit mode.
This sadly means, that whenever people interact with the sheet – for instance by filtering, this filtering will be saved. Extreeeemely annoying.
This may very well not be what you want. Fortunately, you can still set you Excel file to open by default in “Viewing” mode.
Continue reading “Excel – open as “ReadOnly” / Viewing by default”
While Google ChromeCast and products like Xiaomi Mi TV Stick supports wireless screen-sharing and wireless streaming, they come with a caveat that may not make them the best solution in all cases
They require:
Especially the google account makes it a no-go for me.
However, if all you want it to stream Netflix etc., both these products might be a better option for you.
But if all you are interested in is a wireless screen for your pc or mobile device, there are other, simpler options