What makes a good database?
Don't have a data dictionary?
Dynamically creating DBA scripts
The Internet: A double-edged sword in the battle for top database talent
Is seeing believing?
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
Make the most of table scans with multiple summaries
Ranking in Oracle 8.1.6
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
The power of the ROLLUP and CUBE function
Using Oracle functions in ORDER BY and GROUP BY clauses
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!
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
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