03-23-2010, 01:26 PM
|
#21
|
Lifetime Suspension
Join Date: Aug 2005
Location: CP House of Ill Repute
|
Quote:
Originally Posted by photon
OSX is a *nix OS, it's built on Darwin, if you know unix you'll be at home at the command prompt in OSX.
|
Thus it is impossible for it to run better!
|
|
|
03-23-2010, 01:28 PM
|
#22
|
The new goggles also do nothing.
Join Date: Oct 2001
Location: Calgary
|
But it will LOOK better, so it will run better because everyone who's put speed holes in their car knows looks are worth at least 10hp or 10MHz in this case.
__________________
Uncertainty is an uncomfortable position.
But certainty is an absurd one.
|
|
|
03-23-2010, 01:32 PM
|
#23
|
GOAT!
|
Exactly why I paint my Macs red. Red Macs are FASTER.
|
|
|
03-23-2010, 01:35 PM
|
#24
|
Franchise Player
Join Date: Jul 2005
Location: in your blind spot.
|
Oh, and the SQL Server vs Oracle battles are about as strong as the MS v Apple battles.
__________________
"The problem with any ideology is that it gives the answer before you look at the evidence."
—Bill Clinton
"The greatest obstacle to discovery is not ignorance--it is the illusion of knowledge."
—Daniel J. Boorstin, historian, former Librarian of Congress
"But the Senator, while insisting he was not intoxicated, could not explain his nudity"
—WKRP in Cincinatti
|
|
|
03-23-2010, 02:02 PM
|
#25
|
Franchise Player
Join Date: Aug 2005
Location: Memento Mori
|
Quote:
Originally Posted by Bobblehead
Oh, and the SQL Server vs Oracle battles are about as strong as the MS v Apple battles.
|
I've never met a DBA that was a database fanboy, but if they were, they're worthless.
__________________
If you don't pass this sig to ten of your friends, you will become an Oilers fan.
|
|
|
03-23-2010, 02:09 PM
|
#26
|
The new goggles also do nothing.
Join Date: Oct 2001
Location: Calgary
|
Oh I don't know, I've seen some pretty epic DBAs that were definite fanboys, and there were definite wars over.. well usually over anything vs. MSSQL. Think mac vs. PC commercials where anything can be mac but only MSSQL can be PC.
EDIT: And for the record I enjoyed working with MSSQL.
__________________
Uncertainty is an uncomfortable position.
But certainty is an absurd one.
|
|
|
03-23-2010, 02:23 PM
|
#27
|
Franchise Player
Join Date: Aug 2005
Location: Memento Mori
|
Oracle for the longest time had superior transactional support (it's so very easy to deadlock SQL Server), but these days the differences are mostly implementation and not really apparent from a developer POV.
Whenever I deal with with an Oracle doofus, I just ask them to explain VARCHAR2. That usually gets them blushing.
__________________
If you don't pass this sig to ten of your friends, you will become an Oilers fan.
|
|
|
03-23-2010, 02:25 PM
|
#28
|
Franchise Player
Join Date: Jul 2005
Location: in your blind spot.
|
Quote:
Originally Posted by Shazam
I've never met a DBA that was a database fanboy, but if they were, they're worthless.
|
Seriously? There are some pretty heated debates, and some fairly different mechanisms in some areas (how Null is handled being a fairly common example).
__________________
"The problem with any ideology is that it gives the answer before you look at the evidence."
—Bill Clinton
"The greatest obstacle to discovery is not ignorance--it is the illusion of knowledge."
—Daniel J. Boorstin, historian, former Librarian of Congress
"But the Senator, while insisting he was not intoxicated, could not explain his nudity"
—WKRP in Cincinatti
|
|
|
03-23-2010, 02:38 PM
|
#29
|
Lifetime Suspension
Join Date: Mar 2007
Location: Calgary
|
I manage a copy of the entire MLS database for Calgary/Edmonton/Fraser Valley/Greater Vancouver/Chilliwack/Kamloops/Red Deer/Lethbridge/Fort Mac on MYSQL!
|
|
|
03-23-2010, 02:58 PM
|
#30
|
GOAT!
|
Of course my exposure to the different DB environments is minimal at best, but for what it's worth MySQL is the one I like the best so far.
Just yesterday in class, we were running some basic select queries in Oracle, and I started jumping ahead a bit into some other areas... Which lasted until I got to the part where I wanted to incorporate other tables in my queries. That's when I discovered how much I'd been taking for granted the "show tables" command from MySQL.
|
|
|
03-23-2010, 03:11 PM
|
#31
|
Franchise Player
Join Date: Jul 2005
Location: in your blind spot.
|
select *
from user_objects
where object_type = 'TABLE';
__________________
"The problem with any ideology is that it gives the answer before you look at the evidence."
—Bill Clinton
"The greatest obstacle to discovery is not ignorance--it is the illusion of knowledge."
—Daniel J. Boorstin, historian, former Librarian of Congress
"But the Senator, while insisting he was not intoxicated, could not explain his nudity"
—WKRP in Cincinatti
|
|
|
The Following User Says Thank You to Bobblehead For This Useful Post:
|
|
03-23-2010, 03:16 PM
|
#32
|
The new goggles also do nothing.
Join Date: Oct 2001
Location: Calgary
|
Quote:
Originally Posted by MelBridgeman
I manage a copy of the entire MLS database for Calgary/Edmonton/Fraser Valley/Greater Vancouver/Chilliwack/Kamloops/Red Deer/Lethbridge/Fort Mac on MYSQL!
|
Neat! That must be some pretty substantial hardware.
I may become a real estate agent just for you.
*Enters first house on MLS*
Agent Name: "photon'); drop table Listings;"
Mwahahaha...
__________________
Uncertainty is an uncomfortable position.
But certainty is an absurd one.
|
|
|
03-23-2010, 03:31 PM
|
#33
|
Redundant Minister of Redundancy
Join Date: Apr 2004
Location: Montreal
|
Quote:
Originally Posted by photon
Agent Name: "photon'); drop table Listings;"
Mwahahaha...
|
|
|
|
03-23-2010, 03:44 PM
|
#34
|
GOAT!
|
Haha little Bobby Tables. So awesome.
|
|
|
03-23-2010, 03:53 PM
|
#35
|
Lifetime Suspension
Join Date: Mar 2007
Location: Calgary
|
Quote:
Originally Posted by photon
Neat! That must be some pretty substantial hardware.
I may become a real estate agent just for you.
*Enters first house on MLS*
Agent Name: "photon'); drop table Listings;"
Mwahahaha...
|
Not sure you fit in with that crowd, no offense to most realtors out there but here is an example of crap I have to deal with.
select redblud_desc from redblud where instr(redblud_desc,'fort')
will pull up this
FORT MCMURRAY
FORT MCMUURAY
FORT MCMURRAY, AB
FORT MCMCURRAY
FORT MCMMURRAY
FORT MCMURRAY
FORT MCMURARY
FORT MCMURRRAY
FORT MCMURAY
FORT MCMURRAQY
FORT MCURRAY
The many ways a fort mac realtor enters in the name of the city they work in.
And shame on the MLS company for providing third parties with this crap
Last edited by MelBridgeman; 03-23-2010 at 03:56 PM.
|
|
|
03-23-2010, 03:54 PM
|
#36
|
The new goggles also do nothing.
Join Date: Oct 2001
Location: Calgary
|
Heh, yeah that's the comic I had in mind when posting that.
Or these:
__________________
Uncertainty is an uncomfortable position.
But certainty is an absurd one.
|
|
|
03-23-2010, 03:55 PM
|
#37
|
The new goggles also do nothing.
Join Date: Oct 2001
Location: Calgary
|
Quote:
Originally Posted by MelBridgeman
The many ways at fort mac realtor enters in the name of the city they work in.
|
Lol awesome!
__________________
Uncertainty is an uncomfortable position.
But certainty is an absurd one.
|
|
|
03-23-2010, 03:59 PM
|
#38
|
GOAT!
|
I've always been an advocate of pre-populated drop-downs on data entry forms. Text fields are the devil.
|
|
|
03-23-2010, 04:01 PM
|
#39
|
First Line Centre
Join Date: Mar 2009
Location: Brisbane, Australia
|
I think the other smart Mel guy nailed it, working for an outfit where you can do both is a great way to build up your chops on both sides. That's what I've done, and I'm quite happy with how much I've been allowed to learn over the years.
Having very solid database understanding is fundamental to becoming a great application developer. With that, you can work WITH the database developer to come up with really effective solutions. Without it, you frequently get application developers building in too much functionality that should be handled within the database platform.
Within what is usually referred to as a DBA role are actually two roles: true DBA work, and database developer. It sound to me like you're most interested in database development. Designing databases (some think this is DBA work, I don't), creating data loading packages, reporting services, etc. Basically, the bits that your applications might interact with.
One thing to consider is that DBA's (and particularly Oracle DBAs) usually get paid scads of cash.
|
|
|
03-23-2010, 04:07 PM
|
#40
|
First Line Centre
Join Date: Mar 2009
Location: Brisbane, Australia
|
Quote:
Originally Posted by FanIn80
I've always been an advocate of pre-populated drop-downs on data entry forms. Text fields are the devil.
|
Huh. I'm an advocate of implementing constraints on the database so my data integrity isn't dependent on an application.
|
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -6. The time now is 09:52 PM.
|
|