(Lorenzo Alberton) In our big-brother-esque age, we like to have everything under control. While in real life it may not always be a good thing, we certainly want to know what happens to our data. I’ve seen all sort of solutions to log database changes, many of them in PHP or some other language, b
Author: SSWUG Research
Data Manipulation and More for HTML DB Applications
(Lawrence Linnemeyer and Bradley Brown) In this conclusion to a three-part series covering the addition of validations, computations, and processes to an HTML DB application, you will learn about data manipulation, manually creating a web services process, and more.
Lock conflicts with Automatic Row Processing (DML)
(Patrick Wolf) Oracle APEX 3.0 contains a nice new feature you should be aware of. There is a new substitution variable APEX_DML_LOCK_WAIT_TIME which you can use to define how the behavior of the “Automatic Row Processing (DML)” and ApplyMRU/D processes should be in case if the processed row is lock
Left, up, down, right … GROUP!
(Tim Dexter) The majority of reports I see are laid out as what is termed ‘group above’, the break groups appear above the detail data thus.
Improving the performance of queries using SQL Server Part 2
(Pete O’Hanlon) In the previous article SQL_Server_Performance.asp, we discussed using SQL Profiler to identify queries that need looking at, to see if performance can be improved. We learned how to set the criteria that allow us to focus on the queries that are most likely to give us performance ga
Performance Impact of Using NTFS Compression with Read-Only Databases
(Linchi Shea) SQL Server 2005 supports placing read-only filegroups or read-only databases on NTFS compression. In other words, you can compress the database files in a read-only filegroup or a read-only database. This can be a very useful feature if saving disk storage is of high priority.
Important New Concepts in Windows Presentation Foundation
(Adam Nathan) To finish Part I of this book, and before getting to the really fun topics, it’s helpful to examine some of the main concepts that WPF introduces above and beyond what .NET programmers are already familiar with. The topics in this chapter are some of the main culprits responsible for W
Temp Tables and Table Variables: When To Use What And Why – Part 1
(George P. Alexander Jr.) An experience I had once upon a time made me look at writing efficient code even more seriously and meticulously. You usually learn these things the hard way and for me, this was one of those situations where you had to clean up someone else’s code and such an excerise teac
‘Myth-Busting DB2 Version 8 CPU Regression’ in z/Journal Magazine
(Willie Favero) Cute title, right? That’s what we called my latest article in z/Journal Magazine. If you like to take a look at the pre-publication of this article, go here: “Myth-Busting DB2 Version 8 CPU Regression”
Using Java to Produce SVG Code in XHTML Data
(Richard G. Baldwin) This is the third lesson in a series designed to teach you how to write servlets to produce SVG code that will be rendered in graphic form by an SVG-compatible browser. In this lesson you will learn how to write Java code to produce XHTML files containing in-line SVG/XML code.