February 2022
How do you remove duplicate records with different status in SQL Server?
.
In this article, I will explain a scenario where the user has to remove duplicate records with different statuses. Scenario Consider below the table with 2 columns (Employee Name and Status) Now, write a query to fetch a unique Employee…
PowerShell script to create CSV file from SQL Table
.
In this article, we will create a CSV file from SQL Database using PowerShell script. Requirement Suppose there is a table in the SQL Server database and it contains more than 50,000 records. Now we want to create a CSV…
How to implement SignalR in .NET Core?
.
In this article, we will learn the concept of SignalR and also we will implement basic SignalR in .Net Core. Real-time communication is one of the crucial features in the modern tech world, this means allowing users to exchange information…
