(Pat Moffatt, Bruce Creighton and Jessica Cao) This tutorial, Part 6 of the SQL & XQuery tutorial for IBM DB2 series, expands on Data Manipulation Language (DML) and introduces Data Definition Language (DDL) and Data Control Language (DCL). It also discusses SQL statements other than SELECT. (R)
Author: SSWUG Research
Copying Database Backups to an Alternative Location
(Gregory A. Larsen) One of the tasks a DBA must consider is developing a backup strategy for their databases. A key piece of this strategy is to ensure that a complete set of the most recent database backups are available should there be a hardware failure. This article will discuss a method of how
Develop custom client applications with IBM DB2 Content Manager C++ OOAPI, Part 3: A guided tour to using the ADClient application
(Xiao Li and Sheng Wei) The pClient and eClient, packaged with IBM DB2 Content Manager (CM), meet the client requirements of many Content Manager users. However, many others need to develop their own client applications to meet their special business needs and to integrate their own business with CM
FIX: You may receive an access violation error message when you run a linked server query that includes a subquery
When you run a linked server query that includes a subquery in SQL Server 2000, you may receive an access violation error message.
Alerting capabilities in SQL Server 2005
(Jeremy Kadlec) Native alerts were valuable in SQL Server 2000, but at the same time they were unreliable in many cases due to SQL Server Mail’s dependency on MAPI with Outlook. Many ‘work-arounds’ were created to improve the inherent functionality based on individual needs. SQL Server 2005 has alle
Using BITS to Upload Files with .NET
(Phil Wilson) Although FTP is commonly used to transfer files over the Internet, it’s somewhat unfriendly to firewalls, because of the various ports that need to be opened. A Microsoft solution you can use for Internet file transfer is the Background Intelligent Transfer Service, BITS for short. BIT
Hit the ground running with AIDE, Part 5: Build an autonomic computing system
(Stephen B. Morris) This tutorial — the fifth in the series — illustrates the management of Apache Derby databases using touchpoint technology. Learn how to use a touchpoint that contains a working instance of Derby, and work through a management interface to a Derby database instance as a Web ser
An Approach to Viewing the Structure of a Database Using VB 2005
(Scott Lysle) This article describes an easy approach to examining all of the tables, views, and columns in a database, the article is written to describe an example application that may be used to connect to a database (Oracle, SQL Server, or MS Access), view that database’s tables and views, and d
Why you may want to build rather than buy a .NET app
(Tony Patton) Should you purchase an off-the-shelf product and mold your business to fit it, or build what you need from the ground up? The build vs. buy debate is almost as old as the IT industry. In the past, the buy option often trumped the build counterpart, but advances in development tools hav
Reorganize tablespaces using Oracle 10g Data Pump
(Bob Watkins) Oracle’s export and import utilities were re-engineered in Release 10g. Buried among the more flashy features, such as the ability to disconnect and reconnect to a running export or import job, are a number of smaller changes that help the DBA reorganize tablespaces. Here are three of