by Michael Denny – As the hype of past decades fades, the current heir to the artificial intelligence legacy may well be ontologies. Evolving from semantic network notions, modern ontologies are proving quite useful. And they are doing so without relying on the jumble of rule-based techniques common
Other News
Mathematical User-Defined Functions
Alexander Chigrik presents a few Math UDFs he has developed. These scalar User-Defined Functions perform a calculation, usually based on input values provided as arguments,and return a numeric value.
Microsoft SQL Server Webtasks privilege elevation
Using a number of flaws in the webtask functionality of Microsoft SQL Server an attacker may gain control of the database by elevating their privileges.
A report of all users, grants and privileges
By Ofer Harel – Sometimes you need to know all the privileges your users have in a database. This collection of scripts summarize and detail all users, roles and grants in the database.
Retrieve XML Data with a Template File from a Visual Basic Client
This sample in this article demonstrates how to retrieve an XML document from SQL Server 2000 by using a template file that contains parameters. More specifically, a query is issued against SQL Server 2000 by using an ActiveX Data Objects (ADO) 2.6 command stream. This query fetches the XML DataStre
Running total in an SQL query
by James Crowley – There are no standard functions in either MySQL or MS SQL Server to return a running total for an SQL query. It is, however, relatively easy using the CROSS JOIN statement. In order to do this, use the following SQL:
Converting an eMbedded Visual Basic 3.0 Application from SQL Server CE 1.x to SQL Server CE 2.0
Learn How to Set Up Security and Encryption for Servers Accessed by SQL Server CE Clients
XMLNotePad 1.0
Notepad for XML Files
Plan to use XML namespaces, Part 1
By David Marston – This article introduces XML namespaces, explores their practical benefits, and shows you how they are used in the standard XML formats and tools defined by the W3C. Several W3C specifications are mentioned, notably XML Schema and XSLT, which offer useful ideas for using namespaces
Can XML Web Services Offer a Standard Across Databases?
by Brian C. Reed – XML is often promoted as the standard format for exchanging data. But dig into how XML is actually being implemented by the database and tools vendors, and you will often find that XML is not necessarily being delivered in the interoperable way they might expect.