(Kevin Loney and Bob Bryla) The examples in the previous sections assumed that the same user owned the ADDRESS_TY datatype and the CUSTOMER table. What if the owner of the datatype is not the table owner? What if another user wants to create a datatype based on a datatype you have created? In the de
Other News
How to easily populate a table with random data
(Chris Eaton) Have you ever wanted to quickly populate a test table with data? Well here is a single SQL statement that you can use as a basis to add in dummy data into any table with as many rows as you need.
Secure XML messaging with JMS, Part 2: Using XSS4J to implement XML Security
(Bilal Siddiqui) Java Message Service (JMS) is a Java language-based messaging API. XML provides a simple, human-readable data format for information exchange, and is a popular syntax for the formating of enterprise data. Therefore, integrating XML into JMS applications can provide significant advan
SQL Server 2005 Database Mirroring primer
(Greg Robidoux) Since SQL Server 2000, you have been able to create a standby server using replication, log shipping and backup and restore — but now Microsoft has introduced a built-in tool that enables automated failover. Database Mirroring is a new feature in SQL Server 2005 that allows you to m
SQL Built-In Functions and Stored Procedures — Chapter 2
(Mike Faust) Stored procedures and built-in functions can greatly expand the power and usefulness of SQL, but surprisingly these highly useful tools remain untapped by many programmers. For programmers who are new to the subject or those who want to expand on what they already know, this book provid
Building Report-enabled Applications with the New ReportViewer Controls (Part 2 of 2)
(Teo Lachev) In the first part of this article, you saw how to use the Windows Forms version of the ReportViewer control. This article walks you through the differences and discusses the process for using the Web version of the control.
Top Ten SQL Performance Tips
(Sheryl M. Larsen) Structured Query Language (SQL) is the blessing and the curse of relational DBMSs. Since any data retrieved from a relational database requires SQL, this topic is relevant to anybody accessing a relational database; from the end user to the developer to the DBA. When efficient SQ
Core Web Application Development With PHP and MySQL
(Pan Pantziarka) PHP and MySQL provide the development language and database components of the LAMP (Linux, Apache, MySQL and PHP/Perl/Python) stack that drives huge chunks of the web. Over the years they have each evolved and grown in complexity and functionality and yet they are still tied togethe
V5R4 RPG Enhancements
(Ted Holt) The RPG compiler team is one fine bunch of practical people. From my perspective, everything they do seems to be motivated by the desire to help programmers do their jobs more easily, rather than by some theoretical, esoteric computer science concepts that have no practical value. (I will
Weaving WebSphere: Visual Studio vs. Eclipse (Round 1)
(Joe Pluta) My recent articles have leaned toward the overview side of the spectrum, being as they’ve been “first look” articles and coverage of topics from a managerial viewpoint. Not this one, dear reader. Despite the “Round 1” appellation, this article is going to quickly dive right into the nuts