(Anand Narayanaswamy) In the previous article, we examined how to work with ASP.NET 2.0. You have seen the working of some of the important WebForm controls and its usage. In this article, I will examine about the naming conventions which have to be followed while working with ASP.NET and also about
Author: SSWUG Research
Master Oracle’s time interval datatypes
(Bob Watkins) Before version 9i, Oracle had no built-in way to record the passage of time. The DATE datatype records an individual moment in time; but to express a quantity of time (i.e., an interval), database designers had to convert the interval to raw seconds and use a NUMBER column to store it.
Bulky Data Is No Problem Thanks to Compression/Decompression in .NET 2.0
(Wei-Meng Lee) One of the new namespaces in version 2.0 of the .NET Framework is System.IO.Compression. This new namespace contains two classes for data compression: DeflateStream and GZipStream. Both compression classes support lossless compression and decompression and are designed for dealing wit
Generating Excel File Using SQL Server 2000
(Aravind Kumar) This article will explore the features of SQL Server 2000 for using Microsoft tools, such as MS-Excel and DOS. Here we extensively use DOS Shell commands and ODBC database object connectivity for Excel. The main objective of this article is to generate an excel file directly from M
ASP.NET Atlas Powers the AJAX-Style Sites You’ve Been Waiting For
(Matt Gibbs) In September 2005, the ASP.NET team released the first Community Technology Preview (CTP) of the new features in ASP.NET code-named “Atlas.” This extension to the Microsoft .NET Framework 2.0 enables developers to more easily create rich, interactive Web sites that take advantage of bot
PDSE: When ‘must’ really means ‘not just yet’
(Willie Favero) If you have been reading up about DB2 Version 8, you may have come across a new acronym for DB2 folk: PDSE. It stands for “partitioned data set extended” and it has actually been around for quite a while. Maybe not as long as the other acronym that we are a whole lot more familiar wi
Oracle 10gR2 Adaptive Thresholds, Part 1: Overview
(Jim Czuprynski) Oracle 10g Release 2 (10gR2) has improved significantly the methodology for tracking performance metrics within the database. This article – the first in this series – discusses how adaptive thresholds are designed to improve the detection of threshold violations, including the abil
Disaster Prevention and Recovery with the MySQL Database
(Paul Dubois) Because MySQL tables are stored as files, it is easy to do a backup. To get a consistent backup, do a LOCK TABLES on the relevant tables, followed by FLUSH TABLES for the tables. You need only a read lock; this allows other clients to continue to query the tables while you are making a
Scaling Up with XQuery, Part 2
(Bob DuCharme) Last week, we learned that although scaling up from Saxon’s implementation of an in-memory XQuery database to a disk-based version requires a bit of extra effort, it’s worth doing because you can create applications around much larger collections of data. And, it can be done for free.
DB2 9 XML performance characteristics
(Irina Kogan, Matthias Nicola and Berni Schiefer) Learn about the performance and scalability characteristics of a simulated securities brokerage transaction processing environment using DB2 9 XML, IBM POWER5+, AIX 5.3, and TotalStorage DS8100. This scenario includes use of the FIXML schema, a finan