(Patrick Wolf) Did you ever have had the requirement that a validation should only fire if the page item has been rendered (eg. if you have defined a condition or authorization)?
Other News
First the mainframe died, now someone thinks DB2 is on its way out
(Willie Favero) Neither of the above is even remotely true. However, people seemed bound determined to preach the end of all things that work well (or that I work on… LOL).
Scheduling Backups in Oracle Grid Control 10g — Mon-Fri
(Alex Gorbachev) While I like a lot monitoring capabilities and extensibility of Oracle 10g Grid Control it’s lacking a lot in Web GUI usability and ease of use.
Overview of pureQuery tools, Part 1: Increase productivity in Java database development with new IBM pureQuery tools
(Sonali Surange) Whether you’re a Java developer or always wanted to be one, you have come to the right place. Discover how IBM pureQuery tools make Java programming with SQL more productive than ever before. Code SQL and Java applications in the Java editor, and be equally productive in both. Never
Transaction Management
(Arup Nanda) LogMiner is an often ignored yet very powerful tool in the Oracle Database. It is used to extract DML statements from the redo log files—the original SQL that caused the transaction and even the SQL that can undo the transactions. (For an introduction to LogMiner and how it works, refer
Error Handling Examples
(Guy Harrison and Steven Feuerstein) In this second article in a three-part series, you will learn more about errors and exception handlers.
Understand when to use user-defined functions in SQL Server
(Tim Chapman) In the simplest terms, a user-defined function (UDF) in SQL Server is a programming construct that accepts parameters, does work that typically makes use of the accepted parameters, and returns a type of result. This article will cover two types of UDFs: table-valued and scalar-valued.
Reduce Aggravating Aggregation: Improve the Performance of History or Status Tables
(Merrill Aldrich) A third-party system that I manage has “history” or “status” tables following a common pattern: in the database, there is some entity (in my case, apartment units) that is labeled with a value indicating the entity’s status, and the value changes over time. Each of these entities h
Moving averages in MDX
(Mosha Pasumansky) Moving averages is an important statistical technique for analyzing time series data. It is often used to do forecasting or trend estimations, and it is especially popular for analyzing financial data. There are many different types of moving averages, from simple to weighted to e
How to use a stored procedure to monitor traces in SQL Server 2005
This article describes how to use a stored procedure to obtain the following information about one or about all traces in Microsoft SQL Server 2005: • Status • Properties • Events that are traced • Event columns • Filters that are applied