One of the more interesting technology battles this year (and probably 2008) will pit Microsoft's Office 2007 coupled with SQL Server 2005 against established business intelligence players. That fact ...

Teradata Aster has launched a new tool which allows business analysts to work with Hadoop data through SQL query structures. Its Aster SQL-H provides a bridge between widely used business intelligence ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Sub‑100-ms APIs emerge from disciplined ...

How to use BYCOL() and BYROW() to evaluate data across columns and rows in Excel Your email has been sent Most Microsoft Excel functions are autonomous—one result value for each function or formula.

Using the External Data Connection feature in Excel, you can acquire information from external sources, such as Access and SQL Server. The data remains stored at its original source, but the data ...

What if you could transform hours of tedious spreadsheet work into just minutes of streamlined efficiency? Simon Sez IT takes a closer look at how Excel’s most powerful functions can transform the way ...