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 to fulfill this request via send_db_mail.   But while using … 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 by application team, Dbs. which were brought online gets dropped/deleted. … 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 backup could be executed on SQL server. When we run … Continue reading Parallel databases backup in SQL server

Low disk space alert 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 2008 and onward. Scenario:  Assume its exiting or new SQL server handed over to you and you have to implement low disk space alert on the email. … Continue reading Low disk space alert 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 to highly uses, insert, update, delete command on databases, indexes … 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 heap tables and assume you found out many fragmented heap … 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. lets say you also wanna do like this and wanna … 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 on Migration project for one of my prime customer from … 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 subsystem failed to load [see the SQLAGENT.OUT file for details]; … 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 very famous  error which has been seen no of times … Continue reading Cannot open backup device. Operating system error 5(Access is denied.) while backing up\restoring SQL server Databases.