(Rudy Limeback) I need to compare one field in my table against an entire column in another table. The second table has a list of excluded codes that do not need to be in the first table. How would I go about doing this? (R)
Author: SSWUG Research
Replace all occurrences of a pattern in a string with VB.NET
(Irina Medvinskaya) When you need to find a certain pattern of a string and modify the text to hide the contents, you can utilize VB.NET’s Regex.Replace method. Regex.Replace is a very efficient way to replace values. It allows you to replace the string with a fixed string literal, and it provides a
Add advanced search to your WebSphere Commerce store with OmniFind Discovery Edition
(Marc Grosse and Xiaomei Wang) IBM OmniFind Discovery Edition integration with WebSphere Commerce enables you to easily add advanced search and navigation to your WebSphere Commerce store, thereby helping to reduce site abandonment and increasing online conversion. This article provides step-by-step
All Input Data Is Evil—So Make Sure You Handle It Correctly and with Due Care
(Dino Esposito) IT professionals agree that input is a big source of trouble. Input ultimately determines how applications work and wrong or malicious input may cause serious damage. It is extremely important that developers have this fact firmly in mind and consequently apply adequate countermeasur
Microsoft Access ‘Northwind Traders’ Migration to Oracle Application Express
This document contains a guide to migrate the commonly used Microsoft Access sample application, Northwind Traders, to Oracle Application Express. This is a multi-step process that utilizes several products to migrate first the database to Oracle and then the application. It is important that these
SQL 2005 Backups using LightSpeed
(Don Schlichting) LightSpeed by Quest Software is a third party application for backing up and archiving SQL Server databases. Its backup compression algorithms greatly reduce the amount of disk space needed. The backup file created by LightSpeed can be up to 95% smaller than the original database.
RAC – finally into production
(Syed Jaffar Hussain) It was like a long cherished dream become true when we successfully moved one of our highly OLTP database from the single node to 2 node RAC on AIX platform.
‘Who you gonna call?’ For DB2, you don’t want Ghostbusters!!!
(Willie Favero) While you’re reading today’s post, hum the theme song from the movie "Ghostbusters".
DDL Replication in SQL Server 2000 and 2005
(Dinesh Asanka) You may have wondered how to add, drop, or alter (type or size) a column of a table that is an article of a publication. I have seen this question in many forums and discussion boards. Obviously, dropping the replication, making the necessary changes, and then recreating the replicat
Tip and Tricks: ASP.NET 2.0 AJAX 1.0 Extensions and Master Pages
(Bilal Haidar) In my last article, I went into details on how to integrate ASP.NET 2.0 AJAX 1.0 UpdatePanels with UserControls in your ASP.NET 2.0 web application.