(Arvind Shyamsundar) It is a documented fact that using the MAX specifier can result in TEMPDB usage in specific cases. From the TEMPDB whitepaper, some of these can use ‘internal object’ space within TEMPDB:
Author: SSWUG Research
Using Bootstrap Modal with Splunk Simple XML
(Jason Conger) While working on a performance dashboard recently, I wanted an area to further explain the performance metric currently being displayed without taking up too much screen real estate.
Check SQL Server Database Consistency and Backups Without Impacting Performance
(Richard Vantrease) Two key responsibilities of a DBA are ensuring that the databases do not get damaged, and that they can be recovered if they do get damaged. If a database does get damaged, detecting the damage as quickly as possible is very important.
ProgressBar using JQueryUI and SignalR
(Kashif Amin Makhdoom) Today, we can see more and more web applications developed are equipped with AJAX. Although the success of AJAX compelled more developers to adapt and shift towards Ajax-based applications, still we have some areas left behind specially when it comes to real-time progress indi
PERFORMANCE_SCHEMA vs Slow Query Log
(Peter Zaitsev) A couple of weeks ago, shortly after Vadim wrote about Percona Cloud Tools and using Slow Query Log to capture the data, Mark Leith asked why don’t we just use Performance Schema instead? This is an interesting question and I think it deserves its own blog post to talk about.
How to Start the PL/SQL Debugger
(Jeff Smith) Starting the debugger CAN be as simple as hitting this button in Oracle SQL Developer:
Optimizing BDFS jobs using InfoSphere DataStage Balanced Optimization
(Rao Lella) This article explains how to use InfoSphere DataStage Balanced Optimization to rewrite Big Data File Stage jobs into Jaql. BDFS stage operates on InfoSphere BigInsights. BDFS stage is a new stage introduced in InfoSphere Information Server 9.1.
ADF BC Performance – View Object Instance Lazy Activation
(Andrejus Baranovskis) ADF BC is a great framework to manage data, but one thing it does really smart – ADF BC View Object instance lazy activation. You must know by now – passivation/activation events in ADF BC are relatively expensive in terms of performance.
Oracle JDBC Connection Tester
(Bobby Curtis) From time to time, when working at various sites I have to check connections to a database. If you have been an Oracle DBA for some time, you already know that the listener has to be up and services have to be registered before you can connect from a remote host.
Book Review: DB2 10 for Z/OS Database Administration: Certification Study Guide
(Prasad Mani) The DB2 10 for Z/OS Database Administration Certification Study Guide (Exam 612) is goal-oriented and successfully fulfills its primary goal of helping those who want to certify on DB2 Z/OS as a DBA.