(Mary Ann Richardson) SQL Server lets you use one command to quickly create a new table containing a subset of records from a larger table. For example, suppose in Access you want to create a phone list for all employees in the Fort Myers region. To do this, you can create a new table containing onl
Other News
Enabling SOA-based Architectures using WebSphere Messaging
(Carla Sadtler, Philipp Huber and SangMin Yi) Successfully implementing an SOA requires applications and infrastructure that can support the SOA principles. Applications can be enabled by creating service interfaces to existing or new functions hosted by the applications. The service interfaces shou
What Corporate Projects Should Learn from Open Source
(Andrew Stellman and Jennifer Greene) Let’s say that you’re a programmer working on a wildly successful open source project in your free time. You’ll typically go home from work and check your inbox, find that a new patch was committed to the Subversion repository for the project, and review it care
Open For Business
(Kim Moutsos) Has IBM finally solved the age-old challenge of getting the right information into the right hands at the right time? Ambuj Goyal, new GM of Information Management Software, says it has. And now the company has the technology and the know-how to back up that claim.
Using Active Directory to Authenticate
(Abey George) Active Directory is a directory service acquainted by Microsoft to replace the senescent windows NT 4.0 domain architecture. It serves as a primal security point for controlling access to the resources with in the network. If you want to know more about the AD object structure visit Mi
Cycling the ERRORLOG file and Deleting Backup History Information
(Gregory A. Larsen) Every DBA needs a few tricks up his/her sleeves to help them better manage their SQL Server 2000 environment. In this article I will explore a couple of such tricks. I will first explore how to cycle the SQL Server error log, and why you might want to do this. Secondly I will dis
Plone Content Types With Archetypes
(Peyton McCullough) Plone is an excellent content management system. You will probably find everything you need in the system itself, or from third party content types. If you don’t, however, it is very easy to create your own content types, as this article will explain.
Generic Code in ADO.net 2.0
A majority of applications today use a database at the back-end. In application software, database systems have become indispensable. As there are many open and closed source database systems available, the development team has to make a choice as to the database system that they will use in their a
Dealing with images in content management systems, Part 2
(Tom Crane) Regardless of whether the user uploaded a new raw image or picked a thumbnail, we have now supplied the control with information about the image’s width and height, and what the server ID is (either newly generated or inferred from the thumbnail).
Process Portals: A New Way to See Business
(Alan Joch) Knowing their business’s key metrics was vital for Texas Industries (TXI), the growing Dallas, Texas, building materials supplier. With 100 locations and 2,800 employees across Texas, California, and Louisiana, TXI needed to keep a tight rein on business processes for sales, scheduling,