Rajanand Ilangovan
Rajanand Ilangovan

Rajanand Ilangovan

Rajanand Ilangovan

Rajanand Ilangovan

5 followers

I'm a Business Intelligence Developer with over a decade of experience in design and development of databases, data warehouse, ETL, business intelligence reports and data visualization/analytics.

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

Sep 30, 20221 min read 2 views

Error: The request failed or the service didn't respond in a timely fashion consult the event log or other applicable error logs for...

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

Sep 30, 20221 min read 1 views

Error: Log reader agent has failed with an error Login failed for user 'sql-user-account'. Solution: Right click on the publication name and open...

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

Sep 25, 20221 min read

Error Msg 14013, Level 16, State 1, Procedure sp_MSrepl_addpublication, Line 188 This database is not enabled for publication. I have used the below...

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

Sep 20, 20221 min read 4 views

List out all the indexes defined on a table and column details. USE test_db; GO SELECT OBJECT_NAME(i.object_id) AS table_name ,i.type_desc AS...

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

Sep 16, 20221 min read 8 views

This query gets tcp/ip settings of the SQL Server from registry. SELECT registry_key, value_name, value_data FROM sys.dm_server_registry WHERE...

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

Sep 8, 20222 min read 12 views

You can execute the below query to get the list of SQL Server agents jobs and when it was last executed and time it took to complete the job and when...