The Microsoft® SQL Server™ 2000 High Availability Series helps you plan and deploy a highly available data center that uses Microsoft SQL Server 2000 through proper procedures that increase availability, backups help recover from catastrophic disasters, redundant components prevent downtime, and red
Author: SSWUG Research
New Products, January 2003
By Carolyn Mader – Check out the latest SQL Server-related new and improved products.
Web Site Monitoring Tool Broadens Scope
By Paula Musich – Freshwater Software extended its SiteScope active Web site monitoring tool to cover Web services.The wholly owned subsidiary of Mercury Interactive Corp., based in Boulder, Colo., added SiteScope monitors that can monitor the availability of Web services without using agent
Modify XML Schemas in .NET
Use classes within the System.Xml.Schema namespace to create and modify schemas.
Introduction to SALT. Unleashing the Potential
By Hitesh Seth – Speech Application Language Tags (SALT) is a set of XML-based tags that can be added to existing Web-based applications, enhancing the user interface through interactive speech recognition. In addition, SALT can be used to extend Web-based applications to the telephony world, thereb
Book Excerpt: Oracle9i The Complete Reference
This book covers critical relational, object-relational, and Web database concepts, as well as SQL, SQL*PLUS, PL/SQL, Java, JDBC, SQLJ, and XML programming. You’ll also get full details on database administration techniquesand much more. Read all of Chapter 21: “Using SQL*Loader to Load Data.”
Setting Up Full Text Search: A Step-by-step Guide
by Alexander Chigrik – Useful information about full-text search, from software requirements to how to set up full-text search step by step.
Converting Access Data into XML
The following applications can help you convert Access data into XML format: Access 2002, ADO 2.5, and SQLXML. Access 2002 (part of Microsoft Office XP) enables you to query or save a table in XML format. You might be able to automate this process.
Problems with the DUAL table
By Harish Kapgate – DUAL is a table automatically created by Oracle along with the data dictionary. It is in the schema of the user SYS, but is accessible by the name DUAL to all users. It has one column, DUMMY, defined to be VARCHAR2(1), and contains one row with a value ‘X’. Selecting from the DUA
SQLPing.NET
by Chip Andrews – After receiving a few requests for a .NET version of SQLPing I coded one up last night. I’ve only got about an hour invested in it so as you can imagine, its not what you call “fully tested”. In any case, works on my end. Please provide feedback if you have any issues with it. Sour