There are at least two kinds of topics of permanent conversation in the XML development community: formally settled, and formally unsettled. In other words, members of the XML development community are perpetually discussing, on the one hand, issues which have been, more or less, formally settled by
Author: SSWUG Research
Server Explorer for Oracle Databases
Oracle databases display some differences in Server Explorer. For example, when you add a connection to an Oracle database, you will see these folders: Database Diagrams, Tables, Synonyms, Views, Stored Procedures, Functions, Package Specifications, and Package Bodies. The following topics briefly d
XML-ify your stored procedures
(Jimmy Nilsson) Since I’m a geek I love to use new technology. When XML was quite new a couple of years ago, I used it as the file format in a project for a customer of mine. Hey, I know what you think, but my customer actually thought – and still thinks – it was a good solution to use […]
OTL/DB2-CLI and bulk operations with DB2’s CLOB
This example demonstrates simple INSERT and SELECT with DB2’s CLOB data type being done in bulk (buffer size > 1). This example can be easily modified to make it work with DB2’s BLOB by changing the “CLOB” data type in the table to “BLOB”, and by replacing “varchar_long” with “raw_long”.
Constraints and Triggers
The DB2 DBMS offers a useful suite of methods to ensure data consistency. Primary key constraints forbid duplicate values in one or more columns of a table. Foreign key constraints ensure consistency of tuple (row) references across tables. Table check constraints are conditions that are defined
Minimizing Weaknesses in TLS
(Jim Clune) Knowing how to implement transport layer security (TLS) does not guarantee secure Web services. Certificate mismanagement, man-in-the-middle attacks, and XML attacks could compromise the security of your TLS implementation unless you understand how these attacks are executed and you cons
Production to Development: Moving Databases
(David Kline) Moving a database from one system to another can be a complex job, especially if the source database requires 24-hour, 7-days-a-week availablility. Wouldn’t it be nice if you could move all of the database objects in one clean operation? No setting constraints, creating indexes, tables
Tuning the Oracle Server – Identifying Internal Contention
(Virag Saksena) The readers will learn about contention for different resources in the server – latches, locks and ST enqueues. They will learn to determine if contention for any of these resources is responsible for performance problems. They will learn to drill down to identify the sessions causi
Converting from Access to SQL Server
(Eli Robillard) The document assists users migrating from Microsoft Access to Microsoft SQL Server. Though written specifically for users of GenericDB, the process may be applied to any Access database. Of particular note are the steps to convert a Random Autonumber field to one which uses Increm
Unify Data Access with Linked Servers
(Roger Jennings) In SQL Server 7.0, servers linked by OLE DB providers replace the remote server feature of earlier versions. In the past, servers used remote stored procedure calls for interserver communication. Judging from the few non-Microsoft hits returned by Web search engines on linked server