While preparing the lightsaber stage-fighting choreography for our upcoming musical, I couldn’t help but notice that how we approach this challenge is very similar to how I approach challenges at work in an agile way – and it highlights what people often get wrong about solving challenges in an agile way
As a preparation for an upcoming workshop, I had to setup an Oracle instance with utPLSQL for demos and testing purposes. With today’s possibilities of running an Oracle 21c in a container (thank you Gerald Venzl) and great utPLSQL installation scripts (thank you Jacek Gebal), it was a way simpler task than I expected. I thought I’d share it with Read more…
It’s been more than 5 months since I started at Quality Minds and shifted from working as a software developer to a quality engineering consultant. I thought I would soon be doing a lot of test automation, using Cypress or Playwright, but instead of that, something totally different happened
Using Open Broadcast Studio can really improve the amount of control and possibilities you have in your online meetings. Especially the virtual camera is so handy when you have to switch a lot between video conferencing systems.
Here’s how you get started, including a Background Removal solution that doesn’t require a greenscreen.
There is a vast amount of different terms to describe tests, and especially developers can easily struggle with their specific meaning or what the term tries to emphasize.
In this post I try to give an overview about different aspects that are used to categorize and describe tests as a tool to improve one of most effective, frightening and impactful actions in software development: Talking to each other.
Today is my last day at smenso, where I’ve worked for the past 6 years.
Here are the things I want to write down – mainly so I can reread it in the future and remember.
PL/SQL provides three different types of collections to hold multiple items of data. They all come with different capabilities and limitations and since these are hard to remember, I provide a condensed showcase of the different collection types in one single code example.
I already wrote about how much I like the XML generating capabilities of modern SQL, but most examples come only with one or two levels of depth.
What if you want to create deeply nested XML and JSON directly from SQL?
Recursive CTEs (WITH-clause) is one addition to the SQL standard that makes the language incredibly powerful. Besides other things it can be used to generate data rows “from thin air” – for example a list of quarters by year.
SQL is your friend!
One of my favorite features of (Oracle-)SQL is how easy it is to turn relational data into other data formats like JSON or XML.
But what if you need to add a namespace to some of the nodes in your generated XML?
I struggled with that until I made a realization about the nature of the xlmns part in XML.