| Author |
Topic  |
|
|
vabraham
Starting Member
13 Posts |
Posted - 03/24/2004 : 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
USA
35007 Posts |
Posted - 03/24/2004 : 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 |
 |
|
|
vabraham
Starting Member
13 Posts |
Posted - 03/24/2004 : 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 |
 |
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
Posted - 03/24/2004 : 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 |
 |
|
|
vabraham
Starting Member
13 Posts |
Posted - 03/24/2004 : 12:54:07
|
Thanks Tara.
|
 |
|
|
AjarnMark
SQL Slashing Gunting Master
USA
3246 Posts |
Posted - 03/24/2004 : 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 http://weblogs.sqlteam.com/markc |
 |
|
|
Frank Kalis
Constraint Violating Yak Guru
Switzerland
413 Posts |
Posted - 03/25/2004 : 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 |
 |
|
| |
Topic  |
|