Beginning Administration

Question

Beginning Administration

Steve Jones - SSC Editor

SSC Guru

Points: 736188
More actions
June 11, 2004 at 10:23 am

#163892

The first in a series on basic administration of SQL Server servers and databases.
http://www.sqlservercentral.com/columnists/sjones/beginningsqlserver2000administrationpart1.asp
June 14, 2004 at 8:00 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 36 total)

You must be logged in to reply to this topic. Login to reply

MVDBA (Mike Vessey) SSC-Insane Points: 21797 More actions · Answer 1

if anyone has any requests for tutorials on specific matters, we are preparing some material for new SQL DBAs and Oracle DBAs making the transition.

we would be happy to post these here.

MVDBA

Bill Hazelwood SSC Veteran Points: 266 More actions · Answer 2

How about a Security overview and best practice (local logins vs. domain accounts).

How about day to day maintenance and backup plans. What are the necessary jobs that all DBA's should do daily, weekly, monthly.

Thank-you
Iceman
No trees were harmed in the sending of this message, however a large number of electrons were terribly inconvenienced.

MVDBA (Mike Vessey) SSC-Insane Points: 21797 More actions · Answer 3

i think we can manage that.

watch this space in the next few days.

MVDBA

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

Articles on managing a data warehouse would be greatly appreciated.

Specifically any differences between managing a data warehouse as opposed to managing an OLTP system

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Frank Kalis SSC Guru Points: 111183 More actions · Answer 5

Michael,

have I missed something? Any news on this?

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

JGonzales SSC Rookie Points: 33 More actions · Answer 6

TTT

I have been "blessed" as my companies SQL dba and I need some good starting guides.

Scott lancaster SSC Enthusiast Points: 162 More actions · Answer 7

I would be interested in anything you guys can give me on managing all of the above..

Ill keep checking this space..

Scotty

Scott lancaster SSC Enthusiast Points: 162 More actions · Answer 8

I would be interested in anything you guys can give me on managing all of the above..

Ill keep checking this space..

Scotty

Courtney Rabuffo SSC Journeyman Points: 80 More actions · Answer 9

I would definitely be interested in getting some basic information on SQL admin duties. Specifically maintenance plans, security, & optimization.

ckentebe SSC Journeyman Points: 87 More actions · Answer 10

I am definitely interested in the Security and Administration duties of a MS2000 DBA.

Christopher B. Kentebe
B.S.E.E., O.C.P.
Microsoft SQL Server2000 DBA
Phone : (416) 338-1274
Fax : (416) 696-3765
Email: ckentebe@toronto.ca

LN-202212 SSChasing Mays Points: 645 More actions · Answer 11

This should help set something up. This article provides some structure. Hope it helps.

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops4.mspx#ECAA

Phil Henry Mr or Mrs. 500 Points: 528 More actions · Answer 12

Im administrator of an MIS that uses SQL 2000 - and while I can find my way around the db, create backups, use dts, and write Crystal Reports from the data - I find it difficult to understand how to create views ( so that my Crystal Report can report from the view rather than a group of tables.)

eg: I failed miserably at replication ( so I took my ball home and refused to play anymore!)

Im also at a total loss to understand 'joins' - the concept, how they work/how to use them etc etc

Any Steve Jones style prompt sheets would be greatfully appreciated

David Thayer SSChasing Mays Points: 612 More actions · Answer 13

The first thing a good dba should do, coming into an existing environment, is to put together a backup scheme. Typically, a full backup once a week, and transaction logs more often (depending on how your organization would view data loss in a DR scenario). Secondly, maintenance plans, DBCC checks, reindexing, etc. Some good ones to check out are DBCC CheckDB, DBCC Reindex, DBCC IndexDefrag, DBCC ShowContig. Some of these are very intrusive and should be done off-hours. Capacity planning is also important. Monitor your db sizes and keep tabs on it. Once you have all of these automated, then you can start getting your hands dirty with performance tuning at the query level, DTS, Replication.

Getting back to backups, be sure to test your backups on a regular basis.