(Willie Favero) Have you been out on the DB2 for z/OS Version 8 Books website lately? You should. As I am always suggesting, you need to visit this page frequently to make sure that you are always working from the most up-to-date information.
Author: SSWUG Research
Chasing Cars… and XML
“I DON’T KNOW why my dog chases cars,” goes the old joke. “After all, what would he do with it if he ever actually caught one?”
TechTip: Panoply of Free Database Servers
(Michael Sansoterra) Last October, I wrote about learning how to write Microsoft .NET code using one of the free Visual Studio Express Editions. In this tip, I continue with the “free” motif by describing a few of the free database engines that are available.
Concurrent model in ADO.NET, ways that allow to negotiate disconnected model restrictions for Oracle databases
(Michael Milonov) The most popular instrument to access database data for .NET applications is ADO.NET. This set of components contains three main classes those are used to manipulate and store data: DataReader, DataSet, and DataAdapter. DataReader is only able to read data and can’t work as data so
Sun to Spend $200M Moving to Oracle 11i
(Peter Galli) Sun Microsystems will spend more than $200 million consolidating all of its internal business applications onto Oracle 11i and, while the move is expected to generate minimal savings in fiscal year 2008, it should yield major savings in fiscal year 2009 and beyond.
On importing data from Oracle into Excel with CopyFromRecordset
(René Nyffenegger) In my last blog entry, I have written a little Excel macro. This macro opens a connection to an Oracle database, issues a select statement and then iterates over each record within the result set. For each record, it also iterates over each attribute within this record.
DB2 9 Application Development exam 733 prep, Part 1: Database objects and programming methods
(Clara Liu) Get an introduction to the different types of database objects and programming methods. The first in a series of nine tutorials, use this series to help prepare for the IBM DB2 9 Family Application Development Certification exam (Exam 733). (R)
Logical Functions: IsAncestor(): Conditional Logic within Calculations
(William Pearson) In this lesson, we will expose another logical function which we can use for testing a member or level at which a cell is being calculated, the IsAncestor() function. The general purpose of IsAncestor() is to return whether or not a specified member is an ancestor of another member
FIX: CPU utilization may approach 100 percent on a computer that is running SQL Server 2000 after you run the BACKUP DATABASE statement or the BACKUP LOG statement
Consider the following scenario. You start the SQL Server 2000 service. You execute the BACKUP DATABASE statement or the BACKUP LOG statement at least one time. In this scenario, CPU utilization may approach 100 percent. After approximately 15 minutes or less, CPU utilization decreases.
My first steps with Oracle BI Publisher Enterprise Edition 10.1.3.2: create a report based on the OraBlogs rss-feed
(Lucas Jellema) After receiving a new, pretty powerful laptop, on Thursday and installing the Oracle BI Enterprise Edition on Friday, this weekend sees my first steps with the BI Publisher (previously known as XML Publisher). My colleague Marcos is our (AMIS’s) real expert in this area – you may ha