(Stephen L. Michel) MySQL Version 5.0 promises more features that make it much more palatable for database traditionalists, and likely making it more welcome in IT departments, alongside Oracle, Microsoft SQL Server, and Sybase SQL Anywhere. A conference in Santa Clara, CA this week should shed more
Other News
Create Your Own Project Item Templates in VS 2005
(Paul Kimmel) Visual Studio supports extensibility in a couple of ways. One way is to implement the IExtensibility2 interface; another is to implement the IDTWizard interface. An existing IDTWizard is contained in the VsWizard.dll. This wizard supports project items and project templates, permitting
MSMQ for .NET Developers, Part 2
(Michael Jones) Part 1 of this article included an example that demonstrated how to read messages from a queue asynchronously. That example worked by first calling BeginReceive on the queue object and then setting a delegate called whenever a new message is received. The BeginReceive method call inc
Best Practices of Coding
(Anand Kumar Rao) Quality makes the application masterpiece and it’s the responsibility of the developers to focus more on high quality coding. This document covers few recommendations to leverage the quality ,how to avoid bad coding in .NET by using FXCop 1.30 and how to write custom rules through
An introduction to IBM DB2 Connect: It’s more than meets the eye
(Leon Katsnelson and Paul C Zikopoulos) IBM DB2 Connect has become the choice method for opening up DB2 for z/OS databases and all of the traditional recognized benefits of the zSeries hardware platform to the world of applications that run off the mainframe — namely, distributed applications. This
Practically Groovy: Mark it up with Groovy Builders
(Andrew Glover) Groovy Builders let you mimic markup languages like XML, HTML, Ant tasks, and even GUIs with frameworks like Swing. They’re especially useful for rapid prototyping and, as Practically Groovy columnist Andrew Glover shows you this month, they’re a handy alternative to data binding fra
Going Native, Part 2
(Ronald Bourret) The second major use of native XML databases is data integration. XML is well-suited to data integration because of its flexible data model and machine-neutral text format. In addition, XQuery is a good data integration language because of its ease of use, support for transforma
Integrating XML and Relational Database Technologies: A Position Paper
(Giovanni Guardalben and Shaku Atre) The XML markup language should be the lingua franca of data interchange, but its rate of acceptance has been limited by an underlying mismatch between XML and legacy relational databases. This, in turn, has created a need for mapping tools that can make it relat
Retrieving Objects from SQL Server Using SQLXML and Serialization
(Gianluca Nuzzo) This article will describe how to design a data access layer for a set of entities. You’ll learn how to write an XSD schema and design two simple helper classes — one for reading an XML stream from SQL Server using SQLXML and another for deserializing the XML stream.
Oracle/PLSQL: BEFORE INSERT Trigger
A BEFORE INSERT Trigger means that Oracle will fire this trigger before the INSERT operation is executed.