DatabaseJournal.com Staff

[From Search SQL Server] My company needs to meet Sarbanes-Oxley compliance for all its Information Technology (IT) department layers and products, including SQL Server. We’re running SQL Server 2000 and SQL Server 2005 with no security standards. What is the process for meeting SOX compliance? What else should I do in order to secure my […]

[From Peter’s Software] Celebrating eleven years of helping developers create better Microsoft Access applications, Peter’s Software launches Drag-N-Dropper v5.6 for Microsoft Access. Drag-N-Dropper is an Access add-on that provides drag and drop functionality between text-based controls and continuous form subforms. New features include support for continuous form subforms, and Vista and Access 2007 support. The […]

by JP Vijaykumar This article examines how to loop through multiple tables to process the data.drop table temp_jp10; create table temp_jp10(col1 number,col2 varchar2(20)); insert into temp_jp10 values(2,’RAMA’); insert into temp_jp10 values(4,’SITA’); insert into temp_jp10 values(6,’HANUMAN’); drop table temp_jp01; create table temp_jp01(col1 number,col2 varchar2(20)); insert into temp_jp01 values(1,’RADHA’); insert into temp_jp01 values(2,’RADHA’); insert into temp_jp01 values(3,’RADHA’); […]

[From MacUpdate] Oracle SQL Developer is a graphical tool that enhances productivity and simplifies database development tasks. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. The article continues at http://www.macupdate.com/info.php/id/20996/oracle-sql-developer

[From SQL Server Magazine] Database change-management solutions from Embarcadero Technologies and Quest Software can help maintain your Microsoft SQL Server environment by registering changes to data, server configurations, and schema information. You can use Embarcadero Change Manager 4.0 to migrate databases to a different platform. Quest Change Director for SQL Server 1.5 provides a simple […]

>>Script Language and Platform: Oracle This script will backup in noarchivelog using RMAN. Author: Bibhu Ranjan Mohanty Download Script: noarchivelog_backup.sql Disclaimer: We hope that the information on these script pages is valuable to you. Your use of the information contained in these pages, however, is at your sole risk. All information on these pages is […]

>>Script Language and Platform: Oracle This script allows you to see the bufferhit ratio of all application users, when all application users are running on the server, so that you can measure individual performance. Author: Bibhu Ranjan Mohanty Download Script: hit_ratio.sql Disclaimer: We hope that the information on these script pages is valuable to you. […]

>>Script Language and Platform: SQL Server 2005 This procedure is an extension of sp_who2 that shows additional information about the block chain using CTE. It shows the same information about processes that sp_who2 provides when it is called without parameters, but when the spid is passed as a parameter, it adds two more columns called […]

>>Script Language and Platform: Oracle This script performs bitwise math and masking operations on numbers. Performs the bitwise operations “AND”, “OR”, “XOR” and “NOT”; Turns a mask of bits ON or OFF in a larger array of bits; Tests whether a number is a “single bit” number; Tests whether a mask of bits is ON […]

[From internetnews.com] Borland’s CodeGear unit this week released its new version of its Delphi for PHP IDE — introducing a number of enhancements geared to make PHP developers more productive. But the new release may also signal growing competition with Zend, PHP’s lead commercial sponsor, and the maker of Zend Studio IDE. The article continues […]

[From Oracle Corp.] Oracle today announced the immediate availability of Oracle Role Manager, an offering within Oracle Identity Management, a component of Oracle Fusion Middleware. Oracle Role Manager helps customers define and manage organizational relationships, roles, and associated privileges for improved security and regulatory compliance. Business users are empowered to manage business roles accurately and […]

[From Builder AU] Last week, we looked at setting up Snort, a Network Intrusion Detection System. Now we will look at configuring Snort to log packets to a remote MySQL server where a graphical Web interface can be used to view captured packets and statistics. The article continues at http://www.builderau.com.au/program/linux/soa/Configure-Snort-to-log-packets-to-MySQL/0,339028299,339287982,00.htm