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)
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='' />]<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 />Ich unterstütze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>) <br />
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
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='' />]<br /><br />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.<br /><br />Become a DBA? Administrative or developing one?<br />Maybe these give you an idea:<br /<a target="_blank" href=http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_id_com_admn2.asp>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_id_com_admn2.asp</a><br /<a target="_blank" href=http://vyaskn.tripod.com/sql_server_administration_best_practices.htm>http://vyaskn.tripod.com/sql_server_administration_best_practices.htm</a><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 />Ich unterstütze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>) <br />
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='' />]<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 />Ich unterstütze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>) <br />
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,<br />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 <b><a href='www.niitnetvarsity.com' target='_blank' title='www.niitnetvarsity.com'>www.niitnetvarsity.com</a></b> 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... <br />besides this you can learn for free from microsoft it-self. pease refer :<br /><br /><b><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></b><br /><br />and dont forget to regular visit this forum ,its simply gr8 .<br /><br />[<img src='/community/emoticons/emotion-1.gif' alt='' />]<br />Regards.<br /><br /><br />hsGoswami<br />ghemant@gmail.com
