x
login about faq Site discussion (meta-askssc)

Newbie DBA - Best Practices

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

more ▼

asked Jul 11 '10 at 11:31 PM in Default

Cyborg gravatar image

Cyborg
10.1k 29 39 44

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

7 answers: sort voted first

Try looking here, here and here.

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

more ▼

answered Jul 12 '10 at 12:19 AM

Matt Whitfield gravatar image

Matt Whitfield ♦♦
29.2k 56 63 87

Yup - a wealth of information on this site is only a SEARCH away.

Jul 12 '10 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.

more ▼

answered Jul 12 '10 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. 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.

more ▼

answered Jul 12 '10 at 07:27 AM

Grant Fritchey gravatar image

Grant Fritchey ♦♦
62.1k 12 19 66

+1 - and hope you don't mind that I linkified your links :)

Jul 12 '10 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 '10 at 08:08 AM Grant Fritchey ♦♦

@Grant Not showing up in IE 7 for me either - switched to FireFox.

Jul 12 '10 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 '10 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 '10 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. Also hangout with the community in forums, usergroups and keep learning!!

more ▼

answered Jul 12 '10 at 11:36 AM

DaniSQL gravatar image

DaniSQL
4.8k 30 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 '10 at 11:39 AM Grant Fritchey ♦♦
(comments are locked)
10|1200 characters needed characters left
more ▼

answered Oct 29 '10 at 01:43 PM

Håkan Winther gravatar image

Håkan Winther
15k 29 35 46

(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.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments



Facebook logo Follow Ask SSC on Facebook
Find Ask SSC on Google+
linkedin logo Find us on LinkedIn

Topics:

x66
x30

asked: Jul 11 '10 at 11:31 PM

Seen: 1497 times

Last Updated: Jul 12 '10 at 09:17 AM

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.