(Muthusamy Anantha Kumar) In part I of this article, we saw how to generate row numbers and delete a simple single duplicate row. This article walks you through how to delete multiple duplicate rows. This article uses the new feature Row_Number() function, common table expression and the ANSI co-rel
Author: SSWUG Research
Database Opinion: A case for canned SQL
(Arthur Fuller) Like a Phoenix, the dynamic SQL versus canned procedures and user functions argument has resurfaced on the SQL newsgroups. Many of the proponents of the dynamic argument are web or Access developers, or developers of some other front end. Developers in the canned camp tend to be DBAs
IBM versus Microsoft data integration slugfest
(Vincent McBurney) I compare the data integration offerings of Microsft, with the release of SQL Server 2005, and IBM with the Ascential products. With major releases from both companies 2006 is shaping up as a data integration slugfest.
Reduce upgrade unknowns with the SQL Server 2005 Upgrade Advisor
(Adam Machanic) If you are preparing to upgrade your company’s precious mission-critical systems to SQL Server 2005, it’s hardly an exaggeration to say that you need all the help you can get. Be sure to proceed with caution, however, as an installation hiccup could cost your company thousands of dol
Using XML and XSLT
(Krishnan) XML Stylesheet Transformation(XSLT) is defined as a language for converting XML documents to other document formats.
DB2 – the secret database
(Mark Whitehorn) DB2 is the most respectable and most powerful database engine in the world: it’s the pinnacle of database development. IBM makes a claim (undisputed to my knowledge) that more structured data is stored in DB2 than in any other database engine.
Auditing in XML
(Arup Nanda) One of the cornerstones of the security infrastructure in Oracle Database is accountability—the ability to record who did what. Oracle Database 10g provides auditing to record the activities of users in the database. When the activities occur (for example, a user updates a certain table
Simple XML website templates
(OOK) One of the most annoying things about .Net / web development is its growing complexity. As time goes on programming websites becomes more and more complex and the duration of projects are often much longer. Modern code is just full of too many objects and too many lines of code.
Delivering High Availability
(Alan Arnold) Globalization, the Internet, competitive pressures, and higher consumer expectations have significantly increased the need for dependable 24×7 information systems in businesses, as well as in not-for-profit and government organizations. Fortunately, a number of products, from a var
RDF Data Model in Oracle
(Nicole Alexander, Xavier Lopez, Siva Ravada, Susie Stephens and Jack Wang) The Resource Description Framework (RDF) is a language for representing information about resources in the World Wide Web. To describe information in RDF, statements are essentially broken into triples: {subject/resource, p