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 specif
Other News
In The Real World – Disaster!
(Steve Jones) This is a true story and is intended as a case study in showing how I actually recovered from a disaster. As close as I can remember, I am writing this from memory the night of the events, so I think it is fairly accurate. As I’ve said many times, one should always take notes, but I ha
XML, T-SQL, and the CLR Create a New World of Database Programming
(Eric Brown) The next version of SQL Server, code-named “Yukon,” includes quite a few enhancements and expanded language support. For example, Transact-SQL now conforms more closely to the ANSI-99 SQL specification and makes querying more flexible and expressive. Yukon can execute user-defined funct
Preparing an information catalog on a multipartition database
How do I prepare an information catalog on a multipartition database using the Manage Information Catalog wizard?
DB2 Cube Views Webcast: IBM DB2 Built For Business Intelligence Delivers OLAP Power
DB2 Cube Views enables faster deployment, easier management, cleaner source data (thanks to centralization of data marts) and better performance across all analytical applications. And because it’s faster and easier for end users to query, it’s also more cost-effective than competing products. T
Revamping the RSS Bandit Application
(Dare Obasanjo) In my previous article I described the inner workings of the RSS Bandit application, which aggregated information from various Web sites by processing RSS feeds on the Web. As described in my previous article, RSS is an XML format used for syndicating news and similar content from on
Optimize your undo parameters
(Marco Gilbert) When you are working with UNDO (instead of ROLLBACK), there are two important things to consider: –The size of the UNDO tablespace –The UNDO_RETENTION parameter (R)
Microsoft Plans Security Perks for SQL Server 2005
(Clint Boulton) Little by little, Microsoft is peeling away the layers of SQL Server 2005, the company’s forthcoming database server software. The Redmond, Wash., software giant unveiled new native security encryption and decryption support as well as government security certification.
Behold WSE 2.0: Removing Another Layer of WS-Pain
(Michèle Leroux Bustamante) The official release of Microsoft’s Web services Enhancements (WSE) toolkit promises to help developers deal with at least some of the pain and suffering accompanying the emerging Web services’ standards. Updated to support the OASIS WS-Security specification and a promis
Generating random numbers and strings in Oracle
(Amar Kumar Padhi) Do you know how to auto generate random numbers or strings in Oracle? Generating random numbers is required when there is a need to create a lot of data for testing purposes, or when we simply need to use a number to temporarily tag a process. It may also be necessary to generate