I am a Business intelligence lead with over a decade of experience in building DW/BI solutions. I am a Microsoft Certified Solutions Expert in Data management &amp; analytics and trainer.

blog.rajanand.org

<p>I am a Microsoft certified SQL Server and Power BI developer. I write about SQL Server, Power BI, Azure data factory and Azure synapse analytics. If you like the article and if it has helped you in any way, you may consider sponsoring this blog. Thanks for your support. </p>


I am a Microsoft certified SQL Server and Power BI developer. I write about SQL Server, Power BI, Azure data factory and Azure synapse analytics. If you like the article and if it has helped you in any way, you may consider sponsoring this blog. Thanks for your support. 



Rajanand Ilangovan

Rajanand Ilangovan

Archive (31)

How to concatenate multiple rows into a single string in SQL?

How to de-group the data in SQL?

How to find which command has failed in SQL Server Replication?

How to check SQL Server Replication is installed in a Server?

SQL Server Replication Queries

Azure Data Factory - White Papers

SQL Server beginner interview questions and answers

How to regenerate the sp_MS custom stored procedures in SQL Server

How to find the missing numbers in a series?

How to identify similarly pronounced words in SQL server?

How to check the database recovery progress in SQL Server?

List of all foreign keys and referenced tables and columns

How to concatenate values from previous row to current row in SQL?

How to get all the computed columns in a database in SQL Server?

How to swap column value in SQL?

What happens to the records inserted into a table variable, if the transaction rollback?

What happens to the variable value set during the transaction, if its rollback?

How to get nth highest salary in SQL Server?

How to install Git in windows

How to enable dark mode in SSMS?

How to attach database files and create database in SQL Server?

How to get any object's definition in SQL Server?

How to find out frequent credit card spender in SQL?

How to sort result set in custom order in SQL?

How to generate Permutations in SQL?