(Scott Guthrie) SQL Injection attacks are really nasty security vulnerabilities, and something all web developers (regardless of platform, technology or data layer) need to make sure they understand and protect themselves against. Unfortunately developers too often neglect putting focused time on t
Author: SSWUG Research
MySQL developing database monitoring system
(China Martens) Developers at open-source player MySQL are set to make it easier for customers to manage the software. The company is working on a project code-named “Merlin” which continually scans a user’s database network for any likely system crashes, bottlenecks or security vulnerabilities.
Oracle 1000 Events: Applications World Tour to visit 27 cities across EMEA
(Marc Sparrow) Oracle is to take its “Applications Unlimited” message to conferences in 27 cities across Europe, the Middle East and Africa (EMEA), starting on 27 September in Paris. The full-day events, which are part of Oracle’s 1000 Events Applications World Tour, are designed to discuss the comp
SAP and Oracle Battle for SOA Bragging Rights
(Lee Kroon) Over the last two weeks, enterprise application vendors Oracle and SAP have been locking horns in another of their public battles. This time, the dispute is over which company is ahead of the other in delivering a next-generation application suite that delivers a complete service-oriente
DB2 for z/OS: Data Sharing in a Nutshell
(Paolo Bruni, Mark Anders, KyengDong Park, Mark Rader and Judy Ruby-Brown) DB2 for z/OS takes advantage of data sharing technology in a z Parallel Sysplex to provide applications with full concurrent read and write access to shared DB2 data. Data sharing allows users on multiple DB2 subsystems, memb
Table Spaces and Locking Levels, Part 3
(Bonnie Baker) In this column, we’ll look at how DSNZPARMs are used to control the maximum number of locks we may acquire, the length of time we’ll wait for a lock, and other system-level issues. We will also explore timeouts, lock escalation vs. lock upgrades, and deadlocks. And, we’ll find out how
Views in SQL 2000/2005
(cykophysh39) A view is simply a query stored as an object in the database. In essence a view can be thought of a virtual table, that in itself does not contain any data or information. A view can return the same data that we could from any SELECT statement. Views are implemented as stored SELECT st
Print Multiple Page Image with Visual Basic 2005
(Mike McIntyre) This article discusses how to print a multiple page image and provides sample code in a Visual Studio 2005 solution. The process involves calculating an array of rectangles where each rectangle defines a page size chunk of the image. The rectangles are then used to extract a page siz
Low-Cost High Availability: Simple Database Monitoring in a Windows Environment
(John Paul Cook) Many third-party monitoring tools are available for monitoring databases. These tools are often expensive and sometimes overkill for what amounts to answering the simple question: Can the applications reach the database or not? I’ve encountered numerous clients who would not spend a
Drag-and-Drop Techniques for Creating Database Applications in Visual Studio 2005
(Joel Mueller) Many developers today think about database programming as a grueling task requiring hundreds or even thousands of lines of code for each data-manipulation requirement. Of course, it doesn’t help that database programming environments of the past didn’t exactly make working with stored