(Steve Callan) SQL*Plus offers several handy features you can use to control your SQL*Plus session. The SHOW command works the same in both UNIX and Windows environments, and SHOW ALL can be used to display the settings or values of nearly 70 items. Instead of just showing these settings, SQL*Plus o
Other News
Create, Export & Encrypt Connection String on Server and Dev Machine with ASP.Net 2.0
(Steve Schofield) This article covers some basic steps and commands to encrypt your connection string and other items in a configuration file using ASP.NET 2.0. Microsoft has made it easier to have a portable key that encrypts certain sections in a web.config that are normally clear text. I have not
Exception Handling in SQL Server 2000 and 2005
(Jagadish Chaterjee) This article mainly discusses and compares the features of exception handling in Microsoft SQL Server 2000 with the same features in SQL Server 2005.
Serious scaling for open source databases
(Dana Blankenhorn) One of the biggest problems for those who want open source databasing is scaling.
Hardware considerations for simpler SQL Server failovers
(Greg Robidoux) Failing over to another system in a disaster recovery situation is the last thing you want to do. Although you won’t have to do this often, you may need to eventually — and it’s better to be prepared than not. (R)
Bulk Insert from Flat File Using Transact-SQL
(M M Harinath) In a typical IT environment, it is often necessary to import flat files to SQL Server tables. Sometimes it is necessary to format flat file according to our table structure using delimiters. In this Code Snippet, I am going to discuss how to import Flat files to SQL Server.
Table Partitioning in DB2 Viper – Details Part 2
(Chris Eaton) Let’s now look at rolling in new data. Assume you have a partitioned table where each partition is a month worth of data and you want to add a new month. The first step is to create a table that will hold the new month’s worth of data CREATE TABLE FACT_NEW_MONTH LIKE FACT_TABLE
Enable Tivoli Storage Manager for IBM DB2 Content Manager
(Lily Goh and Allan Tham) Information defines health and wealth for a corporation. The lack of information readiness can cost dearly for some. As Steve Mills, senior vice president of IBM Software Group, once put it, “Next to people, information is a company’s greatest asset. But its value can’t be
XML application migration from DB2 8.x to DB2 Viper, Part 2: Compare XML functionality in DB2 Viper to XML functionality in DB2 V8.x
(Hardeep Singh) XML support in DB2 UDB Version 8.x was based on DB2’s relational infrastructure. XML data was either stored intact as a character large object (CLOB) or shredded to relational tables. DB2 UDB Viper, on the other hand, has true native support for XML data. XML is now handled as a new
An Alternate Method for Installing DB2 V8 on UNIX Platforms
This article describes how to install and configure DB2 Version 8 on UNIX platforms without using the “db2setup” command, as described in the “DB2 Quick Beginnings” manual. There are two good reasons for using an alternate method. (pdf)