Featured Article(s) Easy SQL Server Database Monitoring for the Oracle (and SQL Server) DBA – Part 2 This article is the second in this series. It describes how to develop your own SQL Server polling and monitoring system. This article presents the repository ERD and the polling mechanism allowing you to easily retrieve instance, database, and failed jobs into the […]
Other News
Finishing Up with Exam 730
(Troy Coleman) In our look at DB2 certification exam 730, “DB2 9 Fundamentals,” we’ve previously reviewed the planning section, along with different editions of DB2 and the tools available. The final area within planning deals with data warehousing and business intelligence (BI).
Designing and Coding Applications for Performance and Scalability in WebSphere Application Server
(Byron Braswell, Marcelo Manhaes, James Pagadala, Kon Samartzis and Eddy Tjandra) In many WebSphere Application Server environments, support personnel often get more questions on application performance and tuning than WebSphere Application Server tuning. (pdf)
Working with DragPanel AJAX Control
(Nidal Arabi) Enriching your web application has been kind of hard before AJAX. However, with Microsoft AJAX control toolkit, that job is becoming easier. In this article I will explain the DragPanel control with a help of a sample project.
XML data integration for SOA goes open source
(Rich Seeley) XAware Inc. is going open source today with the fifth generation of its XML data abstraction and federation tools for Web services and service-oriented architecture applications. (R)
Using DBMS_SYS_SQL to Execute Statements as Another User
(Alex Fatkulin) I do realize that for most of you, there may be nothing new about the dbms_sys_sql package – knowledge of it has been floating around for quite a while. I myself discovered this package a couple of years ago while playing around with HTMLDB’s (now APEX’s) internals. I’m posting this
Ask Ben: Parsing A Microsoft XML Rowset Into A ColdFusion Query
(Ben Nadel) Hi Ben, do you know a trick/pattern for getting an cfhttp response variable that contains the following and turns it into a query?
MySQL and Disk Transfers Per Second
(Kevin Burton) The UNIX iostat command (along with vmstat) is a great tool for finding bottlenecks in your disk subsystem.
Oracle 11G – Follows in Trigger
(Patch) I’ve seen a presentation on the 11G new features from Alex and Lucas at Amis. One of the questions posed there was when you are using the new follows option in triggers, what would happen if you have two triggers following the same one. A bit like the way it’s done right now.
Identify dynamic and static init.ora parameters
(Vikram Das) To identify whether an init.ora parameter is static (changing it requires restarting database) or dynamic (can be changed without restarting database), let us take a look at the structure of the v$parameter2 view which is like v$parameter, but includes extra rows for long parameters. OR