|
|
|
Document Management Features for 2003
Document Management Features and Capabilities to make quick and easy access to information at your fingertips right from your PC or network!
Document Management Features for 2003 No name brands or ads are mentioned
I am excited to...
How Multiple Server Hosting impacts your web site's uptime
How Multiple Server Hosting impacts your website's uptime by: Godfrey E. Heron This article describes the technology behind multiple server hosting and how you may utilize it to maximize your site's security and uptime. Hosting of websites has...
Need a Copy of Your Tax Return Information?
Taxpayers have two easy and convenient options for getting copies of their federal tax return information — tax return transcripts and tax account transcripts — by phone or by mail. A tax return transcript shows most line items from the tax return...
Recognizing a PC with Malware
What can you do if you think your computer is affected by spyware or a virus or other malware? (Malware is short for malicious
software.) First let me assure you that you aren't in this alone. There are excellent resources and community sites...
The Google Patent Reveals The Secret To Great Site Ranking
How many years did you register your domain name for?
If it was only one then Google could hold that against you.
Why?
Because the majority of Spam websites only register a domain name for one year. A domain name registered for a longer period...
|
|
| |
|
|
|
|
|
|
The Seven Deadly Habits of a DBA... and how to cure them
Calling widespread bad habits in database administration "deadly" may seem extreme. However, when you consider the critical nature of most data, and just how damaging data loss or corruption can be to a corporation, "deadly" seems pretty dead-on.
Although these habits are distressingly common among DBAs, they are curable with some shrewd management intervention. What follows is a list of the seven habits we consider the deadliest, along with some ideas on how to eliminate them.
Habit #1. THE LEAP OF FAITH: "We have faith in our backup."
Blind faith can be endearing, but not when it comes backing up a database. Backups should be trusted only as far as they have been tested and verified.
Cures:
Have your DBAs verify that the backup is succeeding regularly, preferably using a script that notifies them if there's an issue.
Maintain a backup to your backup. DBAs should always use at least two backup methods. A common technique is to use those old-fashioned exports as a backup to the online backups.
Resource test recoveries as often as is practical. An early sign that your DBA team is either overworked or not prioritizing correctly is having a quarter go by without a test recovery. Test recoveries confirm that your backup strategy is on track, while allowing your team to practice recovery activities so they can handle them effectively when the time comes.
Habit #2. GREAT EXPECTATIONS: "It will work the way we expect it to. Let's go ahead."
Although not user friendly in the traditional sense, Oracle is very power-user friendly— once you've been working with it for a while, you develop an instinct for the way things "should" work. Although that instinct is often right, one of the most dangerous habits any DBA can possess is an assumption that Oracle will "just work" the way it should.
Cures:
Inculcate a "practice, practice, practice" mentality throughout the organization. DBAs need to rehearse activities in the safe sandbox of a test environment that's designed to closely mimic the behaviour of the production system. The organization needs to allow the time and money for them to do so.
Pair inexperienced DBAs with senior ones whenever possible—or take them under your own wing. New DBAs tend to be fearless, but learning from someone else's experience can help instill some much needed paranoia.
Review the plans for everything. It's amazing how often DBAs say, "I've done that a hundred times, I don't need a plan." If they're heading into execution mode, they absolutely need a plan.
Habit #3. LAISSEZ-FAIRE ADMINISTRATION: "We don't need to monitor the system. The users always let us know when something's wrong."
If you depend on the users to inform the DBA team that there's a problem, it may already be too late.
Cures:
Install availability and performance monitoring systems so that issues are identified and resolved before they cause service-affecting failures.
Avoid post-release software issues by working with developers and testers to ensure that all production-ready software is stable and high-performance.
Habit #4. THE MEMORY TEST: "We'll remember how this happened, and what we did to get things going again."
It may seem impossible that a DBA team would forget a massive procedure that took them weeks to get right, and yet it happens all the time. In order to prevent recurring mistakes and take advantage of gained experience, documentation is essential.
Cures:
Require that your DBAs maintain a comprehensive documentation library and activity diary, including a significant level of rationale, syntax, and workflow detail.
Provide your team with groupware on your intranet so that these documents become searchable in an emergency.
Enforce the discipline of documentation and check it periodically.
Ask your DBAs: When was this tablespace created, by whom, and with what SQL? What tasks were performed on a particular day? If they can't answer quickly, you'll know they've gone back to relying on memory.
Habit #5. THE BLAME GAME: "Don't look at me, it's the developer's fault that SQL is in production"
Some DBAs have a real "us versus them" mentality when it comes to developers in their organization. They see themselves not as facilitators helping the developers develop quality code from a database standpoint, but rather as guardians who prevent poor-quality code from making it into production. This might seem like semantics, but a confrontational relationship between developers and DBAs results in a lack of developer initiative and significant slowdowns in release cycles.
Cures:
Select DBAs who understand it's their responsibility to work as an integrated team with the developers they support.
Cultivate a team attitude by structuring continuous DBA involvement in every project rather than at review milestones.
Consider assigning an individual DBA in a developer support role. If it's clearly in the job description, there's more motivation to do it well.
Habit #6. THE SOLO ACT: "I know what I'm doing and don't need any help."
Database administration is increasingly complex and even the most senior DBAs can't possibly know every last detail. DBAs have different specialties, which need to be culled and utilized. When DBAs feel like they know, or should know, everything, they don't ask questions and miss out on valuable knowledge they could be gaining from others.
Cures:
Foster a teamwork culture where it's acceptable for DBAs to admit they don't know the answer and to ask for help.
Encourage your DBAs to seek out an outside peer group as a forum for brainstorming and testing their assumptions. No single person can match the expertise and experience of even a relatively small group.
Provide a safety net of tech resources such as reference materials, courses, and outside experts or consultants on call.
Habit #7. TECHNO-LUST: "Things would work so much better if only we had..."
DBAs are often on top of the latest technology, which can help them do a superlative job. But when the desire for new technology causes DBAs to recommend unnecessary hardware purchases or software add-ons, costs tend to skyrocket quickly—as do problems.
Cures:
Never upgrade your hardware infrastructure without first exhausting all tuning opportunities. Remember, ten years ago enormous enterprises were run on servers one-tenth the capacity—all thanks to necessity and skill.
Never consent to using advanced or new features until you're well aware of the ongoing maintenance commitment and resulting costs.
Watch out for DBA support software that presents friendly GUI interfaces for difficult tasks. This type of interface allows a beginner DBA to act as an intermediate DBA under certain circumstances, but simultaneously prevents that beginner from learning the actual skills behind the tasks. Moreover, these tools tend to hide real risks from the DBA, making potentially damaging activities as easy as point-and-click.
Whether it takes a twelve-step program or one tiny adjustment, all of these deadly DBA habits can be kicked. Of course, the first step is recognizing the problem. By starting with this list and doing a careful inventory of the successes and failures in your team's database administration, you'll be well on your way to finding a cure.
About the Author
Since the company's founding Paul has been Pythian's key trouble-shooter for our toughest technical challenges. Before launching Pythian, he worked as an Oracle consultant bringing his vast expertise to various companies across North America.
|
|
|
|
|
| Data Recovery Software and Undelete from R-TT |
| Disk management software including utilities for data recovery, drive imaging, disk wiping and access control. |
| www.r-tt.com |
|
| Data Recovery | Email Data Recovery by Ontrack |
| Data recovery services, data recovery software, file repair software, and diagnostic software from Ontrack. Software for email recovery, file recovery and ... |
| www.ontrack.com |
|
| Data Recovery by DriveSavers | Hard Drive Data Recovery |
| Worldwide data recovery service for all operating systems and storage media. Authorized by all drive manufacturers. |
| www.drivesavers.com |
|
| Hard Drive Data Recovery Software Tools, Disk Recovery Utilities ... |
| Offers data recovery software,data recovery services for hard drive recovery and data safety software services for your computer. Buy award winning data ... |
| www.stellarinfo.com |
|
| Data Recovery by FADV – Hard Drive, RAID, Tape, Database and more ... |
| Offers data recovery services for all hard drive models. RAID, MS SQL, Exchange, Tapes, Camera and USB media, CD and DVD. Service available 24/7. |
| www.datarecovery.net |
|
| Data Recovery Software - File System Utilities |
| Data recovery software for all Windows file systems. Recover deleted files, corrupted hard drives, and partitions. |
| www.runtime.org |
|
| Professional Data Recovery Software from Bitmart. File Recovery ... |
| Data Recovery Software Restorer2000. Undelete & File Recovery utility for FAT and NTFS file systems. Data Recovery from damaged disks and partitions. |
| www.bitmart.net |
|
| Data Recovery Services - ActionFront - Critical Server Data Recovery |
| ISO certified data recovery services with labs in Atlanta, Santa Clara, Dallas, Chicago, Toronto (also Buffalo and Tokyo Japan) |
| www.actionfront.com |
|
| Hard Drive Data Recovery Software: Recover Deleted Files- Recover ... |
| Data recovery software for recovering files that have been deleted or lost due to the hard drive format, virus infection, unexpected system shutdown or ... |
| www.recovermyfiles.com |
|
| Data Recovery Group - Hard Drive Data Recovery Services |
| Data Recovery is Our Only Business! Data Recovery Group's a complete data recovery service that specializes in recovering data from hard disk drives. |
| www.datarecoverygroup.com |
|
| Data Recovery by CBL: Hard Drive Recovery Services |
| Worldwide Data Recovery Services at CBL. Specializing in data recovery, hard drive recovery, hard disk drive recovery and RAID data recovery. |
| www.cbltech.com |
|
| Data Recovery Software, File Repair Utilities, Hard Disk Recovery ... |
| Hard drive data recovery software to perform data recovery & recover deleted files from Novell, Linux, Unix, Mac, Windows & data recovery services for hard ... |
| www.nucleustechnologies.com |
|
| AT&DR: Data Recovery and Liabillity |
| Associated Technologies offers complete data recovery solutions with services for any type of data storage device, including the following: hard drives, ... |
| www.datarecovery.com |
|
| Ontrack UK - Data recovery services & recovery software - hard ... |
| Ontrack offers data recovery services & software for: hard drive recovery, file recovery, server recovery, email recovery, tape recovery, RAID recovery. |
| www.ontrack.co.uk |
|
| Beginners Guides: Hard Drive Data Recovery - PCSTATS.com |
| Beginners Guides: Hard Drive Data Recovery - PCSTATS.com. |
| www.pcstats.com |
|
| File Recovery and Data Recovery Software. Hard Drive recovery utility |
| Data recovery software for FAT, NTFS, Ext2FS file systems. File recovery after FDISK, MBR destruction, FAT damaged, virus infection. Dynamic disk support. |
| www.data-recovery-software.net |
|
| Data recovery - Wikipedia, the free encyclopedia |
| Data recovery is the process of salvaging data from damaged, failed, ... Although there is some confusion as to the term, data recovery can also be the ... |
| en.wikipedia.org |
|
| Active@ UNDELETE Data Recovery. Recover Deleted Files. Windows XP ... |
| Active@ UNDELETE - Data Recovery Software for all Windows File Systems. Recover deleted files from lost, damaged, formatted or reformatted partitions. |
| www.active-undelete.com |
|
| New Zealand Data Recovery & Computer Forensics Experts |
| New Zealand data recovery specialists & computer forensics investigation experts. Recovering lost data for businesses or legal evidence is all we do. |
| www.datarecovery.co.nz |
|
| Canada Data Recovery Services: Hard Disk Drive Recovery, Raid Data ... |
| Provides data recovery solutions for companies experiencing data loss from failed hard drives, raid arrays, and server systems. |
| www.datarecovery.ca |
|
|