Technologies that surround SQL Server...

  • I am Jr. SQL DBA, completed 1 year working with SQL Server. Completed MCTS certification for SQL SERVER 2008.

    I want to learn more about the technologies that surround SQL Server. Please share your thoughts ....

    Sagar Sonawane
    ** Every DBA has his day!!:cool:

  • technologies that surround SQL Server

    I am novice than you. Can you give me an example?

  • VMware ESX/vSphere virtualization, Storage and Storage Area Networks (SANs) ....etc

    Sagar Sonawane
    ** Every DBA has his day!!:cool:

  • I dont know much on Virtualization, Storage Area networks..... as per my knowledge these are used mostly in Large Environments..... please guide on the same and any other relavant technology ...

    Sagar Sonawane
    ** Every DBA has his day!!:cool:

  • That's just so open-ended... How are you at query tuning? Are you an SSIS expert? What about hardware, do much with hardware? Networking? Virtuals? SANs? Performance Monitoring? Operating Systems? The list is just completely endless. I'm just not sure what you're asking for here. What you delve into and expand on depends on where your predilections lie and what people will pay you for. There's too much to make suggestions without a lot more guidance from you what it is you expect us to tell you.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • And note that you cannot possibly learn more than the basics about everything around SQL. There's just so much that it's impossible to become an expert on all of it (hell, it's impossible to be an expert on everything in SQL)

    To add a few more things:

    .Net framework (and CLR)

    Data Access Libraries (ADO.Net, JDBC, OLEDB, ODBC, etc)

    Entity Framework

    Reporting Services

    Excel (powerpivot, power view, etc)

    Analysis Services

    ...

    ..

    .

    Start with Google, really, there's so much written that you should start with web searches and ask questions on specific things you don't understand.

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • I'm in agreement with both Grant and Gail.

    Your training time would be much better used if focusing on what should be your area of expertise which is to be a damn good DBA.

    Believe me, with one year on the job you are barely scratching the surface of it. 🙂

    _____________________________________
    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.
  • PaulB-TheOneAndOnly (11/18/2011)


    I'm in agreement with both Grant and Gail.

    Your training time would be much better used if focusing on what should be your area of expertise which is to be a damn good DBA.

    Believe me, with one year on the job you are barely scratching the surface of it. 🙂

    Ya, how are you with sql 7,8,9,10,11 and 12?

    Once you start to understand your way around 2008, go up & down a few versions just to see how much you don't know :w00t:.

    I reckon 3-6 months on each version is not too much just to get the major differences in each of them.

  • Really thankful for your guidelines, Grant and Gail & Paul.

    Now my thoughts are very clear 🙂

    Sagar Sonawane
    ** Every DBA has his day!!:cool:

Viewing 9 posts - 1 through 9 (of 9 total)

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