(Craig S. Mullins) Last year on the blog I posted a series of 12 DBA Rules of Thumb. As a quick reminder, these Rules of Thumb – or ROTS, are some general rules of the road that apply to the management discipline of Database Administration that I have collected over the years. These ROTs are broadly
Other News
Get rid of wrongly deleted InnoDB tables
(Shinguz) A MySQL user has delete its InnoDB table files for example like this:
SQL Editor Code Templates: A Must-Know Trick
(Jeff Smith) Oracle Docs just underwent a facelift, and I was testing to make sure that the code insight feature in SQL Developer was still able to pick out our code samples. Good news, it still works!
In-depth look into Oracle API Catalog (OAC) 12c
(Robert van Molken) With the release of Oracle Enterprise Repository 12c another product was released. Oracle API Catalog 12c (OAC) allows you to build a catalog of your organization APIs. OAC provides a layer of visibility to those APIs so application development knows what and which one to use.
Using the Exception plug-in node in IBM Integration Bus
(Sandipan Chakraborty and Benu Mohta) IBM Integration Bus doesn’t have a built-in node for capturing exception details in a message flow. This article shows you how to use the Exception plug-in node for this purpose, and reduce the development effort needed to create an exception flow.
Move Items From One List Box to Another List Box Using JQuery
(Rahul Saxena) In this article I explain how to move items from one list box to another list box using jQuery.
Do You Really Need Oracle Optimizer_index_cost_adj Set?
(David Fitzjarrell) It would appear that some DBAs are still using the optimizer_index_cost_adj parameter to make index access paths more ‘desirable’ to the optimizer. In decades past this might have been a good strategy however with the improvement in statistics gathering in recent relesaes of Orac
New features of December release of WAS Liberty
(Roman Kharkovski) Back in April 2014 IBM has announced new strategy for features delivery in WebSphere Application Server Liberty Profile, which IBM calls continuous delivery.
Timing Power Query Queries
(Chris Webb) If you’re interested in performance-tuning a Power Query query, you’re going to need a reliable way of telling how long your query takes to run. It’s not as easy as it seems to adapt your query to do this though, and that’s because of the way the M formula language works.
12 Things To Check With SQL Server To Prepare For Winter
(Chris Bell) There you sit, watching TV, when you hear it: “Analysts are predicting massive cold fronts this winter! Learn 12 tips to prepare for winter and the storm of the century tonight at 11!”