DatabaseJournal.com Staff

>>Script Language and Platform: Oracle This script looks at some of the issues in handling nulls. Author: JP Vijaykumar I love idioms and phrases. One of my favorite phrases is – Nulli secundus (Origin – Latin) adjective, meaning – second to none. I would love to say, null is nulli secundus in Oracle. Why is […]

[From PHPBuilder] I have been using Zend Studio For Eclipse for over a year now and although I started using it around version 5.5, which was rocky to say the least, I am currently using version 6.1.2. and testing 7.0 Beta–which seems rather promising with its error reporting even extending to Zend Server, should you […]

[From Oracle Corp.] To help developers quickly and easily design data models for the Oracle® Database, Oracle today introduced the Oracle SQL Developer Data Modeler. This comprehensive, standalone tool supports logical, relational, multi-dimensional and data type modeling while featuring multi-layered design and generation capabilities to produce conceptual entity relationship diagrams (ERDs) and transform them to […]

[From Stellar Information Systems Limited] Stellar Information Systems Limited, providers of data recovery software, data recovery services and data protection tools, announces the release of updated MySQL Recovery product, Stellar Phoenix Database Recovery For MySQL v2.0. It now supports MySQL 4.x. Also, this updated version helps MySQL database administrators achieving better results with enhanced recovery […]

>>Script Language and Platform: SQL Server 7.0 and SQL Server 2000 This procedure deletes files that are older than a certain period from a folder. Author: MAK [Muthusamy Anantha Kumar] Download Script: USP_DelOldFiles.sql Disclaimer: We hope that the information on these script pages is valuable to you. Your use of the information contained in these […]

by Bryan Sachdeva PHP has exploded onto the web application scene, gaining high popularity among developers. This certainly comes as no surprise given how easy it is to setup and deploy. Typical applications make use of a MySQL back-end, for reasons of availability and cross-platform support. However, once the application is up and running with […]

[From eWeek] A researcher at IBM reports having developed a fully homomorphic encryption scheme that allows data to be manipulated without being exposed. Researcher Craig Gentry’s discovery could prove to be important in securing cloud computing environments and fighting encrypted spam. The article continues at http://www.eweek.com/c/a/Security/IBM-Uncovers-Encryption-Scheme-That-Could-Improve-Cloud-Security-Spam-Filtering-135413/

>>Script Language and Platform: Oracle Use this script to find the session information. Author: Salih Select p.spid “Server Process” , s.username “Username”, s.terminal “Terminal”, s.program “Program” from V$session s, V$process p where p.addr=s.paddr and p.background is null; Disclaimer: We hope that the information on these script pages is valuable to you. Your use of the […]

[From InternetNews] From the “Whatever happened to PHP 6?” files: PHP 5.3 could be out as soon as Tuesday, June 30th. The new open source language release is a big deal for a lot of reasons, not the least of which is the fact that by my count this is the first major update to […]

>>Script Language and Platform: SQL ServerThis script checks to see if a column is NULL or empty. –Query select dbo.isempty(NULL,’This is empty’) as Mycolumn –Result This is empty –Query select dbo.isempty(1,’This is empty’) as Mycolumn –Result 1 –Query select dbo.isempty(”,’This is empty’) as Mycolumn –Result This is empty –Query select dbo.isempty(‘Rainbow’,’This is empty’) as Mycolumn […]

[From Pragmatic Works] Jacksonville, Fla.— June 18, 2009, Pragmatic Works, provider of business intelligence solutions that complement Microsoft SQL Server announced today the acquisition of Bi Documenter, a leading SQL Server documentation tool that documents a client’s environment (metadata documentation and snapshot tool) and the interconnections between SSIS packages, reports, cubes and SQL Server. It […]

[From Oracle Corp.] Students from 13 countries took top honors in the 2009 ThinkQuest Competition. The ThinkQuest Competition, sponsored by the Oracle Education Foundation (OEF), includes… The article continues at http://www.oracle.com/us/corporate/press/018940