(Mladen Golubovic) Data warehouse loads tend to have “deep impact” nature. Hardware used to run data warehouse infrastructure is expected to cope with tremendous load peaks, memory demands and a high degree of I/O utilization. All these parameters are heading toward one achievable target: unlimited
Other News
Introduction to MSSQL Server Analysis Services: Process Analysis Services Cubes with DTS
(William Pearson) In this article, we will examine the processing of an Analysis Services cube via another of the integrated MSSQL Server components, Data Transformation Services (“DTS”). Virtually anyone that works with MSSQL Server in an RDBMS context, and often within a data warehouse or mart des
How the .NET Debugger Works – Introduction
(Jon Shute) This article looks at how .NET debugging API works. In theory this API is simple and a joy to use, but there is a lack of a detailed overview as to how to use it in the framework SDK and you have to get some information from looking through the sources to the example debugger that is sup
A Practical Path Towards the Ultimate Microsoft SQL Server Scalability and Availability
(Justin Y. Shi) It has become a moot point for database vendors to compete for the highest transaction processing capability in the world. Modern database systems have become so well programmed; even the cheapest system can claim very high performance, given the hardware.
Writing XML Files Using the XmlTextWriter Class
(Tom Archer) This first of a multi-part series on using the .NET XML classes begins with the logical first step: programmatically creating and writing XML files or documents. From there, future articles will cover the tasks of sequentially reading XML files, writing a simple XML maintenance appl
The Advantages of Adopting Open Source Software (Sample Chapter)
(Jason Williams, Peter Clegg and Emmett Dulaney) Before you commit to the adoption of open source, Critical Thinking 101 mandates that you ask the question, “Why?” This section attempts to answer that question from a variety of perspectives. Open source has impact not just for developers and in-hous
DB2 Universal Database versus Oracle data movement
(Allan Tham) If you’ve had experience with Oracle and now are starting to learn DB2 Universal Database, this article will help you leverage your previous experience and put you on the fast track for learning how to move data from one machine to another, or from one platform to another.
The Path of Control
(Bob DuCharme) Just as XPath 1.0 was part of XSLT 1.0, XPath 2.0 plays an important role in XSLT 2.0, and all the new features of XPath 2.0 will be available to XSLT 2.0 stylesheet developers. In earlier columns on XSLT 2.0, I reviewed its new data model and some of its new functions, and this month
You receive a ‘Server: Msg 3624, Level 20, State 1, Line 1’ error message when you try to back up a database that is stored on read-only media in SQL Server 2000
In Microsoft SQL Server 2000, when you try to back up a database that is stored on read-only media such as a read-only CD, you receive the following error message: Server: Msg 3624, Level 20, State 1, Line 1 Location: “logtrunc.cpp”:337 Expression: stLSN != NullLSN SPID: 57 Process ID:
Managed I/O Completion Ports (IOCP)
(P.Adityanand) I/O Completion Ports (IOCP) supported on Microsoft Windows platforms has two facets. It first allows I/O handles like file handles, socket handles, etc., to be associated with a completion port. Any async I/O completion events related to the I/O handle associated with the IOCP will ge