Thursday, April 6, 2023

MS-SQL Server - A Divine Technology

A Divine Technology


SQL server has become a divine technology where most of the DBA tasks are getting completed by itself with the help of SQL agent.


These are

- Backups and Restore.

- DB Maintenance

- Clear Cache

- Transfer Backups/Data to one server to another.

- Wait Type Analysis.

- Performance Data capture.

- Change Data Capture to help Developers.

- Intimation for continuous blocking.

- Deadlocks and other important Errors intimation.


Best Regards



T. Amit Vaid S.


No comments: