Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: SqlServer Interview Questions

RE: SqlServer Interview Questions

From: <Peter.McLarty_at_mincom.com>
Date: Thu, 13 Jun 2002 19:43:25 -0800
Message-ID: <F001.0047DBCC.20020613194325@fatcity.com>


Although the site has a problems with there SQL server I would have a look at the notes on the cramsession site for SQL server to give you some guides.

Also have a look around the MS site for some bulletins on SQL server problems with there fixes and see what there knowledge is there, Another resource is possibly Techrepublic for general interest stuff on SQL server

Try him on routine maintenance things that DBA's should be doing regardless of product. things like index rebuilds, space management, explain plans, etc etc and for a tricky one ask them about the wait interface, can't tell you much about it but it has one and it has a number of wait events that it uses.

Cheers

--


Peter McLarty               E-mail: Peter.Mclarty_at_mincom.com
Technical Consultant        WWW: http://www.mincom.com
APAC Technical Services     Phone: +61 (0)7 3303 3461
Brisbane,  Australia        Mobile: +61 (0)402 094 238
                            Facsimile: +61 (0)7 3303 3048
=================================================
A great pleasure in life is doing what people say you cannot do.

This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise.

"Boivin, Patrice J" <BoivinP_at_mar.dfo-mpo.gc.ca> Sent by: root_at_fatcity.com
14-06-2002 10:28 AM
Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Fax to: 
        Subject:        RE: SqlServer Interview Questions


You can evaluate his / her general attitude about work. Most people give the right answers at first, but you can dig in a bit more to see if they really believe in being organized, etc.

Re. SQL Server I don't know enough about it at this point to be helpful, finding practical issues that aren't covered in the MCSE exams would be ideal I think, just to see.

My CDN$0.02.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services        | Services technologiques
Informatics Branch         | Direction de l'informatique 
Maritimes Region, DFO      | Région des Maritimes, MPO

E-Mail: boivinp_at_mar.dfo-mpo.gc.ca

-----Original Message-----

Sent: Thursday, June 13, 2002 2:22 PM
To: Multiple recipients of list ORACLE-L

I've just been elected to particiate in the candidate interview process for
a SQL Server DBA at one
of our satelite offices. After 10 years of working with Oracle, the only thing I know about SQL
Server is the weekly security advisories for either it or Win 2k.

Any tips, links, flames, etc would be appreciated.

Thanks,
Ron Thomas
Hypercom, Inc
rthomas_at_hypercom.com
"The problem with some people is that when they aren't drunk, they're sober." --William Butler
Yeats.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Ron Thomas
  INET: rthomas_at_hypercom.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists

--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Boivin, Patrice J
  INET: BoivinP_at_mar.dfo-mpo.gc.ca
Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists

--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

Content-Type: text/plain; name="ReadMe.txt"; charset="us-ascii" Content-Transfer-Encoding: 7bit

The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail.

This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact Postmaster_at_fatcity.com for clarification.

--=_mixed 000E1EEB4A256BD8_=--
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: Peter.McLarty_at_mincom.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists

--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Received on Thu Jun 13 2002 - 22:43:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US