(Michael Jones) Microsoft offers two queuing frameworks to its ‘brand’ of developers: MSMQ and SQL Service Broker. These two frameworks offer many of the same features, but differ in some important areas that might affect which you choose for your queuing project. MSMQ is a time-tested technology, w
Author: SSWUG Research
Mimicking ROWNUM in DB2
(Craig Mullins) I was going through the many random files stored on my PC when I came across this useful nugget. A year or so ago a reader sent me this code. He and his supervisor had come up with a way to simulate the Oracle rownum feature in DB2 and wanted to share it with the world. I think, […]
SQL Server Backup I/O Performance
(Linchi Shea) I had always thought that: –SQL Server backup reads/writes sequentially, and –SQL Server backup could fully utilize the throughput of the I/O path
Enforce text case with Custom Controls
(Scott Lysle) This article shall describe the construction of three custom controls; each is used to format its text content to be either all upper case, all lower case, title case, or normal (as typed) case regardless of the format of the input. Such controls may be useful if it is necessary to loa
Zip Code Distance Calculations in MySQL and UDB
(John A. Marsh) I am currently involved in a project where the program I am writing is supposed to return a list of the 10 doctors nearest to a visitor’s zip code. Note that this is not the same as doctors in a given radius (say 10 miles), but it does use the same basic formula. This article will be
Overview of the Wizard Control in ASP.NET 2.0
(Curtis Dicken) The Wizard control is an extremely powerful and timesaving tool with over 200 properties and events. Leverage the power of this tool for all types of practical uses such as user account creation, customer registration, application set-up and just about anything you can dream up. (v
Comparing Oracle 10g column masking to relational views
(Bob Watkins) In a previous tip, I described how a column’s data could be masked (hidden) using Oracle 10g’s Virtual Private Database (VPD) feature. TechRepublic member BrooklynPennyPincher suggested I write a comparison of VPD with relational views.
To Trust, or Not to Trust?
(Priya Lakshminarayanan) Validation of an XML document against an Xml Schema guarantees that the structure and content of the xml conforms to the types defined in the schema. Does this mean that we automatically elevate the trust level of a document that has passed schema validation? Can we use sche
Oracle E-Business Suite 12 gets new manufacturing applications
(Mark Brunelli) Oracle E-Business Suite 12 is offering new capabilities for companies in the discrete and process manufacturing industries. (R)
MySQL Cluster restore
(Oli Sennhauser) Recently the question came up if it is faster to restore a MySQL cluster when all nodes are up or only ONE node from each node group during restore. The answer from our gurus was: All nodes up during restore! I wanted to find out why.