(Michael Armstrong-Smith) The following is an interesting conundrum that I have come across recently and is something that you might be interested in knowing about. It’s concerned with what happens when you combine sub-totals and additional rows between group sorted items.
Other News
Copy legacy Oracle tables with SQL*Plus
(Bob Watkins) You may be running Oracle 10g Release 2, but the applications you’re supporting may have been written much earlier. Tables developed in versions of Oracle prior to 8i often used the LONG datatype to store large amounts of text.
SHOW PROFILE
(Ronald) I’ve been playing more with the SHOW PROFILE command available as part of MySQL Community 5.0.37. Thanks to the author Jeremy Cole. This command can provide some interesting insight into the workings of MySQL. It does however like most new releases of software enable users to make suggestio
IBM announces Websphere Portal with Web 2.0 support
(Antony Savvas) IBM has announced a simplified Websphere Portal offering with enhanced Web 2.0 tooling and a set of tailored business-ready packages or “accelerators”.
Three Ways to Consume Web Services with AJAX
(Xianzhong Zhu) In recent months, AJAX has become more and more heated. How Web Service, the commonly accepted way to supply business logic, can be consumed via AJAX naturally attracts the attention of so many AJAX enabled solution providers as well as developers. In this article I will show you thr
Analyzing Requirements and Defining Microsoft .NET Solution Architectures VI: Creating the Conceptual Design
(Chris Sully) The aim of this series of articles is to provide an overview of issues surrounding the architecture of .NET Solutions. In doing so it is following Microsoft’s recommended approach and, in particular, looking at the requirements of the related Microsoft certification exam (70-300), whic
srvctl Error in Solaris 10 RAC Environment
(Padraig O’Sullivan) If you install a RAC environment on Solaris 10 and set kernel parameters using resource control projects (which is the recommended method in Solaris 10), then you will likely encounter issues when trying to start the cluster database or an individual instance using the srvctl ut
SQL Server Interview Questions and Answers – Part 5
(Pinalkumar Dave) What command do we use to rename a db?
Sample Session Providers with PostgreSQL
(Tim Schwallie) Microsoft in ASP.NET 2.0 has opened up the Session State mechanism in ASP.NET so that we can use their provider concept and create our own providers to store ASP.Net Session State data.
How do I… Use the .NET Framework to consume RSS feeds?
(Zach Smith) The process of consuming an RSS feed with the .NET Framework is not complicated. The steps involved are listed below: –Connect to the site offering the RSS feed –Download the feed XML –Load the feed’s XML into an object that allows searching –Search the feed’s XML for the n