(Willie Favero) There were more DB2 product documentation updated in February in addition to the ones I already listed in my February 2, 2008 More updated DB2 documentation post.
Other News
How to create Datafiles in a Data Guard (10g) environment
(Rama Balaji) I came across this Data Guard situation lately where a datafile was added to the primary database, but failed during creation on the standby. The database version was 10.2.0.3 and standby_file_management was set to AUTO. (R)
Working with Range Variables and Let Statements in LINQ
(Paul Kimmel) Complicated things seem intuitively simple when complexity is cleverly hidden in the open. LINQ is a query language that at its basic is pretty simple to learn to use, but there is a lot of meaning in all of the aspects of a query. Understanding these cleverly hidden meanings will help
Creating Extensible and Abstract Layer
(Niranjan Kumar Kandaswamy) Abstraction and Extensibility is an important factor in modern day frameworks. If you are part of any framework team or developing a library that will be used by multiple divisions of your organization or community you will appreciate what I am talking about.
New Features for PostgreSQL Stored Functions
(Leo Hsu and Regina Obe) PostgreSQL 8.3 introduced a couple of new features that improves the processing of functions and makes plpgsql functions easier to write. These are as follows:
Monitor database file sizes with SQL Server Jobs
(Tim Chapman) The ability to automate administrative tasks is vital in almost any SQL Server database environment. In the SQL Server world, this scheduling of work is known as a “Job.” It allows you to perform such tasks as database maintenance, invoke executables, ActiveX script, Integration Servic
SQL Server 2005 Express Edition – Part 17 – Merge Web Synchronization
(Marcin Policht) As part of our series dedicated to SQL Server 2005 Express Edition, we recently have focused on its replication characteristics. As we have explained, its limitations in this area (such as agentless nature or inability to function in a role other than the subscriber) necessitated de
SQL Cache Dependencies
(Greg Low) A little while back I wrote an article on SQL Cache Dependencies. I had a colleague ask about these today so I think it’s time to blog it.
Workload Management: The Database Traffic Cop in DB2 9
(Howard Goldberg) Imagine New York City rush hour traffic during the holiday season. If you’ve never been there, suffice it to say that there are far more cars than the streets can accommodate. Horns blare as frustrated drivers get stuck in the middle of an intersection and end up blocking oncoming
Oracle BI EE 10.1.3.3/2 – Rolling Filters – Inter-row calculations
(Venkatakrishnan J) I got one pretty-interesting question the other day with regard to rolling filters and inter-row calculations. Lets understand the question first with a simple example. Lets consider a simple table containing Date, and the daily temperatures as shown below.