(Jonathan Gennick) DBAs spend a lot of time managing disk space. To maximize I/O rates, we spread the data we manage across many physical disks. Often we do this by working with a system administrator who uses a logical volume manager (LVM) to combine many physical disks into a single logical volume
Other News
XKMS Messages in Detail
(Rich Salz) This month we begin to implement our XKMS server. We’re going to focus on the Register operation. This is the cornerstone of the key registration service, X-KRSS; it implements the core CA function, which is issuing certificates.
Default for start date column
(Craig Mullins) I have a table with a start date column which can be blank. What is your opinion as to a good default to have for this column? Should it be nullable or have some other default when no value is provided? SQL determines if the row is active by checking to see if it’s not null and less
Introduction to XForms: XML Powered Web Forms
(T. Raman) As we deploy Web access to software at all levels of complexity ranging from business back-ends to simple electronic transactions, we need to revisit the design of HTML forms that are the essential underpinnings of the transactional Web. XForms — a revision to the existing HTML forms tech
Troubleshooting .NET Applications
(Karthik Ravindran) Instrumenting and tracing XSLT transformations by treating XSLT as a regular programming language can provide very useful diagnostic data to help analyze and troubleshoot problems.
Software Review: SQLCompare
(graz) I’ve reached that horrible stage in a project. We’re still doing development but the users are in an extended alpha/beta test of the software. And they don’t like to lose the data they’ve entered. That means as I fix bugs and add new features I need to keep our development database in sync wi
Oracle’s CASE Expression
(Amar Kumar Padhi) DECODE is considered the most powerful function in Oracle. Oracle 8i release introduced the CASE expression. The CASE expression can do all that DECODE does plus lot of other things including IF-THEN analysis, use of any comparison operator and checking multiple conditions, all in
DB2 for Linux on iSeries: Implementation Guide
This IBM Redbook discusses DB2 UDB for Linux on iSeries. We provide the installation and configuration steps for DB2 UDB for Linux on iSeries. We also present connectivity scenarios between OS/400 resources and Linux resources. (pdf)
Top 10 Segments by V$SEGSTAT Statistic Name
(Robert Ware) The following lists the top 10 segments by V$SEGSTAT statistic name (since the instance was started). I usually employ this method to help determine which segments are responsible for most of the Logical I/O or Buffer Busy Waits on my system. Once I have this information, then I will s
MDX in Analysis Services: Introducing DISTINCT COUNT
(William Pearson) In this article, we introduce the concept of distinct counts, discussing why they are useful – indeed, often required – in our organizational analysis efforts. Throughout our session, we will describe some of the challenges that are inherent in distinct counts, and then we will und