July 20, 2011 at 1:22 pm
Hi,
Right now working as SQL DBA .Have an interview next week and they want one who is having good knowledge in IIS, Windows server 2000,2003 and 2008.
Can anyone please help me guide for the same? I dont know what exactly i should learn on Windows.
July 20, 2011 at 2:27 pm
Rechana Rajan (7/20/2011)
Hi,Right now working as SQL DBA .Have an interview next week and they want one who is having good knowledge in IIS, Windows server 2000,2003 and 2008.
Can anyone please help me guide for the same? I dont know what exactly i should learn on Windows.
A week just simply even close to enough time to learn IIS and 3 version of windows server. This is the kind thing that you either know or you don't. There is no amount of reading that will get you anywhere near as much knowledge as having done it. Think about many of the things you do as a DBA. There just is no book knowledge even close to the little things you have learned on the job while you were doing it. No amount of reading can replace actually doing it.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
July 21, 2011 at 3:45 am
Thanks Sean,
What you said is absolutely right and 100% i agree with you.
But can you please help me in understanding on what areas can they ask question ,what exactly i need to brush up on windows?
Thanks in advance.
July 21, 2011 at 7:25 am
Rechana Rajan (7/21/2011)
Thanks Sean,What you said is absolutely right and 100% i agree with you.
But can you please help me in understanding on what areas can they ask question ,what exactly i need to brush up on windows?
Thanks in advance.
I have no idea what the job is or what your skill set is. The questions they are likely to ask will be relevant to the position. Is this a DBA position? If so, they are probably wanting somebody who can also manage their web and windows servers. My guess is that once the interview is going they will have a pretty good sense of whether or not you have the skills they are looking for. I wish I could give you a better answer but the topic is HUGE. Hope the interview goes well. Good luck.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
July 21, 2011 at 8:21 am
Thanks Sean,
The opening is for core SQL DBA but they have mentioned Windows 2003\2008 on their JD.
July 21, 2011 at 8:30 am
This is exactly why i wrote my guide for creating a virtual sql server 2008 cluster. It gives you exposure to Windows fundamentals and helps you grow confidence
Check the article in the SSC articles section 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 21, 2011 at 9:01 am
Thanks Perry 🙂
July 21, 2011 at 9:21 am
As everyone else has said the topics are huge.
However in my past experience when companies have asked for knowledge of these areas it is generally been in the context of how SQL Server uses them.
Again in my experience most large organisations have seperate departments for SQL Admin, Windows Admin, Web Server admin etc etc which have their own experts in each field. So they would only look for some intermediate knowledge of the finer workings of the OS \ IIS.
Whereas small organisations generally want to have someone that can cover more areas as they probably wont have dedicated people for each role.
So for example the kind of questions I use and have been given for a large organisation are:
1. What Performance Counters would you use in perfmon to identify CPU, Memory, IO Pressure
2. When creating security logins how would you utilise active directory to reduce the number of SQL logins.
3. When setting up a windows servers that will be used for SQL Failover Clustering what drive configuration can you recommend for conditions X, Y, Z
5. What HDD configurations would you recommend for a database which is X gig in Size, i.e. SAN \ local storage etc.
Whereas small companies could ask anything
MCITP SQL 2005, MCSA SQL 2012
July 21, 2011 at 1:33 pm
Thanks alot Taylor...
A was expecting such questions.. thanks once again..
Viewing 9 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply