(Sara Cushman) Though plenty of people have already caught a glimpse of SQL Server 2005, and some companies are even using Beta 2 in production environments, most enterprises won’t be seeing the latest release of Microsoft’s DBMS until it ships early next year. But attendees at 2004 PASS Community S
Other News
Data Validation Using .NET and External Metadata
(Jonathan Schafer) Using .NET reflection and external metadata makes it easy to add data validation to your objects. Nearly every application that collects data, whether from a Windows- or Web-based form or from a file, needs to validate that the data is in the correct format.
Introduction to IBM Content Manager Portlet Version 2.0.1
(Jane Kohn) The primary focus of this article is on the DB2 Content Manager (DB2 CM) Portlet Version 2.0.1. The DB2 CM Portlet is a DB2 CM Web application that invokes the DB2 CM Java Web Component Toolkit (JWT) and DB2 CM Java Beans components to interface with a DB2 CM server. The portlet implemen
Ease Swing development with the TableModel Free framework
(Michael Abernethy) This article introduces the TableModel Free (TMF) framework which eliminates the need to use TableModels with Swing JTables. The TMF framework allows for more configurable JTables by moving all of table-specific data outside of the compiled code and into a configurable XML file.
Managing Software Entropy with RefactorIT and Oracle JDeveloper 10g
(Dr. Robert J. Pefferly, Jr., Yuri Schimke, and Tanel Unt) The Second Law of Thermodynamics, also known as "entropy," dictates that the chaos of a system increases with time and decreases if and only if outside energy (work) is applied to order the system. In the world of programming, this law often
Stuck in the Senate
(Paul Ford) Last month we created an RDF representation of the United States Senate, and this month I was going to do the same for the House of Representatives. But after looking closely at my Senate RDF, and thinking about the sort of queries I wanted to make of it, I realized that it’s a mess. So
SQL Server Alerts
(Leo Peysakhovich) SQL Server alerts provide an elegant administrative tool to automatically notify pre-designated operators of server event occurrences. Organizations benefit quickly, as alerts make their DBAs more proactive to conditions requiring their attention. You can enable automation of
Bulk Data Transactions using OpenXML
(Harikishan & Ravi Chander) OPENXML is a new function added to SQL Server 2000 that provides a rowset view over an XML document. Since a rowset is simply a set of rows that contain columns of data, OPENXML is the function that allows an XML document to be treated in the familiar relational database
Sample Application: XML Form Generator, Part 3: Displaying the Results
(Andrew Mooney) Part 1 of this series demonstrated how to create an XML form using a DataGrid in a web page. Part 2 focused on how to display the XML form using XSL and then save the user input to a new XML file. This final part of the series will show how to create a web form that will […]
Mining your Business in Retail with IBM DB2 Intelligent Miner
This tutorial shows you how to apply data mining techniques using IBM DB2 Intelligent Miner to generate automatically product recommendations for customers in a possible e-commerce shop environment. (R)