June 5, 2009 at 4:33 am
hello every body im a beginner in sql server 2005 please tell me how i can develope my knowledge in this...:(
Regards,
Seetha
June 5, 2009 at 6:54 am
I'd suggest books. First off, all the Inside SQL Server 2005 (or 2008) books are worth reading. Ross Mistry's book on 2008 Administration is good. Joe Sack's book on Transact-SQL Recipes is pretty handy too.
Second resource, this place. Read the questions & answers. Try answering the questions. Use the Books Online (SQL Server documentation, referred to as BOL) because most people who post here can't seem to find the BOL or look things up in it. If you learn how to use the BOL, you'll be the sighted person in the land of the blind.
Third resource, find a local users group. Most of the good ones are PASS Chapters, so hitting the SQL Pass web site (www.sqlpass.org) would be the best bet. You'll be able to watch presentations on various topics and network with others.
Finally, go back to the PASS web site again and look through the material there. There are lots of good resources to point you to other resources for learning such as Top 10 lists, community lists, articles in the SIG areas.
That ought to keep you busy.
"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
June 6, 2009 at 3:48 am
I agree with Grant.
Also, get yourself a copy of Express and play about with that as well. Can't beat hands on learning!
June 6, 2009 at 11:41 pm
I agree with Grant and Clive, with one exception. If you really want to get down and dirty with SQL Server, spend the approximately $50.00 USD and get the Developers Edition of SQL Server. This will get you everything that is available in the Enterprise Edition and allow you to learn and play with all the available features in SQL Server 2005 or SQL Server 2008.
June 7, 2009 at 5:13 am
I agree with Clive and Lynn, especially Lynn. If you're really planning on making a career out of SQL Server, $50 for the developer's edition, which has everything, is a very small price to pay.
"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
June 7, 2009 at 5:22 am
Is this an agreement party? 😉
One other book I'd recommend, more for development than admin. T-SQL Fundamentals by Itzik Ben-Gan. It's written for SQL 2008, not 2005, but they are not all that different. You'll just have to be aware what features were introduced in 2008. Most of the book though is applicable for both.
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
June 8, 2009 at 1:00 am
Thanks for ur reply!!!!
June 8, 2009 at 2:24 am
You have taken the right step by joining SQLSERVERCENTRAL.COM
Now that you are in the right hands stick with us.
Find the attached you might find it useful.
Tanx 😀
June 9, 2009 at 4:35 am
You can also use the Evaluation Edition of SQL Server 2005/2008 for Free.
Microsoft is offering this evaluation copy for 180 days. I think within that period, you will learn how to start using SQL Server.
Check the Technet (technet.microsoft.com) site, and go to Evaluation Software....
Also search in e-snips website, you will find some valuable resources in that as well.
Welcome to SQL family...:-):-)
Thanks & Regards,
Sudeepta.
http://twitter.com/skganguly
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply