Archive for January, 2009
No Win7 allowed at Georgetown, Alaska volcano about to blow. Sony compared to Nintendo. Amazon to unveil the Kindle 2. Cloned dog still in the news. I got to see the first cloned dog in Korea. Intel going to the SaaS cloud in Europe. Look out for the Aptera. Go to Budget.com/tech. Clicker available for NPR. Listen in to see what I am talking about.
Click to listen:
Gmail taken offline. I’m calling it anti-cloud computing. M-labs will let you check on bandwidth throttling. Blackberry Storm sells well. Day three of IE8 promotion. Digital phone camera adds clicking sound. Should the movie aspect of the phone add a whirring sound? Cloned dog goes commercial. Acer smart phone coming. MSFT keeps H1Bs while firing citizens? IBM wants money.
Click to listen:
More Microsoft IE stories. Please stop! IBM guy finally gets into Apple. IPhone patent looks as if it will impinge on Palm Pre. New Zealander get MP3 player with military screts. 2TB Green HD from WDC. USA may require to make cell phones click loud when taking pictures. Chip market to fall 28-percent. EU warns kids to turn down your MP3 players.
Click to listen:
Layoffs at Sprint and Philips. IE being finalized. Win7 stops downloading on Feb. 10. Blackberry glitches. Photoshop CS4 pirated version has virus. Femtocell changing the way we use phones. iLIFE 09 ships tomorrow. I have no idea what iLIFE actually is and do not want to know. Twitter valued at $250 million. For what? Zune sales way down. Cisco to do servers. Games outselling DVD’s. EU may demand MSFT bundle rival browsers with Windows.
Click to listen:
Yoshi and Toad share a Red Bull.
How did they get up there!?
Gotta be the Red Bull..
- Nicholas
I recently watched the following video by Stephane Faroult in which he talks about the basics of SQL indexing.
Below is a brief summary of what he discusses in the video. This (in addition to the video) should give you a very basic fundamental understanding of what SQL indexing means and why it is important.
An index entry is the association of a key value with a physical address. All entries are stored in order of key value.
Do we need a full index or just a chapter list?
A composite index (i.e. year/country) is a concatenation of the two in which we call the result the key. So if the composite index is Country|Year the WHERE clause must be on country, and vice versa.
Indexes on performance:
100,000 Rows, 12 Columns
No Index: 100 inserts
Prim Key: 65 inserts
2 Indexes: 22 inserts
3 Indexes: 15 inserts
4 Indexes: 5 inserts
As you can see, by adding indexes we are taking a big hit in performance (not to mention storage as well). In the same time it takes to insert 100 records with no index, we can only insert 22 records when we have just 2 indexes.
Model for database architecture:
1 – Production
1b – Mirror
2 – Disaster Recovery Site
2b – Mirror
3 – Development
4 – Development
5 – User Acceptance Test bed
6 – Performance Testing
Microsoft kills 5000 down, profits fall too. Google revenues up while profits slip. Apple made money from overseas. Sony warning of a full year loss — $3 billion. Quad core price war breaks out. Now is the time to get a computer! Seagate finally gets the drives fixed. MSFT sends out a bad patch. Texas heads to creationism. Pandora adds audio ads into stream.
Click to listen:
Jan. 21 marked by no news. Everyone is on pins-and-needles over upcoming earnings reports. Intel may take a loss for the first time in 22 years. Conficker in 6-percent of all computers says Panda. Seagate hard disk fix doesn’t work right. AMD dropping prices again. Linden buying virtual retailers. HP CEO makes 42.5 million. Google earnings tomorrow has everyone wondering.
Click to listen:
Being a blog about geeks, and all things geeky, we very rarely involve ourselves in the world’s politics since, very often, the politicians know nothing about being a geek. This was true with the inauguration coverage as well, for the most part. However, I did stumble across something that struck me as very cool, and therefore, geeky.
[ GeoEye ], provider of satellite and aerial photos, has unveiled exclusive images from the GeoEye-1 satellite free of charge on the corporation’s Web site. TheGeoEye-1 produced color photos of the inaugural celebration from 423 miles above the National Mall during the swearing-in ceremony.
Millions of people lined up early, and waited long hours in the cold, and wind to see the most historic inauguration in American history, and for those in the back, it was likely just an “I was there” moment rather then an real hope of seeing or interacting with the new president.
When that many people come together, getting an idea of what is happening or the true scope of the amount of people gathered is difficult to see from the ground, which is why these satellite images tell an even more impressive story.
The images show the masses of people converging on the Mall, and the capitol building. They look like little crazy ants.
Payment processor Heartland may have lost 100,000,000 credit card numbers to hackers. Intel’s new chips. Steve Jobs needs to disclose health info to SEC. Comcast being probed for phone practices. Android point man quits. Belkin faking reviews. IBM sees strong 2009. Where are the MSFT job cuts? Seagate has maybe 30-percent of drives failing. The Conficker worm is ready to trigger. Google scraps newspaper ad program.
Click to listen: