Ddl
10 Stories
Apple Power Mac G5 (dual 2.7GHz)
Reviews Apple has upgraded the Power Mac G5 with Mac OS X 10.4 Tiger and faster parts, but our complaints about limited expandability still apply.
Rethink five outdated ideas about Oracle
Insight Versions 8i and 9i of Oracle have altered the facts behind several common beliefs of DBAs.
Windows CE finds digs in new Net devices
News Looking to prove that its Windows CE operating system has legs for the consumer electronics market, Microsoft is showing off six new devices based on the slimmed-down version of its desktop OS.
Policy-Based Management in SQL Server 2008
Techguide New to SQL Server 2008 is Policy-Based Management, which gives administrators more control over their database procedures.
Tags: Servers, Databases, Microsoft SQL Server, Database, Policy, Database Table, stored procedure, DDL, Condition, Facet
Introduction to Change Data Capture in SQL Server 2008
Techguide SQL Server database consultant Tim Chapman takes a look at the new auditing features available in SQL Server 2008.
Tags: Databases, Server platforms, Data Management, Microsoft SQL Server, Data, Database, Data Auditing, data capture, DDL, ETL
Document SOX compliance with SQL Server 2005
Techguide Use the built-in tools in SQL Server 2005’s to create a "homegrown auditing system".
Tags: Storage
Passing SQL to Oracle's Heterogeneous Services with DBMS_HS_PASS THROUGH
Techguide There are some functions that cannot be mapped from Oracle SQL to the remote database SQL. In those cases, you should consider passing SQL directly to the remote host. Learn how to use the DBMS_HS_PASS THROUGH "package" to pass SQL through to the remote database.
Tags: Database management
Embed event triggers in Oracle databases and push the limits of ERP
Insight While one benefit of an ERP system is its ability to use databases to trigger multiple events, its real power rests in embedding event triggers in the databases. Here's an overview of how this works in Oracle.
Trace the evolution of rows with Oracle 10g's Flashback Versions Query
Techguide One of the trickiest problems to troubleshoot is the interaction between multiple applications that access the same data. See code samples that demonstrate how Oracle 10g's Flashback Versions Query feature makes this task much easier.
Consider using Oracle objects for OLE in Windows
Techguide Oracle Objects for OLE (OO4O) is a set of software layers designed to provide access to an Oracle database from Microsoft COM Automation and ActiveX compatible languages such as Visual Basic, Visual Basic for Applications (VBA), IIS Active Server Pages (ASP), Windows Script Host, and Visual C++.
