Currently, MySQL supports table-level locking for ISAM, MyISAM, and MEMORY (HEAP) tables, page-level locking for BDB tables, and row-level locking for InnoDB tables.
Other News
IBM unwraps new WebSphere MQ
(Ed Scannell) Hoping to add some muscle to its application integration strategies, IBM rolled out a new version of its WebSphere MQ product with 150 technical improvements, including improved support for creating an ESB, which can serve as a backbone to a SOA.
Introduction to Web Services for Remote Portlets
(Bryan Castle) Get an introduction to Web Services for Remote Portlets (WSRP), a specification which defines how to leverage SOAP-based Web services that generate mark-up fragments within a portal application. By defining a set of common interfaces, WSRP allows portals to display remotely-running po
Best Practices for Problem Resolution and Production Support of .NET Applications
An effective .NET application support strategy is absolutely critical to minimize the risk of deploying .NET applications. To help, this paper: 1. Identifies the main components of the Microsoft .NET architecture 2. Outlines the most common .NET application problems 3. Presents strategi
Generic Linux Upgrade from Oracle9i Real Application Clusters to Oracle10gR1 Real Application Clusters Using Database Upgrade Assistant (DBUA)
The recommended method to upgrade from one Oracle release to the next is to use the Database Upgrade Assistant (DBUA). This document focuses on the upgrade part of DBUA from Oracle9i Real Application Clusters Release to the Oracle10g Real Application Clusters Release on Linux x86. (pdf)
Basic SQL Procedure Structure (Sample Chapter)
(Zamil Janmohamed, Clara Liu, Drew Bradstock, Raul Chong, Michael Gao, Fraser McArthur, and Paul Yip) Stored procedures are used to encapsulate multiple SQL statements with flow logic. They are database objects that serve as sub-routines to applications. SQL procedures are defined in a database
Enumerate SQL Server Instances in C#, Using ODBC
(Eamonn Murray) This article describes a C# class that utilises ODBC (SQLBrowseConnect) to obtain a list of SQL Servers on a network and returns an array of instances. If an instance is supplied with a valid username/password, then a list of all the databases on the instance is returned.
SQL Server 2005: a 3-tier purist’s nightmare
(John Carroll) SQL Server 2005, now available as a “community technology preview,” is an odd beast. For those who believe their databases should be little more than simple data access routines with business logic placed at the “middle tier,” the move towards application server technology integrate
Connecting Legacy Code to .NET
(Linda L. Briggs) Healthcare provider Beverly Enterprises faced an interesting challenge when it decided to streamline its processes and create user-friendly interfaces to 20-year-old legacy mainframe data.
sqlcmd Utility in SQL Server 2005
(Vinod Kumar) Out of the many utilities that SQL Server 2005 has come up with I thought to take a sneak preview of the command line tools that got introduced with SQL Server 2005. Yes, sqlcmd Utility. Even though the intend is to use sqlcmd moving forward rather than the conventional osql comman
