(Timothy Prickett Morgan) Contrary to his name, Jim Stallings, the general manager of IBM’s System z mainframe business line (formerly known as the zSeries) who was put into that position last week, wasted no time in getting out there and banging the drum for the mainframe and launching a new produc
Author: SSWUG Research
Protecting Against SQL Injection With PHP And MYSQL
(Mike Morton) With more and more programmers creating dynamic, database driven websites, the proliferation of PHP and MYSQL is reaching critical mass proportions. With that however, comes the added "bonus" of many different security holes being opened on hosted boxes everywhere. With the current atm
Upgrading to Oracle 10g With Minimal Downtime
(Lenka Vanek and Tom Chu) Upgrading hardware is usually painless, but upgrading databases…well, everyone has a horror story to tell. The primary concerns of a seasoned Oracle DBA are the success of the upgrade and the downtime that could result. Success being not only that the upgrade itself wor
Integrating PHP Web Services using Oracle BPEL
(Alison Holloway) In November 2005 I attended the PHP Conference in Frankfurt. At that conference I did a demonstration which showed how to integrate PHP Web Services using Oracle BPEL, and the Oracle JDeveloper PHP Extension. I have written up that demo for others to get an overview of what I talke
Implementing Transactional Replication
This chapter teaches you how to increase the availability of a Microsoft SQL Server data center by implementing transactional replication. After reading this chapter, you will be able to configure each component in this high-availability solution. To configure transactional replication using Network
Tips for improving INSERT performance in DB2 Universal Database
(Bill Wilkins) Improving the performance of database inserts is very important to managing a database, especially in an OLTP environment. This article explains exactly what happens when an insert occurs, looks at alternatives, and examines issues that affect insert performance, such as locking, inde
Using ADO.NET with SQL Server
(James Crowley) As a developer, I find that an incredible amount of my time is spent dealing with databases in some form or another – be it displaying, manipulating or analyzing data; creating client or server applications. The advent of the .NET Framework has brought with it some major changes, and
Subtleties in Providing a Read-Only User Interface
(Scott Mitchell) A common pattern in data-driven Web applications is that of the read-only user interface. Often a website contains a page that displays records from a database that, by default, the visitor can edit. However, there are times when the data is not editable, and needs to be displayed i
Microsoft Computing: Visual Studio .NET 2005 Programming
(Chris Peters) Last month’s article gave an overview of Visual Studio .NET 2005’s new team environment capabilities, SQL Server 2005, and Microsoft’s remarkable one-year pricing policy. This month, I cover some of the enhancements that Microsoft has made to the Visual Studio 2005 Interactive Dev
Get All Your Devs In A Row With Visual Studio 2005 Team System
(Chris Menegay) Software development is generally recognized as a difficult process. Numerous studies have been conducted and volumes of books written on how to improve the process of developing applications to yield better and more consistent results. The difficulty has never been in coming up