Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 I would like to learn ...

Author  Topic 

vabraham
Starting Member

13 Posts

Posted - 2004-03-24 : 12:42:47
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

38200 Posts

Posted - 2004-03-24 : 12:44:54
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 - 2004-03-24 : 12:48:39
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

38200 Posts

Posted - 2004-03-24 : 12:51:57
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 - 2004-03-24 : 12:54:07
Thanks Tara.
Go to Top of Page

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2004-03-24 : 21:29:39
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 [url]http://weblogs.sqlteam.com/markc[/url]
Go to Top of Page

Frank Kalis
Constraint Violating Yak Guru

413 Posts

Posted - 2004-03-25 : 03:31:32
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
   

- Advertisement -