(Peter Zaitsev) This week I already had two serious performance regression cases when upgrading from MySQL 4.0 and 4.1 to MySQL 5.0. By serious I mean several times performance difference not just 5-10% you often see for simple queries due to generally fatter code.
Other News
End-to-end Ajax application development, Part 1: Set up an Ajax environment with a scenario
(Senthil Nathan) Ajax (Asynchronous JavaScript + XML) is quickly emerging as a modern way of bringing desktop-quality software features to Web applications running on browsers. Open source software such as Linux-Apache-MySQL-PHP (LAMP) and open standards-based Java 2 Platform, Enterprise Edition mid
No Data Can Outrun This ‘Cheetah’
(Clint Boulton) Informix isn’t ready to retire. IBM said it has refreshed its Informix Dynamic Server (IDS), adding continuous availability and disaster-recovery features to its online transaction-processing (OLTP) database.
Unit-Testing XML
(Stefan Bodewig) There are many occasions where software creates XML output. XML documents are used for data interchange between different applications, web application create (X)HTML output or respond to AJAX requests using little XML snippets. There are many use cases where XML is generated and th
Achieving Openness: a closer look at ODF & OOXML
(Sam Hiser) An open, XML-based standard for displaying and storing data files (text documents, spreadsheets, and presentations) offers a new and promising approach to data storage and document exchange among office applications.
Distinct Counts in Analysis Services 2005
(William Pearson) In this article, we will gain some hands-on exposure to distinct counts in Analysis Services 2005. Our examination of the expanded capability will include: –A discussion surrounding the general concepts of distinct counts, including why they are useful (and often required) with
Creating Master Detail Pages using GridView
(Bipin Joshi) Many months ago I wrote an article title that demonstrated the use of DataList and DataGrid controls to create master detail pages. ASP.NET 2.0 introduced GridView control supersedes the older DataGrid control and adds many enhancements. In this article I am going to show how master d
Summarizing Data with CUBE and ROLLUP
(Mike Chapple) Looking for a quick, efficient way to summarize the data stored in your database? The SQL ROLLUP and CUBE commands offer a valuable tool for gaining some quick and dirty insight into your data. ROLLUP and CUBE are SQL extensions and they’re available in SQL Server 6.5 (and above) an
DB2 9 for z/OS Technical Overview
(Paolo Bruni, Roy Cornford, Raphael Garcia, Sabine Kaschta and Ravi Kumar) This IBM Redbooks publication introduces the enhancements made available with DB2 9 for z/OS. Its scope is to help DB2 for z/OS users understand the functions offered by DB2 9, justify their investment in installing or migrat
Scripting Solutions for SQL Server
(Buck Woody) For many department size installations of SQL Server or smaller, you’ll perform most of your management and maintenance tasks using graphical tools. For SQL Server 2000, that’s Enterprise Manager and Query Analyzer, and for SQL Server 2005 you’ll use SQL Server Management Studio and the