(Craig S. Mullins) So far in this series on DB2 locking we have offered up a broad overview of what locking is and then delved into the world of table and table space locks. In this short entry, before we tackles page and row locks, we are going to look at the difference between a lock and a latch.
Author: SSWUG Research
Implementing the Inversion of Control Pattern in C#
(V.N.S Arun) Dependency Injection Principle states that there should be more abstraction between the higher level module and the lower level module. It is required to have loose coupling so that any change in the low level modules will not affect or there will be minimal impact at the higher level m
SQL SERVER – Return Specific Row to at the Bottom of the Resultset – T-SQL Script – Part 2
(Pinal Dave) “How do I return a few of my resultset rows at the bottom of the entire resultset?”
Introducing: Practical JavaScript
(Peter Vogel) Five years ago I wrote a column about JavaScript and AJAX in ASP.NET, where I asked if these tools were ready for prime time. And my conclusion was: No, they weren’t.
Differences between TKPROF and Trace Analyzer TRCANLZR (TRCA)
(Carlos Sierra) When an Oracle user process performs poorly, meaning slower that business requirements, the most common way to start its diagnostics is by turning SQL Trace on, then proceed to review the trace file that is created. This process is usually referred as “tracing” and can be accomplishe
The basics of Oracle database availability
(Jeff McCormick) Oracle database availability — and database availability in general — is essential to systems’ ability to maximize business continuity and is a critical component of a contingency plan for swiftly and efficiently dealing with potential business interruptions.
Secure deployment of PostgreSQL functions
(Joel Jacobson) Two people might be simultaneously modifying the same database function. To protect against this scenario, I created a little tool to stage the source code of all functions in pg_proc and the definition of all views.
Analysis Challenges
(Charles Hooper) Roughly 12 years ago I was attempting to analyze customer order changes that were received through electronic document interchange (EDI), specifically X12 830 documents that show order forecasted demand for specific part numbers. At the time, the EDI data was partially transformed
Use AJAX to fetch XML from an External File
(Benedict Lewis) For a project I was doing recently I needed to fetch the XML file from The Dev Blog and insert in as a news feed. I was unable to find any script or plugin that would work as I needed it so I wrote my own.
Using Apache CXF SOAP service with customized JiBX databinding
(Franz van Betteraey) This post gives a brief overview on how to build an Apache CXF SOAP service with JiBX databinding.