(Dan Morrill) Oracle the Database Company is taking time out on its corporate blog to address a number of critics on the security of Oracle Databases. Like any other application, the security of the application is only as good as how it was configured. It is very easy to take a default installation
Author: SSWUG Research
Oracle vs. Red Hat and the Microsoft/Novell Deal
(Max Hetrick) The database giant Oracle recently announced plans to provide support for its own enterprise-level version of Linux. The Red Hat Enterprise Linux (RHEL)–based distribution will be called Oracle Unbreakable Linux. While it’s completely legal to take RHEL code, remove all trademarks, and
dmvs and CROSS APPLY
(Simon Sabin) In SQL 2005 there is a new feature by which you can extend a result set with the results of another resultset. You might think thats nothing new because thats exactly what a join is, and with the combination of derived tables you have full control, and you can use table valued function
Large Tablespaces the default in DB2 9
(Chris Eaton) Prior to DB2 9 any non long data types (i.e. not blobs, clobs or long varchar) were stored in “regular” tablespaces. Data stored in these tablespaces always had a 4 byte record identifier known as a RID. The 4 bytes are made up of a 3 byte page number and a 1 byte slot number. The slot
Migrating applications from ASP.NET 1.1 to 2.0
(Tony Patton) The introduction of a new version of a platform is always accompanied by lots of press and often excitement over much-anticipated features. Developers love to build applications with new technology, but there is often pain when moving existing, proven applications from older versions t
StAX’ing up XML, Part 1: An introduction to Streaming API for XML (StAX)
(Peter Nehrer) The Streaming API for XML (StAX) is the latest standard for processing XML in the Java language. As a stream-oriented approach, it often proves a better alternative to other methods, such as DOM and SAX, both in terms of performance and usability. This article, the first in a three pa
Using WebSphere Business Modeler to build business integration modules in WebSphere Integration Developer
(Jin Ji Wen and Wang Sheng Ping) There are two ways to create business integration modules: The first is to create a new business integration module in WebSphere Integration Developer directly. The other way is to create a new business modeling project in WebSphere Business Modeler, and then export
Leveraging DB2 Data Warehouse Edition for Business Intelligence
(Chuck Ballard, Angus Beaton, David Chiou, Janardhan Chodagam, Meridee Lowry, Andrew Perkins, Richard T. Phillips and John Rollings) In this IBM Redbook we describe and discuss DB2 Data Warehouse Edition (DWE) Version 9.1, a comprehensive platform offering with functionality to build a business inte
Upgrade to SQL Server 2005 and maintain old database while stabilizing
(Michelle Gutzait) You are about to upgrade your databases from SQL Server 2000 to SQL Server 2005. You have tested everything before the upgrade and the applications have proven stable. Though, you would still like to be sure that you can fallback to your old environment if any problems arise after
The Five W’s of Database Restores
(Gregory A. Larsen) In this article I’m going to deviate from my normal “How To” type of articles to discuss what to consider when you restore a database. I will discuss the kinds of things each DBA should go through as they are requested to perform a database restore. The things that need to be con