by Will Provost – As regular readers of the XML Schema Clinic likely know, I tend to view the world of XML through object-oriented glasses. For this installment, though, we’re reaching out to the relational data folks, switching lenses for one eye at least. The goal is to see what relational concept
Other News
Form Builder 5.0
Book by Stephen Edelstein – Sample Chapter 8: LibrariesPrevious versions of Oracle’s Forms Designer tools, SQL*Forms and Oracle Forms, had two ways of sharing procedural code with multiple applications:User Exits let designers write procedures in a programming language (C, COBOL, For
SQL Server Agent – Creating Performance Condition Alerts on Database Server Objects
Alexzander Nepomnjashiy continues his new series that focuses on SQL Server alerts and errors with a detailed look into SQL Server performance condition alerts and how they are used to monitor the internal performance of SQL Server objects.
Get Sample Records
by Pulkit Mathur – Here is a tip to get sample records from a table. Suppose there are 100 records in a table and you want to see the 5th, 10th …95th, and the 100th record. Or the 1st, 3rd, 5th… record.
SOAPing Up Web Services
Web services offer a new approach to an old idea: A set of interface specifications that don’t care about transport mechanisms, hardware architectures, or operating systems. And an integral factor in making that idea work is the SOAP specification.
The curse and blessings of dynamic SQL
by Erland Sommarskog – In this article I will discuss the of use dynamic SQL in stored procedures in MS SQL Server, and I will show that this is a powerful feature that should be used with care. I first recapitulate why we use stored procedures at all, before I explain the feature as such. I then lo
Collaboration Through DSO
By Russ Whitney – From analysis to final decision, every business process requires collaboration among team members. Here’s how you can use DSO to add collaboration features to your next analytic application.
Oracle Submits New API Spec to the JCP
By Clint Boulton – To assuage the pain of software developers, Oracle Corp. Tuesday it said it has submitted a new Application Programming Interface (API) specification designed to facilitate the creation of extensions that are fully interoperable with any Java Integrated Development Environment (ID
Transactions In Sql Server 2000
Taking forward the topic of the previous article Transactions, within this article we will discuss Transactions with respect to databases and will also see an example which would be implemented in SQL Server displaying how to use Transactions.
Server Side Cursors and ADO Cursor Types
This article discusses some common ADO properties (cursor location, cursor type and lock type) and their effect on performance. It’s mainly concerned with eliminating server-side cursors. These are identified in Profiler traces by sp_cursorfetch statements.