(Josh Berkus and Joe Conway) Earlier today a user came onto the #postgresql channel on IRC.freenode.net with an interesting challenge: he wanted a “random” aggregate. Jan Wieck stated that it couldn’t be done, but I thought there might be a way. Oddly, the user wasn’t satisfied with my solution (I
Other News
Get a leg up on XML security development with security toolkits
(Ed Tittel) Those seeking to include various aspects of XML Security infrastructure in their environments may quickly find themselves puzzled by where to go and how to gain access to such technology for runtime use. But the availability of two different developer toolkits for Java means that at leas
DB2 UDB security, Part 6: Configure Kerberos for authentication on DB2 UDB for Linux, UNIX, and Windows
(Kevin Yeung-Kuen See, Yung Chung and Henry Chan) Using Kerberos for authentication provides a central repository for user IDs (or principals), thus centralizing and simplifying principal or identity management. Learn how to set up a single Kerberos realm environment for DB2 Universal Database for L
Query DB2 XML Data with SQL
(C. M. Saracco) The DB2 Viper release, now in beta, features significant new support for storing, managing, and querying XML data. In this article, learn how to query data stored in XML columns using SQL and SQL/XML. A subsequent article will illustrate how to query XML data using XQuery, a new lang
OLAP SQL Part 3 – RANK, DENSERANK, ROWNUM
(Chris Eaton) In addition to the OLAP grouping functions there are other OLAP functions that can be used to help order rows or to show ordering within a grouping. The first of these is the RANK function. Rank will display the value of the rows order within a set. So for example if I have 10 rows in
Nested declarative data binding in ASP.NET 2.0
(Fritz Onion) I’m becoming more and more enamored with the declarative databinding model of ASP.NET 2.0 the more that I use it. One issue that it deals with rather nicely is the asymmetric nature of join queries and their corresponding update statements, which I find to be one of the most common que
Performance Monitoring – Garbage Collection
(Raymond Lewallen) I see this topic quite a bit on newsgroups and in microsoft chats. People ask how and what to monitor to check out the performance of their application. First and foremost, I tell people to get CLRProfiler.
Walkthrough: Encrypting and Decrypting Strings in Visual Basic
This walkthrough shows you how to use the DESCryptoServiceProvider class to encrypt and decrypt strings using the cryptographic service provider (CSP) version of the Triple Data Encryption Standard (TripleDES) algorithm. The first step is to create a simple wrapper class that encapsulates the 3DES a
Successfully installing Oracle Applications 11i on Windows 2000/NT, part 1
(Richard Stroupe) Oracle provides a utility, called RapidWiz, to automate the 11i Apps installation process. RapidWiz prompts the user for specific locations of prerequisite software, as well as the locations to install the underlying components used by the E-business suite. All three tiers are inst
DBCC IndexDefrag is your Friend!
(William Ryan) Quite often, databases evolve into things that their original designs never had in mind. This usually isn’t good. There’s also not much you can do about it, ‘feature creep’ is a fact of life in the IT field. However, as a develoep or DBA, you often get ‘deal breaker’ requests that