Skip to main content

Posts

Showing posts from 2019

SonarQube Configuration For .NET Core Web API

When multiple developers are working on the same project, it's good to have a code review. SonarQube is a tool through which we can evaluate our code. Here, for demo purposes, we are going to evaluate the web API which is built on .NET Core. Let's see step by step implementation. In order to run SonarQube, we need to install JAVA in our local system.   Refer to the below link to download JAVA installer and install JAVA. https://www.oracle.com/technetwork/java/javase/downloads/index-jsp-138363.html Configure the 'PATH' system variable under environment variables Go to Control Panel > System > Advanced System Settings, it will open the System Properties window. Click on the "Environment Variables" button. Click on the "View" button under User Variables. Give the variable name as 'JAVA_HOME'. The variable value will be your JDK path where you installed JAVA. Select path variable under system variable and click o

Change Data Capture in SQL Server

Change Data Capture (CDC) captures the data of insert, update and delete activity. When you insert or delete the data in the table it maintains a record for the same data. When you update the data it maintains records for before updating the data and after updating the data. To understand the change data capture we go through the following process. Process Step 1: Create DB   CREATE   DATABASE  CDC_DEMO   GO   Step 2: Create Table Create one table in the preceding database. Execute the following query and the "CDC_DEMO_TABLE1" table is created.  USE CDC_DEMO   GO      CREATE   TABLE  CDC_DEMO_TABLE1   (        ID       INT          IDENTITY(1,1)  PRIMARY   KEY ,        Name          VARCHAR (50)      NOT   NULL ,       Age      INT           NOT   NULL ,   );   GO   You can check the table in the Object Explorer.  Step 3: Insert Rows Insert some rows into the table "CDC_DEMO_TABLE1". Here we inserted two rows into th