Last fall brought a bumper crop of free database solutions, with the release of MySQL 5.0, SQL Server 2005 Express Edition, and the beta version of Oracle 10g Express Edition. The Microsoft and Oracle offerings are geared more toward started implementations and learning environments, but MySQL has a
Author: SSWUG Research
Normalize Data Using Views and Triggers (1 of 2)
(Payton Byrd) Many times we inherit databases that were not designed to be completely normalized. Often, columns will be added to a table to store a pre-calculated amount instead or two seperate tables will have redundant information, such as addresses or phone numbers. If you change any of the busi
Call Administration Commands through SQL – ADMIN_CMD()
(Chris Eaton) If you are a command line DBA then you may not even notice the subtle difference between a SQL statement (like RENAME, GET DIAGNOSTICS, SET SCHEMA, etc.) and a command (like SET CLIENT, REORG, DESCRIBE, etc.). Who has time to read the ANSI SQL Standard anyway to find out what is SQL an
Error message when you use the Volume Shadow Copy Service (VSS) to back up SQL Server 2000 database files or SQL Server 2000 Desktop Engine (MSDE) database files
When you use the Volume Shadow Copy Service (VSS) to back up Microsoft SQL Server 2000 database files or Microsoft SQL Server 2000 Desktop Engine (MSDE) database files, you may receive the following error message: Volume shadow copy creation: Attempt 1. “MSDEWriter” has reported an error 0x8004
XML forking in .NET Framework 1.1
(Paulo Morgado) This article will show how to fork XML processing when using XmlReaders and XmlWriters in .NET Framework 1.1.
Upgrading to Oracle Database 10g
(Kevin Loney and Bob Bryla) If you have previously installed an earlier version of the Oracle database server, you can upgrade your database to Oracle Database 10g. Multiple upgrade paths are supported; the right choice for you will depend on factors such as your current Oracle software version and
Answering PL/SQL
(Steven Feuerstein) Although PL/SQL does not natively support the declaration and manipulation of multidimensional arrays, you can emulate these structures using nested collection definitions, which were first supported in Oracle9i Database Release 1.
Customize the DB2 UDB Control Center to better represent your business
(Paul C. Zikopoulos) With custom folders in the DB2 Universal Database (DB2 UDB) Control Center, you can group systems and databases into folder artifacts that represent your business and can more quickly and easily perform DBA tasks. Walk through the steps to customize your Control Center view.
ASP.NET 2.0 (II) Enhancements to existing controls
(Chris Sully) This article is the second in a series looking at ASP.NET 2.0 though it follows on from my earlier overview articles on the subject. In the last article we looked at the enhancements to existing controls. In this article we’ll proceed to provide an overview of the new controls that hav
WebSphere DataStage Hawk beta arrives: spoiler alert!
(Vincent McBurney) The Hawk beta software finally arrived! Warning, this blog contains Hawk (version 8) release spoilers, so if you don’t want to know what is in it until you get your hands on your own dvd then stop reading!