Testing, testing, testing. IT pros have been checking out the new MySQL 5.0 open source database since its recent release its commercial parent, MySQL AB. Some of those IT pros put our resident MySQL expert, Mike Hillyer, to the test, too. In this tip, he answers users’ questions about the ins and o
Other News
DB2 Leader Joins Ants In Database March
(David A. Utter) If the reports can be believed, former IBM DB2 leader Don Haderle may be advising the next challenger to Oracle, Microsoft, and even IBM.
Introduction to the Atlas Controls
(Brian Mains) Atlas is a free framework to develop richer web applications using AJAX with ASP.NET. It provides a means to perform server-side callbacks using client-side scripting capabilities, update only a region of the page, and add additional UI capabilities such as dragging-and-dropping capabi
Testing delays Oracle patches
(Robert McMillan) Some Oracle customers are being forced to wait for their monthly security patches. The company said that some difficulties with testing meant that some April updates would not be available until 15 May. Previously, the company had said that updates would be released on 1 May.
Tour de SQL Part II: Administrative Features
(Eric Johnson) SQL Server 2005 is so packed with new features that it can be hard to keep track of it all. Like a tightly packed peloton of Tour de France riders, the new capabilities of SQL 2005 may appear as a blur. In last month’s installment, we introduced the various versions of SQL 2005 and di
Creating custom Visual Studio 2005 code snippets
(Tony Patton) In last week’s column, we introduced Visual Studio 2005’s new code snippet features. The built-in snippets are great, but Visual Studio 2005 takes it a step further by allowing you to create your own for reuse in a project or projects. This week, we extend the concept by creating custo
Have you been considering the use of large objects (LOBs) but……
(Willie Favero) One of the reasons I am often given by customers for not diving into the wonderful world of large objects (LOBs) has been the lack of support in the LOAD and UNLOAD utilities. The LOAD is especially needed to be able to easily move a LOB into the appropriate table.
Delving Deeper into MySQL 5.0
(Jon Stephens and Chad Russell) One major enhancement that stored procedures and stored functions provide to you in your SQL programming is that they give you the ability to execute code in loops. MySQL 5.0 supports three looping constructs: LOOP , REPEAT , and WHILE . They are largely equivalent, a
AJAX and Screenreaders: When Can it Work?
(James Edwards) We’ve all heard a great deal of buzz about AJAX in the last few months, and with this talk has come a legion of articles, tips, presentations and practical APIs designed to explore the possibilities and try to arrive at best-practice techniques. But, for all of the excitement and hyp
Optimize database triggers in SQL Server 2000
(Michelle Gutzait) One of my clients called me. The frantic communication went something like this: “Our applications started to do crazy things in the database,” said the client. “We don’t understand what is happening. New rows are added to one table and another table is changed. We successfull