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
Other News
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
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.
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.
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.”
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
Modify XML Schemas in .NET
Use classes within the System.Xml.Schema namespace to create and modify schemas.
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
Word wrapping with T-SQL
By Andrew Novick – Word wrapping isn’t the kind of task that is done in T-SQL very often. That’s a good thing. The SQL Server engine isn’t really the right location for formatting functions like wrapping. However, there are times when there isn’t a suitable front end that can perform the word wrappi
Retrieve an Identity Value
by Roman Rehak – Most objects in ADO.NET were designed to operate in a disconnected mode. The data is retrieved from the server and cached on the client in a DataSet or DataTable object. You make changes in the client application and use a DataAdapter to connect to the database and propagate the cha