(yolousa72) Manipulating Binary Large Objects (BLOBs) and Character Large Objects (CLOBs) has always been difficult in SQL Server. The new SQL Server 2005 provides new data types (NVARCHAR(MAX), VARCHAR(MAX) and VARBINARY(MAX)) for large object storage (up to 2 GB) allowing better manipulation as we
Author: SSWUG Research
Go XML
(David Baum) The increased use of content-rich applications and the internet, particularly for business transactions, has put new demands on enterprise databases. One way to handle these demands is with the increased use of XML. As a markup language capable of describing many different kinds of data
Configuring MySQL for Windows
(Mike Chapple) Now that you’ve installed MySQL, it’s time to perform some basic administrative and configuration tasks to ensure that your database environment is ready for production. In this installment of our MySQL series, we’ll look at the process of configuring MySQL on a Windows system. Next t
SQL to View Locks
(Chris Eaton) In my last posting I showed a query that you can use against the administration views to find the longest running queries in the system. In the example you could see an application that was in LOCKWAIT state and was trying to run an UPDATE statement on the ORG table. In this posting I’
Consuming RSS Feeds With ColdFusion
(Ben Cortese) ColdFusion doesn’t seem to get the respect it deserves amongst the dedicated Java or .NET or even PHP development circles, but having worked in all of those environments, I’d like to state for the record, that completing a large scale development project AHEAD of schedule, keeping your
Integrating IBM DB2 Intelligent Miner Visualization into your Web application
(Peter Bendel) Newly updated for DB2 Universal Database V8.2, this tutorial shows you how to deploy IBM DB2 Intelligent Miner Visualization (IM Visualization) as an integrated part of your Web application. (R)
XForms tip: XForms capabilities accessible through Mozilla and CSS
(Tyler Anderson) XForms provides incredible flexibility in the way properties defined within the XForm are displayed and behave. To take advantage of Mozilla’s CSS capabilities, pseudo elements must be accessed using Mozilla-specific pseudo classes, because although there is no current support for t
Ensuring Oracle Application Project Success: Five Keys to Successful Testing
(Jerry Herbek) Every implementation or upgrade of a mission-critical Oracle Application is unique, with its own combination of customized business processes and infrastructure requirements. Testing is the primary means to verify a project’s success in meeting users’ needs and requirements. But more
Rich Text Editor- Part I
(Haissam Abdul Malak) My friend was working on a project (building a blog website) and faced problems concerning which text editor to use. After researching all the free editors that he found were not as he expected so I took the responsibility to create a rich text editor user control and I thought
Best Practices for Migrating to IBM WebSphere Portal 6
(Philip Monson, William Trotman, Dominic Glennie, Misao Ishikawa, Simon McNab, Rob Holt, Frederic Delos and Brian Cheng) IBM WebSphere Portal Version 6.0 is an enterprise portal solution for organizations that want to improve the effectiveness of their operations. WebSphere Portal is the industry’s