SQL Server Performance


Discussion in 'The Lighter Side of Being a DBA' started by silicon_master, Jan 2, 2006.

  1. silicon_master New Member

    Hi Everyone

    Once more i am on this question again and really Need help from you all.

    I am a Software Design Engineer working in India on ASP.Net - Technology with SQL SERVER 2000 as a back end.

    Our company is not so big as it is in its establishing stage but we have one-two Good
    US based Projects but the technique we use is not upto date and there is nothing more tricky(best use of technology) in it.

    Having 1.5 yr of experience i donot feel that i am growing to that pace.

    Now i feel that i should move completely to DATABASE - with in 6 months or so.

    Some say ORACLE is the Best and some SQL SERVER - the Best.

    Should i continue on both FRONT END as well as BACK END or DATABASE ONLY [?]

    I am expecting a Positive & Genuine Suggestions from all of you.


    Silicon Master
  2. Madhivanan Moderator

    As you are ASP.NET programmer, you can continue with it and learn SQL Server. If you want to completely move to Back End side you need to become DBA which I think is somewhat difficult or take more time than becoming Master in Front End Applications. Better you learn Both Front End and Back End [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
  3. ranjitjain New Member

    I feel it's like doing MBA where you do major in one and minor in all.

    As you are already in middle of front end programming so do major in that and minor in SQL Server and others.

    Don't be shaky
  4. ghemant Moderator

    Hi,<br />its a long (might be never ending) debate on whats best sql or oracle,here is a nice article on comparision of both , go through it :<br /><br /><a href='http://www.mssqlcity.com/Articles/Compare/sql_server_vs_oracle.htm' target='_blank' title='http://www.mssqlcity.com/Articles/Compare/sql_server_vs_oracle.htm'<a target="_blank" href=http://www.mssqlcity.com/Articles/Compare/sql_server_vs_oracle.htm>http://www.mssqlcity.com/Articles/Compare/sql_server_vs_oracle.htm</a></a><br /><br />and in regards to become a DBA ,here are some threads on this site please refer this , <br />personally i would say its good to be a DBA,but to suggest its difficult its upto you and surrounding environment + further scope / career perspective, i am mainly network professional but now doing DBA Stuff tooo , its really nice experience,nice learning, keep in touch with SSP , read more and more <br /><br /><a href='http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=8563' target='_blank' title='http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=8563'<a target="_blank" href=http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=8563>http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=8563</a></a><br /><a href='http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=11759' target='_blank' title='http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=11759'<a target="_blank" href=http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=11759>http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=11759</a> </a> <br /><br /><img src='/community/emoticons/emotion-1.gif' alt=':)' /><br />HTH<br />Regards<br /><br /><br />Hemantgiri S. Goswami<br />ghemant@gmail.com<br />"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami<br />
  5. FrankKalis Moderator

    There is nothing like the "best" database. Both, Oracle and SQL Server, have their pros and cons. Which one you choose, depends on either what the shop you work for is running or what is required for the job. As this is SQL Server land here, guess what almost everyone here will suggest as database system? [<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br /><br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br />
  6. silicon_master New Member

    Thanks a Lot to all of You....

    Now i can make up my Mind by continuing in my ASP.NET field and side by side i will increase my SQL Potential as personally also i love Database, so that in future if i need to jump i do not havr to struggle a lot.....

    Silicon Master
  7. Madhivanan Moderator

    &gt;&gt;also i love Database, so that in future if i need to jump i do not havr to struggle a lot.....<br /><br />Thats good [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
  8. rajkolli_2000 New Member


    The Best Greetings From Raaj...According to ur query I give my best suggestion to u
    as, i think u r flexible with database rather than frontend.U can move farward to database programmer and acting like a 'DBA' plays a vital role in the organization, and u will become a key member to the company.

    Coming to the difference between oracle and SQL SERVER, i suggest u to be with sql server than oracle, bcoz already have 1.5 years of experience with microsoft applications and

    have a look here for differences

    With Regards

Share This Page