DatabaseJournal.com Staff

Use our handy database link guide to find the best and most useful database-focused sites from all over the Web. Guides and Resources These are sites like ours, offering a mix of tutorials, news, forums, and reviews related to all database issues. NewsNow: Databases Aggregated collection of breaking database-related news from around the Web. Articles […]

Amar Kumar Padhi, amar_padhi@hotmail.com Oracle 8i introduces an e-mail server option that allows you to send mail from within your code. So imagine firing e-mails to concerned persons when a critical parameter is altered, when a huge report is generated, when a night-job process fails, when a database has some issues (for DBAs), when an […]

Danny J. Lesandrini currently works as the IT Director for Pharmatech Oncology Inc. at http://www.pharmatechoncology.com/. He holds Microsoft Certifications in Access, Visual Basic and SQL Server and has been programming with Microsoft development tools since 1995. Danny maintains a web site with free code samples at http://amazecreations.com/. Article Series Current Articles

Live Event: November 7, 2002 – 9:30am to 11:00am Pacific Time / 12:30pm Eastern Time. Databases are increasingly at the heart of any business, making reliability and security a topline need. Learn about the built-in features that make SQL Server a highly reliable, highly secure platform. Gain a better understanding of the methods, best practices, […]

This script will take the name of a specific log file, its database, and a desired file size, and will then proceed to compress the given log file. All that needs to be entered is the “tx-logname”, “DESIRED_FINAL_SIZE_IN_MB”, and “basename”. Author: Conrado Pacheco DBCC SHRINKFILE ( , ,TRUNCATEONLY ) go BACKUP LOG WITH TRUNCATE_ONLY […]

EADP (Enterprise Application Development Platform) for VA Java is a development platform for building WebSphere applications that communicate with DB2. Most of the applications can be built using bean customizations instead of Java programming. EADP for VA Java can be used to edit and present documents, compile and present information from relational databases, and search […]

[From News.com] IBM announced Thursday that the price of its new version of DB2 would be $7,500 per processor, nearly half the current cost of $14,000 per processor. The new entry-level DB2 Workgroup Server Unlimited Edition will be marketed to mid-size companies (companies with fewer than 1,000 employees), serving the same role as the current […]

These three small scripts come in quite handy when you need to drop and re-create foreign key values for every user table. The scripts run under MS SQL Server 7.0 as well as SQL Server 2000. The initial script creates the view called sysfkeys and then runs the following scripts in Query Analyzer. The second […]

The Access Workbench is a program that will help you manage your Access databases. The Workbench will allow you to see the users/computers using your database, lock out new users so that you can do maintenance, and view who is in your workgroup files and your LDB files. For developers and administrators, the software supports […]

[From IBM developerWorks] How to start and stop DB2 processes, and how to use the DB2 Command Line Processor and Control Center This article guides you through setting up and using DB2 7.2 with the Command Line Processor. You’ll also learn to use the graphical Control Center, which helps you explore and control your databases, […]

Firebird 1.5.0 Alpha 3 is now available on SourceForge.net, the world’s largest Open Source software development Web site. Firebird is a relational database offering many ANSI SQL-92 features that runs on Linux, Windows, and a variety of Unix platforms. Firebird offers excellent concurrency, high performance, and powerful language support for stored procedures and triggers. It […]

askSam Systems recently announced the release of askSam’s Web Publisher version 5. The new Web Publisher makes publishing large amounts of searchable information on the Internet fast and easy. Without any knowledge of HTML, the Web Publisher lets you create new documents or import existing documents and publish this information in a searchable database on […]