June 6, 2011 at 5:07 am
hello experts how are you?
i am bit upset today, i interviewed today with "Microsoft" 4 days back for sql server DBA.
and i got the call today that i couldnt clear even first round of interview. and in feedback he said troubleshooting part was very good but two things he found on which i was not satisfactory
1) operating system concepts
2) RDBMS fundamentals
please let me know wat are the specific things in "operating system concepts" on which i should have strong knowledge as a sql server DBA.
please let me know wat are the specific things in "RDBMS fundamentals" on which i should have strong knowledge as a sql server DBA.
i will appreciate any bodies help.............
June 6, 2011 at 5:55 am
Zeal-DBA (6/6/2011)
please let me know wat are the specific things in "operating system concepts" on which i should have strong knowledge as a sql server DBA.
Quite a lot of things, actually. 🙂
To name a few:
* Windows clustering
* Networking (TCP/IP)
* Windows security (AD/logins/groups/policies)
* Services
* NTFS security
please let me know wat are the specific things in "RDBMS fundamentals" on which i should have strong knowledge as a sql server DBA.
I think they may refer to database design and relational theory, normalization etc.
I'm sure others can add their own $ 0.02.
-- Gianluca Sartori
June 6, 2011 at 6:36 am
I would expect an SQL Server DBA to know enough about Active Directory to leverage it for security and control. That would include knowledge about things like double-hop security tokens (Kerberos issues), account groups, and "minimum privileges". I would expect knowledge about the file system, and how it affects database operations and maintenance. Knowledge about services vs applications, and the relationship between service accounts and security. Configuration of server O/S options that impact SQL Server performance, installation, and operation, like the differences in memory management between AWE and the 3GB switch, vs 64-bit.
On RDBMS basics, this usually means things like ACID, transactions, normalization levels, data typing, data vs log files, and things at that level.
I would expect a DBA to know about those things. The degree of knowledge would determine junior/mid/senior/lead level, but I'd expect some degree on all of those things.
There's more than what I listed, but those are the ones that come to mind off the top of my head.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
June 6, 2011 at 6:49 am
exactly you wrote 80% same thngs wat he asked....
following Ques.. i remember.
Q1 explain ACID
Q2 explain how a T-log follows ACID properties with example
Q3 difference between 32 bit and 64 bit
Q4 explain virtual memory
can u help with these questions or a gud material to study thease thngs..
thnks for ur help...
June 6, 2011 at 7:00 am
For virtual memory, I recommend these:
http://channel9.msdn.com/Events/PDC/PDC10/CD01
http://channel9.msdn.com/Events/PDC/PDC10/CD02
None of the topics you've asked about are basic, simple or trivial to explain. I suggest you start with google and do a lot of reading.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 6, 2011 at 9:57 am
If you go for the videos Gail posted all I can say is buckle in tight, I gave them a listen a while back (at her recommendation) when trying to wrap my head around VAS and making the leap from 32 to 64 bit physical memory management and the phrase "in the deep end" comes to mind 🙂
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 6, 2011 at 10:07 am
opc.three (6/6/2011)
If you go for the videos Gail posted all I can say is buckle in tight, I gave them a listen a while back (at her recommendation) when trying to wrap my head around VAS and making the leap from 32 to 64 bit physical memory management and the phrase "in the deep end" comes to mind 🙂
They start making sense on the third time through. At least they did to me (though I still need to watch them, up until now I've just listened to the audio)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 7, 2011 at 6:13 am
Zeal-DBA (6/6/2011)
exactly you wrote 80% same thngs wat he asked....following Ques.. i remember.
Q1 explain ACID
Q2 explain how a T-log follows ACID properties with example
Q3 difference between 32 bit and 64 bit
Q4 explain virtual memory
can u help with these questions or a gud material to study thease thngs..
thnks for ur help...
Those are very basic questions. You should be able to get answers to most of them online, but if you really need that level of knowledge, you should take some basic classes at a local school. Based on your writing style, I would also suggest a basic English-writing class. It will help you create a more professional image, which is important in getting and keeping a job.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply