(Paul Zikopoulos) Learn the details of how IBM DB2 Universal Database (DB2 UDB) V8.2.2, more than ever, decreases your time-to-value through a self-installing, self-tuning, and self-configuring database. This is the second part of a three part series that examines in depth the new function, feat
Other News
‘Unlearning’ with Database 10g Release 2
(Mark Brunelli) The newly unveiled Oracle Database 10g Release 2 offers enhanced automated features designed to ease the burden of statistics collection and analysis. SearchOracle.com caught up with Mark Townsend, Oracle’s senior director of database product management, to discuss these new features
Push, Pull, Next!
(Bob DuCharme) In a recent weblog post, XML.com’s “Python and XML” columnist Uche Ogbuji provided a nice collection of links to discussions about the push vs. pull styles of XSLT stylesheet development. What do we mean by “push” and “pull”? As a short example of each, let’s look at two approaches to
WMI behavior change for June’s version of SQL Server 2005
(Larry Chesnut) Building with beta products always holds it own unique challenges, but then again, that’s what makes it fun for a lot of us. Solving problems not seen before is a pretty cool. I was reminded of that idea recently when I was trying to use our WMI demo with the latest CTP from June, ID
Saving PHP’s Session data to a database
(Tony Marston) As you should be aware the HTTP protocol, as used for serving web pages, is completely stateless. This means that after the server has received a request, processed it and sent a response, the process which dealt with that request dies. Anything that the process had in its memory ther
The identity crisis in replication columns
(Hilary Cotter) This article discusses three common problems DBAs are likely to encounter when replication columns have the identity property, which is defined as an attribute of int, smallint, bigint, decimal, numeric or tinyint columns that will auto-increment their value when data is inserted. Th
MDX Essentials: String / Numeric Functions: The CoalesceEmpty() Function
(William Pearson) Within the world of OLAP, sparsity is pervasive. There are many reasons to want to display something other than an empty space in a report, where a “blank” is about as welcome, to most readers, as silence on a radio show. In an Analysis Services cube, as well as in the reportin
Debugging stored procedures in SQL Server’s Query Analyzer
(Arthur Fuller) While talking to a colleague about the trouble he was having with a stored procedure, I suggested that he run the debugger in Query Analyzer. He really surprised me when he asked, “What debugger?”
HIPAA Security and Compliance
(Daniel Anderson) The HIPAA Security Rule became final in February 2003, and Healthcare Organizations (HCO’s) are now working towards the compliance deadline of April 21, 2005 which has already occurred. The final HIPAA Security Rule has a flexible approach; the recurring theme is that HCO’s mu
Declare your PHP database independence with PEAR and this script
PHP comes with extensions for a variety of different databases: MySQL, SQLite, SQL Server, PostgreSQL, Oracle, Sybase and many more. However, each extension uses its own set of functions to communicate with the database server and perform SQL queries, making it well-nigh impossible to easily switch