(Girish Sundaram) Learn step-by-step how to implement IBM DB2 for Linux, UNIX, and Windows high availability disaster recovery in an IBM Tivoli System Automation for Multiplatforms cluster domain. You’ll derive the twin benefits of a highly reliable and available cluster and a robust, seamless datab
Other News
Maintain DTS packages in SQL Server 2005
(Joseph Toscano) Let’s assume you are supporting a customer that wants to upgrade from SQL Server 2000 to SQL Server 2005. There are many reasons to justify this decision as outlined in the following excellent white paper: Why upgrade to SQL Server 2005. (R)
Oracle BI Suite EE 10gR3 – My first encounter
(Raymond de Vries) Oracle recently released its official version of the Oracle BI Suite Enterprise Edition – 10gR3 (10.1.3.2.0 – also known as the Maui release). This version is based on the Siebel Analytics application stack, which Oracle obtained with the Siebel acquisition. The release is differe
DataTable to Excel
(Jacob Klint) A common task I’ve run across is the need to export a DataTable to an Excel spreadsheet. It’s a great way to distribute reports, etc. to users. It also seems like an obvious translation, considering the way that DataSets are usually presented in DataGrid controls.
Is 10g feeling the pinch?
(Philip Howard) In its recent quarterly results Oracle announced that its database and middleware division had grown by 17% in terms of new licence revenues. What are we to make of this? Well, it sounds (and is) very impressive. However, Larry subsequently commented that the middleware component of
Accessing form data via JavaScript and the DOM
(Tony Patton) Accessing and manipulating the various elements on a Web page is a common endeavor that is easily accomplished with JavaScript and the HTML Document Object Model (DOM). In this article, I examine the various ways to access page elements and describe how to create them.
Black Belt Administration: Performance Dashboard for Microsoft SQL Server, Part II
(William Pearson) In this article, we extend the meaning of “samples,” as well as the definition of “Administrator,” a bit further. (The Performance Dashboard can serve as an excellent tool for DBAs, as well as other “administrators” within the various layers of the integrated Microsoft BI solution.
Dynamic management function query to view index usage
(Louis Davidson) Last week, I presented a query to view I/O pressure, and (to me) more usefully, look at it in a slice of time, like when doing a performance test.
Multi Column Combo Cell for a .NET 2.0 DataGridView Control
(IssaharNoam) Several months ago, I invested several days’ work to find how to implement the multiline combobox in VS8 DataGridView control. I found several solutions but they didn’t fit my needs. I wanted something very simple. And I found it by using Owner Draw approach—just drawing a multicolumn
sprintf and printf in PL/SQL
(René Nyffenegger) There are a few things in PL/SQL that I am really missing. One of these things is printf. I am not aware of any built-in functionality that remotely resembles the elegance of printf. Ok, lpad and rpad and to_char come to mind. But these functions are, IMHO, tedious to use, especia