From Sql Team – Jerald writes "Dear SQL Team, I am working on SQL Server 7 and also on SQL 2000. Now our company has many SQL Servers running on the Network and also in different domains. Now is there a way where I can find out which SQL Servers are currently running on the Network and list them
Other News
Database options expand
By Evan Koblentz – Embarcadero Technologies Inc. last week announced a Sybase version of its SQL Debugger tool, which will be available later this month for Sybase's Adaptive Server Edition 12.0 and 12.5 as a plug-in to Embarcadero's DBArtisan product. It's the first third-party debugger
Modeling XML Vocabularies with UML: Part I
by Dave Carlson – The arrival of the W3C's XML Schema specification has evoked a variety of responses from software developers, system integrators, XML document analysts, authors, and designers of B2B vocabularies. Some like the richer structure and semantics that can be expressed with these new
Common XML design mistakes and how to avoid them
By Kevin Williams – This column tells how to avoid some common mistakes that even smart architects make when designing an XML solution. XML architect and author Kevin Williams offers four tips for designing flexible and high performance systems.
Top 11 Backup Tips
By Michael D. Reilly – SQL Server's powerful backup and restore capability offers reliable protection for your data. If you have an effective backup-and-restore strategy, you can sleep well at night knowing that if a problem occurs, you can recover from it with minimal downtime and minimal disru
Use Query Name As SQL Statement Variable
Tip by Stan Zylowski – Suppose you have a shopping cart with several categories of products, and your ASP pages use SQL statements that access database queries for the different categories. Instead of creating an ASP page for each category (for example, shirts.asp, caps.asp, and so on), you can have
SQL oversights, a recipe for disaster
By Chris Prosise and Saumil Udayan Shah – For many of us, Web applications have become as much a part of our daily life as the meals we eat. (Some of us even eat while we work on Web apps.) Unfortunately, just as these applications are something else that we have to cook up, they're just as susc
WIPO Publishes XML DTDs for the Electronic Patent Cooperation Treaty Application
Revision 3 of the WIPO 'Draft Legal Framework and Technical Standard' for electronic patent filings under the international Patent Cooperation Treaty (PCT) has been released for public comment. This revision includes XML DTDs for the E-PCT Standard.
Experimental non-XML syntax for RELAX NG
James Clark has announced the release of an experimental non-XML syntax for RELAX NG and a Java translator implementation that converts instances of the syntax into RELAX NG's XML syntax.
A New Kind of Namespace
by Edd Dumbill – Followers of this column will be more than aware that when a technology emerges from the W3C there are always teething pains. W3C Recommendations aren't quite the shrink-wrapped parcels of authority they're often taken to be. Perhaps the canonical example of this has been th