(Chris Herborth) XForms is the next generation of Web-based data processing. It replaces traditional HTML forms with an XML data model and presentation elements. In this three-part series, you’ll be introduced to XForms and its capabilities, including the basic XForms model and form, the various typ
Author: SSWUG Research
Partitioned archive tables
(Kristian Nielsen) Is there anyone using partitioned archive tables in MySQL 5.1 for storing logs (or other voluminous data)?
Profiling XML Schema
(Paul Kiel0 XML Schema is now 5 years old, having matured from a newborn into an active youngster. So what have we learned about this young one’s personality? We’ve always known it was complex. Indeed, the original debate about whether to make it a Recommendation indicated concern. (See Last Word an
Preserve log table entries using autonomous transactions in Oracle
(Bob Watkins) A database transaction is a unit of work that must either succeed completely or fail completely. In Oracle, a transaction starts with the first Data Management Language (DML) statement you execute, and ends when you issue a COMMIT statement to save the transaction or a ROLLBACK stateme
Track down deadlock errors with the SQLDiag utility
(Tim Chapman) SQLDiag, introduced in SQL Server 7.0, is a very handy SQL Server utility that you can use to monitor your database server for problems. It is a command-line tool that was created to provide necessary information for Microsoft customer support calls. When run, the tool outputs data fro
BlackBelt Authoring: Conditional Drillthrough to Multiple Reports
(William Pearson) In this article, we will get some hands-on exposure to conditional drillthrough. We will discuss the general concepts, and then set up a scenario within which we work with basic reports to expose the steps for establishing this capability.
zIIP Specialty Engine – new information and a summary index
(Willie Favero) Today’s post will serve two functions. First, I would like to let you know about a new informational APAR that recently became available for the zIIP specialty engine. The APAR is II14219: DB2 Z/OS ZIIP EXPLOITATION “SUPPORT USE” INFORMATION. This APAR is in its early stages right n
Migrating SQL 2000 DTS packages to SQL Server 2005 Integration Services
(Joe Toscano) DTS (or Data Transformation Services) for all reasonable purposes is out in SQL Server 2005 and replaced by a brand-new ETL engine called SQL Server Integration Services (SSIS). As a DBA you’re wondering what to do with your DTS packages. (R)
Storage Made Simpler
(Ari Kaplan) Some vendors—and even customers—might think that there’s no story in storage. You have hard drives. You store data on them. End of story.
ASP.NET 2.0 — Standard Controls — XML Control
(Namratha Shah) Over the past few years storing data in XML has become very popular. Data stored in XML can be read using a lot of inbuilt objects provided by .NET framework like XMLReader, XPath Query and the old fashioned XMLDOM object. In ASP.NET MS has gone a step ahead and provided an XML contr