CodeFari: SQL SERVER Integration Service (SSIS)

Remove/replace special characters from string in PostgreSQL

Sometimes we need to remove special characters from string or columns value. Suppose, we developed an ETL tool that inserting records on ...
Check if an index exists in SQL Server

Many times we come across the scenario where we need to some code based on whether an index exists or not. The following query may he...
if/else condition in MongoDB

$cond operator has the keyword "if", "then" and "else", using this operator we can perform if/else in ...
How to check if a VIEW exist in SQL Server

Many scenarios come in query writing, we have to check particular VIEW exists in the database or not. There are many approaches to che...
MongoDB Query: Remove duplicate records from collection except one

Problem: DBA work is critical and sensitive; we work on Non Relational or Relational Database and the data consistency is a common facto...
How to get a list column names and data-type of a table in PostgreSQL?

If you are a DBA and you are working on a data-dictionary for a project so that you can keep track of schema changes and so on, then this ...
How to select the nth row of the table in PostgreSQL?

Here we will discuss the technique to fetch nth row of the table in PostgreSQL. I will use the concept of the LIMIT and OFFSET Clause . ...
Common Issue "Can't find module 'bcrypt'" in node.js

This issue comes much time when we are using PostgreSQL with Node.js, Error: Cannot find module 'bcrypt' in nodejs application, and...
AWS: AppSync with Lambda Resolver for MongoDB using DotNet core

In this article, we will learn how to create an AppSync API with the Lambda function. I will show you how a lambda function is written usi...
Order by with dynamic columns in LINQ c#

Hi Guys, sometimes we need to sort the data dynamically with the dynamic column, suppose we are sowing data in the grid, and after a click...