As far as readability, I think it's a matter of preference (i.e., what you were "raised" on). FWIW, I like the JOIN because it separates your joins from your filtering.
The one big reason to use SQL-92 (why we do it at my job) is because it effectively prevents an accidental cartesian query:
SELECT * FROM table1, table2
if table1 and table2 each have 1000 rows, you just selected 1,000,000 rows. 10,000 rows each, that's 100,000,000, and you get the point. You can easily crush a server by making a typo.
While the above query is a trivial example, easy to overlook that you didn't join properly, especially when you start complicating it with > 2 table joins with lots of WHERE critieria. If you always use explicit SQL-92 JOINS, your SQL won't run if you don't join properly.
As the article admits, P2P is tied very closely to broadband. Take away P2P, and you'll chop a significant portion of your market out. For companies struggling to keep customers, this could just add to the bleeding. P2P "hogs" will just start looking for different broadband technology -- be it wireless, DSL, or whatever. It's very possible that these P2P hogs could drive the next innovation to profitability, leaving cable as an also-ran.
"It's a fun idea," Zier says of his brainchild, "but fun ideas can be very dangerous. It can be an inside joke that only you and your co-workers and your Aunt Rose think is funny. Besides, we're happy with the formats we have."
Fun ideas being dangerous? I believe the term for this is "sold out".
Even with firewire's head start, USB2.0 is already catching up in terms of availability -- both in installation on PCs and availability of peripherals. Apple has to open up and make firewire more attractive to companies who would use the technology for their products. Otherwise it could end up being the Betamax of serial interfaces.
Firewire is here to stay for video because all DV camcorders have firewire. However, firewire could end up being used for little else if USB2.0 catches on in a big way, which is not what Apple wants.
Earlier versions of SQL Server (i.e., before SQL 2000) did default to a blank sa password, so there's probably plenty of 7.0 and 6.5 servers out there swingin' in the breeze.
Microsoft makes it a trivial thing to install SQL Server, so inexperienced people can successfully installing -- it's easier to install than MS Office. It's pretty common for developers to install it and try to admin it, which is how you get 1433 exposed to the internet with a blank sa password.
However, if you're exposing port 1433 to the internet, not only are you unzipping your fly security-wise, but you also probably owe microsoft some huge money for licensing. Under SQL 2000, to have a server that lets internet clients connect (either directly or indirectly, as through a web server), its $5,000 per processor or for SQL Server Enterprise Edition (required for >2GB RAM usage, log shipping, indexed views), $20,000 per processor. Earlier versions weren't as expensive, but required this whole complicated internet connector licensing that confused the hell out of everyone.
So maybe Microsoft will adapt this exploit to find out who's using SQL Server on the internet but cheating them out of their licensing fees. If UCITA or other self-help laws get passed, they'll have every right to.
...how long do y'all figure it would be before someone showed up at my door asking what i was doing?
and do they make something like that?
Yes, they do make something that shows up on your door like that. It's called an FBI agent. You can't buy one, but the government will send you one for free if you ask in the right way. Try threatening a government official, that usually works.
It always sounded like some cheap Chinese knock-off to me. I think you want to sound like your quality is better than Windows...
Homer:[gasps] Look at these low, low prices on famous brand-name electronics! Bart: Don't be a sap, Dad. These are just crappy knock-offs. Homer: Pfft. I know a genuine Panaphonics when I see it. And look, there's Magnetbox and Sorny.
One reason is this: the difference between air traffic control software and an open source MP3 encoder or web browser is that anyone can run the latter 2 examples in a real-world situation. I can encode MP3s or browse the web and really put the software through its paces quite easily. I can make changes, compile, then test. I can participate easily in the development process.
How do you suggest the average coder puts his copy of OpenATC to the test? Start controlling planes from his bedroom? Maybe have all the kids in the neighborhood clear their bicycles and bigwheels for takeoff? I wonder if the testing phase for ATC software is a bigger effort than the actual development.
Netscape navigator 4.08 or later is supported, but not my Mozilla 0.99? a step backward? or basically just not going to be friendly towards open source?
Well, they weren't found guilty of trying to run Mozilla out of business, just Netscape. I'm sure they're sensitive to charges that they are deliberately breaking compatibility with Netscape. But they're free to crush everyone else.
College can be a time where you immerse yourself in something and can participate in experimental projects and activities. Trust me, in most jobs, you don't get to do that. But in college, you won't have to justify your projects -- the payoff is the education, not the usefulness or profitability of the project. In college, you will find yourself with many people around you who are excited about learning and experimenting as you are (if you look).
Or you could spend it trying to live a beer commercial fantasy and wonder why you wasted 4 years and tens of thousands of dollars. Your choice.
I had a domain hosted by a company in india which registered the domain for me for 2 years. After a year, I transferred to a hosting company in the US. When the second year was up, I was thinking that I need to track down who the registrar is and renew, when I got a verisign e-mail saying I need to renew. Thinking that was convenient enough, I renewed with them. About a week after I did this I started to see all the articles on slashdot about domain slamming. I looked through some records and realized that Verisign was not my original registrar and they grifted me good, like Homer and the Cooders. I'd like to say I was beaten by the best, but...
...dropping the price on anything. Here we see the effects of competition. Microsoft doesn't have a monopoly on game consoles, and PS2 isn't susceptible to FUD attacks, so MS has no choice to actually compete in the proper way. By lowering price.
The question is, what will be MS's strategy for the Xbox2? They can't beat PS2 (and maybe not even gamecube). So they will go back and come up with the marketing strategy to win the console monopoly in the next round. They could give their Xbox2 away for a pittance, and hope to get such a large user base as to strangle PS3. But to really kill it, they also need developers to not develop games for the PS3. If they can accomplish both of those they have a shot.
...is with their relationship with Intel. Intel must have known that Microsoft was giving them a bit of the cold shoulder, but it's hard to address that diplomatically. But now the Intel management can act shocked - shocked! that Microsoft would be secretly scheming against them.
Whenever Microsoft gets caught with its hand in the cookie jar, they try hard to make up for it. If Intel and IBM got together and said, we're going to put a Linux desktop out there that the average joe wants and can use as easily as windows, Microsoft will have something to fear. I suspect that they will make a lot of conciliatory gestures towards Intel. Kind of an Ike Turner thing -- take me back, baby, I never meant to hurt you!
And as the rage raged through Anakin's rage, he raged through his raging rage to rage the rage rage.
Anakin raged in a cage without his mama kin
Raging rage like a tearing page set the stage
Gauge his rage with a wise mage
You'll see how Anakin can rage man can Anakin
Why can't he do more of those light, upbeat movies like Amistad and Schindler's List?
SELECT * FROM table1, table2
WHERE table1.id = table2.id
SQL-92:
SELECT * FROM table1 JOIN table2
ON table1.id = table2.id
The one big reason to use SQL-92 (why we do it at my job) is because it effectively prevents an accidental cartesian query:
SELECT * FROM table1, table2
if table1 and table2 each have 1000 rows, you just selected 1,000,000 rows. 10,000 rows each, that's 100,000,000, and you get the point. You can easily crush a server by making a typo.
While the above query is a trivial example, easy to overlook that you didn't join properly, especially when you start complicating it with > 2 table joins with lots of WHERE critieria. If you always use explicit SQL-92 JOINS, your SQL won't run if you don't join properly.
...is build a computer capable of withstanding a full slashdotting.
Slashdot has successfully teleported a months-old story to its current front page. Thankfully, the process does not work on Jon Katz.
My favorite bad physics movie, is, of course, the Zapruder film. You gotta love that Magic Bullet!
As the article admits, P2P is tied very closely to broadband. Take away P2P, and you'll chop a significant portion of your market out. For companies struggling to keep customers, this could just add to the bleeding. P2P "hogs" will just start looking for different broadband technology -- be it wireless, DSL, or whatever. It's very possible that these P2P hogs could drive the next innovation to profitability, leaving cable as an also-ran.
Fun ideas being dangerous? I believe the term for this is "sold out".
Firewire is here to stay for video because all DV camcorders have firewire. However, firewire could end up being used for little else if USB2.0 catches on in a big way, which is not what Apple wants.
You'd probably get so mad you'd start blowing up things and killing people to spite the government that let you down.
Microsoft makes it a trivial thing to install SQL Server, so inexperienced people can successfully installing -- it's easier to install than MS Office. It's pretty common for developers to install it and try to admin it, which is how you get 1433 exposed to the internet with a blank sa password.
However, if you're exposing port 1433 to the internet, not only are you unzipping your fly security-wise, but you also probably owe microsoft some huge money for licensing. Under SQL 2000, to have a server that lets internet clients connect (either directly or indirectly, as through a web server), its $5,000 per processor or for SQL Server Enterprise Edition (required for >2GB RAM usage, log shipping, indexed views), $20,000 per processor. Earlier versions weren't as expensive, but required this whole complicated internet connector licensing that confused the hell out of everyone.
So maybe Microsoft will adapt this exploit to find out who's using SQL Server on the internet but cheating them out of their licensing fees. If UCITA or other self-help laws get passed, they'll have every right to.
and do they make something like that?
Yes, they do make something that shows up on your door like that. It's called an FBI agent. You can't buy one, but the government will send you one for free if you ask in the right way. Try threatening a government official, that usually works.
That's not much of a virus. Step 2 should be to build 10 copies of itself from the items in the owner's home, and send those out.
..as long as you're in reruns.
I think it was called "Searching for Yoshiharu Habu."
Now you're just being ridicurous!
Homer:[gasps] Look at these low, low prices on famous brand-name electronics!
Bart: Don't be a sap, Dad. These are just crappy knock-offs.
Homer: Pfft. I know a genuine Panaphonics when I see it. And look, there's Magnetbox and Sorny.
How do you suggest the average coder puts his copy of OpenATC to the test? Start controlling planes from his bedroom? Maybe have all the kids in the neighborhood clear their bicycles and bigwheels for takeoff? I wonder if the testing phase for ATC software is a bigger effort than the actual development.
Well, they weren't found guilty of trying to run Mozilla out of business, just Netscape. I'm sure they're sensitive to charges that they are deliberately breaking compatibility with Netscape. But they're free to crush everyone else.
Or you could spend it trying to live a beer commercial fantasy and wonder why you wasted 4 years and tens of thousands of dollars. Your choice.
I had a domain hosted by a company in india which registered the domain for me for 2 years. After a year, I transferred to a hosting company in the US. When the second year was up, I was thinking that I need to track down who the registrar is and renew, when I got a verisign e-mail saying I need to renew. Thinking that was convenient enough, I renewed with them. About a week after I did this I started to see all the articles on slashdot about domain slamming. I looked through some records and realized that Verisign was not my original registrar and they grifted me good, like Homer and the Cooders. I'd like to say I was beaten by the best, but...
The question is, what will be MS's strategy for the Xbox2? They can't beat PS2 (and maybe not even gamecube). So they will go back and come up with the marketing strategy to win the console monopoly in the next round. They could give their Xbox2 away for a pittance, and hope to get such a large user base as to strangle PS3. But to really kill it, they also need developers to not develop games for the PS3. If they can accomplish both of those they have a shot.
No, no, Spintronics a new Richard Simmons aerobics program entirely based on twirling...
Whenever Microsoft gets caught with its hand in the cookie jar, they try hard to make up for it. If Intel and IBM got together and said, we're going to put a Linux desktop out there that the average joe wants and can use as easily as windows, Microsoft will have something to fear. I suspect that they will make a lot of conciliatory gestures towards Intel. Kind of an Ike Turner thing -- take me back, baby, I never meant to hurt you!
Anakin raged in a cage without his mama kin
Raging rage like a tearing page set the stage
Gauge his rage with a wise mage
You'll see how Anakin can rage man can Anakin