by Manoj Sharma – Complex applications often consist of many individual tasks, each of which may depend upon the successful completion of other tasks. For example, you may want an application to execute only if a preceding series of steps occur without failure, in a specific sequence. Managing such
Author: SSWUG Research
Guidelines for the Use of XML within IETF Protocols
There are a wide variety of Internet protocols being developed; many have need for a representation for structured data relevant to their application. There has been much interest in the use of XML as a representation method. This document describes basic XML concepts, analyzes various alternatives
DSN less Database Connections
DSN less connections don’t require creation of system level DSNs for connecting to databases and provide an alternative to DSNs. We will now see how to connect to a database via ASP using Connection String in place of DSN name.
Retrieve Rows Set by Set from the Database—Without Duplicates
Learn how to retrieve rows set by set from an Oracle database without getting previously obtained rows in subsequent sets. Boris Milrud demonstrates how to use packages as holders for session-persistent data.
Introduction to Relational Databases – Part 1: Theoretical Foundation
By Tore Bostrup – This is the first of a two-part article that will provide an introduction to relational databases and the SQL language. This first part describes some of the key elements of the technology with an emphasis on database normalization. The second part will describe a less theoretical
Ellison: No profit warning here
By Wylie Wong – Oracle Chief Executive Larry Ellison on Wednesday said the database giant will meet Wall Street estimates for its fourth-quarter earnings, ending speculation that the company might have to announce a profit warning this week.
Control Log File Growth to Avoid Out-of-Space Errors
By Andrew Georgopulos – The first step in my initiation as a SQL Server admin came after only a week or two on the job. I was confronted with a message that made my palms sweat. The error read something like this:
Detailed locking view: sp_lock2
By Alexander Chigrik – As a SQL Server DBA, I often need a reference to information about locks. Microsoft recommends using the sp_lock system stored procedure to report locks information. This very useful procedure returns the information about SQL Server process ID, which lock the data, about loc
How to retrieve the newly inserted GUID value?
This is yet another FAQ from Microsoft public SQL Server newsgroups. Lot of SQL Server developers are used to using @@IDENTITY to retrieve the value of the IDENTITY column immediately after inserting a row. We are missing that functionality when it comes to inserting rows with GUIDs as keys. Unfortu
Analysts antsy about Oracle
By Larry Dignan – Oracle’s fiscal year ended with a thud, raising the specter of “significant employee reductions,” according to Wall Street analysts.Oracle had to resort to heavy discounting in the final weeks of the quarter, and analysts are betting that the company will take a revenue hit