By David Litchfield – With Microsoft SQL Server 2000 and 7 comes a “helper” service, the SQLServer agent. The Agent is responsible for restarting the database service if it stops for some reason, has a role to play in replication and runs scheduled jobs. As the public role can submit jobs to the SQ
Author: SSWUG Research
Oracle aims to run entire business on Linux
ORACLE Corp is working towards running its entire business on Linux as part of a commitment to drive the adoption of the open source operating system. The company started the initiative last month with its application demo services group by migrating 349 demo server machines, with over 3,400
Perl for Oracle DBAs
By Andy Duncan, Jared Still – Perl is a very powerful tool for Oracle database administrators, but too few DBAs realize how helpful Perl can be in managing, monitoring, and tuning Oracle9i, Oracle8i, and earlier databases. You don’t need to be a Perl expert to reap the rewards of reading Perl for Or
Count Replication Errors in def$_error table
by Johnny Ayanda Tshepo Moleleki – This script pertains to Oracle’s Multi-Master (MM)Replication environment. All the DML errors encountered by a site in MM replication are stored locally on a table DEF$_ERROR (and other tables) until the cause of the error has been resolved. The script gives the DB
Operating System Performance Checklist
by Brad M. McGehee – This third part of the SQL Server Performance Audit series covers the operating system.
Get Smart with BI
By Michael Otey – BI–and the OLAP and data-mining technologies that comprise it–are aimed squarely at delivering strategic business advantages.
Top Ten Tips to Using XPath and XPointer
by John E. Simpson – XPath and XPointer allow XML developers and document authors to find and manipulate specific needles of content in an XML document’s haystack. From mindful use of predicates, to processor efficiency, to exploring both the standards themselves and extensions to them, this article
Data Types Undefined in XML Schema?
The XML Schema Working Group was tasked with adding the two most important pieces to the XML puzzle: Schema Definitions and a Data Type Libary. Criticism rises now as more and more people work with the resulting specifications, including XML Schema part 2: Datatypes.
XML Events, XHTML in W3C XML Schema
The W3C HTML Working Group has released two new working drafts, XML Events and Modularization of XHTML in XML Schema, along with the jointly produced XHTML+MathML+SVG Profile.
The Absent Yet Present Link
by Kendall Grant Clark – In last week’s column, ” XHTML 2.0: The Latest Trick”, I described the next step in the evolution of XHTML, at least according to the 5 August XHTML 2.0 working draft. As is often the case, however, reaction to a new W3C specification, even a very early draft, exposed