by Dan Clark – A well-designed application that uses a relational database management system in the backend should make extensive use of stored procedures. A stored procedure is a named collection of SQL statements that you store in a database. A stored procedure is similar to a function. You call t
Author: SSWUG Research
Analyst: XML-enabled Office a plus but not a cure-all
By Eric B. Parizo – Many would argue that Microsoft Corp. hasn’t had nearly as much success in the enterprise software market as it has selling consumer products. However, the Redmond, Wash.-based software giant no doubt hopes its XML-enabled Office 2003 software suite will change that when it is re
Upgrading SQL Server, part II: Critical upgrade decisions
By Jeremy Kadlec – This article will begin to detail the technical components faced by DBAs and developers during the upgrade process. The technical components detail critical upgrade decisions related to ANSI NULLS, quoted identifiers and other items. In addition, a valuable redundant upgrade archi
Reading XML with the XmlReader
The XmlReader class is an abstract base class that provides non-cached, forward-only, read-only access. The XmlReader class checks that the XML is well-formed, and throws XmlExceptions if an error is encountered. It can read a stream or a document, and it implements the namespace requirements outlin
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
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.
Find Transitive Closure of Parent-Child Relationship in Oracle9i
by Marina Gurskaya – Suppose we have a hierarchical sructure defined by a manager-employee relationship described in table HIERAR:
Using Microsoft SQL Server Constraints
By Alexander Chigrik – In this article, I want to tell you about SQL Server constraints: what a constraint is, when it is used and for which purposes. You can find in this article some examples of constraint creation and SQL Server 2000 constraints enhancements.
Writing Cached High Performance Database Applications
by Larry Ashworth – Many otherwise outstanding applications fail miserably due to database performance issues. Caching is a commonly used method of accelerating applications, but cache aging, data integrity, and multi user issues make caches difficult to implement at the application level. As a serv
Tutorials: DB2 UDB for Linux, UNIX, and Windows Version 8 DBA Certification (701) Preparation
This series of six free tutorials is designed to help you prepare for the DB2 Version 8 DBA (Exam 701) certification exam. These tutorials provide the solid base knowlege needed to attain the certification “IBM Certified Database Administrator – DB2 UDB V8.1 for Linux, and UNIX.”