(James Koopmann) In the last article, I wrote on case insensitivity I made the point that the only way to extend an application to be completely case insensitive was to get away from the LIKE comparison and begin to use regular expression matching using the REGEXP_LIKE function. I thought it wou
Other News
An introduction to SQL Server 2005’s CLR functions
(Serdar Yegulalp) Among the many highly touted features in SQL Server 2005, the one that probably has the most relevance for programmers who work with SQL Server is the Common Language Runtime, or CLR for short. CLR allows programmers to create stored procedures, triggers, user-defined functions, ag
FIX: The query runs slower than you expected when you try to parse a query in SQL Server 2000
When you try to parse a query in Microsoft SQL Server 2000, you notice that the query runs slower than you expected. This problem may occur when the following conditions are true: • Your query is based on a view that contains many aggregate functions. • You have a filter condition on your quer
Creating Team Speed
(Sanjay Mishra) When the primary mode of transport was horse-drawn carts, one horse was enough to draw the cart and a small load of cargo. When you needed to transport a bigger load, you used carts that could be pulled by two or more horses.
Has IBM Bitten Off More Than It Can Integrate?
(Lisa Vaas) Like a cherry on top of a sundae, IBM’s Information Management division on Wednesday put its newly acquired Ascential data integration technology on top of a stack of acquisitions that, it says, is deeper and broader than any existing content management technology.
High-Availability Spurs Interest in Open Source
(Vance McCarthy) As enterprise IT begins to more aggressively consider Open Source options beyond Linux, the four other members of the LAMP-J stack often get the lion’s share of the attention.
Web services testing tools mature
(Colleen Frye) In the context of a service-oriented architecture, the notion of testing Web services, and which tools to use, is evolving. (R)
Type Converters, Your Friendly Helpers!
(Klaus Salchner) You may not have written your own type converter yet. But, any time you develop a Web form or Windows form using the Visual Studio .NET designer or use the view state architecture of ASP.NET, you rely on the help of a type converter. As the name already states, type converters are u
The .NET Framework & Protecting your Code – Introduction
(James Crowley) Microsoft plans for .NET framework to revolutionise the way developers work – both in terms of productivity and features. It has, however, introduced some problems that until now, many developers have not needed to worry about. Whatever language you choose to write your .NET programs
Commentary on the State of J2EE
(Peter Zadrozny) Over the years, I’ve witnessed the Java “evolution” firsthand—from its origins as the Oak language for TV set-top boxes; into Java, an interesting programming language initially intended for the client side (within the browser); and ultimately into Java 2 Enterprise Edition, an ente