(Alejandro Gervasio) It’s unusual to create multiple instances of a class, but certainly it may happen during the development of a PHP application. To solve this issue quickly and with minor hassles, the prototype design pattern can be really useful. If you want to learn more about it, this article
Author: SSWUG Research
New OLAP Capabilities [DB2 9 for z/OS]
(Craig Mullins) DB2 9 for z/OS offers several new SQL improvements focused on improving OLAP functionality. The OLAP functions provide the ability to return ranking, row numbering, and existing aggregate function information as a scalar value in the result of a query. You can include OLAP specificat
How fast is MySQL Table Checksum?
(Xaprb) A few people have asked me how fast MySQL Table Checksum is. As with so many other things, it depends. This article shows how long it takes to checksum real data on a production server I help manage, which might give you a rough idea of how long it’ll take on your servers.
Take Five with SQL Server 2005: New XML Capabilities in SQL Server 2005
(Kevin S. Goff) This is the first installment in a monthly, ten-part series on new developer features in SQL Server 2005. The objective of this series is to provide software developers with quick information and meaningful examples that demonstrate new capabilities in SQL 2005. Many developers can t
Debugging SQL Server 2005 Stored Procedures in Visual Studio
(Scott Mitchell) With Microsoft SQL Server 2000 it was possible to debug stored procedures from directly within Query Analyzer (see Debugging a SQL Stored Procedure from inside SQL Server 2000 Query Analyzer for more information). With SQL Server 2005, however, this functionality was moved out of SQ
DBA Interview Questions
(Sean Hull) There are nearly an infinite number and combination of questions one can pose to a DBA candidate in an interview. I prefer to lean towards the conceptional, rather than the rote, as questions of this kind emphasize your foundation, and thorough understanding. Besides, I’ve never been one
‘plus archivelog’ and RMAN optimization
(Shervin Sheidaei) I just want to raise a warning flag for DBAs using RMAN and flash recovery area in Oracle 10g.
DB2 and Ruby on Rails, Part 1: Getting started with DB2 and Ruby on Rails
(John Chun, Christine Law, Naomi Ngan and Alex Pitigoi) The emergence of the Ruby language, coupled with the powerful Rails framework, provides a myriad of opportunities for Web solutions development. With the introduction of the IBM_DB adapter and driver, Rails applications can now interact seamles
Performance Tuning – Implementing Indexes
(Buck Woody) One of the most important knobs and levers you have in tuning a system from the database perspective is in your database’s indexes. The indexes you apply (or don’t apply) can create performance gains far greater than any hardware changes you can make. Because the effect of the indexes i
DB2 for z/OS maintenance: It’s time to reevaluate your strategy
(Willie Favero) I have always been troubled by the maintenance strategies some of my friends have chosen for their DB2 for z/OS subsystems. In fact, in some cases, I might almost label their strategies as reckless; they’re just asking for a DB2 problem to occur. I was thinking that maybe I’m not the