Newbie DBA - Best Practices

What are the best practices for a Newbie SQL Server DBA?
more ▼

asked Jul 11, 2010 at 11:31 PM in Default

Cyborg gravatar image

10.6k 36 40 45

(comments are locked)
10|1200 characters needed characters left

7 answers: sort voted first

Try looking here, here and [here][3].

These are all similar questions which really cover what you're asking entirely...

[3]: http://ask.sqlservercentral.com/questions/1467/advice-for-new-dba
more ▼

answered Jul 12, 2010 at 12:19 AM

Matt Whitfield gravatar image

Matt Whitfield ♦♦
29.5k 61 65 87

Yup - a wealth of information on this site is only a SEARCH away.
Jul 12, 2010 at 06:02 AM Blackhawk-17
(comments are locked)
10|1200 characters needed characters left

WARNING: Totally shameless plug follows for some of my content that I am certain you will find useful.

You may also be interested to learn of the soft skills that are useful to a DBA.

[5]: http://www.johnsansom.com/index.php/2009/10/blog-your-way-to-becoming-a-better-dba/
more ▼

answered Jul 12, 2010 at 03:03 AM

John Sansom gravatar image

John Sansom
897 2

(comments are locked)
10|1200 characters needed characters left

I would strongly recommend several books. First, and most important, is Craig Mullins book, Database Administration. This is a fantastic walk-through of the job of being a DBA. It's completely technology agnostic, so it's useful for any DBA or data oriented worker. Second, Itzik Ben-Gan's T-SQL Fundamentals. You're going to be hard pressed to find a better introduction to SQL Server and how to do set-based programming. Finally, I have to recommend a book that I wrote a couple of chapters for, [Beginning SQL Server Administration][3]. It's a good overview of how to do the most important parts of the DBA's job.

With those, you'll learn a pretty healthy chunk of what you need to know.

[3]: http://www.amazon.com/Beginning-SQL-Server-2008-Administration/dp/1430224134/ref=sr_1_5?ie=UTF8&s=books&qid=1278944589&sr=8-5
more ▼

answered Jul 12, 2010 at 07:27 AM

Grant Fritchey gravatar image

Grant Fritchey ♦♦
103k 19 21 74

+1 - and hope you don't mind that I linkified your links :)
Jul 12, 2010 at 07:52 AM Matt Whitfield ♦♦
No, that's fine. How the heck do you do that? I never get a tool box on the editor like I used to, or I can't see where it is.
Jul 12, 2010 at 08:08 AM Grant Fritchey ♦♦
@Grant Not showing up in IE 7 for me either - switched to FireFox.
Jul 12, 2010 at 10:25 AM Blackhawk-17
Not an option at work. So there is supposed to be a toolbox... well, that's something.
Jul 12, 2010 at 10:27 AM Grant Fritchey ♦♦
Oh really? Crazy - I use chrome... Just tested it using IE7 mode in IE8 and yeah - it's totally not there. I have raised it on meta.OSQA http://meta.osqa.net/questions/3748/answer-toolbar-doesnt-show-in-ie7
Jul 12, 2010 at 12:17 PM Matt Whitfield ♦♦
(comments are locked)
10|1200 characters needed characters left

Almost all best practices are listed in this artice [Best Practices for Becoming an Exceptional SQL Server DBA][1]. Also hangout with the community in forums, usergroups and keep learning!!

[1]: http://www.simple-talk.com/sql/database-administration/brads-sure-dba-checklist/
more ▼

answered Jul 12, 2010 at 11:36 AM

DaniSQL gravatar image

4.9k 33 35 39

Oooh, yeah, I always forget about Brad's book since I gave away my last copy. Need to get another one so I can remember to mention it.
Jul 12, 2010 at 11:39 AM Grant Fritchey ♦♦
(comments are locked)
10|1200 characters needed characters left

Also check [here][1] for a light-hearted list of things to avoid.

[1]: http://ask.sqlservercentral.com/questions/17073/sql-practises-that-iterate-er-irritate-you
more ▼

answered Oct 13, 2010 at 02:20 AM

GPO gravatar image

2.9k 35 38 42

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jul 11, 2010 at 11:31 PM

Seen: 2492 times

Last Updated: Jul 12, 2010 at 09:17 AM