Author: SSWUG Research

Community

Advanced Tuning with Statspack

By Rich Niemiec – If you could choose just two Oracle utilities to find and monitor performance problems in your Oracle9i Database system, those two utilities would be Oracle Enterprise Manager (now available in Release 4.0) and Statspack. As of Oracle8i Release 8.1.6, the Statspack utility replaced

Community

XML Validator

This article was written by Vaiyapuri Subramanian. He writes “In SQL Server 2000, XML can be parsed using the extended stored procedure sp_xml_preparedocument. This works fine as long as a well-formed xml is provided. Then do whatever needs to be done and you can call the extended procedure sp_xml_r

Community

Negligence Abets Slammer Attack

When a threat "is permitted to fully and suddenly emerge, all actions, all words and all recriminations … come too late." So said President Bush in his State of the Union speech at the end of last month, in words that might well have been aimed straight at the IT community as it dug itself out fro