SQLCache is an OLE DB data provider with an in-built and fully tunable data cache. This means SQLCache can be used with traditional database queries made within web pages without the need for any code changes or the learning of a new Application Programming Interface (API). When SQLCache is used to
Community
Send Books Online Feedback with One Click
By Brian Moran – I discussed the recent update to SQL Server Books Online (BOL) in “Check Out the Updated SQL Server BOL”, and I encouraged you to download the new version ASAP. Have you ever wondered how Microsoft finds out what changes the company needs to make to BOL? Many requests for changing o
Create a Developer’s Extract of a Production Database
By Drew Georgopulos – With this 10-Minute Solution, you will meet the challenges of providing a manageable development environment. You will develop an extract of the production environment that is just like production in every way but size, enabling developers to work with a representation of the d
Statement Tracer for Oracle
Above Software has made available a free beta release of their new Statement Tracer for Oracle software. Statement Tracer can be downloaded and used for free through the end of April (an official release is expected in early May).Statement Tracer for Oracle is an effective and easy-to-use so
Oracle wants to be the host with the most
By Ed Parry – When Oracle announced it was getting into the hosting business in a big way, it wasn’t kidding. The company is turning into an outsource to be reckoned with.Oracle has cut the ceremonial ribbon for its 9i Database and Application Server hosting and managing services. The servic
XML-the Microsoft Way
by Peter G. Aitken – The Simplified Object Access Protocol, commonly known as SOAP, is a technique that uses XML to transport information over the Internet. More specifically, SOAP provides a way to invoke object methods, and to retrieve the results of those methods, using a standard and widely adop
OASIS Members Form Technical Committee to Advance XML Rights Language
OASIS, the XML interoperability consortium, announced its members have formed the OASIS Rights Language Technical Committee to advance a common XML rights language standard for the digital rights management (DRM) marketplace. Their work will provide a universal method for specifying and managing rig
W3C releases Namespaces in XML 1.1, Requirements
Two new drafts detailing the future of XML namespaces, Namespaces in XML 1.1 and Namespaces in XML 1.1 Requirements are now available.
Move multiple tables belonging to a particular schema
by: jai Tanwar – If you are running a number of schemas under one service — which is usually the case — and you need to move all the tables belonging to a particular schema to a new tablespace, then this script is for you.
Thanks XMLType
by Marius Nicoras – Last year I wrote “Another way to have your own aggregate function” ( Tip for Week of October 28, 2001 ) on the string data type as an alternative to a solution using object types ( Tip for Week of May 20, 2001 ). Now, in Oracle 9i, using XMLType I can build a DML statement […]