Romesh Maling Perera

Finding a solution for hard questions was one of my hobbies from my childhood. You will find me on almost all problem solving web sites, like top coder, project eular, Hacker Rank, etc. My hobby leads my way towards being an engineer. I play lot of strategy games like Age of Empires, League of Legends, Command and conquer, etc. Team play and good communication can change a game, If you agree with me add me as a League of Legends friend. Having my school education from Maris Stella College, I was selected to the University of Moratuwa having the best advance level results (in mathematics section) in my school. I have the dream of being a part of the biggest changes in the world. I was able to be batch 5th in first year field-selection examination in University of Moratuwa. My dream had its hand on my selection of Computer Science and Engineering Field after the field selection exam. I completed my Industrial training in WSO2 Lanka (pvt) Ltd. Currently I am working in Leapset (pvt) Ltd Specialties: Software Engineering, Marketing, Technical Writing, Presentation Skills, Music, Karate, Real time strategy games.

Finding a solution for hard questions was one of my hobbies from my childhood. You will find me on almost all problem solving web sites, like top coder, project eular, Hacker Rank, etc. My hobby leads my way towards being an engineer. I play lot of strategy games like Age of Empires, League of Legends, Command and conquer, etc. Team play and good communication can change a game, If you agree with me add me as a League of Legends friend.

Having my school education from Maris Stella College, I was selected to the University of Moratuwa having the best advance level results (in mathematics section) in my school. I have the dream of being a part of the biggest changes in the world. I was able to be batch 5th in first year field-selection examination in University of Moratuwa. My dream had its hand on my selection of Computer Science and Engineering Field after the field selection exam.

I completed my Industrial training in WSO2 Lanka (pvt) Ltd. Currently I am working in Leapset (pvt) Ltd

Specialties: Software Engineering, Marketing, Technical Writing, Presentation Skills, Music, Karate, Real time strategy games.

    Find more about me on:
  • facebook
  • linkedin
  • skype
  • twitter
  • youtube

SLGS Scholarship Program 2021

The Sri Lankan Graduates’ Society (SLGS) is a postgraduate society affiliated with the Graduate Student Association (GSA) at the University of Melbourne, Australia. We aim to advocate for the welfare of Sri Lankan graduate students and promote our culture and heritage among the multicultural community of the University, whilst also being… Read More »SLGS Scholarship Program 2021

SQL Server Snapshot Creation Error – “All files must be specified for database snapshot creation”

There are several reasons where you will get this error, but I’m going to talk about the one I faced and can be fixed in seconds. I was working with an IMDB dataset. The reason for my error was a database rename. I created the database initially with the name… Read More »SQL Server Snapshot Creation Error – “All files must be specified for database snapshot creation”

VS Code Won’t Open After Unplanned Restart (Failed to deserialize the V8 snapshot blob)

The visual studio was running fine in my machine till an unplanned restart happened. Soon after restart VS didn’t open giving me the below error. I reinstalled the Visual Studio Code without uninstalling which fixed the issue. In addition, it started without any loss to previous plugins and open projects.… Read More »VS Code Won’t Open After Unplanned Restart (Failed to deserialize the V8 snapshot blob)

PostgreSQL – BULK INSERTING from a delimited file, Most common errors in Windows

PostgreSQL alternative for MS SQL Server BULK INSERT is the equally simple COPY command. In this article, we are going to take a step by step look at how to use this and possible errors. So I tried below command, which is completely correct. I faced a couple of issues… Read More »PostgreSQL – BULK INSERTING from a delimited file, Most common errors in Windows

PostgreSQL – How to get the total index size used by each table in a database

As per the documentation, To get the total size of all indexes attached to a table, you use the function. The pg_indexes_size() function accepts the OID or table name as the argument and returns the total disk space used by all indexes attached to that table. We will use this… Read More »PostgreSQL – How to get the total index size used by each table in a database

Sri Lanka Holidays Calendar 2016 for Outlook & Google

Sri Lanka Holidays Calendar 2021 for office365, Google etc. in .ics format

Honouring everyone’s request I added the Sri Lankan Holiday calendar for 2021. This will allow you to add the Sri Lanka Holidays Calendar 2021 to your digital calendar (Most of the online digital calendars that we use these days don’t have inbuilt option to add the holiday calendar for Sri… Read More »Sri Lanka Holidays Calendar 2021 for office365, Google etc. in .ics format

DBA bandits: Self-driving index tuning under ad-hoc, analytical workloads with safety guarantees

Abstract: “Automating physical database design has remained a long-term interest in database research due to substantial performance gains afforded by optimised structures. Despite significant progress, a majority of today’s commercial solutions are highly manual, requiring offline invocation by database administrators (DBAs) who are expected to identify and supply representative training… Read More »DBA bandits: Self-driving index tuning under ad-hoc, analytical workloads with safety guarantees