(Joe Pluta) In a recent article, I introduced the new Eclipse-based Rational tools and did the best I could to explain how they relate to the existing Eclipse-based WebSphere Studio tools. In essence, the primary connection is that they are Eclipse-based. That, and the fact that IBM renamed the WebS
Other News
Oracle, Zend Deliver Beta of PHP Tool
(Darryl K. Taft) Oracle Corp. and Zend Technologies Inc. Monday announced the beta release of the Zend Core for Oracle technology for integrating the Oracle database with Zend’s PHP development environment.
Emerging Standard Eases Content Modeling Headaches
(Doug Henschen) Switching to XML-based content management can save big money in the long run by promoting content reuse and multichannel delivery. It can also be an expensive, time-consuming challenge akin to building a house from a pile of lumber. Using the Darwin Information Typing Architecture (D
Oracle, IBM Battle Beyond the Database
No longer satisfied with its role as the corporate database leader, Oracle has been building out its middleware portfolio through R&D and acquisitions and is increasingly going head-to-head with IBM.
Intro to DB2 Performance Tuning
(Dwaine Snow) Performance is one of the most important keys in any type of database system. This chapter focuses on a number of performance tuning tips with DB2 Universal Database (UDB). Although some tuning tips are the same, regardless of the database workload, there are differences between OLTP-
Search Stored Objects
(Ilya Petrenko) This script finds objects in a schema based on a text string/name.
Security Guidance for .NET Framework 2.0
(J.D. Meier, Alex Mackman, Blaine Wastell, Prashant Bansode and Kishore Gopalan) This page explains the rationale behind the patterns & practices Security Guidance for .NET Framework 2.0 project and provides an index into the guidance. You can use the guidance referenced on this page to improve both
SQL Essentials: SQL Server Data Importing: Do’s and Don’ts
(Ron Talmage) SQL Server DBAs often find themselves importing and massaging data using T-SQL. Why? Because some transformations of the data simply require the power of full-fledged SQL. Having just recently survived yet another case of data importing, I was inspired to assemble a list of do’s and do
Create Provider-Independent Data Access Code with ADO.NET 2.0
(Thiru Thangarathinam) One of the new features of ADO.NET 2.0 is the ability to create provider-independent data access code that enables you to code against a set of base abstract classes without referencing provider-specific classes. The key advantage of this approach is that it gives you the opti
How To Use SQLXML to Retrieve Data From SQL Server database?
Using SQL Server 2000 and above versions you can retrieve data from SQL Server in XML format directly from the database. Many XML related features were incorporated in the SQL Server database. This enables the development of XML enabled applications very easy and it makes exchange of data over inter