(Vasantha Jayakumar) The IBM Database Add-ins for Visual Studio 2005 allow users working in the Visual Studio 2005 environment to connect to several IBM databases and perform rapid application development, as well as several database operations. The latest release of IBM Database Add-ins for Visual
Other News
Using Nested Grids in .NET
(Paul Kimmel) Get the step-by-step details on how to use nested grids in .NET to provide rich web-client presentations. (video)
Prompt for Service Account During Windows Service Installation
(Steve Hall) This article shows how to customize the installation of a windows service in Visual Studio 2005 to prompt for a service account username and password. This process involves combining several separate techniques than can each be used for other purposes (like passing setup screen values t
MySQL Performance – eliminating ORDER BY function
(Peter Zaitsev) One of the first rules you would learn about MySQL Performance Optimization is to avoid using functions when comparing constants or order by. Ie use indexed_col=N is good. function(indexed_col)=N is bad because MySQL Typically will be unable to use index on the column even if functio
Integrate XForms with the Google Web Toolkit, Part 4: Creating interactive forms with GWT and XForms
(Michael Galpin) In this final installment of the series, you’ll add an interactive form for adding new albums for an artist. This will use GWT Ajax, JSNI, and XForms controls. You’ll look at how GWT can augment XForms. To demonstrate this, you’ll look at how you can use GWT to provide localized con
Oracle BI EE 10.1.3.3/2 – Blocking Answers Requests
(Venkatakrishnan J) One other least explored/talked about feature of BI EE is the Blocking Requests feature. One can have customized pop up messages prompting users to enter valid data. For example, as administrators we might know that certain columns once pulled into the report will consume huge am
DB2 ‘Viper 2’ Accelerates IT Agility
(Deb Jenson) Real-time information is crucial to businesses today. Companies need to make information-based decisions and introduce new products and services before their competitors do. The challenge for IT is not only to keep up with the pace of change, but also to lead with innovation that’s alig
External Tables with 11g JDBC driver
(Pas Apicella) External tables arrived in the Oracle 10g database today I had to give it a test drive on a 11g database with the 11g JDBC driver. In the old days I would use sql*loader to load a flat file into the database and then access the data but with external tables you can avoid that as shown
Security
(Arup Nanda) In 2006 OTN pubished a series of articles I authored called “Project Lockdown: A Phased Approach to Securing Your Database Infrastructure”, in which I discussed how to address common security challenges such as the use of default passwords by users, and how to scan your database for the
Normalization’s other little side effect…
(Louis Davidson) It isn’t that I don’t like a challenge, really it isn’t. I like puzzles, mazes, Suduko, video games with challenging levels where I have to really think about a problem to solve it. So why don’t I like poorly designed databases, where finding a value that you want can be just as c