Scott Walters writes "Many of the recipes in SQL Hacks will improve the SQL you write day to day, and many will give you the confidence to attempt much more involved tasks with SQL. Other recipes will rarely if ever be needed, but make for a entertaining and education reading in a similar way that "worse case survival scenario" books do — SQL is pitted against the most difficult analysis tasks just as survival scenario books pit humans against pavement and lions. SQL Hacks fits well in the Hacks series, which raises the bar on advanced books by offering large, eclectic sets of tricks for problems that an unambitious person (a non-hacker) wouldn't ever push technology hard enough to run into. Put another way, the questions answered in a good Hacks book are ones that would get a "good question" comment rather than a an "RTFM!" response. It does a good job continuing where O'Reilly's SQL Cookbook left off, which is always difficult with two books written at slightly different times by different authors. Still, it's harder to review a Hacks book than a Learning book as, with hacks, the sky is the limit, and the reader will always find herself wishing for more. To this end, I hope O'Reilly continues to publish newer editions of their various Hacks books, drawing in more and more content in each edition, and identifying recipes that might better serve in the Cookbook counterpart." Read the rest of Scott's review.

Drakewolf writes to tell us that despite the many failed attempts to bridge the gap between the PC and home entertainment systems, AMD has released several new products at CES under their LIVE! brand. The centerpiece was the AMD LIVE! Home Cinema, an all-in-one device that combines a set-top cable box, stereo receiver, DVD player, digital video recorder, and a PC.

bvc writes "Marucs Ranum notes that 'It's really hard to tell the difference between a program that works and one that just appears to work.' He explains that he just recently found a buffer overflow in Firewall Toolkit (FWTK), code that he wrote back in 1994. How do you go about making sure your code is secure? Especially if you have to write in a language like C or C++?"

yavori writes "Internet Explorer 7 has kicked in at last on all MS Windows OS running PCs because of the fact M$ decided to force it's users to migrate through update. In fact this has started a IE7 Web Developers Nightmare. The article actually explains that most of the small company B2C sites may just fall from grace because of IE7 incompatibility. One of the coolest thing IE7 is unable to do is actually processing form data when clicked on an INPUT field of TYPE IMG... which is pretty uncool for those using entire payment processes with such INPUT fields."

Zrop writes "AppleInsider is reporting that Apple has been working on OS-level integration of an geographical mapping technology as an integral part of Leopard, its next-generation OS. The technology is rumoured to employ GPS functionality. Will GPS chips make Apple iPod phones and MacBooks location aware? Users would be able to post information at a location, hanging in the air, ready to be browsed by people passing by. Imagine getting highly relevant messages, without even pressing a button, simply because you are in the vicinity and your preferences match the content of the post."

An anonymous reader tipped us to a post on ZDNet about some disturbing freedom of the press issues in Second Life. Content mogul Anshe Chung is filing DMCA complaints with organizations that post screenshots of her content, citing an infringement of copyright. From the article: "The issue has surfaced after the avatar Anshe Chung (real name Ailin Graef) was attacked by animated flying penises during a virtual interview with CNET news, conducted in their Second Life bureau last month. A video of the attack surfaced on YouTube, and was then taken town after Anshe Chung Studios filed a DMCA complaint. The Sydney Morning Herald and the blog BoingBoing have also received similar notices."

autophile writes "It's official: M-Law's 10th Annual Wacky Warning Label Contest is over. First prize has gone to a washing machine label urging not to put people in washers. Started to promote awareness of excessive litigation, the contest highlights common sense warning labels, such as the one that warns not to dry cellphones in microwave ovens. Companies find it necessary to stick crazy warnings on their products because of previous insane lawsuits: 'A front loader (washing machine) is just at the right height — speaking now as a mother and not a corporate spokeswoman — for a four-year-old,' said Patti Andresen Shew of Alliance Laundry Systems. Personally, I think a four-year-old precocious enough to read and understand all the warning labels hidden all over a product probably doesn't need those labels."

Roland Piquepaille writes "An international team of researchers has discovered a new generation of optical molecules which interact 50% more strongly with light than any molecules ever tested. These organic molecules, known as chromophores, have been theorized by physicists at Washington State University, synthesized by chemists in China and tested for their actual optical properties by chemists in Belgium. But if they're excellent candidates for being used in optical technologies such as optical switches and Internet connections, these new materials should not be used before several years — if ever. Read more for additional details and a picture of the physicist who broke a law he established in 1999."

tridium asks: "I recently moved into a new place where the landlord left a Linksys WRT54G v2 router for us to use. The three laptops in the house running XP connected to it fine, but my desktop, running Vista RC1 build 5600, had to be hardwired. The Internet worked fine for a bit, but I noticed some websites weren't loading up (Google, Gmail, and several others), and IM clients weren't working. Vista's self-diagnosis said it couldn't communicate with the DNS server, so I researched and it seems the new TCP stack in Vista is wreaking havoc with my router. I upgraded the firmware from Linksys, tried manually setting IP settings, modified the registry to disable TCP window stacking, but nothing helped. Linksys support was also useless in fixing the problem. I'm at a loss and any help, short of downgrading to XP, would be greatly appreciated." Other people have experienced problems getting Vista to work with off-the-shelf routers. A thread from September identifies the new window scaling feature as a potential culprit, while another article says that Vista and SPI-enabled routers don't play well together. Whether the problem is related is unknown, but another thread offers some troubleshooting tips for anyone else who may be experiencing this problem. Has anyone figured out how to disable (or at least work around) some of the more troubling aspects of Vista's new TCP 'features'?

Frumious Wombat writes "Over at the Register Developers section, they are quoting the head of research for Ovum Consulting on the continuing dominance of COBOL in certain business applications. The antique language accounted for 75% of all business transactions last year, and some 90% of financial transactions. For all the time spent arguing the merits of Ruby vs. C#, should the community spend more time building tools to make COBOL livable? The article goes into what it terms 'legacy modernization', and lays out some details on how to go about it. From the article: 'The first stage in the legacy modernization process is to understand the business value embodied within legacy systems. This means that developers must give business domain experts (business analysts) access to the legacy, using tools that help them find their way around it at the business level. Some awareness of, say, COBOL and of the legacy architectures will be helpful but we aren't talking about programmers rooting around in code - modern tools can automate much of this analysis for staff working at a higher level.'"

MarkWatson asks: "I keep two Windows machines: a Windows 2000 laptop (bought with XP, but installed an old Windows 2000 license and Linux) and a desktop with XP (dual boot to Linux). I would like to avoid ever buying a PC with Vista, a situation that looks good because I believe both my Windows systems are reliable, fast, and will service my Windows needs for the long term. My problem is this: I like Windows 2000 better for a few reasons, but mainly because the license is transferable. I would like to still be using Windows 2000 5 years from now in a secure and reliable way (again, just for when I need Windows). Since I am far from a Windows expert, I would like to know your strategy for archiving Microsoft's latest Windows 2000 updates, and generally dealing with security issues. My strategy is to set my firewall up to run in stealth mode and not use Windows for general web browsing. Any suggestions will be appreciated!" How would you keep an old Windows OS (like Win98, and WinXP in another year or two) running long after official support for it has ended?

bluefoxlucid asks: "With Apple having now switched to x86 CPUs, I've been wondering for a while why we use the x86 architecture at all. The Power architecture was known for its better performance per clock; and still other RISC architectures such as the various ARM models provide very high performance per clock as well as reduced power usage, opening some potential for low-power laptops. Compilers can also deal with optimization in RISC architectures more easily, since the instruction set is smaller and the possible scheduling arrangements are thus reduced greatly. With Just-in-Time compilation, legacy x86 programs could be painlessly run on ARM/PPC by translating them dynamically at run time, similar to how CIL and Java work. So really, what do you all think about our choice of primary CPU architecture? Are x86 and x86_64 a good choice; or should we have shot for PPC64 or a 64-bit ARM solution?" The problem right now is that if we were going to try to "vote with our wallets" for computing architecture, the only vote would be x86. How long do you see Intel maintaining its dominance in the home PC market?

peterwayner writes "If you're jazzed by the communitarian impulses driving Wikis, idea agora, Web 2.0 and other collaborative happenings, you'll be pleased to know that the new book Wikinomics is a great gift for that boss, spouse, or friend who doesn't quite grok it yet. The only logic bomb hidden in this statement is that much of what is wonderful in this book is wonderful because it's a book printed on pulp and written by two and only two authors. That is, the book is good because it's not a wiki." Read the rest of Peter's review.

holy_calamity writes "Hot on the heals of a UK government report that predicted robots would demand citizens rights within fifty years, an Arizona state lawyer has suggested that sub-human robots should have rights too. Harming animals far below human capabilities is thought unethical — would you ever feel bad about kicking a robot dog? And can we expect militant campaigners to target robot labs as they do animal labs today?"

mstaj noted that Bill Gates has an article in January edition of Scientific American A Robot in Every Home."Imagine being present at the birth of a new industry. It is an industry based on groundbreaking new technologies, wherein a handful of well-established corporations sell highly specialized devices for business use and a fast-growing number of start-up companies produce innovative toys, gadgets for hobbyists and other interesting niche products. But it is also a highly fragmented industry with few common standards or platforms. Projects are complex, progress is slow, and practical applications are relatively rare. In fact, for all the excitement and promise, no one can say with any certainty when — or even if — this industry will achieve critical mass. If it does, though, it may well change the world."