(David) I really like DB2s ability to quickly restore a backed up database into a new database with a different name in a different location. Just like in SQL Server and easier to do then Oracle.
Author: SSWUG Research
Creating an Oracle driver for the Radicore Development Infrastructure
(Tony Marston) The software that I write is not intended for just one customer who is locked into a single RDBMS. Instead it can be used by virtually any customer using the RDBMS of their choice. How is this possible? I deliberately designed and built my infrastructure around the 3 Tier Architecture
DB2 goes hybrid: Integrating native XML and XQuery with relational data and SQL
(K. Beyer, R. Cochrane, M. Hvizdos, V. Josifovski, J. Kleewein, G. Lapis, G. Lohman, R. Lyle, M. Nicola, F. Özcan, H. Pirahesh, N. Seemann, A. Singh, T. Truong, R. C. Van der Linden, B. Vickery, C. Zhang, and G. Zhang) Comprehensive and efficient support for XML data management is a rapidly increasi
Use Apache Derby to develop Eclipse plug-ins
(Ilya Platonov, Artem Papkov, Jim Smith and Terry Finch) Eclipse is a powerful IDE platform that supports numerous frameworks used for the creation of GUI components (such as SWT or JFaces) or for working with data (such as the Eclipse Modeling Framework). One of the most exciting features of Eclips
Embedding Open Source
(Rich Schwerin) Oracle’s role in open source development has been a well-kept secret. It’s also the reason for this column: To inform you about Oracle’s commitment to open source software—a commitment measured by significant investments in ongoing development and support across a wide variety of ini
Delve into Hierarchical Inherited Rule-Interpreted XML
(Chad L. Meadows) With the new XML technology called Hierarchical Inherited Rule-Interpreted XML, you can replace standard Java properties with dynamic versions. It allows you to define properties that you can evaluate based on the state of the application using simple expressions or even Groovy exp
Database-related security policies to think about
(Kevin Beaver) With all the government and industry regulations affecting practically every business, sooner or later, the time will come when you’re essentially forced to put some information security policies in place. You may already have the basic policies for passwords and data backups. But the
Using Asynchronous Statistics Updating in SQL Server 2005
(Brad M. McGehee) Most DBAs are familiar with the AUTO_UPDATE_STATISTICS database option. Under most conditions, this feature provides the Query Optimizer with up-to-date index and column statistics so that optimum query plans can be created to execute queries.
Passing Information Between Master and Content Pages
(Jacob J. Sanford) With the introduction of the .NET 2.0 Framework, there came an abundance of new and cool features, not the least of which is Master Pages. Master Pages allow you, as a developer, to create the structural layout of your entire site and use this structure as a template for all of yo
Importing Dynamic Images to the Crystal Report without Database Overhead using Visual Studio 2005
(Pradeep Shukla) When it comes to import a dynamic image to the Crystal report, one would like to follow the traditional approach of storing the image in the database and then pull it to the report.