DatabaseJournal.com Staff

[From MySQL Announcements] MySQL 4.0.20, a new version of the popular Open Source/Free Software Database Management System, has been released. It is now available in source and binary form for a number of platforms from our download pages at http://www.mysql.com/downloads/ and mirror sites. Note that not all mirror sites may be up to date at […]

[From Altova Inc.] BEVERLY, Mass., May 17, 2004 – Altova® Inc. (www.altova.com) producers of Altova XMLSPY®, the world’s leading XML development environment, today announced the immediate availability of Release 4 of its Version 2004 product line. Among the major enhancements are greatly extended data-mapping functionality in Altova MAPFORCE™ 2004, a completely redesigned Altova STYLEVISION® 2004, […]

This script will print tables according to their FK dependencies, making it helpful in determining the hierarchy of tables in a database. Author: Uri Margalit Download Script: table_hierarchy.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 […]

[From webpronews.com] Benefits of Oracle Certification In the present day competitive world, it has become essential for professionals, especially in the field of Oracle Database Administration, to acquire proper certifications to have an edge over others. Oracle Certified Professional Exams are a boon for the Oracle DBAs to prove their underlying skills and expertise and […]

[From Wingenious] Wingenious announces SQL Server Tools, a new SQL Server utility product. The SQL Server Tools family of applications has many features that target various levels of a system such as servers, databases, tables, fields, code, and data. Visit http://www.sqlservertools.us for more information and a trial version. Visit http://www.wingenious.com for more resources, including a […]

This article will explore the uses, restrictions and benefits of User Defined Functions in Microsoft SQL Server 2000 Introduction User Defined Functions are compact pieces of Transact SQL code, which can accept parameters, and return either a value, or a table. They are saved as individual work units, and are created using standard SQL commands. […]

[From eWeek] In an effort to accelerate application development and enhance administrator productivity, IBM is rolling out new automation features with links to development technologies in a forthcoming DB2 Universal Database upgrade. The upgrade, which is code-named Stinger and will be released to open beta this week, includes 200 new features that enhance the software’s […]

[From Daffodil Softwares Ltd.] Daffodil Software Limited announces the release of Daffodil DB v3.1 with several improved and enhanced features like: Full-Text Search support Support for invoking External Java Methods Import and Export of databases Backup and Restoration of data XA-Compliance To download an evaluation copy of Daffodil DB v3.1: http://daffodildb.com:8080/eval/filldetails.jsp The article continues at […]

>>Script Language and Platform: SQL Server This user defined function will search procedures, views and functions for the given string. –usage select * from dbo.udf_Findstringinobjects (‘Quantity’) –results CK_Quantity others Products by Category View Invoices View Order Details Extended View Order Subtotals View Product Sales for 1997 View CustOrdersDetail Stored procedure CustOrderHist Stored procedure SalesByCategory Stored […]

>>Script Language and Platform: MS SQL Server Whenever stored procedures and user defined functions are dropped and recreated in production, it is very tedious to find who had permissions on the dropped procedures and functions before. This script will generate the GRANT EXEC statements for all existing users in the database who have execute permissions. […]

>>Script Language and Platform: Oracle 8i/9i Enterprise Edition This functionality to support fine-grained access control is based on dynamic predicates, where security rules are not embedded in views, but are acquired at the statement parse time, when the base table or view is referenced in a DML statement. A dynamic predicate for a table or […]

By James Lee Generating and storing large volumes of data has reached a critical mass. Where companies once managed megabytes and gigabytes, they now handle terabytes and petabytes of data and storage. Comprehensive application software, the Internet and new computing and storage technologies have made it easier to create, collect and store all types of […]