What is the best way to have your junior DBA do

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

(Continued from previous question...)

What is the best way to have your junior DBA do this?

You want to ensure that your junior DBA properly enables your SQL Server 2005 servers to allow OPENROWSET and OPENDATASOURCE commands so developers can write routines that access various files. What is the best way to have your junior DBA do this?

Answer: Tell your junior DBA to use the SQL Server Surface Area Configuration Tool to enable this feature.

Explanation: The best way to ensure it is properly done is to use the Surface Area Configuration for Features tool. This minimizes the chance a mistake will be made by a junior DBA.

(Continued on next question...)

Other Job Interview Questions

• When a user on a remote SQL Server wants to execute a stored procedure through a linked server on your local server, what security context is used?
• Using Reporting Services 2005, it is true or false that subreports execute a query against the datasource once for every detail row in the report?
• You want to speed up your SQL Server 2005 Service Broker queue by placing an index on it. What is the best way to do this?
• Setting the TRUSTWORTHY database property to ON allows you to execute the following from within the context of the database: Submitted by Charles Hawkins
• What does the CREATE SERVICE statement do in SQL Server 2005?
• When declaring an XML document, which type allows text nodes at the top level?
• How can you determine which user is executing statements in Profiler?
• You are building an application for a Smartphone and want to use SQL Server Compact Edition. However you do not want this to run as a service all the time because of power concerns. What can you do?
• You wish to prevent anyone from using the sa account on your SQL Server 2005 instance, but still keep it available if your polocy changes. What can you do?
• What is the easiest way to capture the SQL statement for a Report Builder report you're troubleshooting?
• More...