«Home

What Kind Of DBA (Database Administrator) Are You?

Hi guys. i am new in tis house and would love to contribute . ave read a lots of posts here i mean great topics which i gained from.

i am trying to take a survey among the DBAs in the house.

Please DBAs i need your response.

Are you a nut-n-bolt dba or a props-n-tool dba?

Respnse needed.

Avatar
Newbie
29 answers

how would you feel if someone uses your work without your permission or including any information that you are the person that did it be it name email or web address.

Well give me some of your work and let me distribute it as mine with my name, email

0
Avatar
Newbie

what ever man mine, theirs, yours, hers, his, HANG YOURSELF IF IT DISTURBDS YOU SO MUCH,

0
Avatar
Newbie

not yours, never yours, never will be yours nor your friend's it is their. this is all about netiquette. go figure

0
Avatar
Newbie

@catus

mine or their or yours doesn't really matter, it's information and it'smeant to be passed on ok, beside i got it from a friend who uploaded them so pls if you don't need it then i think there are others who might.so stop stressing ok and live you life lol.

0
Avatar
Newbie

@ larryoncol why would you copy someone else blogpost and post it as yours this is not cool men. Give credit to whom credit is due.

I am not sure if this is the original post but a copy of this same post made by larryoncol can be seen here with deleted paragraphs

http://cahock.wordpress.com/2007/05/23/microsoft-office-2007-enterprise-blue-edition/

I spit on people who plagiarize. WHAT A SHAME

0
Avatar
Newbie

am sure you guys wondering what office 2007 is like, for those of you who ain't seen it here, well thats gona be a thing of the past because you can download it from this link. and this is the blue edition

There's quite a big chance that you've never heard of this 'Blue Edition', because - as the NFO says - it is only available to equipment manufacturers and not to the general public. This is the copy from the original disk, which is (as said before) only accessible to technicians of Microsoft. This version of Microsoft Office 2007 will never appear for sale, since this is the only version where there is no need for a serial. This version also doesn't need an activation. The installer is very simple, undetailed and handy. The interface of application is completely changed, it is modernized and practically reminds in no way to the previous versions.In a few minutes the software will be installed on your computer, without any questions or other things that slow down the installation.

Office Enterprise 2007 is the most complete Microsoft toolset provided for people who must collaborate with others and work with information efficiently, regardless of location or network status. Office Enterprise 2007 builds on the strengths of Microsoft Office Professional Plus 2007, adding Microsoft Office Groove 2007 and Microsoft Office OneNote 2007, enabling people to collaborate and create, manage, and use information more efficiently.

This collection includes:

* Access 2007

* Excel 2007

* Groove 2007

* InfoPath 2007

* OneNote 2007

* Outlook 2007

* PowerPoint 2007

* Publisher 2007

* Word 2007

All programs can be installed on Windows XP and Vista.

Release Name: Microsoft.Office.2007.Enterprise.Blue.Edition-DiGiTAL

Size: 563MB

[hide_me]

http://rapidshare.com/files/36887336/MS_OF, tilan.part1.rar

http://rapidshare.com/files/36900288/MS_OF, tilan.part2.rar

http://rapidshare.com/files/37110582/MS_OF, tilan.part3.rar

http://rapidshare.com/files/37125305/MS_OF, tilan.part4.rar

http://rapidshare.com/files/37148280/MS_OF, tilan.part5.rar

http://rapidshare.com/files/37264717/MS_OF, tilan.part6.rar

[/hide_me]

RAR Password = pastilan

0
Avatar
Newbie

this is the link to download fedora core 6,you also have to get a FTp client in other to download.

ftp://ftp.is.co.za/linux/distributions/fedora/linux/core/6/i386/iso/FC-6-i386-DVD.iso

0
Avatar
Newbie

By the way for those of you who are intersted in running oracle on other operating systems i have some unix OS that you can install. ubuntu, fedora core

these are the links for ubuntu downloads it's going to take time depending on the speed of your connection, for 100mbps it can take about 2 to 3 hours and make sure you use a download manger incase the link flaps.

Ubuntu is a complete Linux-based operating system, freely available with both community and professional support. It is developed by a large community and we invite you to participate too!

The Ubuntu community is built on the ideas enshrined in the Ubuntu Philosophy: that software should be available free of charge, that software tools should be usable by people in their local language and despite any disabilities, and that people should have the freedom to customise and alter their software in whatever way they see fit.

These freedoms make Ubuntu fundamentally different from traditional proprietary software: not only are the tools you need available free of charge, you have the right to modify your software until it works the way you want it to.

The team behind Ubuntu makes the following public commitment to its users:

Ubuntu will always be free of charge, and there is no extra fee for the "enterprise edition", we make our very best work available to everyone on the same Free terms.

Ubuntu comes with full commercial support from hundreds of companies around the world. Ubuntu is released regularly and predictably; a new release is made every six months. Each release is supported with free security updates and fixes for at least 18 months.

Ubuntu will include the very best in translations and accessibility infrastructure that the Free Software community has to offer, to make Ubuntu usable by as many people as possible. We collaborate as widely as possible on bug fixing and code sharing.

Ubuntu is entirely committed to the principles of free software development; we encourage people to use free and open source software, improve it and pass it on.

Ubuntu is suitable for both desktop and server use. The current Ubuntu release supports PC (Intel x86), 64-bit PC (AMD64) and PowerPC (Apple iBook and Powerbook, G4 and G5) architectures.

Ubuntu includes more than 16,000 pieces of software, but the core desktop installation fits on a single CD. Ubuntu covers every standard desktop application from word processing and spreadsheet applications to internet access applications, web server software, email software, programming languages and tools and of course several games.

info:

http://www.ubuntu.com/

640MB

------------Install CD---------------

PC (Intel x86) install CD

http://releases.ubuntu.com/5.10/ubuntu-5.10-install-i386.iso

Mac (PowerPC) install CD

http://releases.ubuntu.com/5.10/ubuntu-5.1, all-powerpc.iso

64-bit PC (AMD64) install CD

http://releases.ubuntu.com/5.10/ubuntu-5.1, stall-amd64.iso

-----------Live CD-------------------

PC (Intel x86) live CD

http://releases.ubuntu.com/5.10/ubuntu-5.10-live-i386.iso

Mac (PowerPC) live CD

http://releases.ubuntu.com/5.10/ubuntu-5.10-live-powerpc.iso

64-bit PC (AMD64) live CD

http://releases.ubuntu.com/5.10/ubuntu-5.10-live-amd64.iso

0
Avatar
Newbie

Yeah, definately. administering a database is the major role of a dba, GUI or CLI who cares. but there are ksituations where by you have to use your CLI, e.g you want to implement a complex resource plan, or a special of backup. we all know that the GUI is not the guy for this, but for daily managment and administration it's advisable to use your GUI it makes management more precise, faster and easy.

the fact is that even as a DBA you get to learn alot of this as you administer a database. oracle is wide.

0
Avatar
Newbie

I'm not a DBA however if we assume that the prime objective of the DBA is to ensure the database is running at optimum performance at all times, then surely the critical factor is the speed with which you execute tasks and/or foresee problems and solve them to that extent whether you use a GUI to achieve that or not is purely academic.  Your employer will be happy if the database has high availability and doesn't really care whether or not you know all the system commands from memory as in the unlikely event that you don't know a command and the GUI you are using cannot help, there are a vast umber of resources on the internet where you can look it up.

Imagine for example that you have a large database and you want to monitor it's performance (i.e. Number of connections, CPU usage, Cache hits etc.), surely this type of data is easier to view as a series of graphs and/or bar charts in a GUI rather than rows and columns of figures in the CLI. I would argue that using a GUI in this instance will make you more efficient and less likely to make errors and in no way constitutes a softer option as it’s still your responsibility to set performance parameters correctly.

To give another example, surely it's easier to write/read Oracle PL/SQL in a GUI with colour coded syntax highlighting not to mention the ease of debugging where you can insert breaks, view the value of variables etc.  I would imagine that in most cases, stored procedures, triggers, views etc. can be developed much quicker and are less error prone using a GUI then the CLI because for example you don't have to remember the exact spelling of every table and column as you can just pick what you need from a list.

Having said that, there may well be circumstances where it's quicker and easier to use the CLI and there is of course no harm in knowing how to use it effectively however this does not in my view automatically give you more control over the database than a DBA who is more reliant on GUIs.

0
Avatar
Newbie

this is all crap, a dba is a dba it just depends on the platform they work on, oracle, microsoft etc. all these crap about nuts and bolt etc its all big time BS.

As long as you get the task done. who cares how you achieve it. Well, in IT it is a common thing to give acronyms or different categories to things just to make it looks special or something crazy.

It doesnt matter, it is irrelevant. a true dba should also be able to navigate by writing codes or scripts in addition to using GUI tools

The truth is if all db systems only function using a command line interface, ah ah many people will be out of jobs. It just depends on personal preference as to how you want to go about doing things

It is so annoying just to see people trying to add efezi. No efezi can be added to a dba's job description.

A DBA IS A DBA ONLY PLATFORMS OF OPERATION DIFFER

0
Avatar
Newbie

If interviewer ask, Are you a nuts-n-bolts DBA or a tools-n-props DBA ?

{I would explain myself as a combination of the two.} I, having been in the business for over 6 years, have grown up in a command line era where the GUIs never seemed to work. There was high complexity in systems and not much good documentation on how things worked. Thus, I had to learn everything about most aspects of the database environment I was working in and thus became a nuts-n-bolts DBA. I was a true command line and vi bigot. Times have changed and the GUIs are very reliable, understand the environment they are installed on, and can generally get the job done quicker for individuals new to database administration. I too am slowly slipping over to the dark side of GUI administration. {If you find yourself as a tools-n-props DBA, try to convey that you are aware of some tasks that require you to be a nuts-n-bolts DBA.}

Hope this may help.

Thanks all and take care.

0
Avatar
Newbie

yeah i go for the gui, when configuring the listener and network features becasue the listener.ora,tnsname.ora and sqlnet.ora file could be very delicate, even a single unwanted period (.) or an unwanted parathesis could casue havoke, but as time goes on it better you learn how to edit the network files using a notepad, that even more interesting.

but i still find the CLI more interesting than the GUI.

0
Avatar
Newbie

@babsin

yeah there are situation where you will have to use your em in other to make this easier and faster, but it's still mandetory that you mater the CLI

larry

0
Avatar
Newbie

@Maleeq,

Thats true but if you have 37TB of data to maintain, what type of tasks you solve faster?

are you scripts not already on cron?

0
Avatar
Newbie

I am a nuts-n-bolts Oracle DBA. With vast experience in PL/SQL programming, I cant help but say CLIs makes me feel in control. I solve a lot of tasks faster in command line.

0
Avatar
Newbie

I am tool-n-prop DBA using MySQL database to access front-end PhpMyAdmin to code SQL queries creating new database connection, table and PHP script. It executes MySQL database result no problem.

0
Avatar
Newbie

GUI VS CMD

the fact is that you can even do more using the command prompt than using the GUI, you don't always have to type all your script when you need them,you could always make them down b4 using them and allyou need to do b4 execution is edit some things thats all. but oracle 10g still recommends us to use the em cdbconsole when creating a database but i guess am just being stubborn. but really its for you own goo to learn how touse the cmd.

larry

0
Avatar
Newbie

i'm just learning the ropes in dba, but i've found out that the cmd prompt can be fun. it gives u a feeling of being in control, but i'll just get the job done with a gui if i'm constrained for time.

0
Avatar
Newbie

I don't nderstand why you have to use the command line where there are GUI tools out there. Especially when using MySql databse running on a Php/Apache platform. Besides, most hosting providers wont give u a telnet access so how would u use CLI on ur DB.

I'd rather use PhpMyAdmin or run queries thru my Php Scripts. That doesnt mean, I am limited in my use of MySql in anyway.

0
Avatar
Newbie

@ Uyai help me ask them

I don't understand a thing

0
Avatar
Newbie

http://en.wikipedia.org/wiki/DBA

0
Avatar
Newbie

i am an oracle DBA and i prefer to use the cli especially when the gui is taking time

it is real time on oracle

i only use the gui when i don't know the command to use

0
Avatar
Newbie

well let me tell you guys something,

if your GUI fails you, then you cmd will not, (black box)

but as for me i prefer using the cmd, i don't see the gui as a means to make administration more easy i see it as making us more lazy, but there are some cases where you are recommended to use the gui, like when creating a database and executing pl/sql codes but i always love doing it the hard way, sorry guys maybe am just being stubborn.

but you must know that you gui will fail you someday, so be warned.

larry

0
Avatar
Newbie

I'm always on the MySQL command line, so I guess I'm a nuts and bolts DBA. That is, assuming the backend of a site like this is considered to be a real database.

0
Avatar
Newbie

I'm a SQL SERVER Database Adminstrator..

0
Avatar
Newbie

Seems like u know your [stuff], Sesal. What platform do you use?

0
Avatar
Newbie

thanks seun. i will explain what i mean.

The two terms are not good or bad groups but something people think about when talking to DBA

A nuts-n-bolts DBa is the type that likes to figure out every little item about how the database works.He/she is a DBA who typically hates a GUI environment and prefers the command line to execute command and accomplish task. A nuts-n-bolts DBA like to feel in control of the database and only feel comfortable at the command line.

A tools-n-props DBA is mostly the opposite of nuts-n-boltsDBA.They like the feel of a GUI.(hun!thats phpmyadmin,MySQL administrator e.t.c).the ease at which things can be accomplish without knowing much about the database.They want to get the job done with the least amount of intervention from having to figure out what everything is doing behind the scene.

Now that have explain these two terms i think you guys can now contribute. as for me most DBA i see choose to be tools-n-props DBA because of the reasons above.(including myself) that actually doesnt mean they cannot work at the command line but to get your job done quikly.with ease and also sometimes when u have more than a server to administer.most of choose to go the way GUI.

0
Avatar
Newbie

I consider myself a MySQL Database Administrator, so I'd like to answer your question. Can you describe what you mean by "nut and bolt DBA" and "props and tool DBA"?

0
Avatar
Newbie
Your answer
Add image

By posting your answer, you agree to the privacy policy and terms of service.