Video Programming for IT Professionals
Other News
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
Building a Data Validation System with the Prototype Pattern with PHP 5
(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
Security guru blasts Oracle’s patching policies
(Mark Brunelli) Oracle could issue a million new security features when it debuts Oracle Database 11g later this year, but it wouldn’t change the fact that Oracle’s patching problems still need to be addressed, according to Oracle Security Handbook author Aaron Newman. (R)
Oracle to DB2 Conversion Guide – Converting to DB2 for Linux, UNIX, and Windows
(Whei-Jen Chen, AnNa Choi, Arthur V Sammartino, Carlos Eduardo Abramo Pinto, Fraser McArthur, Marina Greenstein, Nora Sokolof and Scott J. Martin) This redbook will provide guidelines for migrating existing Oracle 10g database and applications to DB2 9. (pdf)
Sending E-mails with ASP.NET 2.0 using C#
(Anand Narayanaswamy) Nowadays, web masters prefer to receive information from their users or customers through a contact or feedback form placed on the website. ASP.NET 2.0 provides a simplified approach to achieve the task as compared to ASP.NET 1.1. In this part of the series, we will examine how
Parallelism and zIIP specialty engines – it just keeps getting better
(Willie Favero) Yes, I know you have heard all this stuff already about which workloads are eligible to run on a zIIP specialty engine. Although I am going to rehash some of that old news, I do have what I think is a piece of up-to-the-minute zIIP details that you might find mildly interesting, espe
Custom schemas revisited
(Doug Mahugh) I’ve seen some signs of confusion about custom schema support lately. For example, I’ve seen a vendor claim that Open XML’s support for custom schemas is “essentially inherent in XML itself” and that “there is nothing that OOXML supports via custom schemas that ODF 1.0 does not already
Oracle Session Tracing Part I
(James F. Koopmann) This is the first in a series to introduce some of the new tracing concepts and options within Oracle.
What’s swimming in your bufferpool?
(Tony Voellm and Gaurav Bindlish) When doing a performance investigation a useful thing to do is look at what data is present in the buffer pool. This can be used to analyze impact of running a query on the state of data pages in buffer pool. By collecting the pre and post picture of buffer pool, y