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 «««56789»»

interview questions Expand / Collapse
Author
Message
Posted Wednesday, April 22, 2009 7:04 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 9:52 AM
Points: 2,006, Visits: 6,078
This could be an indispensable guide for interviews
http://www.howtonailaninterview.com/




Shamless self promotion - read my blog http://sirsql.net
Post #702307
Posted Wednesday, September 22, 2010 2:58 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 22, 2010 3:51 AM
Points: 1, Visits: 3
Hi,

you can find a good set of sql server interview questions
at the following link.

http://www.wiziq.com/online-class/292863-sql-server-interview-questions

Thanks
Regards
Kolla Sanjeeva Rao
Post #990943
Posted Wednesday, September 22, 2010 3:07 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, September 22, 2010 3:05 AM
Points: 83, Visits: 172
Great place, thank you
Post #990946
Posted Wednesday, January 12, 2011 10:21 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, January 12, 2011 10:12 PM
Points: 4, Visits: 2
paul.starr (4/17/2009)
any info on really good interview questions for a sql server dba?


Check here - MS SQL Interview Q&A


==================
Visit my blog!
Post #1046997
Posted Monday, June 20, 2011 3:56 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, April 14, 2014 8:28 AM
Points: 47, Visits: 117
First of All,

I should be aware of the problem before the business looking for the answer. If not I will confirm that I am wokring on the issue and will update you in 10-15 min.

10-15 min is always enough for you to understand the Problem. I will take the following steps.
1. Check the database server error log for any obvious failure for the last 30 min.
2. Check if the network connectivity is fine. Telnet the SQL on the configured port fro the application server
3. Check the server if there is disk space issue.

Now I have an more information to handle the problem and probably understood what fixes need to apply.

Update myLead/Manager that abou the issue and suggest the next steps. Once he approved the changes then go ahead and apply the changes to resolve the issue.

I and my manager shoould have an idea of how much time it takes fix these klind of problem. So he can communicate to relevent people.

I willl crack on appying the fixes.

.....


Post #1128045
Posted Tuesday, June 21, 2011 4:43 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, September 21, 2014 10:47 AM
Points: 258, Visits: 1,093
paul.starr (4/17/2009)
any info on really good interview questions for a sql server dba?


In addition to everything else that has been mentioned in this thread, I would recommend that you study and be prepared to answer questions about best practices. There are best practices for virtually every aspect of DBA work so there is a lot to study.

In addition to being prepared to answer questions about/discuss best practices, I would also recommend that you interview your prospective employer. Unless you have no other options, you probably will not want to work for a prospective employer who has no interest in, no knowledge of, nor any commmitment to the implementation of best practices. To work in a "non-best practices" environment means constant firefighting, bandaiding, and generally reacting to problems rather than being a proactive DBA.

It's not much fun.

LC
Post #1129383
Posted Saturday, May 5, 2012 4:37 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, August 28, 2014 2:07 PM
Points: 19, Visits: 116
What is called Object in SQL Server? Tell me some objects name?
Post #1295557
Posted Saturday, May 5, 2012 2:35 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 11:18 PM
Points: 35,267, Visits: 31,759
best_yunus (5/5/2012)
What is called Object in SQL Server? Tell me some objects name?


Google. Seriously... Google for "sql server objects" and you'll find out. To summarize, just about anything you can name in SQL Server is an "object".


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1295588
Posted Sunday, May 6, 2012 10:05 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, August 28, 2014 2:07 PM
Points: 19, Visits: 116
thanks
Post #1295693
Posted Monday, May 7, 2012 2:38 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 5, 2014 5:16 PM
Points: 5, Visits: 39
Applying for a DBA position can involve a lot of different knowledge areas. You need to understand what the job is that you are applying for and determine if your skills match the position. There are jobs that are more involved in the database administration portion of the work and there are other jobs that need more database developer, SSIS, or SSRS background. While these could all be advertised under the label of Database Administrator you would need to look at the details of the position being posted to better understand what the company is looking for. There are different sites for different points about certain topics. You can start by looking up best practices for setting up databases, indexing, and so forth. As you find articles that peak your interest in certain area's you can branch off into those areas and learn more. One of the things a good DBA has is the ability to observe events to capture what is going on, that helps them solve the issue or to research the issue to find the solution. The one thing about technology is that if you want to keep your job and be an asset to your company you never stop learning so forget about just looking up the data just for the interview, it will be a continual process if you want to be successful. I have attached a document that pretty much sums up characteristics any good employee should have but is written for DBAs. I do not endorse the products listed, I just think it's a good summary.

  Post Attachments 
How_To_Become_An_Exceptional_DBA_Ebook.pdf (6 views, 3.00 MB)
Post #1296112
« Prev Topic | Next Topic »

Add to briefcase «««56789»»

Permissions Expand / Collapse