(Willie Favero) Data warehousing and Business Intelligence (BI) have been around as long as DB2 and both concepts have presented implementation challenges. IT professionals have struggled with query performance due to the increasing size of the queries. Sometimes, simply having a query complete was
Other News
3 Steps to Configuring Oracle for Automatic Database Monitoring
(James Koopmann) The home-grown automatic monitoring of an Oracle database often results in time consuming, resource intensive tactic, in terms of DBA hours and development costs. A more elegant way to monitor database performance automatically is Oracle’s Automatic Database Diagnostic Monitor (ADDM
Day 12: Readers do not block writers; writers do not block readers
(Iggy Fernandez) Transactions that are executed serially, one after the other, may produce different results if executed in different orders. All such results are arguably valid.
SQL SERVER – 2012 Auditing Enhancement – On Audit Log Failure Options – Maximum Rollover Files
(Pinal Dave) Recently I was exploring SQL Server Audit and found something very interesting. I found two enhancements in the SQL Server 2008 Create Audit Screen.
Real-time monitoring and more cool features in the new InfoSphere Optim Performance Manager V5.1 for DB2 for Linux, UNIX and Windows
(Ute Baumbach) IBM InfoSphere Optim Performance Manager V5.1 for Linux, UNIX and Windows is a major step forward in bringing the ability to monitor very large workloads spanning 100 plus partitions.
Using a Clustered Index to Solve a SQL Server Deadlock Issue
(Ben Snaidero) At some time or another every DBA has been faced with the challenge of solving a deadlock issue in their SQL Server database. In the following tip we will look at how indexes and more specifically clustered indexes on the right columns can help reduce the chance of your applications r
Automated Application Testing
Automated Application Testing I have been testing the waters for different open systems Web Application testing tools. A Google search will provide you with many different tools. Currently I am taking WatiN for a test run (pronounced What-in). WatiN is short for Web Application Testing in .Net. WatiN is a porting of the popular WatiR product from Ruby to the […]
Automated Application Testing
Automated Application Testing In a previous life I was the manager of system testing for a custom appliction. We were testing a pretty sophisticated software application. The team had a combination of developers and business analysts. The team ratio was 60% analysts and 40% developers. The analysts generated the tests necessary for the application using a word template providing one […]
The DB2Night Show #Z18: Eggnog Party! World’s Largest DB2 Experts Panel
(Scott Hayes) Martin Hubel, Klaas Brant, Susan Visser, Phil Grainger, Christian Molero, Chris Eaton, Mike Winer, Ember Crooks, Iqbal Gorawalla, Willie Favero, Serge Rielau, Paul Zikopoulos, Burt Vialpando, Norberto Gasparotto Filho, John Hornibrook, and several others shared with us their highlights
On protecting MySQL from unwanted use of –skip_grant_tables
(Mike Frank) If a DBA needs to reset the mysql root password – one method of doing this is to run mysqld with -skip-grant-tables as a command line parameter. This is a bad practice for many reasons and as a DBA friend of mine says – it’s a lot like locking your door with the window open. If you are