By John Geralds – Linux was the talk of the Oracle database user conference in the US last week, with firms looking at evaluating or moving corporate applications with database servers to run on the open source operating system.
Other News
Tutorials: DB2 Version 8 Family Fundamentals Preparation
This series of six tutorials is designed to help you prepare for the DB2 Version 8 Family Fundamentals (Exam 700) certification preparation. These tutorials provide a solid base for each section of the exam. However, you should not rely on these tutorials as your only preparation for the exam. Each
Announcement of the DB2 .Net Data Provider beta
The DB2 Development team is announcing the DB2 .NET Enablement beta program and the delivery of the initial beta. This program is further evidence of IBM commitment to strengthening the role of DB2 as the premiere database platform for application developers that use Microsoft technologies. This bet
IBM Delivers World’s Top Performing Transaction Server, Database
IBM announced a new world record for transaction processing. A new eServer(TM) pSeries(TM) system and DB2 Universal Database used half the number of processors to beat HP’s Itanium 2-based Superdome running Microsoft Windows Server 2003.
Creating Alphanumeric Sequence Using Decode
by Romer L. Vinuya – Normally, table columns with system-generated values contain numeric data (e.g. 00001, 00002, and so on). The code combines alphanumeric sequence in a column that increment even the alphabet value when the numeric value reaches the maximum. Create the table and trigger below and
Script to create a restore.bat file
(Glen Stromquist) While doing a database restructure for the purpose of upgrading a client, I had a need to restore the database from backup several times because of a flaw in the applications database restructure program. After the second time, I wrote a quick little script to create a restore.bat
Hunting Flaws in Microsoft SQL Server Presentation
This presentation was delivered at the Black Hat Windows Security Conference, and illustrates many new Microsoft SQL Server vulnerabilities and how they were found. Improvements that were made to Microsoft SQL Server in the new SP3 release to fix these vulnerabilities are also discussed. Also, a new
Metadata Create a Database Schema Repository with Meta Data Services in SQL Server 2000
Reuse database schemas with Meta Data Services
W3C brushes up SOAP standard
By Martin LaMonica – Simple Object Access Protocol (SOAP) acts as a transport mechanism to send data between applications or from applications to people. SOAP, along with Extensible Markup Language (XML) and the Web Services Description Language (WSDL), is considered to be the foundation of Web serv
Putting an XML Peg into a Database Hole
by Dan Wahlin – Employ XML and .Net technologies to move XML data into database tables despite disparate structures.