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:


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.

Read More »

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. Read More »

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).Read More »

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. Read More »

SQL Error : Index was outside the bounds of the Array (Microsoft.SqlServer.smo)

If while working on Azure SQL PaaS or even on-premise SQL database, you are stuck with this error “Index was outside the bounds of the Array. (Microsoft.SqlServer.smo)”, the most likely reason is that the version of SQL server management studio on your local machine is on the lower version that the SQL server version on the server end.

In such a scenario, you would need to upgrade the SSMS version installed on your local machine. Apparently, the reason behind the error message is that SQL couldn’t show new features in your old SSMS version. Read More »

Install oracle virtual box using PowerShell

Oracle virtual box  is a cross-platform virtualization application. It installs on existing Intel or AMD-based computers, whether they are running Windows, Mac, Linux or Solaris operating systems. You can choose to jump through several urls to find and download the right version or you can use the easier way. I’m going to explain the latter in this blog. For this post, you need to have Chocolatey installed on the machine. You can check here on how to do so.

Once you have done this, open a PowerShell prompt and run below Read More »

Install Chocolatey on a windows machine

As you know, Chocolatey is a very known and useful package manager for windows. Chef, Puppet, Boxstarter, PowerShell DSC, Ansible, Saltstack, Microsoft, etc all have ways for using Chocolatey to ensure the state of a computer and packages installed. If you don’t know about package manager, see my blog post here.

There are more than few ways to install it.One of the easiest ways is to use the built in package management inside PowerShell:

Install-Package chocolatey

You can also use NuGet command lineRead More »