IBM announces new and enhanced tools designed to provide functions that improve DB2 recovery by offering increased compression of archived logs, and easier identification and restoration of logs. Service stream enhancements to the DB2 object management tools continue to make database management task
Other News
Open Source Software Firms Expand Presence In DBM System Market
(Kim Ik-jong) Open source software companies are beginning to augment their presence in database management (DBM) system market.
Use search engine technology for object persistence
(Mikhail Garber) In this article, the author looks at how to address an old problem—provide simple persistence to basic JavaBeans—with a new twist. He shows you how to achieve this goal without the complexity of a full-blown database- or XML-driven solution. At the same time, he doesn’t over-sim
Developers Prep for Oracle
(Renee Boucher Ferguson) Although the ink on the deal between Oracle Corp. and PeopleSoft Inc. is barely dry, third-party software developers that make their living selling add-on enterprise resource planning applications are bracing for a seismic shift in their business.
IBM Flexes XML Muscle
(Brian Fonseca) In an effort to give customers more focused control over internal and non-IBM external enterprise data stores, IBM is planning to add native XML support to its relational DB2 Universal Database wrapped around new indexing capabilities.
Finding your trace file from SQL*PLUS
(Neaman) Run this script from your sqlplus session to find trace files. (script)
MDX Essentials: String / Numeric Functions: More on the IIF() Function
(William Pearson) In this lesson, we will continue our examination of the IIF() function, which we began in my article String / Numeric Functions: Introducing the IIF() Function. In that introductory session, we explored the IIF() function, discussing its primary purpose, and touching upon its many
Discovering Visual Basic .NET: Using Functions and Arguments
(Bill Hatfield) In the previous article in this series, you discovered how to use variables to store information, do math and other operations, and how to display the results. In this article, you’ll explore the use of functions and arguments.
Grouping Ranges
(Itzik Ben-Gan) T-SQL querying problems often require you to apply complex logical thinking. Even though some people may be born with stronger logical-deduction abilities than others, logic is an area in which you can significantly improve by constant practice. So, the more you practice tough T-SQL
Controlling SQL Server Settings
(Andre Vigneau) Haven’t you dreamt about a way to prevent the change of some parameters by some people that still have system administrators privilege and that can seriously put in danger your SQL Server and applications running on them. I know I have this nightmare. (R)