(Ian Gilfillan) Last month we looked at the MySQL Core certification, aimed at MySQL users and developers. For people wanting to go even further, there is another MySQL certification – the MySQL Professional certification, aimed at database administrators. The Core certification is a prerequisite fo
Other News
An Oracle Collaboration Suite preview
(Mark Brunelli) The Oracle Collaboration Suite is getting a facelift. Due out this summer, the third version of the product will be known as Oracle Collaboration Suite 10g release 1 and will feature major enhancements to its file management and group collaboration capabilities. SearchOracle.com rece
PHP on iSeries Could Be as Easy as a TV Dinner
(Rita-Lyn Sanders) IBM is working on a deal that would put TV dinners to shame, it could make Web developers’ lives so much easier. Big Blue wants to distribute Hypertext Preprocessor (PHP), a Web development scripting language, with all of its eServer platforms by the end of the year. It just has t
Using recursion in stored procedures
(Arthur Fuller) Recursion is one of the most elegant programming constructs in my opinion. I have used it in dozens of situations and in several programming languages. The basic concept of recursion is straightforward: a given chunk of code calls itself until some boundary condition is reached.
Review: AxpDataGrid for ASP.NET
(Andrew Mooney) The AxpDataGrid from Axezz is much more than another web grid component. This control can automatically generate both forms and grids from OleDb data sources. If you haven’t looked at this component lately, look again, you’ll be pleasantly surprised.
Sudden slowdowns in SQL Server: Database autosizing?
(Serdar Yegulalp) When a database administrator creates a database in SQL Server, he can control how the database’s filegroups (the physical files that contain the database) are sized initially and then resized later over time. The way resizing is handled can be done either by percentage or by n
ASP.NET 2.0 Internals
(Jayesh Patel, Bryan Acker and Robert McGovern) While 100 percent backward compatible with ASP.NET 1.1, ASP.NET 2.0 brings a number of internal changes to ASP.NET. These include changes to the code model, compilation, page lifecycle, and more. This article outlines those changes.
The next 700 architectures? XML’s coming impact on software design
(Rick Jelliffe) I suspect that we haven’t seen anything yet, as far as XML’s mid-term impact on software design.
DB2 Basics: An introduction to the DB2 UDB SQL administrative routines
(Roman Melnyk) The IBM DB2 Universal Database SQL administrative routines represent an easy-to-use application programming interface (API) to DB2 administrative functions through SQL. Working examples show you how to use some of these routines, which can be invoked from a DB2 command line, a command
You may receive a SqlException error message when your .NET Framework client application calls a stored procedure that has an output parameter of the nvarchar type
When you use the SqlClient class in a Microsoft .NET Framework client application to work with Microsoft SQL Server 2000 hotfix build 2000.80.811 or a later version, you may receive an error message if the following conditions are true: • Your application tries to call a stored procedure. • The