x

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

avatar image

Cyborg
10.8k 37 55 51

(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, 2010 at 12:19 AM

avatar image

Matt Whitfield ♦♦
29.5k 62 66 88

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.

more ▼

answered Jul 12, 2010 at 03:03 AM

avatar image

John Sansom
897 2 4

(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, 2010 at 07:27 AM

avatar image

Grant Fritchey ♦♦
137k 20 43 81

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

more ▼

answered Jul 12, 2010 at 11:36 AM

avatar image

DaniSQL
4.9k 33 39 43

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 for a light-hearted list of things to avoid.

more ▼

answered Oct 13, 2010 at 02:20 AM

avatar image

GPO
4.8k 40 49 56

(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

SQL Server Central

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

Topics:

x117
x32

asked: Jul 11, 2010 at 11:31 PM

Seen: 2864 times

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

Copyright 2016 Redgate Software. Privacy Policy