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

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 …

Continue reading 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 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

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

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.