(Kaj Arnö) MySQL 4.0 has now reached the final stage of its active development life cycle. As I noted on 12 July 2006 when announcing the MySQL Lifecycle Policy, keeping legacy versions of our software alive is expensive and time-consuming. While we know that database administrators hate to upgrade
Author: SSWUG Research
SQL Statement Generator
(Chris Hambleton) The SQL Statement Generator is a Windows application that loads a DataTable from the specified query and then generates INSERT, UPDATE, or DELETE SQL statements based upon the type of SQL command and the selected columns of the DataTable.
WebSphere Process Server made easy, Part 2: Installation and configuration
(Addison Goering) This tutorial outlines the procedures and best practices for installing WebSphere Process Server. You’ll also learn about configuration for the business process container. It is the second in a series of three tutorials on WebSphere Process Server. (R)
Managing Distributed Transactions with ADO.NET 2.0 using TransactionScope
(Muhammad Mosa) A transaction is a unit of work. You use transactions to ensure the consistency and integrity of a database. If a transaction is successful, all of the data modifications performed during the transaction are committed and made permanent. If an error occurs during a transaction, you c
ADO.NET vNext Part 2: Using the Object Services Layer
(Thiru Thangarathinam) The first installment of this three-part article series introduced the core concepts of ADO.NET vNext, including the Entity Data Model (EDM), Entity SQL, and the Mapping Provider. It also discussed the steps involved in executing entity SQL queries against the EDM and retrievi
.NET Tip: Comparing Strings Safely
(Eric Smith) You often need to compare strings (or other data types), but sometimes a value could be null or DBNull if it’s coming from the database. The built-in C# comparison functions don’t handle nulls properly, so I wrote a couple of functions to take care of this for me.
Changes to Daylight Savings Time in 2007 may affect your databases (DB2, Oracle and others)
(Chris Eaton) In the United States the start and end of daylight savings times are being changed in 2007. Daylight savings time will now start on March 11, 2007 (rather than early April) and will end on November 4, 2007 (rather than late October). Canada has also decided to follow the same schedule.
Importing extra columns as null values
(Maria Anderson) We are migrating our Oracle database to a new environment. There are some custom tables which are present in both the databases, but the new environment database has some extra columns in those tables. Could you please help me in using the export/import utility so that the extra col
Hackers in your Database
(Steve Callan) Tinker, Tailor, Soldier, Spy comes to mind when the subject of database security comes up. How would you know if there was a mole in your database? A mole, in this context, refers to a malicious user who has hacked Oracle objects to cover his tracks, and much like the mole in John le
Getting to know the Atom Publishing Protocol, Part 3: Introducing the Apache Abdera project
(James Snell) Earlier articles in this series provided an overview of the Atom Publishing Protocol and described the various ways it is being utilized in real world applications. This article begins to demonstrate how you can start to implement Atom-enabled applications using a new open-source proje