(Vincent Chan) Ever experience the frustration of managing several copies of the tnsnames file on servers or desktops, or coordinating the distribution of the file to all your corporate users only to realize later that an incorrect file was distributed? These hassles can easily be avoided with centr
Author: SSWUG Research
Interview with Rohit Nadhani, Co-founder of Webyog
(Jay Pipes) Webyog is the company behind the popular SQLyog GUI tool for managing and developing MySQL databases. They have a great history of partnership with MySQL and, recently, decided to open source part of their product line. I had a chance to interview Rohit Nadhani, co-founder of Webyog, abo
Using XML pipelines – part 1
(William Brogden) Mechanical assembly lines achieve efficiency by moving product through a series of fixed machines, each one specialized to do one function very efficiently. This familiar image has inspired software designers to attempt something similar. The first example I can think of is the Uni
Microsoft Atlas makes AJAX easier
(Matt Nicholson) Microsoft Atlas aims to make AJAX development much easier for the Visual Studio developer, thanks to client-side Javascript code and Atlas-enabled controls on the server. Matt Nicholson finds out more from Microsoft’s Mike Ormond and Ian Moulster.
On splitting a string into words with regular expressions
(René Nyffenegger) With Oracle’s regular expressions, it’s relatively easy to split a string into it’s words. Easy, that is, compared with a solution that doesn’t use regexp_substr. It still requires some amount of setup as the following steps show.
Become a Master
(Aradhana Puri) The Oracle Certification program offers three distinct certification levels for Oracle Database 10g— Associate, Professional, and Master —shown in Figure 1. The three levels are organized to suit the needs of entry-level, professional, and senior-level IT professionals, respectively.
VARCHAR versus Compression
(Craig Mullins) A couple of days ago I posted a blurb giving advice on using variable character columns in DB2. After thinking about the topic a little bit more, I decided to post a follow-on topic: namely, comparing the use of VARCHAR to DB2 compression.
Build a DB2 Bound Data Application using Visual Studio 2005
(Paul Zikopoulos) In a previous series of articles I showed you all the great integration features between the IBM DB2 Universal Database for Linux, UNIX, and Windows Version 8.x (DB2 UDB) product and the Microsoft Visual Studio.NET 2003 integrated development environment (IDE).
DB2 Express-C: The Developer Handbook for XML, PHP, C/C++, Java, and .NET
(Whei-Jen Chen, John Chun, Naomi Ngan, Rakesh Ranjan and Manoj K Sardana) DB2 Express Edition for Community (DB2 Express-C) is a no charge data server for use in development and deployment. DB2 Express-C supports a full range of APIs, drivers, and interfaces for application development including PHP
Log shipping in SQL Server 2000 can provide for automatic failover
(Michelle Gutzait) When it’s necessary to have disaster recovery or high availability architecture at the database level, you have a few options for implementing it, such as: –Windows clustering –Disk mirroring –- mirroring in the physical disk level, such as RAID –Data replication –Da