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 (50)

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?

Table Variable 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?

How to find an account balance in SQL?

How to calculate total travel hours in SQL?

How to execute SQL commands within a batch file?

10 tips to increase your SQL Server Management Studio productivity

How to resolve TCP/IP connection issue and connect to SQL Server?

How to properly install SQL Server?