(Tarry Singh) In part 11 of RACing Ahead with Oracle on VMware, we covered OCFS2 and its installation. The last couple of weeks, we have seen how Oracle has been contemplating the move to host its applications on its own Linux distribution. Oracle develops (or should I say the geeks at Oracle develo
Author: SSWUG Research
SAP database endorsement at Sapphire bolsters feud with Oracle
(Robert Westervelt) SAP is endorsing IBM’s DB2 database management system for midmarket applications in a move that analysts say could stave off future deployments of SAP on Oracle’s 10g. (R)
Looping for Performance – A Tuning Methodology
(Greg Scriba) In the computer performance arena we often think of “Looping” in a negative sense. But is all looping really bad? The loop control structure is actually one of the most often used control structures in programming today. This paper suggests using the loop structure in our daily perf
Legacy Systems – What Next? Consider Recycling
(Arik Kilman) Every Fortune 1,000 corporation has within its IT domain robust, mission-critical legacy applications. Deployed as far back as the 1970s and ’80s, they are often stable, reliable, fast, productive, efficient, and are the heart and soul of the enterprise. In many cases, legacy systems a
SQL Server 2005 Programmability Enhancements — Common Table Expressions
(Scott Klein) There is a plethora of new T-SQL features and enhancements in SQL Server 2005, and you could probably write a small book talking about all of them. However, this article will focus on one of them — specifically, Common Table Expressions (CTE), because personally they have come in handy
DB2 Viper: Range Partitioning and Large RID support
DB2 Viper contains innovative features for delivering information on demand and scaling databases to new levels. The Table (Range) Partitioning capabilities in DB2 Viper provide a number of advantages including better query performance, improved large table manageability, and dynamic data roll-in/ro
Planned Improvements in MySQL 5.1
(Jon Stephens and Chad Russell) Looking even further ahead, we expect continued improvements in MySQL 5.1, with the possible addition of another major feature that so far hasn’t been implemented yet. This is the implementation of triggers. Triggers are almost certain to make an appearance in MySQL 5
Using For XML in Sql Server2000
(Abey George) In order to get the data in XML format you need to change the select statement. You can use the FOR XML clause of select statement. Format of FOR XML is given below.
Oracle’s Fusion – too much, too soon?
(Nestor E. Arellano) Software maker Oracle Corp’s., release of a broad range of “Fusion” products based on a service oriented architecture (SOA) might be a case of too much too soon for Canadian firms, says one analyst.
Why Oracle Works the Way it Does (8) – Intro to Oracle Processes
(Dratz) So far we have discussed Oracle storage at different logical and physical layers and the basic memory structures. The last basic piece we need to in order to complete our “instance” is some code to actually do things.