05-29-2021 , 02:09 PM
SQL Server | Oracle Engineer - (TOAD, SSMS,Data Migration) | Udemy
https://www.udemy.com/course/sql-server-...18956CA434
Quote:Description
SQL Server Database Engineers are in hot demand due to the growth and reliance on data.SQL Server is a relational database management system from Microsoft that's designed for the enterprise environment.
Some of the key daily responsibilities of a SQL Server Engineer includes:
Confirm that backups have been made and successfully saved to a secure location Check the backup failure alerts, correct the errors and rerun the backups Review the average duration of backup, any significant changes occurred investigates on this.Most of the time it happens due to networking low bandwidth Validate the backup files using restore verify only. Jobs can be created to take care of the task and to send a notification if it fails to verify any backup.
Performance Regularly monitor and identify blocking issues. Check Performance counters on all production servers and verify that all counters are within the normal range. Throughout the day, periodically monitor performance by collecting relevant data Create indexes to reduce the time it takes to get responses from the SQL Server after a T-SQL Script is executed.
https://www.udemy.com/course/sql-server-...18956CA434