Updated: Upcoming dark theme changes

In order with the latest trend of dark theme, which is growing popular for many good reasons, this site will also switch to true dark theme starting December 25, 2018 0000 HRS UTC. You can find the associated good reasons at this, this and this links, which summarizes the benefits quite well.

A preview of the same can be accessed using below url:

https://metavrse.wordpress.com/?customize_changeset_uuid=f3caa97c-ae28-4066-bb00-7746a35c5ae6

Hopefully, this should not mess up with other content on this site. Please feel free to share your feedback by filling the contact form associated with this blog, in case of any issues.

Rebuild msdb database on SQL server

I don’t do this a lot since most of the apps are now a days using Azure SQL using all the benefits it offers. So I thought it would be better to take note of all the steps done for this. If the msdb database is damaged and you do not have a backup of the msdb database (for whatsoever reasons), you can create a new msdb by using the instmsdb script. In this blog post, we’ll go through steps required for the same.

Rebuilding the msdb database using the instmsdb script will eliminate all the information stored in msdb such as jobs, alert, operators, maintenance plans, backup history, Policy-Based Management settings, Database Mail, Performance Data Warehouse, etc.

Continue reading “Rebuild msdb database on SQL server”

Create a VM instance on Google cloud

Google cloud platform aka GCP is a cloud offering from Google. GCP frees you from the overhead of managing infrastructure, provisioning servers and configuring networks. To let innovators innovate and let coders, well, just code. In this blog post, we’ll get to know how to create a VM instance on GCP.

First of all, you’ll need to sign in to google cloud platform using https://cloud.google.com. If you don’t already have access, you can sign up quickly by providing few basic details. Once its done, google will automatically create a project for you and take you to the GCP Console.  Continue reading “Create a VM instance on Google cloud”

Difference between URI, URL and URN

It has been my observation that many of the tech engineers do not know the difference between URI, URN and URLs. For many of them, they are same. For very of them, rest of them and few others are confused. So through this blog post, I intend to clarify that difference. I guess this is more of the classical questions like what to formally call a web address and what do you mean by a web address in first place. In this age of varying protocols and APIs and methods, what is called as a web address is itself of a question. for example, ftp://files.metavrs.in may serve entirely different content than http://files.metavrs.in which may further differ that mailto:files.metavrs.in (these urls are just for understanding purposes only). Continue reading “Difference between URI, URL and URN”

Understanding JSON and compare it to XML

In this day and age of continuous delivery and integration, the focus is continuously moving away from software interface and on to APIs. One of the prime objectives of DevOps is to achieve end to end automation of delivery. For this, the various kinds of softwares which are used in the process of delivery, need to exchange data. This is where APIs come in handy. Using APIs, there is no manual intervention needed, and all the data can be exchanged easily.

APIs, more specifically REST APIs, return data when queried. The earlier format of choice used to be XML, then it turned over to XAML but now the focus is on JSON due to its easiness.  Continue reading “Understanding JSON and compare it to XML”