(Matthias Nicola) A few weeks ago somebody asked me how to select information from one branch of an XML document based on search conditions in another branch of the same document. Writing such a query in XPath (or XQuery or SQL/XML) is actually not very complicated. It’s a nice example of a query th
Other News
DB2 10 for z/OS: What do You Know About High-Performance DBATs?
(Robert Catterall) DB2 10 for z/OS, which became generally available this past October, is loaded with features and functions that can reduce the CPU cost of applications. One of my favorites is high-performance DBATs (DBATs, or database access threads, are associated with SQL statements that are is
MySQL replication for demanding users
(Giuseppe Maxia) I have been working with MySQL replication for quite a while. I have dealt with simple replication setups and I have experimented with complex ones. Five years ago I wrote an article about advanced MySQL replication, which was mostly a dream on what you could do with imagination and
Anatomy of a .NET Assembly – The CLR Loader stub
(Simon Cooper) In Windows XP and above, the OS loader knows natively what to do with .NET executable assemblies, and fires up an instance of the CLR. However, .NET also runs on Windows 98, ME, NT 4.0, and 2000. When you run a .NET assembly on the older operating systems, the CLR has to be loaded som
There are no sequential or random disk I/Os
(Linchi Shea) Okay, it’s a bit of a hyperbole. But let me elaborate.
The Complete Guide To Validation In ASP.NET MVC 3 – Part 1
(Paul Hiles) The latest release of ASP.NET MVC (version 3) has a number of new validation features that significantly simplify both the validation code AND the html outputted to the client. This multi-part article will attempt to cover all common validation scenarios and introduce all the new MVC3 v
Four tips on boosting SQL Server scalability
(Don Jones) Scaling out a SQL Server environment across multiple systems can be a difficult and complicated project, involving partitioned databases, federation and more. So, when it comes to SQL Server scalability, most organizations prefer to scale individual systems up as much as possible before
XML Browser in C# Windows Form
(Krishna Garad) In this article we will see how to show dataset data in XmlBrowser.
Take a beginner’s tour of the Informix virtual table interface with shared libraries
(Daniel Hebert and Carla Wilcox) IBM Informix provides access to external data sources through the virtual table interface (VTI). The VTI provides a set of hooks called purpose functions. As a developer, your task is to create an access method that implements VTI purpose functions and as many additi
How to Identify CPU Bottlenecks in SQL Server
(Tibor Nagy) We experience regular slowdowns on our MS SQL database. After analyzing the memory usage we would like to continue the root cause investigation by examining CPU bottlenecks. What is your recommendation to recognize CPU related bottlenecks in SQL Server?