Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12345»»»

SQL DBA high ended question (5+ years’ experience) Expand / Collapse
Author
Message
Posted Tuesday, August 5, 2014 1:53 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, August 25, 2014 1:24 AM
Points: 339, Visits: 310
Hi Friends,
I would like to know SQL DBA high ended question (5+ years’ experience) what kind of questions they will ASK …………………. Just for curiosity
Thanks a lot :
Rajesh
Post #1599500
Posted Tuesday, August 5, 2014 2:19 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 7:45 AM
Points: 40,456, Visits: 36,911
What do you mean? What kind of questions they'll ask in what context?


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1599507
Posted Tuesday, August 5, 2014 2:20 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:32 AM
Points: 13,570, Visits: 11,382
GilaMonster (8/5/2014)
What do you mean? What kind of questions they'll ask in what context?


I guess in a job interview.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1599508
Posted Tuesday, August 5, 2014 2:25 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 7:45 AM
Points: 40,456, Visits: 36,911
Koen Verbeeck (8/5/2014)
GilaMonster (8/5/2014)
What do you mean? What kind of questions they'll ask in what context?


I guess in a job interview.


In that case, for 5+ years experience:

Name 3 backup types in SQL Server
List the three recovery models and the differences between them.
Name two types of indexes and the differences between them.

On the off chance that they get any of those right, then we could get into a proper discussion.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1599509
Posted Tuesday, August 5, 2014 2:26 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:32 AM
Points: 13,570, Visits: 11,382
GilaMonster (8/5/2014)
Koen Verbeeck (8/5/2014)
GilaMonster (8/5/2014)
What do you mean? What kind of questions they'll ask in what context?


I guess in a job interview.


In that case, for 5+ years experience:

Name 3 backup types in SQL Server
List the three recovery models and the differences between them.
Name two types of indexes and the differences between them.

On the off chance that they get any of those right, then we could get into a proper discussion.


Good grief. Is this for 5+ years experience? I'm not a DBA but I know the answer to all of them (at least on a high-level).
I'm probably spoiled for hanging out too much on this site.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1599510
Posted Tuesday, August 5, 2014 4:14 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 10:07 AM
Points: 14,034, Visits: 28,406
I asked the same questions I asked someone with 2-3 years of experience. I just expected better answers. Also, when we get to the open-ended questions, I expect answers with stories as well as questions to test assumptions, etc.

Here's a sample:
You get a phone call. The person on the phone says the database is slow. What do you do?

Your responses to this tell me what you know, how well you know it and your experience level. And, there is absolutely no way to look up the answer ahead of time. You know this stuff, or you don't.


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server Query Performance Tuning
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1599551
Posted Tuesday, August 5, 2014 4:17 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 7:45 AM
Points: 40,456, Visits: 36,911
Koen Verbeeck (8/5/2014)
GilaMonster (8/5/2014)
Koen Verbeeck (8/5/2014)
GilaMonster (8/5/2014)
What do you mean? What kind of questions they'll ask in what context?


I guess in a job interview.


In that case, for 5+ years experience:

Name 3 backup types in SQL Server
List the three recovery models and the differences between them.
Name two types of indexes and the differences between them.

On the off chance that they get any of those right, then we could get into a proper discussion.


Good grief. Is this for 5+ years experience? I'm not a DBA but I know the answer to all of them (at least on a high-level).
I'm probably spoiled for hanging out too much on this site.


I'd expect the majority of DBAs at the mentioned level to be able to give me two backup types and two recovery models and maybe get the index question half right, maybe.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1599552
Posted Tuesday, August 5, 2014 4:29 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 10:07 AM
Points: 14,034, Visits: 28,406
GilaMonster (8/5/2014)
Koen Verbeeck (8/5/2014)
GilaMonster (8/5/2014)
Koen Verbeeck (8/5/2014)
GilaMonster (8/5/2014)
What do you mean? What kind of questions they'll ask in what context?


I guess in a job interview.


In that case, for 5+ years experience:

Name 3 backup types in SQL Server
List the three recovery models and the differences between them.
Name two types of indexes and the differences between them.

On the off chance that they get any of those right, then we could get into a proper discussion.


Good grief. Is this for 5+ years experience? I'm not a DBA but I know the answer to all of them (at least on a high-level).
I'm probably spoiled for hanging out too much on this site.


I'd expect the majority of DBAs at the mentioned level to be able to give me two backup types and two recovery models and maybe get the index question half right, maybe.


Yeah, everyone gets the intro level questions. "What's the difference between a deadlock, spelled d e a d l o c k, and a block, spelled b l o c k?" God I love that question. Most people carefully describe a block and then carefully describe a block. Recovery models, yes. "What's the difference between a clustered and a non-clustered index?" I've actually listed out the basic questions in a blog post. But, that's just the "get me in the door" questions. The real interview starts with my previous question.


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server Query Performance Tuning
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1599564
Posted Tuesday, August 5, 2014 4:32 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:32 AM
Points: 13,570, Visits: 11,382
Grant Fritchey (8/5/2014)

You get a phone call. The person on the phone says the database is slow. What do you do?


Migrate from Oracle to SQL Server? Do I get the job now?




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1599567
Posted Tuesday, August 5, 2014 4:35 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:32 AM
Points: 13,570, Visits: 11,382
Grant Fritchey (8/5/2014)

"What's the difference between a deadlock, spelled d e a d l o c k, and a block, spelled b l o c k?" God I love that question. Most people carefully describe a block and then carefully describe a block.


I'll take a stab at this (mind that I am a lowly BI developer).

Blocking is when one process has locked a resource and another cannot use that resource until the first process finishes. Usually resolves itself once the first process gives up the lock.

Deadlock is when two processes have acquired locks on two different object and before they can move on they need access to each others resources. They lock each other out and there is no resolution but to kill one of the processes.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1599568
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse