(Vasantha Jayakumar) The IBM Database Add-Ins for Visual Studio 2005 provides significant enhancements to application development using DB2 databases, tight integration with Microsoft Server Explorer, and enhanced debugging. It introduces IBM Designers to create database objects and includes several
Other News
JOINS in Action
The purpose of this handout is to give you mini-example of the different types of joins we covered in class using two tables. We will illustrate cross join, inner join, left outer join, right outer join, and the full outer join. For this example, I used MS Access (the screen shots look much nicer t
ALTER INDEX (Transact-SQL)
Modifies an existing table or view index (relational or XML) by disabling, rebuilding, or reorganizing the index; or by setting options on the index.
Parameterize Your Apps Using XML Configuration In The .NET Framework 2.0
(Bryan Porter) Applications are complicated. Even the simplest software invariably contains numerous settings that have to store some sort of value in order to function at even a basic level. Database-driven applications usually have the luxury of storing the lion’s share of their configuration info
User-Defined Database Functionality
(Kuassi Mensah) Beyond the out-of-the-box built-in RDBMS functionality, you often need to extend the capabilities of your database by developing your own database-resident functionality, or data logic.
Extend Constraints using Function Based Indexes
Function Based Indexes are a feature virtually every DBA and programmer will be using immediately — the ability to index functions and use these indexes in query. In a nutshell, this capability allows you to have case insenstive searches or sorts, search on complex equations, and extend the SQL lan
Digits to Charts
(Dmitry Khudorozhkov) This article presents several XSLT stylesheets for visualizing numerical data rows contained, as you may have guessed, within XML files. The article explains the details of stylesheet setup and the template design rationale.
The Viper is coming
(Philip Howard) The next release of IBM’s DB2 (for both z series and distributed systems), which is code-named ‘Viper’, will be generally available in the not too distant future: “mid-summer” for distributed systems, according to IBM. It is therefore appropriate to consider some of the new features
FIX: You may receive an error message, and the SQL Server process may crash when you copy or transfer SQL Server 2000 data
When you copy or transfer Microsoft SQL Server 2000 data, you may experience one of the following problems: • You may receive an error message that resembles the following: 2002-11-07 14:53:06.29 spid52 Error: 1203, Severity: 20, State: 1 2002-11-07 14:53:06.29 spid52 Process ID 52 attempting to
Dealing with the Dodgy GO Command
(Subramanyam Krishna Murthy) The GO command plays a very important role in Microsoft SQL Server. It signals the end of a batch of SQL statements and executes them as a whole. Seems simple enough. But using GO can be disastrous if you don’t understand its usage in a certain scenario.