(Kashif Butt) Object oriented applications usually have inheritance as an important part of their design, including in their domain objects. However, the corresponding data model has no built-in mechanism for specifying inheritance. Therefore, you must map your domain objects to your relational data
Other News
Refactoring your code with VS.NET 2005
(Bipin Joshi) There are developers who write code and then there are developers who write better code. The difference is obvious. Writing good code is skill that not all developers have. This also implies that this skill can be improved. A part of this skill includes ability to refactor the code tha
DB2 XML evaluation guide
(Gerald Leung and Grant Hutchison) The DB2 XML evaluation guide is a step-by-step tutorial to introduce the reader to the DB2 Viper data server on Windows platforms using the XML storage and searching (SQL/XML, XQuery) capabilities available to support next-generation applications. (R)
Introducing DB2 Viper, Part 4: Autonomic and other enhancements in DB2 Viper
(Rav Ahuja) IBM has been a pioneer in autonomic computing. DB2 Version 8 introduced a number of self-configuring, self-optimizing, and self-healing capabilities. DB2 Viper continues along this strategy of helping you derive more business value from your data, while spending less time managing it.
Manipulate time and date values with JavaScript’s Date object
(Tony Patton) One of the trickier aspects of development is working with time and date values; it seems like each language or platform has its own format. With Web development, you can utilize server-side code to manipulate dates, or you can utilize JavaScript’s Date object. In today’s column, we ta
Executing SQL Stored Procedures from inside a Web Application
(Don Schlichting) This article, the last in the Stored Procedure series, will focus on RETURN parameters. The first article in this series explained the benefits of using stored procedures as well as an example demonstrating a data grid being populated from one. The DOT NET aspx web page develop
Overview of Bulk Import and Bulk Export
Bulk-import and bulk-export operations allow you to move data easily between Microsoft SQL Server 2005 and heterogeneous data sources. For example, you can export data from a Microsoft Excel application to a data file and then bulk import the data into a SQL Server table. Bulk exporting refers to co
Introducing Common Table Expressions in SQL Server 2005
(Jagadish Chaterjee) This article mainly focuses on the new concept of “Common Table Expression” introduced in Microsoft SQL Server 2005. I shall emphasize simple code. I will use different approaches not seen in any of the previous versions of SQL Server, together with several examples covering a v
SQL Server 2005 Upgrade Advisor
The new features of SQL Server 2005 are well worth the upgrade effort, but how do you upgrade your existing systems painlessly? Microsoft’s Jennifer Perret drills into the necessary upgrade planning: preparing to upgrade, choosing the best upgrade strategy, and identifying incompatibility issues. Yo
.NET Remoting Versus Web Services (The Real Facts)
(Anil Kumar.M.S) With the advent of .NET and the .NET Framework, Microsoft introduced a set of new technologies in the form of Web services and .NET remoting. .NET remoting and ASP.NET Web services are powerful technologies that provide a suitable framework for developing distributed applications. I