(Lenka Vanek and Tom Chu) Upgrading hardware is usually painless, but upgrading databases…well, everyone has a horror story to tell. The primary concerns of a seasoned Oracle DBA are the success of the upgrade and the downtime that could result. Success being not only that the upgrade itself wor
Other News
Protecting Against SQL Injection With PHP And MYSQL
(Mike Morton) With more and more programmers creating dynamic, database driven websites, the proliferation of PHP and MYSQL is reaching critical mass proportions. With that however, comes the added "bonus" of many different security holes being opened on hosted boxes everywhere. With the current atm
IBM Previews zIIP DB2-Assist Mainframe Engines
(Timothy Prickett Morgan) Contrary to his name, Jim Stallings, the general manager of IBM’s System z mainframe business line (formerly known as the zSeries) who was put into that position last week, wasted no time in getting out there and banging the drum for the mainframe and launching a new produc
Managing XML data: Tag URIs
(Elliotte Rusty Harold) Uniform Resource Identifiers (URIs) can identify things without necessarily locating them. XML namespace URIs are the most obvious such use, but many others abound. When you use URIs primarily as identifiers, it’s important to create URIs that are globally unique without impl
Generate SQL queries based on DB2 Cube Views metadata
(Jason Dere) DB2 Cube Views is an add-on feature of DB2 Universal Database (DB2 UDB) that provides OLAP awareness to DB2 UDB. A data warehouse will normally be presented as a set of tables, which requires an end user to have knowledge of what tables and columns are relevant and how to join the table
Create and Export Custom Classes as Reusable Templates in VB 2005
(Alessandro Del Sole) Visual Studio 2005 and single Express Editions implement a new great feature, which allows you to create your own project templates or item templates. These last can be added to your project when you select the "Project/Add new item" menu command.
Batch processing rules for SQL Server
(Baya Pavliashvili) A batch is one or multiple T-SQL statements executed by SQL Server as a single unit. Batches are separated by a GO statement, which marks the end of one batch and beginning of another. This command must appear on a separate line from all other commands. (R)
Introduction to Visual Web Developer 2005 Express Edition
Visual Web Developer 2005 Express Edition is part of the Microsoft Visual Studio 2005 family, and is the best development tool for building data driven web applications with ASP.NET 2.0. As part of the Express family, Visual Web Developer provides a seamless upgrade path to Visual Studio Standard, P
SQL Server DTS Designer
(Steven Warren) Prior to SQL Server 2000, the only way to back up or export databases from SQL Server to other databases was to use the bulk copy program. We all spent hours configuring scripts to do miraculous things using this cumbersome method. Then, when we finally mastered the art, SQL 7.0 was
Twelve Best Practices For Spring XML Configurations
(Jason Zhicheng Li) Spring is a powerful Java application framework, used in a wide range of Java applications. It provides enterprise services to Plain Old Java Objects (POJOs). Spring uses dependency injection to achieve simplification and increase testability. Spring beans, dependencies, and the