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 …
Category: Uncategorized
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 …
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 …
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 …
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. …
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 …
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 …
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 …
ADsql-Tech Forever 
You must be logged in to post a comment.