Skip to main content

Posts

Showing posts from September, 2021

Frequent Terms used in Cloud world

In cloud world, number of terms or terminology used. We listen and use those terms on our daily life and also implement it in the project. But sometimes if someone suddenly ask about those words, we get confused and feel guilty because of unable to answer properly. That is the reason I am summerising some of the important terms together on this page so that we can memorize it quickly. Before going to the cloud world, lets first understand the Environment . Environment: Combination of Infrastructure/Hardwares, Softwares and Networking is collectively called as environment. Environment can be setup in two way On-Premises environment and Cloud environment. 1. On-Premises Environment: When all the required resources (Hardwares, Softwares, Tools, Applications etc.) are deployed in-house and within an enterprise’s IT infrastructure then it is called on-premises environment. An enterprise is responsible for maintaining the solution and all its related proce

Infrastructure Automation OR Infrastructure as Code (IaC)

Infrastructure as a code means create your required infrastructure through the code written using PowerShell or Azure CLI or Terraform.  The purpose of infrastructure as code is to enable developers or operations teams to automatically manage, monitor and provision resources, rather than manually configure discrete hardware devices and operating systems. Here I am not going to much focus on what is Infrastructure as a code rather I will prefer to focus more on 1. How to learn it?, 2. How to write the code for it?, 3. How to execute the code? and 4. How to automate whole process? There are various way to write code to create infrastructure but I will mainly focus on using Terraform script to create infrastructure. You can see the whole steps at this Github link For the simplicity, I have created two folders in this repository one is learning and another is practical. I will suggest to first refer the learning part and then come to practical part.

Frequent Terms used in Container World

In the container world, number of terms or terminology used. We listen and use those terms on our daily life and also implement it in the project. But sometimes if someone suddenly ask about those words, we get confused and feel guilty because of unable to answer properly. That is the reason I am summerising some of the important terms together on this page so that we can memorize it quickly. Some of the important terms are as below: Virtual Machine (VM), Container, Docker, Kubernete, Cluster, Nodes, Master Node, Worker Nodes, POD, Kubernete Service, Replication Controller or ReplicaSet and Auto Scaling I am trying to arrange those terms as per their uses and sequence. Virtual Machine (VM): VM is a kind of a virtual server that you can connect remotely. VM contains whole Operating Systems with all its libraries like any other physical machine that make it heavy in GB in size. To run an application web/window, you need a machine either (virtual or physical). Let sa

How to parse JSON data in SQL Server

To parse JSON data in SQL Server, there is a function called OPENJSON can be used in SQL Script. Syntax:   OPENJSON( [jsondata] , [path] ) [ with Clause  ] . Parameter jsondata is your json data and parameter path is the node of your jsondata. '$' is used to hold the root node. But before using OPENJSON function in your SQL Server, you must set compatibility level as 130 at least in your database to support OPENJSON function. Example: ALTER DATABASE MyDatabase SET COMPATIBILITY_LEVEL = 130 Parse JSON Data Example 1: DECLARE @Json NVARCHAR(MAX) SELECT @Json = ' { "StudentList": [  {  "Id":1, "FirstName":"Amalay", "LastName":"Verma", "Class":10, "Marks":61.5 }, {  "Id":2, "FirstName":"Saurabh", "LastName":"Sharma", "Class":11, &qu

Automation of Coding Standards for .Net using StyleCop

While writing c# code, it is very difficult to ensure that every developer is following coding standards guideline. Forget the advanced level of coding standards even we have experienced that basic level of coding standards are not followed properly in the project. And the major reason behind this is the manual process of forcing team members to follow the coding standards some time developer minds it and taking negatively. It is better idea to force developer by machine rather than human to follow coding standards in their code. For this there are couple of tools which are used to automate the coding standards process such as   StyleCop   FxCop   Code Analysis etc.  All these tools have some good and bad thing with own. Here this document is going to contain all about StyleCop.  StyleCop is a tool from Microsoft (an open Source Tool btw.) to analyse the Source Code. It works on C# source files directly rather than .DLLs. Sty