What should you have applied a patch for by now

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What should you have applied a patch for by now on your Windows 2003 and XP systems?

Answer: Daylight Savings Time

Explanation: If you haven't, daylight savings time comes early, this Sunday in fact. Be sure you patch your systems, set an Outlook reminder, and get up Sunday to check servers.

(Continued on next question...)

Other Job Interview Questions

• In SQL Server 2005, can you include a user-defined role as a member of another user-defined role?
• In SQL Server 2005, what permissions does a user need to successfully execute the USE command?
• What T-SQL function can achieve this?
• How many users can be added to an application role in SQL Server 2005?
• Which of the following is not true about the Raw File Destintion connection in SQL Server 2005 Integration Services?
• Where can you view the list of server-scoped DDL triggers?
• What does REVERT do in SQL Server 2005?
• What type of connectivity does the readpipe/makepipe utility test?
• Your SQL Server 2005 Express Edition locks up frequently and cannot be accessed. How can you enable the dedicated administrator connection?
• What is the granularity in seconds of the timestamp datatype?
• More...