Preview MS Sql DBA Day to Day Activities

Sql DBA Day to Day Activities

Topics Covered

Class 1 Handling Tickets and Different Environments

Class 2 Discussion Service Now , RDP, Connection Errors

Class 3 Login Failures, Backups and Restores

Class 4 Discussion On Database Refresh, Checking Job failures

Class 5 Discussion On Fixing Failed Jobs, Maintenance Plans

Class 6 Discussion On Disk Space issues, Shrinking Data files

Class 7 Discussion on Shrinking Log Files, Temp DB files, Sp_whoisactive, Kill sessions

Class 8 Discussion On Server Logoff, Disconnect, Fixing Blockings

Class 9 Discussion On Script Executions, Log Shipping Monitoring, Failover

Class 10 Discussion On Log Shipping, Patching HADR Server, Mirroring Monitoring and Failover

Class 11 Troubleshooting Mirroring, Replication and adding article in Replication

Class 12 Monitoring Sql Clustering and Failover, Troubleshooting Cluster issues

Class 13 Discussion on Always On, Adding Database into AG, Removing database, Refresh AG Database, Failover AG

Class 14 Discussion on AG, Giving permissions on Databases and Creating Logins

Download Sql DBA Daily Used Sql Scripts