(Subal Mishra) Input validation ensures a user not only enters or selects values when required but also enters appropriate and correctly formatted values. Any user input form/window that support insert, update, delete or any calculated functions are all common scenarios where input validation should
Author: SSWUG Research
Download DataStage 8, Information Analyzer and IBM Information Server for Windows AIX and Linux
(Vincent McBurney) Looks like the Information Server 8.0.1 is now available for AIX, Linux and Windows and can be downloaded from the IBM website.
Oracle to Buy Tangosol for Data Grid Help
(Darryl K. Taft) Amid the aggressive churn of the rumor mill, Oracle has announced that it is has entered into an agreement to acquire Tangosol, a provider of in-memory data grid software.
Now Available: Profiling in MySQL
(Jeremy Cole) Back around November 2005, I started working on query profiling in MySQL via the SHOW PROFILE and SHOW PROFILES commands. It’s been an interesting ride, but profiling support is finally available in public releases of MySQL starting with MySQL Community 5.0.37!
Create custom notifications with SQL Server 2005
(Tim Chapman) In my article on sending e-mail with Database Mail in SQL Server 2005, I discussed how crucial it is to be notified when problems occur so that you can make adjustments to fix the problem and ultimately prevent it from happening again. This week, I will build a small custom notificatio
Subclassing and Overriding ASP.NET Pages—Part I
(Dino Esposito) A client recently approached me and said “we need to enter changes to some ASP.NET pages. Can you help?” Like any consultant would, I promptly replied “Sure. Tell me more.” But the client didn’t actually have much more to share than the URLs to the pages. In a nutshell, the client ha
Finding Foreign Key Constraints in Oracle
(JP Vijaykumar) Many times developers find it difficult to delete records from parent tables when child records reference those tables through foreign key (referential integrity) constraints.
Tip: Use Atom’s structure to avoid duplicates in aggregate feeds
(Tyler Anderson) Atom is a growing syndication format favored by many over the major syndication format, RSS. With any indexing system like Atom, you never want to intentionally create duplicate feeds as this can overwrite the older, original id element. And duplicated entries (if they aren’t overwr
IBM puts the shizzel into the Data Warehouse
(Vincent McBurney) IBM has been trailing Oracle in the data warehouse market share for years now. To make IBM products more attractive they have just put some shizzel into the DB2 warehouse offerings.
SelectViews: DLP, Laptop security, Monitoring SQL Server…
Video Programming for IT Professionals
