By Brad McGehee – What’s is really like to experience a SQL Server cluster failover on your most important production server?
Other News
Refresh value of a global variable only after commit
By Ravinder Bhalla – Using the tip below, you can not only reinitialize the value of a variable after COMMIT at the backend or the SQL prompt, you can also execute specific functions or procedures only after COMMIT. It was tested on the Oracle 9i database, but it should be possible to run on 8i also
Activebase Disaster Recovery and Performance Enhancement Solutions for Oracle Databases
ActiveBase recently announced disaster recovery and performance enhancement solutions for Oracle databases.
Take the Pain Out of Reading XML
by Elliotte Rusty Harold – Reading XML documents isn’t as easy as writing them. Fortunately, you can use an XML parser to do the work for you. Download a sample chapter from Processing XML with Java to get the scoop.
Java Architecture for XML Binding
by Hitesh Seth – Two foundation technologies, Java and XML, represent the marriage of portable code and data. A key ingredient of a successful marriage is compatibility. XML and a number of XML-based vocabularies are being used extensively as the standard data-exchange mechanism (and beyond) by both
Tip: Basics of bootstrapping with DOM, Part 3
By Brett McLaughlin – This tip explains the changes to DOM Level 3 that relate to bootstrapping, and how they improve upon DOM Levels 1 and 2.
Introduction to MSSQL Server 2000 Analysis Services Custom Cubes: Financial Reporting (Part I)
Join author Bill Pearson as he expands our cube building skills to create an integrated Financial Reporting Cube. This two-part lesson will present hands-on practice in building core cube structures from multiple data tables and developing the initial design to focus on the production of financial s
Importing an XML file
You can import an XML file into SQL Server in several ways. Here are three approaches:
SQL Server backup and restore, part 1: The basics
By Greg Robidoux – This document analyzes the various options available for your backup and recovery process with SQL Server 2000. The next part of the series will present best practices and tips.
Practicing Recovery
Brian Moran talks more about his conversation with escalation engineer Bob Ward and the thoughts he shared about three common problems that many database customers bring to PSS.