(James Koopmann) The homegrown automatic monitoring of an Oracle database often results in time consuming, resource intensive tactics, in terms of DBA hours and development costs. A more elegant way to monitor database performance automatically is Oracle’s Automatic Database Diagnostic Monitor (ADDM
Other News
Manage DB2 for z/OS applications performance using InfoSphere Optim
(Thuan Bui and Erin A. Wilson) See how the staff at one fictional organization, the Great Outdoors Company, takes advantage of InfoSphere Optim integrated data management solutions for performance management.
Database Controls are not Only History Tables
DBTechCon – Spring 2011 The SSWUG Spring 2011 virtual conference is quickly coming together. You can go to the registration page and see profiles for presenters, and summaries for the sessions to be presented. Without a doubt, this will be the largest virtual conference in the information technology industry. Access more than 70 sessions from well seasoned professionals with in-depth […]
XSLT: How to convert NaN (Not a Number) to zero
(Attila Pápai) Are you using XSLT to render pages in Sense/Net? I’m sure you have already seen NaN when you wanted to work with numbers.
ORA-00439: feature not enabled: Deferred Segment Creation
(Flavio Casetta) If you are wondering why after exporting with EXPDP a schema from an Oracle Enterprise Edition 11gR2 database and importing it on an Oracle Standard Editon 11gR2 you are getting errors like:
PTFs for the DB2 9 and DB2 10 Diagnostics Guides are available
(Willie Favero) As part of the December 2010 product documentation update, APAR PM26884 has been updated with the numbers for the PTFs that allow you to download the PDF version of the DB2 for z/OS Diagnosis Guide and Reference for DB2 9 and DB2 10.
jQuery Does Not Post Undefined Values In AJAX Requests
(Ben Nadel) When you trigger an AJAX request in jQuery, you have the option to supply a “data” object with the request. This data object contains a collection of key-value pairs that get posted as individual form (or url) parameters.
Create a synonym in MySQL
(Michael McLaughlin) A friend wanted to know how to create a synonym to a library of stored functions and procedures in MySQL. I had to deliver the sad news that you can’t create a synonym in MySQL 5.0, 5.1, or 5.5. You need to write a wrapper function or procedure.
Different ways to secure the SQL Server SA Login
(Jugal Shah) What are the different ways to secure the SA login? Everyone is aware of the SA login and its administrator rights, so it is very risky if some unwanted users try to use the SA account or hack the SA account. It is also not advisable to use the SA account in any application or by users.
SQL Server 2008 : Explaining XML – XQuery and XPath
XQuery is a language used to query XML data. You can query and manipulate data from XML documents or data sources that can be viewed by XML. There are four simple methods for querying XML data with XQuery: