Detailed course structure for each branch and semister
Syllabus for each semester subjects
Previous Mid Exam Question Papers
Previous Semesters Final Exam Question Papers
You are responsible for administering 30 SQL Servers located in various cities.
You spend a significant amount of time each day logging into each server to check for new alerts.
What can you do to ease this administrative burden?
Use the xp_alertrelay stored procedure
Configure the remote servers to use event forwarding
Set up Enterprise Manager to query each server for alerts
Use Query Analyzer to execute Transact-SQL code that checks for new alerts
Event forwarding allows for centralization, scalability and efficiency of SQL Server event monitoring