(James Snell) Get a technical overview of the popular Atom Syndication Format. This article discusses Atom’s technical strengths relative to other syndication formats, and offers several compelling use case examples that illustrate those strengths.
Other News
SQL Server Class Generator For C#
(Sheel Gohe) Application that Looks at an MS SQL SERVER Database. Pulls the Tables from that Databse and Generates a Class File for the selected Table. This class file generates SQL for all the DML operations based on selected criteria. The criteria can be defined through a seprate criteria class.
Exploring XML Schema Styles Using JAXB in Enterprise Applications
(Pushkar Varma) This article explores various styles for designing XML Schemas and assesses each style in terms of certain quality attributes. Figure 1 shows how an information model is transformed to a class model using JAXB, and shows which qualities of the artifacts should be assessed based on a
Using ADO.NET 2.0 to get schema and metadata information
(Amirthalingam Prasanna) This article describes how to obtain different types of information from your SQL Server 2000 database using ADO.NET 2.0, part of Visual Studio.NET 2005 and Microsoft .NET 2.0.
Database Interaction with PL/SQL: Explict Cursors in Depth
(Jagadish Chatarji) This is part 11 of a series of articles focusing on database interactions with Oracle PL/SQL. In my previous article, I introduced the concept of the explicit cursor and looked at several approaches for using the explicit cursors. In this article, we shall delve more deeply into
You may experience an access violation or data corruption in Analysis Services when you use DTS to merge partitions when lazy processing is occurring
In Microsoft SQL Server 2000 Analysis Services, you may experience an access violation or data corruption when you try to merge partitions when lazy processing is occurring.
Exploit Open Source Technologies for Transactional Data Management
(Sami Akbay) In 2004, total online consumer spending grew by 26 percent to a record level of more than $117 billion. Millions of consumers are researching and buying goods and services over the Web, which translates into businesses processing higher volumes of transactions online every day. To a
Managing Transactions in SQL Server Stored Procedures
(Scott Mitchell) Last week’s article, Maintaining Database Consistency with Transactions, looked at what, exactly, transactions are and how they can be used to guarantee consistency in a database when issuing commands that modify multiple tables. Specifically, transactions ensure that a set of modif
Appreciating Libxslt
(Bob DuCharme) The two most well-known XSLT processors are probably the Apache project’s Xalan (available in both a Java and C++ version) and the Java-based Saxon, which was written by XSLT 2.0 specification editor Michael Kay. If those are the only two XSLT processors you currently use, it’s worth
Merge (AKA Upsert) – A Definition in Plain English
(Lewis R Cunningham) The basic Data Manipulation Language (DML) commands that have been in use over the years are Update, Insert and Delete. They do exactly what you expect: Insert adds new records, Update modifies existing records and Delete removes records.