DatabaseJournal.com Staff

[From 4GuysFromRolla] While databases can efficiently hold large amounts of information that can be queried, all that data and all that querying power is useless if the data is incorrect or nonsensical. Databases provide a plethora of techniques for ensuring the integrity and consistency: primary key and unique constraints can be employed to ensure entity […]

[From internetnews.com] Who said the PC is killing the mainframe computer? Those that heard IBM officials talk about the potential of the mainframe in the modern computing age would think that Big Iron has always waxed and never waned. For Big Blue, the talk is now centered around collaborative processing at a time when supply […]

by Paul C. Zikopoulos, IBM Canada In Part 1 of this series, I covered the richness of the IBM Explorer and its unique features that help Microsoft .NET application developers write applications for the IBM DB2 Universal Database (DB2 UDB) product on any platform. In Part 2 , I introduced you to a set of […]

>>Script Language and Platform: SQL Server 2000 This script will use xp_cmdshell and the DOS FTP commands to send a local (or network) file to a remote FTP site. It can use either a URL or an IP Address as its destination. This script should be able to use wildcards in file names, but this […]

[From MySQL Developer Zone] All robust relational database management systems utilize memory caching to help improve the overall responsiveness of their underlying engine. While certainly not free, accessing application data, query plans, or database metadata in RAM is normally much quicker than repetitively retrieving that same information from disk or building it from scratch. This […]

[From Oracle Corp.] REDWOOD SHORES, Calif., 18-JUL-2005 Oracle today announced two record-setting TPC-H 300 gigabyte data warehousing benchmarks that hallmarked Oracle(r) Database 10g Release 2’s performance power and leadership among enterprise-class databases. Available since July 11, 2005, Oracle Database 10g Release 2 is already setting industry standards by elevating the price performance bar in the […]

[From internetnews.com] Oracle (Quote, Chart) plans to introduce new software licensing schemes today that are kinder to users of multi-core processor machines. The move could curb the harsh criticism the company weathered from customers who protested paying for each socket or core in a multi-core chip. Going forward, Oracle said on its Web site that […]

>>Script Language and Platform: Visual Basic This program is written and tested in VB 6.0 against SQL Server 7.0. It uses registry API to programmatically add SQL Server advanced entries. Actually you should be using a tool called ”Client network utility” that comes with SQL Server 7.0. My code comes in handy when you want […]

[From internetnews.com] Officials at Oracle (Quote, Chart) released the company’s quarterly allotment of security fixes earlier this week, plugging 49 vulnerabilities in its software line. The update also includes a number of non-security patches that are needed because of interdependency issues with the security patches. The “Critical Patch Update” affects the Oracle Database Server, Application […]

[From Daffodil Software Ltd.] Daffodil Software announced the release of Daffodil CRM v1.2, it’s feature-rich, user-friendly contact/leads management solution. The reporting feature in v1.2,in addition to customizable views, makes it now possible to generate different views of data available within the software. Additionally,these views can now be printed with the help of the ‘Export to […]

[From Oracle Corp.] REDWOOD SHORES, Calif., 12-JUL-2005 Oracle today announced the immediate availability of Oracle(r) Developer Tools for Visual Studio .NET 2003, a free plug-in that enables developers to use Microsoft Visual Studio .NET 2003 to develop and deploy Oracle Database 10g applications on Microsoft Windows. This plug-in integrates Oracle Database 10g and Visual Studio […]

>>Script Language and Platform: SQL Server ScriptThis script creates View ‘User_Table_Index_Details’ for more infotmation about indexes that exist in the database. Author: Anand Mahendra Download Script:User_Table_Index_Details.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. […]