LearnKey’s SQL Server 2000 for Developers offers developers, programmers, webmasters, and managers an in-depth look at this powerful product. Experts Mary Chipman and Andy Baron show you the essentials of using the Transact-SQL language and SQL Server’s graphical tools to perform all the tasks neces
Community
What is the best way for maintaining a standby SQL Server?
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
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