Rajanand's Blog

Archive (76)

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

Oct 10, 2022 ·  Rajanand Ilangovan

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

Oct 1, 2022 ·  Rajanand Ilangovan

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

Sep 30, 2022 ·  Rajanand Ilangovan

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

Sep 25, 2022 ·  Rajanand Ilangovan

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

Sep 20, 2022 ·  Rajanand Ilangovan

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

Sep 16, 2022 ·  Rajanand Ilangovan

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

Sep 8, 2022 ·  Rajanand Ilangovan

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

Sep 5, 2022 ·  Rajanand Ilangovan

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

Sep 1, 2022 ·  Rajanand Ilangovan

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

Aug 26, 2022 ·  Rajanand Ilangovan

How to generate numbers table in SQL?

Aug 23, 2022 ·  Rajanand Ilangovan

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

Aug 1, 2022 ·  Rajanand Ilangovan

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

Jul 31, 2022 ·  Rajanand Ilangovan

How to undo the last git commit in local repository?

Jul 28, 2022 ·  Rajanand Ilangovan

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

Jul 12, 2022 ·  Rajanand Ilangovan

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

Jul 6, 2022 ·  Rajanand Ilangovan

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

Jun 22, 2022 ·  Rajanand Ilangovan

How to enable SQL Server database for publication

Jun 14, 2022 ·  Rajanand Ilangovan

What is the difference between stored procedure and function in SQL?

May 22, 2022 ·  Rajanand Ilangovan

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

May 16, 2022 ·  Rajanand Ilangovan

How to de-group the data in SQL?

May 15, 2022 ·  Rajanand Ilangovan

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

May 14, 2022 ·  Rajanand Ilangovan

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

May 11, 2022 ·  Rajanand Ilangovan

Azure Data Factory - White Papers

May 3, 2022 ·  Rajanand Ilangovan

SQL Server beginner interview questions and answers

May 2, 2022 ·  Rajanand Ilangovan