(Muhammad Mosa) A transaction is a unit of work. You use transactions to ensure the consistency and integrity of a database. If a transaction is successful, all of the data modifications performed during the transaction are committed and made permanent. If an error occurs during a transaction, you c
Other News
Redirect I/O to a TextBoxWriter in .NET
(Paul Kimmel) A data stream is like a river where you set data adrift. You put data on the river and it floats along, waiting to be plucked out at some other location. As with streams in nature, you can move up or down the stream, see what’s there, and put in or take out things. Streams in .NET work
CodeSnip: Charting with DataGrid Control
(Amal ElHosseiny) This article discusses how to create charts inside a DataGrid control using an XML file.
An Object-based Approach to HTTP Compression in PHP
(Alejandro Gervasio) Welcome to the second tutorial of the series “Using HTTP compression in PHP.” In three parts, this series demonstrates how to apply HTTP compression to parsed PHP pages, in order to reduce their overall download times, which results in faster delivery of dynamic content.
Master Pages: Tips, Tricks, and Traps
(scott) Master pages are a great addition to the ASP.NET feature set. Master pages help us build consistent and maintainable user interfaces. Master pages, however, are not without their quirks. Sometimes master page behavior is surprising, and indeed the very name master page can be a bit misleadin
SQL 2000 to SQL 2005: Where Have All the Old Features Gone?
(Boris Baliner) As more DBAs across the planet begin using SQL 2005 Tools, but still manage SQL 2000 servers with them, I suspect there will be lots of muffled moaning as to where all the good old features have gone. Although Management Studio has some very nice long-awaited features, some of the go
Introducing the SQL Server 2005 Surface Area Configuration tool
(Adam Machanic) As part of Microsoft’s secure computing initiative, many new security features were added to SQL Server 2005. While features like encryption and granular permissions control secure databases within a server, other features are dedicated to securing the “surface area” of the server. T
FIX: You receive an access violation error message when a user-defined function is in a high-stress scenario in SQL Server 2000
When a user-defined function is in a high-stress scenario in Microsoft SQL Server 2000, you receive an access violation error message.
Using DOM 3.0 Validation Techniques with XDK 10g
(Deepak Vohra) The DOM 3.0 Validation specification provides for validation of an XML document with a DTD or an XML Schema. The advantage of DOM 3.0 Validation over validation with a validating parser such as the DOMParser is the support for dynamic validation. The DOM 3.0 Validation specification i
From DAD to annotated XML schema decomposition
(Mayank Pradhan) The annotated XML schema decomposition feature introduced in DB2 Viper can be used to decompose XML documents, wholly or partially, into relational tables. It uses annotations in XML schema as the mapping language to map information in an XML document to relational tables. The new X