DatabaseJournal.com Staff

[From WebReference] Some real-world constants, such as pi, the speed of light, the number of inches in a foot, and the value of midnight, are values that don’t change. PHP not only provides its own predefined constants but lets you create your own. Using constants makes it easy to write and maintain your programs. What […]

[From DBTools Software] DBTools Manager is a complete database management tool with native support for MySQL, PostgreSQL, Interbase, Firebird, Oracle, MSAccess, MSSQL Server, Sybase, SQlite, DBF Tables and ODBC Datasources. The article continues at http://www.dbtools.com.br/EN/article.php?id=00082

[From PremiumSoft CyberTech Ltd ] Navicat MySQL GUI for Windows (ver. 7.2.11) is now available. This version includes improvements on Query Builder and Schedule Backup features. Navicat is a powerful yet easy to use MySQL GUI that provides extensive functionality for managing and developing MySQL. Free trial: http://www.navicat.com/download.html PostgreSQL version: http://pgsql.navicat.com/ The article continues at […]

[From W3C] Based on widespread implementation experience and extensive feedback from users and vendors, W3C has published eight new standards in the XML Family to support the ability to query, transform, and access XML data and documents. The primary specifications are XQuery 1.0: An XML Query Language, XSL Transformations (XSLT) 2.0, and XML Path Language […]

by Rebecca Bond, Kevin Yeung-Kuen See, Carmen Ka Man Wong, Yuk-Kuen Henry Chan First Words—What’s the Plan? When thinking about organizational information security, your mind might jump to the technical details such as firewalls, access control lists, certificates, auditing, encryption, and all those well-known electronic trappings that present a mental vision of a secure architecture. […]

>>Script Language and Platform: SQL Server 2000 This is an new version of the Index Defrag script posted earlier. In this new version, if no table is specified, the script runs for all tables in the target database. Running ‘DBCC INDEXDEFRAG’ on a table can be a big performance boost without the overhead of the […]

[From PHPBuilder] In this article I will show how to generate dynamic XML documents with Object-Oriented PHP. Before I get started, let’s get right to the heart of this functionality. Although the code may look fancy, being packaged up inside objects and inheritance, the key elements of this functionality rest in the the mysql_list_fields() and […]

[From Builder.com] Oracle 10g introduced a new type of tablespace called BIGFILE. Unlike traditional tablespaces that are composed of up to 1,022 datafiles, a BIGFILE tablespace stores its data in a single datafile with a much larger capacity. BIGFILE tablespaces can grow as large as 32-128 terabytes (TB), depending on the chosen block size. The […]

by Alex Polishchuk and Michael Procopio Introduction We all remember too well the cases of Enron and WorldCom. In light of those cases, the government has created new laws commonly known as the Sarbanes-Oxley (SOX) Act of 2002 to protect investors and insure the accuracy of corporate disclosures. SOX-type regulations are being implemented around the […]

>>Script Language and Platform: Sybase Transact SQL This stored procedure displays user of system table list ordered by size (Ko). Author: jflebon use sybsystemprocs go if exists (select name from sybsystemprocs..sysobjects where name=”sp_dba_table” and type=”P”) begin drop procedure sp_dba_table end go create procedure sp_dba_table @tabletype char(1) = NULL as /* *@(#) Author : JF LEBON […]

[From ENT News] After shipping the first release candidate, or RC1, of SQL Server 2005 Compact Edition in mid-November, Microsoft quietly began shipping RC1 of the product’s documentation, which has been updated to reflect the database’s recent renaming, in late December. Dubbed the SQLce Books Online RC1, the downloadable package contains setup and upgrade instructions, […]

>>Script Language and Platform: Sybase Transact SQL This stored procedure displays useful information about the transaction of a given spid (client connection). Author: jflebon use sybsystemprocs go if exists (select name from sybsystemprocs..sysobjects where name=”sp_dba_spidinfo” and type=”P”) begin drop procedure sp_dba_spidinfo end go create procedure sp_dba_spidinfo @sybpid smallint = NULL as /* *@(#) Author : […]