(Arthur Fuller) Cross-tab queries are an extremely common requirement in database applications. Given SQL Server’s stability, performance, and range of tools, it is surprising that no facility is provided for building cross-tab queries. But before I demonstrate how to build cross-tab queries, I’ll r
Other News
IBM, Oracle Tie For No. 1 In Database Market
IBM and Oracle tied last year for No. 1 in worldwide new license sales for relational database management systems, as the total market rose more than 10 percent to $7.8 billion, a market research firm said.
RSS 101
(Bob Reselman) Blogging, formally known as web logging, is becoming as pervasive as email. These days it seems as if everybody—from worldwide news services to soccer moms and dads—has a blog. Newspapers and magazines with an online presence use blogging technology to publish the work of its jour
Connect to Apache Derby databases using Python
(Bob Gibson) There are times, and reasons for manipulating Derby relational databases in a language other than Java. If you are interested in using a flexible interpreted language such as Python, then this article can help you get everything set up properly.
Tools of the Trade: Application Center Test
(Rob Howard) When you sit down to write an ASP.NET application, how much time do you spend thinking about performance? It’s unfortunate, but for most developers performance is an afterthought. Performance planning and design really need to be front and center. Think about your goals and make sure on
Optimizing the Downloading of Large Files in ASP.NET
(Bruce Johnson) Maximizing performance is the holy grail of every web site. Developers are always looking for that edge…the way to squeeze more bytes of throughput from the same pipeline. Whether it be large files or small, download speed is of paramount importance. To facilitate a study of this
Cloudscape using Eclipse
(Eric Long) This demo covers the installation of Cloudscape and the IBM DB2/Cloudscape plugin. Users will also learn how to connect to a sample Cloudscape database in Eclipse.
Cold backup using RMAN
(Brian Peasland) Can one do a cold backup using RMAN? (R)
Create an XML File via PL/SQL
(Steven Swafford) This article will present the concept of utilizing the UTL_FILE package supplied in Oracle 9i or better. To comprehend this approach, you should be familiar with PL/SQL, SQL, and XML. While this article is simple and straightforward, my goal is to present an alternative that you ma
How to send e-mail notifications when new records are added to a table
(Serdar Yegulalp) In various scenarios, an administrator may want to have e-mail notifications sent out when there are updates for a particular table, i.e., when new records are added or when existing records are changed or deleted. (R)