(Willie Favero) RELEASE (DEALLOCATE) changes a few of the rules when it comes to releasing storage. For example, even if you choose to use the DSNZPARM keyword CONTSTOR in attempt to take advantage of storage contraction, RELEASE(DEALLOCATE) negates the entire process. A commit does not trip CONTSTO
Other News
Deconstructing .NET 3.0: Windows Communication Foundation
(Matthew David) Unless you’ve been sleeping, you’ve noticed a change in the way we architect solutions. The foundation for the post-Web 2.0 world is to leverage services, such as SOAP and WSDL, to connect to clients. The client can be a web browser, server, or client solution—Apple’s iTunes being th
Oracle 10gR2 Security, Part 3: Transparent Data Encryption
(Jim Czuprynski) In the previous articles in this series, we first discussed how to implement fine-grained auditing using Oracle 10g’s enhanced DBMS_FGA package. We then looked at methods that prevent users from querying or changing data via the fine-grained access control tools that are supplied wi
Why I use explicit date math in SQL
(Xaprb) I sometimes see advice to do SQL date operations with the + and – operators on platforms where they are overloaded for date types. I try to avoid that, because it can give unexpected results. I prefer to explicitly use the built-in date/time functions. I’ll show you an example where the oper
XML Country List File
(Mads Kristensen) Today, I had to bind a list of countries to a drop down list in ASP.NET 2.0. I wanted to use an XML file to store the countries. There are more than 200 so there was not way I was going to hard code them in the HTML.
SQL to View Notification Log
(Chris Eaton) About 16 months ago I posted a series of blog entries on monitoring your database with SQL Scripts (based on a presentation I gave at IDUG Europe in 2004). Here is the start of that string of entries (click next entry near the top to read the full series).
A Quick Look at IIS 7
(John Peterson) If you’ve been curious about what to expect in the next version of IIS, there’s no need to wonder any more. Microsoft quietly slipped the latest version of their web server, IIS7, into the recent release of Windows Vista. This article will give you a quick look at the all new managem
Getting into SQL/XML with Oracle Database 10g Release 2
(Tim Quinlan) XML data is commonly used in today’s production systems and is a major part of database implementations. In the past, this fact caused design problems for database developers who consequently had to store, query, and update XML data as unstructured LOBs, or alternatively, “shred” data
Hit the ground running with AIDE, Part 7: Better IT management
(Stephen B. Morris) The IBM Autonomic Integrated Development Environment (AIDE) facilitates a model-driven approach to touchpoint development, which is a useful, factory-style, wizard-assisted pattern for producing generic touchpoints. However, at some point in the AIDE-driven workflow, the touchpoi
Managing MySQL on Solaris 10: Part 3: Inter-process communication
(Frank Mash) Ever wondered how threads exchange data between themselves?