Trees in SQL
Automating hot backups
Using Oracle functions in ORDER BY and GROUP BY clauses
The power of the ROLLUP and CUBE function
A tip for success: Keep the business users engaged
Choosing the appropriate JDBC Driver to connect to an Oracle database
Synchronize your servers
Regional focus: Mid-Atlantic goes heavy on the technology
Good customer service will not a warehouse give
Using in-line views
Computing values from different child segments
Normalization and performance: Never the twain shall meet!
Four methods for designing a data warehouse/data mart environment
Schema, query: Is it database or XML?
Why data warehousing projects fail
Review your Oracle & HP MC/ServiceGuard configuration
Oracle backups with RMAN
Practice safe changes to Oracle RDBMS
Normalization and tracking systems
Oracle flexible architecture layout
Using SQL to calculate nearby ZIP codes
Is your organization ready for data warehousing?
So you want to be a DBA?
Critical success factors for data warehousing projects
Adding database redundancy to reduce SQL complexity, increase performance, and reduce your workload
Those who don't know (or forget) the past are condemned to repeat it
Is what you are seeing real?
Creating test data with SQL
Creating an artificial sort order using the Oracle DECODE function
The data warehousing year in review
Three checks to increase your SELECT statement execution productivity
Where are DBA salaries headed in 2001?
Managing the WHERE clause for better query performance
Managing data with XML: Forward to the past?
Choosing between HAVING and WHERE
The associative model of data
Scheduling with SQL
What's wrong with this (database) picture?
Clustering database servers for reliability and scalability
10 tips for building Java servlet applications with IBM tools
Microsoft's best-kept database secret