(Brian Knight) Trying to get past the Microsoft SQL Server Reporting Services learning curve? Well never fret, this article is a first in a series of tutorials to walk you through creating a practical report for your company to monitor your SQL Server’s databases. In this sample report, we’re going
Other News
RSS, Blogs, and Attention.XML
Attention.XML – a specification for tracking, prioritizing and sharing what people are reading, looking at or listenting to in RSS – is still in its prototype stage. But it may soon have a role to play in searching weblogs, an activity known to some as ‘blogrepping’ (from blog and grep).
Reset ROWNUM and Suppress Repeating Groups
(Satyanarayana Josyula) You can reset the serial numbers after each group break using a single query–without using any utilities. This technique uses the ROWNUM returned by Oracle and resets the serial number at the beginning of each group. Also this query shows how to suppress the repeating gr
Oracle Tip: Understand how NULLs affect IN and EXISTS
On the surface, it may appear that the SQL clauses IN and EXISTS are interchangeable. However, they’re quite different in how they handle NULL values and may give different results. The problem comes from the fact that, in an Oracle database, a NULL value means unknown, so any comparison or oper
Create Real Apps Using New Code and Markup Model
(Charles Petzold) The presentation subsystem in the next version of Windows, code-named "Longhorn," offers powerful new capabilities to developers. This subsystem, code-named "Avalon," allows developers to take advantage of its capabilities through a new markup language code-named "XAML." In add
InformixConnection: THE BIG LEAGUES
With a head-turning new release (backed by the full power of IBM’s software portfolio), Informix technology blazes onto center field. In this special e-book for Informix customers, you’ll read how businesses are using the new release of Informix Dynamic Server, how Informix technology is finding its
Stinger Makes its Mark
(Michelle Carlson) The next release of IBM DB2 Universal Database (UDB) for Linux, UNIX and Windows, referred to as Stinger, packs many valuable enhancements. Customers will notice broadened autonomic capabilties, improved flexibility for securing DB2 environments and easier distribution and install
Advanced Data Access with ADO.NET and Oracle
(Bill Hamilton) Learn how to use ADO.NET 1.1 to retrieve data from complex Oracle data types.
DB2 Basics: The whys and how-tos of DB2 UDB monitoring
(Martin Hubel) Measurement is crucial in building and managing your organization’s applications. IBM DB2 Universal Database (UDB) on Linux, UNIX, and Windows includes facilities for problem determination, performance management, and trend analysis. This article examines event and snapshot monito
Practical SAX Notes
(Uche Ogbuji) In this article I discuss issues related to recent articles in this column, including some practical problems using XML facilities — SAX in particular — across Python versions and installed software configurations. I also revisit ElementTree’s support for XML namespaces and discuss s