(Frederic Descamps) There is one new feature in MySQL 5.6 that didn’t get the attention it deserved (at least from me 😉 ) : “DATA DIRECTORY” for InnoDB tables.
Other News
Understanding XML and XPath
Microsoft Scripting Guy, Ed Wilson, is here. One of the things that confused me for a long time about using the Get-WinEvent cmdlet is the difference between the –FilterXPath parameter and the –FilterXml parameters.
HTML 5 Input Types
(Sourabh Somani) Forms are the essential and inevitable component of any web application and Website. HTML 5 has many new input elements. To do the same work in a previous version of HTML then we needed an explicit implementation by using JavaScript or jQuery or other framework.
WebSphere Commerce Performance Tests with Rational Performance Tester, Part 3: Problem determination
(Charek Chen and Noureddine Brahimi) Part 3 of this three-part article series describes where some common test errors occur and how to determine the problem.
How to Tell When an Index Reorg is Needed
(Ember Crooks) My earlier post on table reorgs covered Reorg’s place in a database maintenance cycle and running reorgchk. If you haven’t already read it, check it out:
New Stored Procedure Simplifies EXPLAIN Maintenance
(Troy Coleman) Managing EXPLAIN tables can be time-consuming. DB2 developers often create EXPLAIN tables and allow them to exist on the system for years without being upgraded to include the latest columns or support the newer table types that have been introduced in recent DB2 releases.
Bin Fitting problems with SQL
(stewashton) “Bin Fitting” or “Bin Packing” means putting the greatest quantity in the smallest number of “bins” or containers. There are some good solutions with the MODEL clause, but the most concise and efficient solutions use the new 12c MATCH_RECOGNIZE clause.
Audit space threat – a perfect storm
(Dom Brooks) According to http://en.wikipedia.org/wiki/Perfect_storm:
SCAN listener logs – where are they?
(Neil Chandler) These are a bit of a pain as their location isn’t intuitive. So to remind me where they are:
SQL Server – Script to Configure TempDB Files per Number of Logical Processors
(Hareesh Gottipati) In order to reduce Tempdb contention one of the best practices is to maintain multiple sized Tempdb data files, matching the number of processors and up to a maximum of 8.