(Muthusamy Anantha Kumar) Part of Database Administrator’s job is to monitor blocking in SQL Server. By taking advantage of the Microsoft Knowledge Base article 271509, we can monitor the blocking and capture the SQL statements that are involved in the blocking to a file. This can be accomplished by
Author: SSWUG Research
Disaster Recovery with DB2 UDB for z/OS
(Paolo Bruni) DB2 for z/OS is the database of choice for critical data for many enterprises. It is becoming more and more important to protect this data in case of disaster and to be able to restart with a consistent copy of the DB2 data as quick as possible and with minimal losses. A broad rang
Essential Facts about Index Covering in DB2 Universal Database
(Alexander Kuznetsov) This article uses examples to illustrate cases in which adding a column or two to an index can boost a query’s performance by “covering” the columns used in a SELECT statement. The DB2 optimizer is very good in recognizing such situations and can choose a very efficient executi
Are You Ready for the ACID Test?
(Christopher Byrne) Though Lotus Notes/Domino developers and administrators may think that someone on mind-altering substances created relational database concepts relating to systems controls, I am not talking about The Electric Kool-Aid Acid Test, made famous by Tom Wolfe in the 1960s. And I do no
Access queries with a wildcard character do not export data to an XML document
When you export an Access query to an XML document, and the query contains a Microsoft Jet wildcard character such as an asterisk (*) in the criteria, the data is not exported to the XML document. Therefore, the resultant XML document does not contain any data. The query functions correctly if yo
Stored Procedures on PHP and Microsoft SQL Server
(David Clark) Though it’s not as common a combination as PHP and MySQL, PHP and Microsoft SQL Server can be a powerful team. You can query SQL Server databases easily and effectively using the PEAR database abstraction layer, just as you would a MySQL database. But once you start trying to use one o
Benchmarking PHP with no BS
(John Lim) This article focuses on a rather difficult topic – understanding the performance characteristics of PHP. It is difficult, not because PHP is complex, but because PHP’s performance depends on many outside factors such as software versions, available hardware, operating system settings,
DB Change Management: An Automated Approach – Part 3
(Darren Fuller) In part 2 Darren Fuller examined an automated approach to database change management and outlined the essential elements of an automated methodology. In this third article of a 4 part series, he lists the requirements to implement an automated approach and highlights some of the bene
The State of Python-XML in 2004
(Uche Ogbuji) The table below lists the currently available Python-XML software that I judge to be significant. It is not a list of every bit of software in Python that has anything to do with XML. For example, I do not list pyglade (part of PyGTK), which is software for generating user interfaces i
Using Hibernate to Persist Your Java Objects to IBM DB2 Universal Database
(Javid Jamae and Kulvir Singh Bhogal) Hibernate, an open source application, provides a way to easily persist your Java objects to DB2 Universal Database without writing a single line of SQL code. Our authors show you how.