(Dmitry Khudorozhkov) The initial idea of this article was to bring you a simplistic example of using a Scripting Runtime Library, “click here and here, blah-blah-blah, thank you”. The reason why I began writing was the need to make my and my colleagues’ scripts file-system-aware. This ability prove
Author: SSWUG Research
XML application migration from DB2 8.x to DB2 Viper, Part 1: Partial updates to XML documents in DB2 Viper
(Hardeep Singh) XML support in DB2 Universal Database (UDB) Version 8.x is based on DB2’s relational infrastructure. Previous to the DB2 Viper release, XML data was either stored intact as a character large object (CLOB) or shredded to relational tables.
Using XQuery, New Large DataTypes, and More
(John Papa) SQL Server 2005 introduces a lot of new features, but it also enhances the popular and oft-used Transact-SQL (T-SQL) language. Changes include the introduction of new datatypes to store large values using the MAX indicator, the integration of enhanced XML querying and data modification
Using XQuery to Manage XML with SQL Server 2005
(Jesse Smith) It has probably taken longer for XML to become a mainstream part of today’s applications than many developers first thought. XML is now becoming more widely used as wireless devices are becoming more secure and with better bandwidth. New technologies such as XQuery for SQL Server 2005
Checklist: Archiving SQL Server backups
(Greg Robidoux) Archiving database backups is probably relatively low on most DBA to-do lists. Unfortunately, it’s one of those things that has to be done. (R)
ASP.NET security with SQL Server 2005
(Sanjay Gulati) Today I was trying to access the web page and getting following error Error Message:Login failed for user ”. The user is not associated with a trusted SQL Server connection.
Writing PostgreSQL Functions with PL/pgSQL
(David E. Wheeler) One of the most powerful features of PostgreSQL is its support for user-defined functions written in various programming languages, including pure SQL, C, Perl, Python, and PHP. Perhaps the most common programming language for PostgreSQL functions, however, is PL/pgSQL (don’t ask
SAP To Bless IBM DB2 Viper As Best Midmarket Database
(Barbara Darrow) SAP is slated to anoint IBM’s upcoming DB2 database, code-named Viper, as the “preferred and recommended” database for midmarket customers.
Developing with Apache Derby — Hitting the Trifecta: Database development with Apache Derby, Part 3
(Robert Brunner) In the previous article in this series, “Database development with Apache Derby, Part 2: Schemas,” you executed SQL commands directly at the prompt of the ij tool. By using the ij tool, you can easily experiment with different SQL or Derby commands. Often, however, you’ll need to ex
Project Management: The Brain of the Organization
(Abraham Knell) Teamware, groupware, collaborative solutions, peer-to-peer, professional services automation, portfolio management, task management, workgroup software . . . During the past decade, project management (PM) solutions have taken on many names and faces, and have been clustered with a v