SQL Server Performance Forum – Threads Archive

web data administration

Hai What is SQL data administration?
tell me detail. rgds
anita

Do you mean the SQL Server Web Data Administrator? If so, have a look here:
http://www.microsoft.com/downloads/…98-C57A-419E-ACBC-2A332CB7F959&displaylang=en —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstÃ¼tze PASS Deutschland e.V. http://www.sqlpass.de)

http://www.databasejournal.com/features/mssql/article.php/3484936 – about above tool.
About SQL administration:
http://vyaskn.tripod.com/sql_server_administration_best_practices.htm
http://vyaskn.tripod.com/microsoft_sql_server_articles.htm Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

I have worked with the above tool. it is good tool. it covers basically every aspects of data administration. but is bit slow in the performance wise

Thank U Guys! Then What is the difference between Query analyzer and SQL Web data administation thanking u anticipation rgds
anita

SQL Server Web Data Administrator enables you to admin a server with only a browser. So, virtually from everywhere where you have access to the internet.
Query Analyzer need to be installed on the machine from which you want to access your server. —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstÃ¼tze PASS Deutschland e.V. http://www.sqlpass.de)

i am new to the sql server
Thank u Frank
Thanks a lot of all guys rgds
anita

Anita I suggest you to refer to the following links to know more about SQL Server:
http://sqlzoo.net/
http://www.webdevelopersnotes.com/tutorials/sql/index.php3
http://www.w3schools.com/sql/sql_intro.asp Good luck. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Anita, welcome to the family! [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] – Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de</a> Ich unterstÃ¼tze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>)

What is the difference between MYSQL and SQL Server?
what are the things i learn to become a SQL DBA?
can u help me and give some guidelines
rgds
anita

MySQL is a open soruce database system http://builder.com.com/5100-6388-1054385.html

Anita, it’s usually better to start a new thread when you have a new question. That way, more people will get aware of it which in turn increases your chances to get good and quick suggestions. [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] The difference between MySQL and SQL Server cannot be described in a few words. Dinesh mentioned probably the most noticeable difference. Maybe you should google a bit. Both systems have been described in many places. Become a DBA? Administrative or developing one? Maybe these give you an idea: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_id_com_admn2.asp</a> http://vyaskn.tripod.com/sql_server_administration_best_practices.htm</a> – Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de</a> Ich unterstÃ¼tze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>)

Hi Frank! Is administrative is difficult one?
can i iearn this without the help of computer centre(like NITT..) rgds
anita

I don’t know. I am neither administrative nor developing. [<img src=’/community/emoticons/emotion-1.gif’ alt=’

Thank u Frank! Hi All!
Is anybony help me? rgds
anita

Anita You can achieve it with constant learning and put into practice, review all the links referred above and feel free to ask any doubts you’ve. But before that have a thorough lookup in books online about the topic. On the lighter side I was never been to a training institute to learn/know SQL Server, all I have learnt from my experience. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Hi Anita,
My office sent me on a 5 day course on SQL Server, but i have found i learnt a lot more using it that in the course. You can download the SQL Server 2005 June CTP for free off the microsoft website at the moment- get it and have a play!
Ben ‘I reject your reality and substitute my own’ – Adam Savage

Hi!
Anita.What I belive being a DBA is ongoing process.Administration needs practice and practice.I am sure if you stay in touch with this forum you will definitely get a lot of help.

Hi Anita, Its very much true that being a DBA is process where you need more and more practice and as you keep updating yrself will sure makes you good dba , and reading is also a very much important offcourse <a href=’www.niitnetvarsity.com’ target=’_blank’ title=’www.niitnetvarsity.com’>www.niitnetvarsity.com</a> is a very good site and their’s a section ‘expert answers’ in which you can questions to experts and ‘online test’ is also their… besides this you can learn for free from microsoft it-self. pease refer : <a href=’http://www.microsoft.com/technet/prodtechnol/sql/2005/learning/default.mspx’ target=’_blank’ title=’http://www.microsoft.com/technet/prodtechnol/sql/2005/learning/default.mspx'<a target="_blank" href=http://www.microsoft.com/technet/prodtechnol/sql/2005/learning/default.mspx>http://www.microsoft.com/technet/prodtechnol/sql/2005/learning/default.mspx</a></a> and dont forget to regular visit this forum ,its simply gr8 . [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] Regards. hsGoswami [email protected]

Hi Friends! Thanks a lot for all ur responses rgds
anita

]]>