Alexzander Nepomnjashiy continues his new series that focuses on SQL Server alerts and errors with a guide to creating new SQL Server alert definitions.
Other News
XML for ASP.NET Developers
Book by Dan Wahlin – Text focusing on the different ways XML can be leveraged in ASP.NET applications to create flexibility, ease of maintenance, and efficiency. Feature thousands of lines of code samples illustrating techniques for XML for ASP.NET, and related technologies such as XPath, XPointer,
Serve Office Documents Using MIME Types and J#.NET
The conversion of the native Office document format to XML allows developers to create documents on the fly and serve them from a Web service.
XML 1.1: Here We Go Again
by Kendall Grant Clark – Despite the frequent and usually accurate complaints that XML specifications and standards are insufficiently layered, there is a sort of conceptual stack of technologies which together constitute the architecture of the Web. In this week’s XML-Deviant column I report on dev
True DBA Blooper #6: Vacation mindset leads to trouble
By Sara Cushman – Bob Lawrence knows the pain that comes with accidentally deleting several production IMS databases while they are online in a CICS production system. Now 20 years older and somewhat wiser, Lawrence recalled the scenario, and his recovery from the trauma, for SearchDatabase.com’s Tr
Limited-Function Server Roles
By Michael Otey – Here’s a quick introduction to fixed server roles in SQL Server 2000 and 7.0.
Backing Up to a File on a Network Share
I tried to back up my databases to a file on a network share and restore the databases on the secondary server. I tried to use the net use command to create the share on the target server, but I keep getting the message “There are no available drive letters left.” However, SQL Server Enterprise Mana
Oracle Claims Top Cluster Performance on Linux, Windows
A report submitted to the TPC (Transaction Processing Performance Council) puts Oracle in the lead in database performance on 32 processor clustered server systems. But you’ll have to wait until next spring for the test system that was used to generate the results to become available.
Using NID to Change DB Name
by Darl Kuhn – Prior to Oracle9i Database Release 2, you were required to rebuild the controlfile to rename your database.Now with Oracle9i Database Release 2, you can use the “nid” utility automates this task. For example, if you want to change your database name to BRDSTN here are the step
Tip: Traversing an XML document with a TreeWalker
By Nicholas Chase – XML’s Document Object Model provides objects and methods that enable a developer to navigate a document’s tree, but typically the process involves NodeLists and recursive methods that make it easy to get lost within the structure. The DOM Level 2 Traversal module provides a new o