(Andy Oppel) This section covers some tuning considerations that are specific to Oracle databases.
Other News
Sorting Custom Paged Results
(Scott Mitchell) Last week I wrote an article on implementing custom paging in ASP.NET 2.0 aptly named Custom Paging in ASP.NET 2.0 with SQL Server 2005. In that article I covered how to efficiently page through large amounts of data using Typed DataSets, an ObjectDataSource control, and SQL Server
Comparison chart between ASP 1.x and ASP 2.0
(Benoyraj B) This article explores a comparison chart between ASP.NET 1.x and ASP.NET 2.0.
MySQL 5.1 – the next generation
(Ian Gilfillan) There are still people using MySQL 4.0 (and I even came across a MySQL 3.23 installation recently), but MySQL 5.1 is now the latest of the MySQL releases–with 5.1.7, the latest as I write; it has just moved from alpha to beta status. Recently I have been writing about what the futur
DB2 Versions, Service, and Such
(Craig S Mullins) Keeping up-to-date with the latest and greatest DB2 versions and functionality can be a time-consuming task. Every 18 to 36 months IBM announces a new version of DB2 with even more features and functionality than ever before.
XForms meets Ajax: Can they get along?
(Rich Seeley) When the W3C released a second edition of XForms this month as a recommendation for “new generation of Web forms,” the question that begged to be asked was where does this fit into the Web development world where Ajax is the hot technology? (R)
AJAX Isn’t All Purpose Soap
(Justin Schultz) In this article, my goal is to provide you with a thorough AJAX primer and give you a real-world illustration of its usefulness.
Oracle unveils BI suite
(Heather Havenstein) Oracle Corp. unveiled a suite of business intelligence (BI) tools and applications that folds in analytic technology from Siebel Systems as part of an effort to go up against Microsoft Corp. — from the low end of the market up through the enterprise level.
Discover and lock down vulnerable SQL Server services
(Kevin Beaver) In a previous tip, 10 hacker tricks to gain access to SQL Server, I outlined various ways SQL Server can be compromised. Here I’m going to expand upon a couple of vulnerabilities that I see time and time again when performing security assessments. (R)
Speed Up Your SQL Inserts
(Alex Kozak) Database performance is one of the most critical characteristics of almost any application, and for the developer or DBA it usually depends on how fast they can retrieve data. Hence, many a performance optimization and tuning book discusses the ways to make queries faster. Even RDBMS ma