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
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”
Codenames Duet keeps the basic elements of Codenames — give one-word clues to try to get someone to identify your agents among those on the table — but now you’re working together as a team to find all of your agents. (Why you don’t already know who your agents are… Read More »Codenames Duet Editable Digital Mission Map
The Sri Lankan Graduates’ Society (SLGS) of the University of Melbourne organized “අවුරුදු උදානය 2021” to celebrate the Sri Lankan New Year 2021. Below are some clicks from my camera.
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 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
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
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
I was working on a problem in UVA online judge where I needed to do a simple data addition. However, the catch was year can go beyond 9999 (which is the limit in python). Below code is the python solution for this problem. I simply divided the date-delta with (1200… Read More »UVA 893 – Y3K Problem: Handling Python years above 9999
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