Janne Mattila

From programmer to programmer -- Programming just for the fun of it

Some-Questions-And-Some-Answers (SQASA) repository and repeat questions

Posted on: August 7, 2023

Over the years I have received tons of different questions around application development and Azure from my customers and colleagues.

As I have been answering those questions, I have also been writing many of them down. This of course has made my life a lot easier, since I can just provide link to my notes instead of writing the same answer over and over again.

In fact, many people are now quite frequently asking from me:

“Do you happen to have code example about…?”

Maybe it’s not a big suprise that same questions have come up several times. Therefore, I created a repository for all these smaller random questions. I ended up calling it SQASA (Some Questions And Some Answers) and you can find it here:

Below you can find three examples of the questions that I have received several times over the years.


First example is quite technical and many times complex. These kind of questions might come up when you’re doing custom application development or when you’re migrating older application to cloud. This is definitely a repeat question for me and it has come up at least 10+ times.

It comes in many different forms, such as:

“My app seems to perform slowly in Azure.”

“Our application works so much faster in our laptops.”

“We’re scaling up the database but we don’t see performance improvements we’re expecting.”

Core question from above discussions can be summarized to:

“My app seems to have higher latencies that I’m expecting when using our database. Why?”

I’m not going to duplicate my notes here, but you can check my notes from the original location: Azure Databases.


Second example of repeat question is related to Azure DevOps Agents and network access:

“I want to connect to Azure Storage from my pipeline, but it doesn’t work because of network restrictions.”

“I want to update my database schema but I can’t connect to database during the deployment due to network configuration.”

Those questions can be summarized to:

“How do I access network restricted resource from pipeline?”

For some reason it took me years to write this down but eventually I did it. You can find it here: How do I access network restricted resource from pipeline. Again, it should help you when having the customer discussions.

GitHub Actions & GitHub-hosted Runners have similar challenge and above applies there as well. Additionally, GitHub has documented other more complex options but I haven’t really seen these used within Enterprise customers.


Third and final repeat question example is the most repeat question that I’ve ever had.

It’s related to Azure deployments and what’s my view on it. I wrote that to Azure deployment entry point and I have been using that as a reference for years to in my discussions.


Even if some of the above notes are already quite old, I have found them to be still useful for suprisingly long time.

Therefore, I highly recommend you to begin documenting your own work and giving yourself a good productivity boost.