(Brian Mains) Recently I had a large amount of data for an in clause in a SQL string. Rather than formatting each item to appropriately meet the SQL parser syntax, I used Microsoft Word instead. Microsoft Word has many functions that can assist a developer or analyst with data queries or data manipu
Other News
Global Information Framework and Knowledge Management, Part 3
(Paul Prueitt) Informational convolution is defined to be a process that visits each element in a hash table and performs some logic using a small rule engine and the contents of the hashed element and associated bucket. Our work is a generalization of patents and partially owes its origin to a cont
How to back up and restore Analysis Services databases
(Baya Pavliashvili) Microsoft Analysis Services (MSAS) looks simple to use on the surface, but you’ll quickly discover otherwise when you start working with it daily. Backups are the topmost priority for any database administrator, so you’d think that backing up MSAS cubes would be straightforward,
Sloppy Leftovers from Yukon Betas; Package ‘Visual Studio Common IDE Package’ failed to load
(Larry Chesnut) No, I’m not talking about Thanksgiving leftovers … that comes later this week. Today, I’m talking about those of us who always have to download the latest version of SQL Server 2005. By living on the bleeding edge, we eventually get cut in one way or another. Mine happened to be with
Use Best Practices for Keeping Your SOX in Compliance
(Niel Robertson) Sometimes bad things happen to good people. For many developers, that is the perfect summation of how the Sarbanes-Oxley (SOX) Act has affected their daily lives. At first blush, the SOX Act looks like yet another set of checks and balances to ensure accurate financial reporting
FIX: The Spanish versions of SQL Server 2000 Analysis Services hotfix packages do not install correctly
The Spanish versions of some Microsoft SQL Server 2000 Analysis Services hotfix packages do not install correctly. Therefore, you cannot use Add or Remove Programs to remove the hotfixes as expected. You may receive an error that is similar to the following in the uninstall log for the hotfix: 0.0
BPEL: Web Services orchestration, hands-on with ActiveBPEL
(Daniel Rubio) Designing Web services in the context of an SOA entails striking a balance between a series of issues — mainly reusability and flexibility — but once this initial design is done coordinating individual services to play out their role in an aggregated manner implies another set of re
MySQL AB to counter Oracle buy of Innobase
Six weeks after Oracle Corp. bought Finnish software developer Innobase Oy, MySQL AB is working to provide its customers with an alternative to the open-source InnoDB database engine often used at the heart of its product, a MySQL executive said.
The Case for XQuery
(Jerry King) XML use is widespread across modern information systems in all industry, government, and academic sectors. The core technologies for processing XML (XML, XSLT, XPath, XML Schema, and others) are maturing steadily – thanks to support from standards bodies like the W3C and OASIS, and from
Using multiple Struts configuration files
(Brett McLaughlin) This tutorial shows Java Web developers how to set up Apache Struts to use multiple configuration files. You’ll learn about the purpose and structure of the various Struts configuration files and the rationale for working with smaller files. You’ll follow steps to split a large, c