by Marina Gurskaya – Suppose we have a hierarchical sructure defined by a manager-employee relationship described in table HIERAR:
Other News
Wired Slammed For Publishing Slammer Code
By George V. Hulme – Some security experts are criticizing the decision by Wired magazine to publish the complete source code to the SQL Slammer worm in its July issue, which hits newsstands Tuesday, saying it amounts to an algorithm on how to wreak havoc on IT systems worldwide.
Managing rollback segments
(James Giordano) Sizing rollback segments can be a difficult task, especially with new applications. A good rule of thumb when sizing a rollback segments is to start by creating each rollback segment with a total rollback segment size at 10% of the largest table in the database. I like to start by s
SQL Server 2000 XML Distilled
Book Description – XML is one of a family of web standards for data description, validation, manipulation, and interchange. It enables the construction of application-specific data languages, which can be handled by generic tools. Its other main benefits are its platform independence, self-describin
In the Picture: Drawing with T-SQL
Some problems aren’t just practical; they’re also fun. SQL Server Magazine’s Itzik Ben-Gan shows you how to implement the Game of Life in T-SQL code.
IBM Ships ‘Invisible’ Database
By Lisa Vaas – IBM released DB2 Express, a no-click, quiet-as-a-mouse, self-installing version of its DB2 UDB (Universal Database) that’s aimed at small to medium-sized businesses.
Data Miner – Are You Really in the Know?
By Keith Hermiz – Without data mining, you shouldn’t bet the business on what you think you know.
IBM Unveils New DB2 Software to Further Automate & Optimize Information Analysis
IBM introduced DB2 Cube Views, new software that better prepares complex information for analysis by a large spectrum of third-party business intelligence applications, helping them perform 10% – 70% more efficiently, and enabling them to share information more easily with one another.
Oracle Drill Down
by Jack Hakim and Tom Spitzer – Already a dominant player in data management, Oracle is on a quest to deliver the business intelligence “stack” as a tightly integrated whole. Is the sum greater than the parts for your business analysis needs?
Oracle Closes In on ‘Unbreakable Linux’
By Peter Galli – One year to the day after announcing its Unbreakable Linux initiative, Dave Dargo, the vice president of Oracle Corp.’s Linux Program Office, took to the stage at the Enterprise Linux Forum at the Santa Clara, Calif., convention center on Friday to talk about how Oracle has achieved