(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
Author: SSWUG Research
GridView-DetailsView (Master/Detail) Control
(Chris Hambleton) The GridViewDetailsView control is an ASP.NET user control that displays a fully-featured GridView-DetailsView (Master/Detail) Control with the capability to edit existing records, insert new records, and delete records, along with sorting, filtering, and paging. The control can be
Performance enhancements in IBM WebSphere Federation Server V9.1, Part 2: Performance characteristics of new functionality in WebSphere Federation Server
(Susanne Englert, Simon Harris and Holger Kache) Part 1 of this series covered new features in IBM WebSphere Federation Server that are specifically designed to enhance performance. Now in Part 2, learn about performance characteristics and configuration (where applicable) of significant new functio
Error message when you use the dtsrun command prompt utility in SQL Server 2005 Integration Services: ‘This application has failed to start because SQLResourceLoader.dll was not found’
Consider the following scenario. On a computer that has Microsoft SQL Server 2000 Data Transformation Services (DTS) installed, you install Microsoft SQL Server 2005 Integration Services. Then, you use the dtsrun command prompt utility (Dtsrun.exe) to run a DTS package that contains the ActiveX Scri
Managing MySQL on Solaris 10: Part 3: Inter-process communication
(Frank Mash) Ever wondered how threads exchange data between themselves?
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
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
Decoding Microsoft’s New Document Formats
(Jeff Cogswell) For many years, Microsoft Office products have made use of a type of file called structured storage. This file type, which will soon be moved to the wayside, is a proprietary format that has its roots in the precursor to today’s ActiveX technology (called OLE, or Object Linking and E
And even more about DB2’s storage usage below the bar
(Willie Favero) So, we just talked about thread storage yesterday in my post “Did someone tell you that 64 bit would solve all of your DB2 storage issues?”. I have also had a post about the local statement cache being below the bar a few weeks ago: “The next episode in our KEEPDYNAMIC dialogue co
Memory Structures of ORACLE
(Chetan) Oracle has two types of Memory Structures: System and Program.