(Raja Kishore Reddy) I was quite surprised when a few of my developer friends pointed out that they were not really aware of some of the XML basics, despite using Java or C# to handle XMLized data for some time. I am thrilled when they tell me that this basic workshop on XML concepts is actually hel
Author: SSWUG Research
Use XForms to create an accounting tool, Part 6: Wrapping it up
(Nicholas Chase) This six-part series demonstrates how to leverage the power of XForms in conjunction with MySQL and PHP to create an online accounting tool called X-Trapolate. Every good programming technology possesses a range of problems it excels at solving. This series highlights some of the pr
Tips for Optimizing Rails on Oracle
(Luca Mearelli) Using the Ruby on Rails framework it is relatively easy to develop complex systems that are backed by an Oracle database, but this ease doesn’t exempt the developer from the need to optimize the data model and the code that manipulates it.
FIX: The Sqldumper.exe utility cannot generate a filtered SQL Server dump file when you use the Remote Desktop Connection service or Terminal Services
When you try to connect to a remote Microsoft Windows 2000 Server-based computer by using the Remote Desktop Connection service or by using a Terminal Services session, the Sqldumper.exe utility in Microsoft SQL Server 2000 cannot generate a filtered SQL Server dump file. Additionally, you receive t
Merge Tables Gotcha
(Peter Zaitsev) I had the interesting customer case today which made me to do a bit research on the problem.
SQL Server Management Objects
(John Papa) Not only must database developers query and manipulate data, but they must also perform administrative tasks on a regular basis. SQL Server Management Objects (SMO) offer developers a robust toolset for operations such as backing up and restoring databases, and issuing Data Definition La
Get your DB2 for z/OS system ready for Developer Workbench V9.2
(Marichu Scanlon) This article discusses the system-related tasks that you, as a DB2 for z/OS V8 or V9 user, should consider when utilizing the functions in Developer Workbench (DWB). It provides an overview of DWB, then discusses customization JCLs, RACFs, and migration considerations. Finally, you
SQL Server 2005 Integration Services – Part 48
(Marcin Policht) In the most recent installments of our series dedicated to SQL Server 2005 Integration Services, we started exploring database maintenance functionality. Our interest in this subject (within the context of our series) results from the fact that SSIS Designer of Business Intelligence
XML Paper Specification (XPS) of a Word 2003 Document
(Jayaram Krishnaswamy) Microsoft breathed new life into legacy office documents by opening an XML window (Office Open XML) to its office products through its royalty-free XPS specification. XPS stands for XML Paper Specification that specifies cross-platform, open standard, document representation t
LOB sizing
(Jonathan Lewis) Some time ago, I was asked to take a quick look at an application that had to handle a lot of LOBs. The LOB-specific part of the application was actually quite simple – contracts were stored as LOBs – but only for occasional visual reference; all the “structured” information from th