Since SQL Server provides so many options for copying data between different databases and servers, novice/inexperienced DBAs often get confused, as to which option to go with, for maintaining a standby server. Some of those options include Data Transformation Services (DTS), BCP, Replication, Clust
Other News
Database administration 101
By Tim DiChiara – On Friday, August 16 Craig Mullins, one of the world’s top database experts, examined each of the components that comprise the discipline of database administration. Whether you’re a newbie or guru-level database administrator, analyst, architect, or application engineer, this webc
Database study puts Oracle on top — for now
By James Niccolai – A recent analyst report on the relational database market puts Oracle Corp. in pole position, though Microsoft Corp. will quickly gain ground as customers become more confident about its software and seek new ways to reduce their IT budgets, according to the report’s author.
XML, Part 2: XML Schemas
By Heath Stewart – This tutorial will be short and will present how a namespace is defined. Defining a namespace with a schema is important when your XML document must be not only well-formed but must match a particular namespace exactly. In some applications of XML, if the document is well-formed b
Support online communities with FOAF
By Edd Dumbill – In his previous installment, Edd introduced Friend-of-a-Friend (FOAF). FOAF is an XML/RDF vocabulary for describing, in computer-readable form, the sort of personal information that you might normally put on a home Web page. In this installment, he explores more deeply some of the i
XHTML 2.0 Drafted
By Michael Classen – New language specs can be both a blessing and a curse for Web developers. While new, easier to use elements provide the blessings, the removal of elements you already know can be a curse. Find out what the next XHTML version has in store in this quick overview.
Free SQL Server Tools
By Michael Otey – Many free tools are available on the Web to help DBAs and database developers. Here are my seven favorite free SQL Server utilities.
Incepto Releases SQLUP! version 1.3
SQLUP! clusters SQL Server databases over LAN or WAN, with no shared storage device. The software automatically synchronizes the clustered databases in real time and continuously monitors the servers and databases statuses and update levels, directing traffic to those databases that are available to
Microsoft® SQL Server™ 2000 Administrator’s Pocket Consultant
By William R. Stanek, Chapter 4: Core Database Administration – Core database administration tasks involve creating, manipulating, and supporting databases. In Microsoft SQL Server 2000, a database is a collection of data and the objects that represent and interact with that data. Tables, views, sto
Database link without SQL*NET string
By Syed Ali – You can create a database link without having a SQL*NET string in your tnsnames.ora file. This is beneficial when you use a remote database for one time only or you have a different client (eg, 8.0 vs. 7.3). This tip has been tested on Oracle 8.0.5. It may also work with 8i or other ve