This tutorial shows you how to successfully create two tables and an index using the IBM DB2 Development Add-In for Microsoft Visual Studio .NET. You can use the IBM Explorer to view a sample of the contents of the table. The IBM Explorer automatically queries the number of rows that the user sp
Other News
Book Review: In the Trenches with SQL Server & .NET
(Danny Lesandrini) The Hypnerotomachia Poliphili (pronounced Hip-ner-AH-toe-mak-ee-a Poh-LI-fi-ly) is an ancient text that is the subject of a da Vinci Code style best seller named Rule Of Four. This obscure text, completed in 1499, is clearly the work of someone versed in multiple disciplines;
Stop SQL Injection Attacks Before They Stop You
(Paul Litwin) Armed with advanced server-side technologies like ASP.NET and powerful database servers such as Microsoft SQL Server, developers are able to create dynamic, data-driven Web sites with incredible ease. But the power of ASP.NET and SQL can easily be used against you by hackers mounting a
Serializing Java Objects with XStream
(Michael Fitzgerald) Joe Walnes’s XStream is a unique open-source Java library for serializing objects into XML and deserializing that XML into objects. Unlike other APIs, such as David Megginson’s XMLWriter or Elliotte Rusty Harold’s XOM, which use specific classes and methods to produce XML, XStre
In-Container Testing with JUnit
(Julien Dubois) Today, unit testing is a very popular technique for ensuring code quality. Thanks to the JUnit framework, it has become quite easy to write unit tests for simple Java applications. However, where real-world enterprise applications are concerned, the typical JUnit testXXX() method wil
Tip: Send part of an XForms instance to a Web service
(Nicholas Chase) An XForms form is handy as a Web service client because it enables you to easily send and receive an XML document, but what if you don’t necessarily want to send the entire data instance? This tip explains how you can build an instance that includes a SOAP message along with other d
DB2 Server for VSE & VM Application Designer & Programmer Workshop
Learn about Structured Query Language (SQL) used to access the data stored in a DB2 database, with attention to the facilities available only in the programming environment. Learn about table design, recovery, security, and integrity to help you understand DB2 facilities. Emphasize the DB2
Restoring a SQL Database
(Muthusamy Anantha Kumar) When we create a backup maintenance plan with one Full backup and transaction log backups for every 15 minutes, it is sometimes necessary to restore the FULL backup and all the corresponding transactional backups sequentially. This may happen if the production box goes down
Backup Scenarios for successful SQL Server Restores and Recovery
(Bilal Ahmed) The intent of this document is to explore various backup scenario plans for SQL servers and come up with a recommendation to successfully restore them when the need arises. Database Administrators (DBAs) typically spend most of their time working on configuring and monitoring backu
New CONNECT BY Features in Oracle Database 10g
(Jonathan Gennick) Recently I wrote about Oracle’s support for hierarchical queries in an OTN article titled Querying Hierarchies: Top-of-the-Line Support. While writing that article, I learned about some exciting, new features in Oracle Database 10g that strengthen Oracle’s already robust support f