Open source and free software projects often encounter culture clash whenever they have to work with standards bodies. The most obvious problem is the secrecy that many proprietary-vendor-driven ...

SEATTLE — At the first Microsoft Business Intelligence Conference, held here last week, the company announced the target ship date and new details for the follow-on to SQL Server 2005. In an interview ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Lily Mara explains how to avoid high-risk ...

Out of all the programming languages you need to learn in the IT industry, SQL is one of the most important. SQL is so integral to modern big data access and organization processes that it’s never a ...

I've got a runaway sql process (not the service itself, but a hung transaction) that's eating up the cpu on 4-way box to 100%. It's a member in an active/active Win2k Sql cluster. I've tried to kill ...

SQL Server 2005 is so packed with new features that it can be hard to keep track of it all. Like a tightly packed peloton of Tour de France riders, the new capabilities of SQL 2005 may appear as a ...

Have you ever tried recursive queries in SQL with CTEs? Ugh, no. :) I guess my use of SQL is not at that level. I agree that such queries are unreadable piles of evil, and predicting how they will ...