(Peter Aitken) This is the first in a series of articles that takes an unusual approach to teaching programming. Most articles zero in on a specific aspect of development, whether it be a language feature, a framework component, or a design principle. This approach has a lot of value, as proven by t
Author: SSWUG Research
What Windows Vista means for .NET developers
(Brian Eastwood) Not sure if your existing application will run on Windows Vista? The best way to find out, believe it or not, is to open it up and see what happens. (R)
Experiences with Oracle 10gR2 Solutions on Linux for IBM System z
(Lydia Parziale, Kathryn Arrell, Dennis Dutcavich, Terry Elliott, Bruce Frank and Erik Kane) This IBM Redbook describes experiences gained while installing and testing several Oracle solutions, such as: – Single Instance of Oracle Database 10gR2 – Including sharing ORACLE_HOME and Cloning Oracle
Removing double records (and keeping one of them)
(Patrick Sinke) Assume you have a table with contaminated data (in this example: non-unique values on col1 and col2), for instance because no unique key was implemented.
Podcasting software covers many bases
(Ed Tittel) In the last tip, we got into the markup that’s required to create XML documents to use for podcasting, including the nearly ubiquitous iTunes namespace and related document elements one must use for best results on the Apple iTunes Music Store. In this current tip, we’ll take a look at s
The Essence of Microsoft’s .NET Framework
(Saripalli Koti Reddy) Microsoft .NET Framework [.NetFx] is one of the most important technological platform to any professional associated with Microsoft technologies. In the vein of any other upcoming technology, .NET Framework is undergoing rapid changes and enhancements to empower its developers
PHP: Export Database Schema as XML
Sometimes it can be useful to have a dump of the current database schema. The script below reads the schema from a MySQL database and outputs XML that describes the schema.
Oracle indexes: Adding database performance
(Alf Pedersen) Oracle indexes : Proper database indexing is a crucial factor for the database performance. Most Oracle databases have hundreds or even thousands of indexes. This large number of indexes and their complexity make index tuning and monitoring a difficult task for the DBA.
solidDB for MySQL
(Peter Gulutzan) Solid Information Technology (www.soliddb.com / www.solidtech.com) has been around for several years, not in the limelight, but familiar to cognoscenti of the SQL world. Trudy Pelzer and I even visited their office in Helsinki a few years ago; they were all friendly and competent. (
The remote instance of SQL Server 2000 does not stop when you use SQL Server Management Studio on the server that is running SQL Server 2005
Consider the following scenario: • You have two servers that are in different domain forests. • The two servers have the same computer name. • You install Microsoft SQL Server 2000 on one server, and you install Microsoft SQL Server 2005 on the other server. • On the server that is running