(Lester Knutsen) All good DBAs have some tricks up their sleeves to make their jobs easier. One I like to use is to write an SQL query of the Informix system tables and use the output of that query to generate another SQL script. This trick saves a lot of time (and reduces the possibility of missing
Other News
Display XML Menu Items Based On User
(Andrew Mooney) Displaying a menu that shows items based on the current user can be done easily by using roles in membership. In ASP.NET 2.0 membership and login controls make it easy to setup and maintain users for a web site. However, membership comes with some overhead. For example, a database (u
HOW TO: Use ASP to Query and Display Database Data in Excel
(Krishna) This article describes how to build a tab delimited text file dynamically from a SQL Server or Access database query, that can be opened in Excel from within Internet Explorer using Active Server Pages.
Integrating IBM Workplace Forms V2.7 with IBM WebSphere Portal V6.0 Document Manager
(Kiat Sing Lai) In this article, learn how to use IBM Workplace Forms V2.7 Integrator for WebSphere Portal V6.0 Document Manager to integrate your Workplace Forms offerings with your WebSphere Portal backend application to maximize the benefit of the two systems.
Can “between” and ‘>= and <=' Differ in Oracle?
(Alex Fatkulin) To between or not to between? Sometimes I wonder how “simple” things can end up being not where you would expect them to be.
Approach to unit testing of .NET database applications with NDbUnit and XPath queries
(Serioja Sidorov) Any developer should be a big fan of unit testing for a multitude of reasons. If a good set of unit tests are written for a software unit, it is possible to verify at any time if the code still behaves as assumed by the developer who has written the unit tests. It allows you, as th
Tuning LAMP systems, Part 2: Optimizing Apache and PHP
(Sean A. Walberg) Applications using the LAMP (Linux, Apache, MySQL, PHP/Perl) architecture are constantly being developed and deployed. But often the server administrator has little control over the application itself because it’s written by someone else. This series of three articles discusses man
Getting Inside the Optimizer
(Steve Callan) Everyone has them, even you. Don’t be afraid to admit you have some less than optimal code consuming resources in one or more of your production databases. The tuning advisor’s output of, “Hey DBA, you should do a better job tuning statement with a SQL ID 8ycxdfgyre2” is useful, but w
Understanding Open XML
(Matt Nicholson) Developers have long been building applications around Microsoft Office, using its rich API to build complex business solutions. However until now this has usually meant either running Microsoft Office in an unattended server mode, which is extremely resource intensive and not suppo
If You Build It, They Can Know
(Rod Coffin) In a previous article I showed you how to leverage Semantic Web technology to create a relatively sophisticated sommelier application that recommended wines based on an understanding of wine styles. The application’s understanding of wine was based on a model—a pre-existing ontology of