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.