Grid computing isn't actually the fabulous architectural advance that the database vendors want you to believe it is. It's actually just the one that enables them to keep charging you more than they should.
Pervasive.SQL and its ancillary tools may be a serious contender for the business of software companies needing an embedded database engine.
SQL Server and Oracle each have very different methods for maintaining data constancy when accessed by concurrent users. Oracle maintains a snapshot of the data, which prevents queries from hanging without stooping to "dirty reads." Find out how it works.
Compared to SQL Server, Oracle allows a DBA to go much further under the hood to properly manage data space requirements. However, space allocation in Oracle is complicated. Learn how locally managed tablespaces can let the database engine make most of the decisions for you.
Oracle's SQL*Plus is no SQL Server Query Analyzer, but with a little practice you'll get the hang of it.
In the last several years, I have built and expanded my career based on my knowledge of Microsoft SQL Server. However, I am in the process of learning more about the flagship product of Microsoft's chief rival: Oracle.
The complexity of information storage and retrieval is hidden from casual database users, but that's exactly what you need to know if you want to administer Oracle.
Oracle9i and SQL Server 2000 add enhancements to the standard SQL language that enable you to use the database to implement your business rules and processesSQL Server with Transact-SQL and Oracle with PL/SQL. Find out why the Oracle database engine is better suited for this role.
How best to capture changes that have occurred in a database using triggers.
The article describes a simple process for assessing and mitigating risk from data loss.
In this 10-Minute Solution, Joe Lax demonstrates how to use Dynamic SQL to process those changes and apply them to the second database.
SQL Server 7 provides another method for obtaining metadata: the INFORMATION_SCHEMA views. The article introduces these views and shows how they can provide critical information about your database.
The article describes a basic understanding of the metadata in a database. Though theoretical in nature, it can be used to solve complex problems.
This 10-Minute Solution warns of the dangers of using identities and triggers together.
You can boost your performance greatly by separating indexes and data onto different physical disks, which allows both the index and data to be accessed at the same time. However, in SQL Server 6.5, ...