(Elena Litani and Michael Glavassevich) Write your application to get the best possible performance, plus learn which SAX or DOM operations and features affect application performance. In this first of a three-part article, the authors describe best practices for writing XML apps and documents, and
Other News
MDX in Analysis Services: Create a Cube-Based Hierarchical Picklist
(William Pearson) As most of us who work in the Business Intelligence community are aware, parameters (sometimes known as “prompts” or “parameter prompts”) are a staple of enterprise reporting, because they enable information consumers to quickly find the information they need from a report. These f
Yukon Beta 2 Release Leaves Many Scratching Heads
(Lisa Vaas) The long-awaited second beta of the very long-awaited update to Microsoft Corp.’s SQL Server enterprise database is out. But analysts say Microsoft still has a lot of explaining to do. “Some enterprises and ISVs have started to link the delays in the product line with the Longhorn an
Totally RAD
(Paul C. Zikopoulos and Abdul H. Al-Azzawe) The term “performance” means just one thing to a programmer: How fast can I build the application? To attract developers, DB2 Universal Database (UDB) has to deliver an ecosystem that combines tooling, programming models, and data access in a cost-efficien
ApexSQL Edit Replaces the Need for SQL Server’s Query Analyzer
(Brad M. McGehee) To many DBAs and Transact-SQL developers, Query Analyzer is an old friend. We are familiar with how it works, and we understand its strengths and weaknesses. And, like many of our friends, most of them have some room for improvements. (My friends excluded, just in case they read th
Make Recovery Logical
(Darl Kuhn) Many enterprises have conflicting requirements for transaction processing and business reporting. For example, decision reporting cannot be allowed to degrade the performance of online transaction processing. Additionally, mission-critical systems are required to be highly available, wit
Dynamic e-Business with DB2 and Web Services
It is a bold goal: Create an architecture that makes it possible for software to do what humans do with the Web—access documents and run applications in a general way without requiring application specific knowledge and client software. An architecture that supports Web services provides the groun
Designing Extensible, Versionable XML Formats
(Dare Obasanjo) This article discusses what considerations you should make when versioning XML formats, as well as covering some approaches to designing extensible XML formats in a manner compatible with existing XML technologies.
Transitioning to Locally-Managed Tablespaces
(Jim Czuprynski) Oracle 8.1.6 offered a new format for tablespace storage management – locally-managed tablespaces – that offers significant improvements in tablespace performance and free space management. Oracle 9i Release 2 improved upon segment storage in locally-managed tablespaces with the Aut
SQL Server 2000 Security – Part 8 – Introduction to Replication Security
(Marcin Policht) So far in our series of articles, we have been discussing relatively generic SQL Server 2000 security related issues that every database administrator is likely to encounter on a daily basis. Now it is time to look into less common scenarios that deal with one specific area of manag