(Adam Machanic) It all started so innocently. The MegaWare marketing department wanted a new Web site to post documents on, and the development team thought that using the SQL Server 2000 database as the document repository would simplify things. Steve, MegaWare’s DBA, didn’t see any major issue
Other News
Building .NET Applications with NAnt
(Dave Bost) A key tool in any software development arsenal is a structured build process. NAnt is a tool for building Visual Studio .NET applications that you can incorporate into your development process and that provides something greater than simply compiling code.
Class Relationships
(Kendall Scott) Classes, by themselves, aren’t particularly useful. It’s the relationships among classes that provide the foundation for the structure of a new system. The following sections explore how you use the UML to illustrate various kinds of class relationships.
An Extensive Examination of the DataGrid Web Control: Part 18
(Scott Mitchell) The DataGrid Web control includes a bevy of common features, such as paging, sorting, and row-by-row editing of the DataGrid’s underlying data. We’ve discussed how to accomplish these tasks in previous installments of the An Extensive Examination of the DataGrid Web Control article
Insight Beyond The Obvious
(Michael L. Gonzales) Data provides no judgment or interpretation and, therefore, no basis for action. Context turns data into information. When the context is well understood, business intelligence (BI) enables the transformation from data to decision to become a routine process in a business.
Happy birthday XML
(Martin Banks) XML is already so well established that is seems to have been around for decades, yet earlier this year, February 10th to be precise, saw it reach just its seventh birthday. As one of the companies that was a participant in its conception and gestation, Microsoft decided it would
More Unicode Secrets
(Uche Ogbuji) In the last article I started a discussion of the Unicode facilities in Python, especially with XML processing in mind. In this article I continue the discussion. I do want to mention that I don’t claim these articles to be an exhaustive catalogue of Unicode APIs; I focus on the Unicod
XML Data to SQL Data: There and Back Again
(Jesse Smith) Prior to the development of Extended Markup Language (XML), the only way to perform complicated queries and data analysis was by using a database. XML was developed to put data in a flat-file format for data retrieval and manipulation. One advantage of an XML file is that it can be use
FIX: A memory leak may occur when a client application uses the Dbmslpcn.dll shared memory network library version 2000.80.828.0 and connects to a local computer that is running SQL Server 2000
When a client application such as Sqlagent.exe tries to connect to a local computer that is running Microsoft SQL Server 2000, a memory leak in the client process may occur. This problem occurs when the client process uses the Dbmslpcn.dll shared memory network library version 2000.80.828.0.
Shredding a Recordset
(Allan Mitchell) Shredding a recordset in this instance means that we are going to show you how to take a recordset produced in your SSIS package, loop over the rows in that recordset, break apart the columns and do something with them. This is really useful when you want to preform an action on a r