(george.p.alexander) Sometimes overlooked and innocently missed during the development phase of a project is the existence of poor SQL queries. There can be various excuses for getting poor performance queries. But it won’t be unusual if you find somewhere during the programming life that end users
Author: SSWUG Research
FIX: You may receive incorrect results when you run a Transact-SQL query in SQL Server 2000
When you run a Transact-SQL query in Microsoft SQL Server 2000, you may receive incorrect results. You experience this problem when all the following conditions are true: • The query contains an inner join that has a one-to-one key relationship. • The query contains an aggregate expression or a
PHP 5 and Polymorphism
(David Fells) This article explains what polymorphism is and how it applies to object oriented design in particular. It also explains the pros and cons of polymorphism when working with certain versions of PHP.
Ten of the Biggest Mistakes Developers Make With Databases
(Mike Gunderloy) Although fashions come and go in software development, some things stay remarkably constant. One of these is the use of databases. You may be wonderfully up-to-date with an AJAX Web interface or the latest whizbang Windows user interface, but under the covers, you’re probably still
SAP vs. Oracle: Users speak out
(Robert Westervelt and Mark Brunelli) The ongoing fight for business applications supremacy between Oracle Corp. and SAP has technology professionals taking sides. (R)
Utilities to maintain a surrogate key architecture
(Brian Walker) This article offers some additional commentary about the use of SQL Server IDENTITY values as surrogate keys. I will describe several utility routines to help maintain a surrogate key database. I will also provide six stored procedures to implement the utility functionality. (R)
Message-level declarative security using WSE 3.0
(Pietros Ghebremicael) Web Services Enhancement version 3.0 (WSE 3.0) is a SOAP extension managed API (Microsoft.Web.Services3.dll) compatible with the .Net Framework 2.0; it ships with a design time tool (WSE Settings 3.0) that fully integrates with Visual Studio 2005. WSE 3.0 simplifies the creati
Highly Available Architectures and Capacity Planning with WebSphere Remote Server V5.1.2.1
(Chris McCollum, Byron Braswell, Ryan Brown, Ivor Castelino, Kevin Collins, Maria Koshkina, Anant Kumar and Chris Li) IBM WebSphere Remote Server V5.1.2.1 delivers a fully integrated platform that helps manage remote environments such as retail stores and branch offices. It is a key component of the
DB2 and open source: Put yourself on the map with Google Maps API, DB2/Informix, and PHP on Linux
(Marty Lurie and Aron Y. Lurie) The recent explosion of information has spawned many new technologies that help digest all these gigabytes. Most humans do best with graphical representations when trying to absorb lots of information. Geographic data, in this case from the US Census, can be visualize
Using foreign keys and referential integrity in MySQL
Referential integrity is an important concept in database design. The term refers to a state when all the references in a database are valid and no invalid links exist between the various tables that make up the system. When referential integrity exists, any attempt to link to a record which does no