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