Post reply

hiii everyone

  • January 19, 2012 at 12:14 am

    #263049

    hi,

    i want to start my carrier as sql server dba and i want to know what are the major things i should learn from development side

  • January 19, 2012 at 2:13 am

    #1435700

    From the development side I would start off with SELECT statements and move on from there. Once you've understood this, move onto INSERTS, UPDATES, DELETES & MERGES, before moving onto stored procedures, views, functions & triggers.

    The MCTS cert in Db Design (70-433) covers all these areas plus more.

    Cheers

    Vultar

  • January 19, 2012 at 5:04 am

    #1435737

    trinamjose23 (1/19/2012)

    hi,

    i want to start my carrier as sql server dba and i want to know what are the major things i should learn from development side

    Have a look on this..

    http://www.mssqltips.com/sqlservertip/2145/starting-your-sql-server-career-path/

  • January 19, 2012 at 7:53 am

    #1435871

    trinamjose23 (1/19/2012)

    i want to start my carrier as sql server dba and i want to know what are the major things i should learn from development side

    May we ask about your background and current position?

    A DBA position is usually the technical end of the road for a much larger IT career.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  • January 19, 2012 at 10:41 am

    #1436054

    thanks all ...:-)

  • January 19, 2012 at 11:46 am

    #1436104

    I personally think developers need to learn about SQL Server security also. I've seen a lot of code fail due to lack of understanding of SQL authentication and how SQL processes requests (especially the notorious ownership chain issues).

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • January 19, 2012 at 11:56 am

    #1436111

    Tooting my own horn a bit but an article series I wrote for the site on this topic:

    http://www.sqlservercentral.com/articles/Career/71608/ - Overview of SQL Server positions

    http://www.sqlservercentral.com/articles/Career/73400/ - How to get started, career wise

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply