Archive

March 2020

Browsing

Every year I read at least a dozen books about software development, computer science, etc. In 2019, I read a book I can easily classify as one of the best books written on software development topics. The book is about developing distributed systems in the right way. The full name of the book is “Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems” by Dr. Martin Kleppmann (links are not affiliated links). I liked the book because every topic is presented in-depth but also in a simple way of understanding. The author starts with the very basic…

Last week I had to check a slow executing report. It was an SSRS 2016 report. I am not that familiar with the system so I took the task as a challenge. The execution time of the report was around 35 seconds. This time was very unrealistic based on the volume of the used dataset. My first task was to start removing queries one by one (and running the report) so I can catch a bad optimized one. Surprisingly there was no such a query. The queries were not perfectly optimized but not badly written. Also, it was interesting that…