Resource for new SQL Server DBA and beginners in SQL Server

"Give me some good resource that I can refer as new dba or beginner or new learner " this is the question asked by beginners and new learners in various forums I participate, thus I decide to post a blog referring the same, they are:

Here are some good resources for SQL Server beginners and new DBA(s)
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp
http://www.academictutorials.com/sql/
http://www.developer.com/db/article.php/718491

SQL Server Administration and best practice
http://vyaskn.tripod.com/sql_server_administration_best_practices.htm
http://vyaskn.tripod.com/sql_server_2000_fast_answers.htm
http://vyaskn.tripod.com/sql_enterprise_manager_or_t-sql.htm
http://www.sql-server-performance.com/self_taught_dba.asp

Also suggest to keep on reading and posting in technical websites/ web forums like
http://www.sql-server-performance.com/community/forum
http://forum.sqlknowledge.com/
http://www.sqlserver-qa.net/community/forum/
http://forums.microsoft.com/
http://www.experts-exchange.com/
http://www.sqljunkies.com/

Read More

DevCon - 2007 Organized by Pune User Group

Pune User Group has organized an event “DevCon “ in the month of August, the details and for Entry passes check your nearest location on website

http://devcon.puneusergroup.org/

Read More

Download System View Map for MS SQL Server 2005

Download the System View map for SQL Server 2005, this would definately helpfull to DBA(s).
http://download.microsoft.com/download/0/d/f/0dfe488e-a335-4480-8a8a-b405e32f4368/SQL2005_Sys_Views.pdf

Read More

Webcast on Reading Execution Plan and Query Tuning

http://www.microsoft.com/india/webcasts/default.aspx

Aug - 28th ; 14:00 - 15:30 IST

SQL Server 2005: Reading Execution Plans
The toughest part of analysis of any query is reading the execution plans. Many see this as the most difficult part, but this webcast removes this myth. We will walk you through the various operators and what they mean in the actual reading of the execution plan. There are some small changes made between SQL Server 2000 to SQL Server 2005 and we will take a quick at the same too.

Speaker: Vinod Kumar

Aug - 28th ; 14:00 - 15:30 IST

SQL Server 2005: Query Tuning
As part of application development everyone is faced with the need to tune their applications query. One aspect will be reading execution plans, but there are tons of other parameters that need attention to start the tuning exercise. This webcast takes a look at those parameters and the various tools and the tuning parameters we need to use with SQL Server 2005.

Speaker: Vinod Kumar

Read More