(Mark Goetsch) In this article you’ll see an exciting use for XMI—reading the connections between two server nodes in a UML diagram using C#. While my last XMI article collected information about the hardware in a system from XMI, capturing the connections can help answer questions about how servers
Other News
Better Exception Handling in Visual Studio 2005
(Mahesh Chand) Better exception handling is one more nice feature in Visual Studio 2005. You remember the exception dialog in prior versions of Visual Studio which used to popup whenever an exception was occurred when you were compiling and debugging the code.
Stored Procedures in MySQL 5.0
(Carsten Pedersen) MySQL 5.0 introduced Stored Procedures which allow us to automate or program our way out of many tasks on directly on the server rather than having to write external scripts to do complex manipulation of data.
Views in SQL Server
(Steve Manik) A view is a virtual table that consists of columns from one or more tables. Though it is similar to a table, it is stored in the database. It is a query stored as an object. Hence, a view is an object that derives its data from one or more tables. These tables are referred to as base […]
RACing ahead with Oracle on VMWare – Part 3: Installing Oracle 10g Release 2 Clusterware on a 2-node Windows 2003 Enterprise Edition Server
(Tarry Singh) Since the last article, I have received several e-mails requesting a description on the installation of Clusterware on a 2-node windows 2003 server with VMWare. We will cover the installation issue on RHEL4 Release 2 (Nahant) as well, in a later article.
Build apps using Asynchronous JavaScript with XML (AJAX)
(Naveen Balani and Rajeev Hathi) AJAX (Asynchronous JavaScript with XML) enables a dynamic, asynchronous Web experience without the need for page refreshes. In this tutorial, you will learn to build AJAX-based Web applications — complete with real time validation and without page refreshes — by fo
Enforce development standards with code reviews
(Tony Patton) One of the greatest aspects of application development is the plethora of ways to solve a problem. This flexibility affords developers a lot of creativity. However, it may not be wise to have all your developers stretching their creative limits at once.
DBA Checklist Part 4 – Daily Tasks
(Dwaine R. Snow) Verify that all instances are up and running. This can be done in a number of ways: –Use Health Center –export/set DB2INSTANCE=instancename –and run db2start –Attach to all instances –On UNIX or Linux, run ps –ef | grep db2sysc –Verify there is one db2sysc process
Using BIRT To Report On Bugzilla in MySQL
In this example, we are going to develop a BIRT listing report. We will use a bugzilla database installed on MySQL as our data source. What we would like to show in this report is a listing of all current bugs in the system. This will be a simple yet powerful report, showing groupings on Bugzilla Pr
System.Transactions: Implement Your Own Resource Manager
(Sahil Malik) One of the biggest paradigm shifts that has occurred with the introduction of .NET 2.0 probably is the introduction of System.Transactions. I talked briefly about System.Transactions in my previous article about SQLCLR, but why should transactions be limited to databases? Don’t we need