Posts

Azure Interview Questions Basic

              Azure Interview Questions     Q1 What are the types of scaling in cloud computing?  There are two types of scaling in the cloud computing Horizontal scaling: Horizontal scaling is when you scale up your pool by adding more systems/machines to your collection of resources Vertical scaling: Sometimes, you want to scale up your existing machines by increasing the (CPU and RAM )  size.   Q2 What are the primary   uses of the Azure Cloud Service? The primary purpose of the Azure Cloud Service is to host the running application. This service is also responsible for maintaining the   background application.   Q3 What are the different roles in Azure? There are three different types of  roles  are there in Azure Web Role:  A web Role is used to deploy web applications that are built on other languages that are supported i...
Post a Comment
Read more

Azure Devops - Create a CI / Build Pipeline

Image
    I n this article, we will cover how to add new pipeline to Devops project.  Go to  https://dev.azure.com /. Sign in with your credentials.  Open the Devops Organization and Open the listed project. To understand, how to create Devops Organization and project, Go to my previous article . Now, We will create CI/ Build pipeline for C# project so that developers can work on code and checkin their changes. Pipeline will generate build artifacts, which will be further sent to CD / Deployment pipeline for deployment on various servers like Pre-Prod or Prod servers. Please see the below image for more understanding. CI stands for Continuous Integration and CD stands for Continuous Deployment. Go to Pipelines in the left menu. Click on New Pipeline. This screen will appear.  There are two ways to create pipeline One way is using classic editor and other is using yaml code. classic editor is the way of creating pipelines as was done in TFS earlier....
Post a Comment
Location: Gurugram, Haryana, India
Read more

Azure Devops - Create Organization and add dotnet project to the Azure Devops repository.

Image
  I n this article, we will cover how to add new Azure Devops Organisation and also how to add the C# project code in the Azure Devops Repository. Go to  https://dev.azure.com /. Sign in with your credentials.  Click on the link New Organization.  Provide the name of the organization. I have given TechGeekGen-Z. Press Continue . This screen will appear for few mins. Devops Organization will be created after this. Create a Project in the newly created Devops Organization.  Click on New Project button in the left. Provide the Project name.  Choose Private if you want your project to be used only by the people you give access to otherwise choose Public. I am choosing  Private  here. Click on  Create Project.  The Project is created successfully. copy the highlighted command for pushing the origin on git as it contains origin url. This origin url will be used further.  Now, we have to add the code in Azure Devops repository. Let'...
Post a Comment
Location: Gurugram, Haryana, India
Read more

Using CTE Recursively to get the hierachy from Parent child stored in same table (Continent-> Country-> State-> City)

In this article I will explain how to write a query to create parent-child hierarchy ( Continent-> Country-> State-> City ) with levels using recursive common table expression (CTE).  While working with database we often store parent and child id in same table. Let's take the example of  Continents, Countries, State/Province and City. They are stored in same table, and we have to get all of them in hierarchy e.g.  Continent-> Country-> State-> City . Let's begin and understand this via an example:  Create a table using the script below:    IF   OBJECT_ID ( 'tempdb.dbo.#tbHierarchy' ,   'U' )   IS   NOT   NULL    DROP   TABLE  #tbHierarchy ;     GO   CREATE   TABLE  #tbHierarchy    (           Id  INT          , [Name]  VARCHAR ( 20 )      ...
Post a Comment
Read more