(Elie Muyal) When speaking about the modernization of the IBM i, usually the first thing that comes to mind is the modernization of the user interface, since it’s the visible part of the application.
Other News
Creating a JBoss software pattern on IBM PureApplication System
(Ashok Iyengar and Greg Scott) This tutorial shows you how to use the Extend and Capture feature to create a software pattern on IBM PureApplication System using non-IBM software such as JBoss Application Server.
Show SQL Server Data Table in a XML Using SQL Query
(Rahul Saxena) In this article I explain how to show our SQL Server data table in a XML format using SQL Query.
ORA-4068 and CONSTANT keyword…good and bad
(connormcdonald) Anyone that has ever coded PLSQL will be familiar with the error ORA-4068, where you had some state persisted in a session due to a package variable, and then when you change the package, the state is cleared along with an ORA-4068.
SQL Developer 4.1 – Log All the Queries!
(Jeff Smith) Oracle SQL Developer is a graphical user interface and integrated development environment for Oracle Database. As you can imagine, a few clicks can results in an awful lot of queries being executed on your behalf.
MySQL’s INNODB_METRICS table: How much is the overhead?
(Peter Zaitsev) Starting with MySQL 5.6 there is an INNODB_METRICS table available in INFORMATION_SCHEMA which contains some additional information than provided in the SHOW GLOBAL STATUS output – yet might be more lightweight than PERFORMANCE_SCHEMA.
Customizing Test Plan and Test Suite Work Items using Visual Studio 2013 and Microsoft Test Manager 2013
(Gouri Sohoni) In this article, we will discuss benefits of Test Plan and Test Suites in Visual Studio 2013 Update 3 as work items, which can now be customized to suit the specific needs of an organization.
Making sense out of optimizer trace files
(savvinov) Sometimes the optimizer makes really odd decisions. We can use optimizer (gevent 10053) tracing to obtain clues as to why such decisions were taken, but itfs not simple. First, such trace files tend to be big. Second, they donft always contain the necessary information. There is a si
Moving Items from One Multi Select List To Another using jQuery
(Suprotim Agarwal) This article demonstrates how to use jQuery to move items from one multi select list to another.
Canned Application Indexes and Maintenance
Indexes are important for any database. For canned packages the application designer makes the best indexes they can. The problem is that indexes on any system go through a lot of change as data is added, updated or deleted. Data changes cause indexes to become fragmented, and statistics about the indexes to become inaccurate. As your data is modified it […]