Change or customize “from” portion/header of the email when calling sp_send_dbmail in SQL server

Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Scenario:- Recently, I had received a request from one of the customer to send some report from SQL to his management and it looks pretty simple …

Continue reading Change or customize “from” portion/header of the email when calling sp_send_dbmail in SQL server

How to find who has dropped/deleted SQL server user databases

Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Scenario:- During DR exercise,Prod and DR was configured with log shipping technology and once the Dbs. were brought online, somehow due to incorrect connection string settings …

Continue reading How to find who has dropped/deleted SQL server user databases

Parallel databases backup in SQL server

Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Infrastructure: This has been run and tested successfully on SQL 2005 and onward. Scenario: Parallel backup as the name itself suggest at a time multiple databases …

Continue reading Parallel databases backup in SQL server

Rebuild Indexes in SQL server using cursor

Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Infrastructure: This has been run and tested successfully on SQL 2005 and onward. Scenario:  In DBAs life, this is most important and weekly\daily kind of stuffs. Due …

Continue reading Rebuild Indexes in SQL server using cursor

Rebuild heap tables in SQL server using cursor

Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Infrastructure: This has been run and tested successfully on SQL 2005 and onward. Scenario:  There might be few cases where you as a DBA need to rebuild …

Continue reading Rebuild heap tables in SQL server using cursor

Configure SQL server database mail on your personal desktop for personal accounts like gmail, rediffmail,hotmail etc.

Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Infrastructure: This has been run and tested successfully on SQL 2005 and onward. Scenario: Many DBAs create their own lab at home for learning and r&d purpose. …

Continue reading Configure SQL server database mail on your personal desktop for personal accounts like gmail, rediffmail,hotmail etc.

FullText Search Error 1075: The dependency service does not exist or has been marked for deletion

Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Error: FullText Search Error 1075: The dependency service does not exist or has been marked for deletion Infrastructure: SQL server 2005 and onward Scenario: While I was working …

Continue reading FullText Search Error 1075: The dependency service does not exist or has been marked for deletion

The SQL server job is in suspended mode-Unable to start execution of step 1 (reason: The %s subsystem failed to load [see the SQLAGENT.OUT file for details]; The job has been suspended). The step failed.

Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Note:  Best viewed in Internet Explorer 6 and above Error: The SQL server job is in suspended mode-Unable to start execution of step 1 (reason: The %s …

Continue reading The SQL server job is in suspended mode-Unable to start execution of step 1 (reason: The %s subsystem failed to load [see the SQLAGENT.OUT file for details]; The job has been suspended). The step failed.

Cannot open backup device. Operating system error 5(Access is denied.) while backing up\restoring SQL server Databases.

Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Note:  Best viewed in Internet Explorer 6 and above Error: Cannot open backup device. Operating system error 5(Access is denied.) Infrastructure: SQL server 2000 and onward Scenario: This is …

Continue reading Cannot open backup device. Operating system error 5(Access is denied.) while backing up\restoring SQL server Databases.