Category Archives: Uncategorized

Automate changes in SSIS packages

We use Sql Server Integration Services (SSIS) for importing and exporting data. The number of SSIS packages is stil growing and on writing this post we have 35 of them. Changing the database connectionstring for development means opening and editing … Continue reading

Posted in Uncategorized | Tagged , , | Leave a comment

Parse IIS logs with powershell

With the log4j CVE we’re checking our IIS logs in detail. To automate this we’ve created a powershell script that parses the logs and provides query access. Below a script that searches for 502 responses and prints the fields we … Continue reading

Posted in Uncategorized | Tagged | Leave a comment

R Shiny dashboard inspection with profvis

We’re building a R Shiny dashboard to display big datasets. In our production environment we sometimes experience slow performance. Profiling with the profvis package is our plan to fix this. The profvis package needs to be installed. Then it can … Continue reading

Posted in Uncategorized | Tagged , | Leave a comment

The Unicorn Project

During lockdown I’ve been reading The Unicorn Project. The follow-up to The Phoenix Project. Again a very entertaining writing about the rocky road to get the IT department to the next level. I’ve read this book after I’ve read The … Continue reading

Posted in Uncategorized | Leave a comment

iOS 14 Wi-Fi Private Address

I’ve setup my Wifi router with timed access. This allows internet for certain time slots and denies access outside these time slots. After installing iOS 14 on both my iPad and iPhone I noticed no internet for me too. But … Continue reading

Posted in Uncategorized | Leave a comment