The Most Important SQL DBA Areas

Question

The Most Important SQL DBA Areas

Viewing 6 posts - 16 through 20 (of 20 total)

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

Robinson SSCrazy Points: 2194 More actions · Answer 1

Above, Carl gave us an example of simulating a particular kind of corruption to practice recovering from it. Are there other simulations that you guys run through to help keep you prepared?

Good example Carl.

Thx,

Rob

Carl Federl One Orange Chip Points: 25384 More actions · Answer 2

The only other example that I have is when one drive of a RAID array goes bad and the hardware operator pulls a good drive instead of the bad drive, which causes the entire RAID to go down.

The first time I encountered this human error, only the C drive was affected, so that was handled by the Windows Admins.

The second time was on a SAN but I was out of the country on vacation, so I did not need to perform this recovery.

This senario shows the critical importance of keeping database backups on different disks/SANS than the live database files.

SQL = Scarcely Qualifies as a Language

Grant Fritchey SSC Guru Points: 398909 More actions · Answer 3

There was a session at PASS last year that showed how to make low level manipulations to the system to simulate data corruption, etc. It was pretty scary stuff, but really interesting. I forget the presenters name though.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Loner SSC-Insane Points: 21279 More actions · Answer 4

Maybe I work with data warehouse. I think learning business intelligence (data warehouse) is necessary.

matt stockham SSCrazy Eights Points: 9942 More actions · Answer 5

Every case, and business, will differ to some extent but the common items mentioned above (backups, restore, monitoring, security etc) will apply to EVERY database so I would consider them to be basic required knowledge.

A lot of people dismiss the MS exams but I would say that they give you a good grounding in pretty much everything mentioned here, albeit not in huge detail (in some cases).

Robinson SSCrazy Points: 2194 More actions · Answer 6

the common items mentioned above (backups, restore, monitoring, security etc) will apply to EVERY database so I would consider them to be basic required knowledge.

That's a great way of putting it: what are the common areas that apply to EVERY database, no matter where you go. Thx.