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

SSIS Error: Failed to open package file "T:\SSIS\Package.dtsx" due to error 0x80070003 "The system cannot find the path specified.".

SSIS Error: Unable to load the package as XML because of package does not have a valid XML format.

SSIS Error: Cannot create a task from XML for task, "task" type Microsoft.ExecuteProcess due to error 0x80070057 "The parameter is incorrect

Dashboard Inspirations

SQL Server Performance tuning and troubleshooting checklist

How to search for a table or column in all the databases in a server

How to fix the error of dynamically generated T-SQL query when the syntax is correct?

How to fix SQL Server SQL authentication login issue when the user name and password is correct?

How to fix SQL Server Integration Services could not be started issue?

How to fix Log reader agent login failure in SQL Server replication?

How to fix "This database is not enabled for publication" issue when the replication option is already enabled in SQL Server?

List of indexes on a table with column details in SQL Server

How to get the TCP / IP Settings of a SQL Server?

How to find a SQL Server agent jobs last executed and next scheduled date time?

How to rename a database without an error in SQL Server?

How to fix "Can not find path" error in PowerShell?

How to check database restore history and backup file used for restore in SQL Server?

How to generate numbers table in SQL?

How to search for a list of words contains in a string column?

How to split a string into a list of values in SQL?

How to undo the last git commit in local repository?

SQL Replication - Post Tracer Token error due to no active subscriptions

How to replace the first instance of the string in T-SQL?

How to find customers who never placed an order in SQL?

How to enable SQL Server database for publication