What makes a good database?
Dynamically creating DBA scripts
Is seeing believing?
The Internet: A double-edged sword in the battle for top database talent
UNION, EXCEPT, and INTERSECT clauses
Repairing a Microsoft Jet database
Regional focus: Chicago's winds blow well for the IT professional
Is it knowledge or shared knowledge?
Serial ID fields
Key database design concepts
Ranking in Oracle 8.1.6
Make the most of table scans with multiple summaries
What you don't know about denormalization can hurt you, Part I
JDBC: Setting your AS/400 library list
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
Synchronize your servers
Choosing the appropriate JDBC Driver to connect to an Oracle database
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!
Why data warehousing projects fail
Schema, query: Is it database or XML?
Four methods for designing a data warehouse/data mart environment
Review your Oracle & HP MC/ServiceGuard configuration
Practice safe changes to Oracle RDBMS
Oracle backups with RMAN
Normalization and tracking systems
Oracle flexible architecture layout
Is your organization ready for data warehousing?
Using SQL to calculate nearby ZIP codes
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