(Paul McCullagh) Current plans call for the use of the HTTP protocol to upload and retrieve BLOBs to and from the database. The BLOB Streaming Engine makes this possible by integrating a lightweight HTTP server directly into the MySQL server.
Other News
Rows to single string or aggregating strings
(Pawe³ Barut) In oracle there is no build-in group function that will concatenate strings, just like max summarizes all numbers. But there is quite easy way to do that in pure SQL. Assume we want to have get as an query result list of tables and column. But we want all columns to be concatenated and
Batch Processing with BPEL
(Antony Reynolds) Last week I had a question from a consultant about how to efficiently process a large number of records in a file within BPEL. He needed to take a large file and insert all the records in it into a database. Lets look at the challenges and gotchas along the way.
Move a Table to a Different File Group
(Richard Campbell) We’ve been having problems with disk space on our SQL Server. I’ve been deleting old, unimportant data, but that isn’t enough. I set up additional hard drive space on a separate drive, and I know how to create a new filegroup for the database to use. Is there a way to move existin
Increasing Productivity with CATALOG MANAGER for DB2
BMC CATALOG MANAGER for DB2 automates the tedious, error-prone management tasks involved in complex DB2 Universal Database for z/OS environments. DBAs, application developers, system programmers, and anyone requiring easy access to the information in the DB2 catalog can have BMC CATALOG MANAGER fo
Import an XML Schema into a Stylesheet Using XSLT 2.0
(Anghel Leonard) This tip shows you how to import an XML schema in your XSL pages, using XSLT 2.0
Customizing the Login Page in SharePoint 2007
(Damon Armstrong) Microsoft SharePoint 2007 gives you the option of using forms authentication, but the out-of-the-box forms-based login experience is fairly bland. It’s not bad if you’re doing something for internal use, but if you’re doing something for internal use then you’re probably using Wind
Improving the MySQL Test Framework
(Charles Cahoon) In my last post I reviewed how to create a test case using multiple connections and it is quickly apparent that keeping track of concurrent connections within test cases is difficult and error prone. Creating a tool to make test case writing easier and more automated is the goal of
Find size occupied by millions of rows without VSIZE function
(Brian Peasland) I am working on Oracle 9i. One of my tables contains around 10 million records. I want to find out the size occupied (in MB) by the first 8.5 million rows. I cannot possibly use the VSIZE function because my table contains 136 columns (which means writing 136 queries). (R)
HiT Software Delivers ADO.NET 2.0 Data Provider for DB2/400
(Alex Woodie) HiT Software last week unveiled a new version of Ritmo/i5, its data provider product connecting Microsoft Visual Studio 2005 to DB2/400. With Ritmo/i5 version 4, HiT is providing support for Visual Studio developers using the latest ADO.NET 2.0 techniques to pull data from their System