DatabaseJournal.com Staff

[From InternetNews] If setting up and implementing Oracle environments makes your database administrators break out in a sweat, help may be at hand. Yesterday the company announced its VM Templates suite, which combines Oracle’s Database 11G, Enterprise Manager 10g, Siebel CRM 8 and Enterprise Linux. All of the apps come preinstalled and preconfigured. The article […]

[From WebReference] Developing a robust, interactive and engaging Web site involves many different avenues, such as interactive pop-out menu’s using dynamic JavaScript, Cascading Style Sheets (CSS), complex maps that allows visitors to rollover individual sections for detailed information, forms designed and formatted with CSS and areprogrammed to collect and send visitor feedback to a specified […]

>>Script Language and Platform: Oracle Get a new date based in interval parameter. Author: Alexis Create or replace Function DateADD(DatePart VarChar , Number int, CurrentDate Date) /* ================================================================================ Arguments: DatePart : Specifies which part of the date to calculate the difference. The table below list DateParts and abbreviations recognized 1) D, DD, Day; 2) M, […]

[From SQL Server Performance] SQL Server 2008 introduces a new feature called Change Data Capture (CDC). CDC Captures DDL and DML activity on a SQL Server table, and places the changes in a separate SQL Server relational table. In this article we will see how CDC can help DBA’s to track the DML changes for […]

>>Script Language and Platform: OracleDetermine the elapsed time between two dates stated in a specific interval. Author: Paul Hunter create or replace function DateDiff(DatePart varchar, StartDate date, EndDate date) /* ================================================================================ Developer: Paul Hunter Created : 05/22/2007 Purpose : Returns the DatePart difference between the two dates provided. Arguments: DatePart : Specifies which part of […]

[From Emvarcadero Technologies] SAN FRANCISCO – July 15, 2008 – Embarcadero Technologies is releasing Embarcadero DB Optimizer, a new tool that allows developers and database administrators to maximize database performance by detecting and reconciling SQL coding issues. DB Optimizer enables quick discovery, diagnosis and optimization of poor-performing SQL, eliminating performance bottlenecks and improving the operation […]

by JP Vijaykumar The move command compacts the rows within Oracle blocks, resolves row chaining, and resets a table’s High Water Mark Both the move and shrink commands reset the high water mark of a table, but which command is more efficient? This article discusses re-organizing a table using the move and shrink commands, then […]

This VBscript code will check for low disk space on the local SQL Server. Schedule the package to run once a day, and let the job report to you by e-mail when a drive runs low on free space. The script will check all disks except for the C: drive and will trigger an alert […]

[From ANTs Software] BURLINGAME, Calif., July 1, 2008 – ANTs software inc. introduces the Sybase-to-Oracle Accelerator Program, a new promotional offering that complements Oracle’s current Sybase Safe Switch Program by providing financial and productivity incentives for organizations wanting to migrate their Sybase applications to the Oracle database. The ANTs program significantly reduces the complexity of […]

[From eWeek] Symantec officials spent a fair amount of time discussing integration possibilities between their security and storage products during their Vision conference in Las Vegas. Now, two weeks later, the company has taken a step toward that goal by expanding the data discovery technology of its Vontu Data Loss Prevention product. The article continues […]

[From Zidsoft] CompareData is a native Windows cross-dbms application that allows you to visually compare and synchronize data between two SQL databases using ODBC drivers. You can retrieve some/all data for a table/view from two databases and compare the data visually to see differences highlighted on the screen. You can also compare data of two […]

[From Developer.com] With the growing use of XML data, the need for the coexistence of relational data and XML data is also growing. The classic approach of storing XML data as physical disk files is unsuitable and tedious in many situations. No wonder modern database engines are geared to store XML documents right along with […]