(Joe Kunk) One of the primary themes in Windows 8 is availability over a wide range of hardware platforms, from low-power smartphones to portable tablets to desktop PCs. Windows 8 will have the Metro mode — very similar in behavior and appearance to Windows Phone 7 — that will run across all the p
Other News
Planning, Scoping and Recon Techniques
(David Dodd) The purpose of this article is to describe some tools and techniques in performing the planning, scoping, and recon portion of a penetration test.
V$BLOCKING_QUIESCE and the difference between killing and disconnecting
(Matthias Rogel) Testing how to quiesce an instance today:
Curious Case Of The Ever Increasing Index Solution (A Big Hurt)
(Richard Foote) Based on the excellent comments in the Quiz post, we have some clever cookies out there.
Speeding up the gathering of incremental stats on partitioned tables
(John Hallas) 11G introduced incremental global stats and the table WRI$_OPTSTAT_SYNOPSIS$ contains synopsis data for use in maintaining the global statistics. This table can grow very large and Robin Moffat has produced a good blog post about the space issues – note we both worked at the same s
Optimizer Tracing
(Dave Stokes) A a new tracing capability has been added to the MySQL optimizer with 5.6.3. Optimizer Tracing goes beyond EXPLAIN EXTENDED to show how the optimizer treats queries. The demonstration of this feature at Oracle Open World had several noted DBAs speechless.
The DB2Night Show #66: Top 10 Tips for e-Commerce Databases, Ember Crooks
(Scott Hayes) Over the top! Our special guest, Ember Crooks, Technology Manager for Rosetta, under committed and OVER DELIVERED! Each of her Top 10 tips for e-Commerce database success were filled with important ideas and considerations!
A MIN, a VIEW, a UNION ALL, and a DB2 SQLSTATE Mystery Solved
(Robert Catterall) Last month, a DBA at an organization with which I work sent me a query that was getting a puzzling result. The query executed successfully in their DB2 for z/OS environment, generating the correct and desired result set; however, it was also getting an SQL warning code on executio
Configuring the IBM Business Process Manager V7.5 environment for a typical installation
(Hua (Ted) Cheng) Quickly installing and configuring a working environment for IBM® Business Process Manager is important for new users. The “typical installation” option provides a simple method to install Business Process Manager V7.5.
Publishing XML data in HTML and PDF using a single XSLT stylesheet
(Claudius Teodorescu) Storing data, for example as part of an XForms/REST/XQuery [XRX] architecture (see Resources), is commonplace today. You can query, retrieve, and serialize data stored in this manner to the desired format.