(Alejandro Gervasio) Building database-driven web sites is one of the most popular trends today in web site development. However, this approach implies that potential visitors must be provided with a straightforward mechanism that allows them to search through web site content. This three-part serie
Other News
Lazy XML Enrichment
(Dave Kellogg) One of my big gripes with most content-oriented software is that it requires a big bang approach (see The First Step’s a Doozy). The basic premise behind most content software is roughly:
Optimistic Locking [DB2 9 for z/OS]
(Craig Mullins) DB2 Version 9 improves support for coding optimistic locking techniques. What is optimistic locking? Sometimes referred to as optimistic concurrency control, optimistic locking is basically just what it sounds like. We are optimists and think that usually we will be the only ones wit
Clustering Oracle RAC Virtual Machines across physical and ESX hosts
(Tarry Singh) In our previous article, we looked at the clustering possibilities across two or more ESX Servers. In this article, we will take a detailed look at various possibilities of building clusters across several physical and ESX hosts since we weren’t able to pick that one up in our last art
Did you Know? Nesting Transactions
(Kalen Delaney) Transact-SQL provides three different methods of transaction control: autocommit transactions, explicit transactions and implicit transactions.
ASP.NET Hang Case Study: Application hangs on startup
(Tess Fernandez) Recently we have been getting quite a few similar hangs in ASP.NET. From the first look they really aren’t all that similar but when we get down to the nitty-gritty we see that they all hang or rather have a very high latency, in the exact same location.
MySQL VIEW as performance troublemaker
(Peter Zaitsev) I start to see applications being built utilizing VIEWs functionality which appeared in MySQL 5.0 and quite frequently VIEWs are used to help in writing the queries – to keep queries simple without really thinking how it affects server performance.
New SQL Server Weekly Show, SelectViews, Open Access
New Weekly SQL Server Show Posted (Open access for everyone): SelectViews: SQL Server versions settling in? SQL On Call, Upcoming events…The 60 second tip of the day, keeping users from becoming numb to security and much more. Our MiniCast is all about setting up a trace using SQL Server 2000. > Watch the show here Featured Article(s) Make your Applications […]
XML to DDL imports, synchronizes database schemata
(Ed Tittel) The Freshmeat.org project known as xml2ddl provides a set of Python programs under the GNU General Public License, or GPL. Given a working Python runtime environment, this set of tools works on many operating systems, including most Windows, Linux, and UNIX platforms. It also works with
Performance: Caching vs. Reading from an In-Memory XML Document
(Damon Armstrong) I’ve been working with a number of XML documents recently. Basically I’m trying to expose configuration values stored in XML configuration files in an object-oriented structure. I’m using an in-memory XML document and just referencing values as needed from that document. The XML