(Peter Gulutzan) Andrey Hristov added “Events” for MySQL version 5.1 when he was working on his master’s thesis for the University of Applied Sciences in Stuttgart. We liked the feature a lot, and now Andrey works for MySQL. An inspiring story, eh? And now MySQL 5.1 is getting stabler, it’s “beta” i

(James F. Koopmann) FIPS stands for Federal Information Processing Standards which includes which include a set of standards and guidelines for governments. Included are requirements for SQL to meet a set of standards. Wow! What a mouthfull. Really if you care about this you should do a search on th

(Willie Favero) Do you run into small problems when defining a DB2 object with an 8K, 16K, or 32K page size? Do you wish you could use VSAM striping and/or concurrent copy but can’t because of the page size you have chosen? DB2 even gives you an SQLCODE -905 with a reason code 00C20111 if you try to

(Chris Eaton) In the last post I described the motivation for using a completely new storage engine within DB2 for storage and management of XML data. In this post I will describe the storage in a bit more detail along with the syntax for using an XML datatype.

(chimezie) I promised myself I would write at least one entry related to my experience at the 2006 Semantic Technology Conference here in San Jose, which has been an incredibly well attended and organized conference. I’ve found myself wanting to do less talking and more problem solving lately, but I

(Jonathon Lewis) There is white paper on OTN at present about the improved sorting algorithm used by Oracle in 10g Release 2. The file name of this paper is twp_general_sort_performance_10gr2_0605.pdf and, as the name indicates, it was written about six months ago to describe the general improvement

(Grant Zhang) A SharePoint site and its contents can not only be created and updated manually, but also programmatically. Microsoft has provided SharePoint class libraries and web services for this purpose. I was involved in programmatically creating SharePoint sites, adding and updating web parts,

When you try to run a Transact-SQL query from an application in Microsoft SQL Server 2000, an access violation may occur. This problem occurs when the following conditions are true: • The Transact-SQL query contains a UNION operator. • The Transact-SQL query uses a parallel execution plan.

(Bryan Sylverson) Figure 3-7 introduces you to functions and illustrates how you use them in column specifications. A function performs an operation and returns a value. For now, don’t worry about the details of how the functions shown here work. You’ll learn more about all of these functions in cha

(David Vineyard) While developing with ASP.NET 2.0, I ran into a situation where I needed to create controls dynamically. As usual I started looking for best practice methods by searching the websites and blogs I often turn to. Every example I found talked about the need to recreate the dynamically