By Andrew L. Newton – This document describes an application layer client-server protocol for a framework of representing the query and result operations of the information services of Internet registries. Specified in XML, the protocol defines generic query and result operations and a mechanism for
Author: SSWUG Research
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
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
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
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.
Establishing a Connection to a Data Source
To access the Microsoft OLE DB Provider for SQL Server (SQLOLEDB), the consumer must first create an instance of a data source object by calling the CoCreateInstance method. A unique class identifier (CLSID) identifies each OLE DB provider. For SQLOLEDB, the class identifier is CLSID_SQLOLEDB.
Registration and Discovery of Web Services Using JAXR with XML Registries such as UDDI and ebXML
By Qusay H. Mahmoud – Businesses can describe their Web services on the Internet using an XML-based language, such as the Web Services Description Language (WSDL), or simple plain text, and list them in an XML-based registry such as Universal Description, Discovery, and Integration (UDDI), or the el
Using SAX InputSource effectively
By Brett McLaughlin – This tip explains how using an InputStream to feed XML to the SAX API is significantly more efficient and safer than using a Reader as input. It also briefly touches on the impact of such a choice on internationalization.
XML Firewalls Aid Services
By Darryl K. Taft – Two technology companies are helping corporate users embrace XML-based information while ensuring the security and integrity of the messages that come into their systems.
SQL Server Springs Another Leak
By Dennis Fisher – Security researchers have found a new flaw in Microsoft Corp.’s SQL Server database software. The problem lies in the SQL Server agent, which is responsible for various functions, including running scheduled jobs and restarting the database service if it stops. By default,