SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 I would like to learn ...
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

vabraham
Starting Member

13 Posts

Posted - 03/24/2004 :  12:42:47  Show Profile
Hi everyone,
I have used this forum to get answers to many of questions. i work trying to maintain, write, create tables, stored procedures, etc, but have never put a great amount of effort in trying to learn enough to help others and myself on the fly. I recently was trying to program a back up solution for a database and had taught myself to do a back up using the SQL Servers Maintenence Plan. I learnt from this forum that the better solution is to write the back up plan myself instead of usuing the wizard. I am here trying to answer the question, where do I start? anyhelp will be greatly appreciated.

thanks
abraham

tkizer
Almighty SQL Goddess

USA
37142 Posts

Posted - 03/24/2004 :  12:44:54  Show Profile  Visit tkizer's Homepage
Always start with SQL Server Books Online. No matter how much you know, you'll find yourself consulting BOL regularly.

Look up BACKUP DATABASE in BOL under the Index tab. Go to the Transact-SQL Reference for the Location.

Tara
Go to Top of Page

vabraham
Starting Member

13 Posts

Posted - 03/24/2004 :  12:48:39  Show Profile
Hi Tara,
I just put the discussion about Back ups as an example. In general, as a beginner would you suggest starting with BOL.

thanks
abraham
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37142 Posts

Posted - 03/24/2004 :  12:51:57  Show Profile  Visit tkizer's Homepage
Yes, always. BOL is the manual for SQL Server. There are several books that can be used to "fill in the blanks":

http://www.sqlteam.com/store.asp

Tara
Go to Top of Page

vabraham
Starting Member

13 Posts

Posted - 03/24/2004 :  12:54:07  Show Profile
Thanks Tara.
Go to Top of Page

AjarnMark
SQL Slashing Gunting Master

USA
3246 Posts

Posted - 03/24/2004 :  21:29:39  Show Profile  Visit AjarnMark's Homepage
I find BOL excellent for getting answers to specific questions such as "What is the syntax for..." or "What are the different Recovery Models". If you're looking for something more general, education-wise, then you might want to look for a training oriented book that will take you through specific guided tasks with explanations. Then you might find yourself filling in more details from BOL.

--------------------------------------------------------------
Find more words of wisdom at http://weblogs.sqlteam.com/markc
Go to Top of Page

Frank Kalis
Constraint Violating Yak Guru

Switzerland
413 Posts

Posted - 03/25/2004 :  03:31:32  Show Profile  Visit Frank Kalis's Homepage
quote:
Originally posted by vabraham

Hi everyone,
I have used this forum to get answers to many of questions. i work trying to maintain, write, create tables, stored procedures, etc, but have never put a great amount of effort in trying to learn enough to help others and myself on the fly.

To help others, there is nothing better than actually answering questions here on the fora. That will automatically let you flip through BOL or other stuff. Even if your answer is not completely correct, you will learn from being corrected and next time the same question comes up, you can reply with what you have learned.

Personally I think, there is absolutely no need to know everything right out of the head. Instead it's smarter to know where to look for answers. And honestly, I think in the end it boils down to a handful of place where to look for answers




--Frank
http://www.insidesql.de
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.16 seconds. Powered By: Snitz Forums 2000