(Linchi Shea) Have you ever run into a situation where you’d like to search many of your SQL Server instances to look for a specific piece of information? Ideally, you should maintain an inventory database of all your SQL Server instances so that all you need to do is query that database. In case yo
Other News
XForms tip: Dynamically create controls with the repeat, select1, and itemset elements
(Tyler Anderson) Forms can have lists of data, which are difficult to display using regular HTML forms. The select1 and itemset elements have a lot of flexibility and are very similar to the select or option tags in HTML. The repeat element really shows its power here in that you can have a list of
Pop Rivett and the Suspect Database
(Pop Rivett) Blake Savage gazed in horror at the string of errors in the database activity log of his communications module. It was always at the worst possible moment that SQL Server grenaded itself and produced a corrupt database. Without the database data, all off-planet communications were impos
Paging in DataGrid
(Sanjay David) This is application logic this code demonstrates the access to the access Database. The result sets are stored in the DataSet and it is assigned to the Datagrid for Datasource.
TechTip: Full Outer Joins on DB2 for i5/OS
(Gene Cobb) If you are a System i application developer using SQL for data access, you may have encountered the need to implement a full outer join. Or perhaps you have implemented full outer joins on another database platform and are porting your application to support DB2 for i5/OS. In either case
A DB2 Connect quick tip
(Willie Favero) I don’t have the chance to make very many posts that cover anything that doesn’t run on a z9. Today’s post is a little different. I’m often asked what DB2 Connect FixPak you should be on if you are running DB2 for z/OS Version 8. In 99.9% of the cases, the answer is pretty easy. In t
Differences between tables and views
(Brian Peasland) What are the differences between tables and views? (R)
Managing the Oracle HTTP Server
(Sam Alapati) Oracle HTTP Server (OHS) is OracleAS 10g’s Web Server component and is based on the Apache 1.3 Web server. OHS handles client HTTP requests and can serve static and dynamic content in response. OHS supports Server Side Includes as well as providing load-balancing capabilities. As you p
Use of rand() in stored procedures replication
(Il Corra) If we have a replication architecture and we are using stored procedures, we need to pay attention to the use of rand() inside the SPs.
Unleashing the power of WebSphere Portal V6 Search with the Portal Search Toolbox
(David Konopnicki and Eitan Shapiro) Do you want to empower your portal users with productive and advanced search capabilities such as suggested links or faceted search navigation? You can do just that with the Search and Indexing API (SIAPI) , published for IBM WebSphere Portal V6.0. This article d