(Shinguz) “A sparse file is a file where space has been allocated but not actually filled with data. These space is not written to the file system. Instead, brief information about these empty regions is stored, which takes up much less disk space. These regions are only written to disk at their act
Other News
Tracking XML Data Changes Easily with SDO
Young Yang) Tracking data changes is an essential requirement in many software, application, and business-integration scenarios. Rigorously implementing this requirement is relatively difficult because modeling and working with the delta for typical changes is generally very involved. On the other h
ASP.NET hang/slowness on startup
(Tess Fernandez) After making some changes to their domains one of my customers noticed that their ASP.NET 2.0 applications didn’t respond anymore. HTML pages and images were serving just fine as well as their ASP.NET 1.1. sites, but all their 2.0 sites on all servers seemed to hang when browsing to
Using ASP.NET 3.5’s ListView and DataPager Controls: Sorting Data with the ListView Control
(Scott Mitchell) When binding data to a GridView using a data source control, enabling sorting is as simple as ticking the “Enable Sorting” checkbox in the GridView’s Smart Tag. Enabling sorting turns each GridView column’s header into a LinkButton that, when clicked, causes a postback and re-binds
mod_auth(nz)_ibmdb2
(Helmut K. C. Tessarek) This article shows you step by step how to compile and configure mod_auth(nz)_ibmdb2 (an Apache authentication module) using IBM DB2 Universal Database (UDB) as the database for storing user and group information. It explains the creation and use of the User Defined Functions
Understanding Single Sign-On in ASP.NET 2.0
(Masoud Tabatabaei) Normally when you are implementing authentication in ASP.NET web application, you have to create a login page for each of your applications. Imagine that you have two or more web application which are related together. So you may want to use a mechanism which allows you to create
View database structure using C#
(Scott Lysle) This article describes an easy approach to examining all of the tables, views, and columns in a database, the article is written to describe an example application that may be used to connect to a database (Oracle, SQL Server, or MS Access), view that database’s tables and views, and d
Bin packing part 3: Need for speed
(Hugo Kornelis) In the first post of this series, I explained the bin-packing problem and established a baseline solution. The second post investigated ways to increase the packing efficiency. In none of these posts did I pay particular attention to performance – and frankly, it shows. Performance o
Determining SQL Server database storage requirements
(Denny Cherry) Determining accurate storage requirements in SQL Server is an ongoing process that you should repeat regularly throughout the life of the database application. The first time to decide how much storage you’ll need is during the development phase of the database application’s life span
Oracle 11G – Compound Trigger
(Patch) In Oracle 11G it is now possible to create a compound trigger. One piece of trigger code that holds all the code for the different triggers you would want. Why do we want to have this? Consider a solution for a mutating table problem. Normally you would use about at least three different tri