(Alex Gorbachev) Today is the first time I had to look at MySQL performance. Tiny database as web application back-end was having significant performance issues with spikes of CPU workload. After identifying problematic queries, I found a pile of statements using IN subqueries.
Other News
New JDBC SQL/XML Features Improve XML Data Handling
(Oliver Kaljuvee) The new version of the Java Database Connectivity API (JDBC 4) is getting a major face-lift with many great new features. Perhaps the most important update is the support for the XML data type, defined by the SQL 2003 standard. While storing XML in the database and having your appl
Error handling in SQL Server 2005
(Muthusamy Anantha Kumar) In SQL Server 2005, error handling was made easy. This article illustrates various methods of handling errors using the TRY and CATCH command and various ERROR_ functions.
Make .NET 1.1 and 2.0 apps work on Windows Vista
(Brian Eastwood) There was a bit of hullabaloo recently when Microsoft announced that Visual Studio 2005 was the only version of VS that would be supported in the Windows Vista operating system. Contributor Mike Gunderloy covered all the bases in Visual Studio vs. Vista: What’s going on here? (R)
Oracle Critical Patch Update Pre-Release Announcement – January 2007
This Critical Patch Update Pre-Release Announcement provides advance information about the Oracle Critical Patch Update for January 2007 which will be released on Tuesday, 16 January 2007. While this Pre-Release Announcement is as accurate as possible at the time of publication, the information it c
Exporting DB2/400 Dates to Excel
(Jeff Haddix) In order for Microsoft’s Excel spreadsheet to recognize the set of values for a column as dates, those values must be stored as a number of days. For example, to export the date December 26, 2006, to an Excel spreadsheet, you should export the number 37,066, not a date value like 12/26
XML Matters: Ajax tradeoffs: The many flavors of XML
(Dethe Elza and David Mertz) Ajax stands for Asynchronous JavaScript and XML and the idea is that with modern Web browsers you can, with acceptable reliability, keep a channel open to the server to pass data back and forth as your Web application is used. This contrasts with standard Web techniques
InnoDB vs MyISAM vs Falcon benchmarks – part 1
(Vadim Tkachenko) Several days ago MySQL AB made new storage engine Falcon available for wide auditory. We cannot miss this event and executed several benchmarks to see how Falcon performs in comparison to InnoDB and MyISAM. The second goal of benchmark was a popular myth that MyISAM is faster than
Creating a VB.NET form that users cannot move
(Irina Medvinskaya) There are situations that require developers to prohibit users for moving a particular form. This may be required whenever you feel that the users need to fill out some data before proceeding or moving the form to work with some other application form.
Using SQL for IIS Logs Part 2
(Don Schlichting) The previous article began with the benefits of utilizing Microsoft SQL Server for Internet Information Service (IIS) web log analysis. While there are many third party packages on the market for web log analysis, sometimes you may need highly specific information derived from the