By Timothy Dyck – Expand Beyond’s PocketDBA 2.0 provides database administrators with a lightweight, HTML-based administration console for on-the-move management. The previous version, 1.4, was an Oracle-only product, but PocketDBA 2.0 broadens users’ options by including modules for Microsof
Author: SSWUG Research
DB2 UDB Express offers the lowest entry price of any full function database
Looking to stretch the most out of your investment dollars? DB2 UDB allows you to start with a minimum investment without sacrificing functionality. Unlike other databases, DB2’s entry level pricing doesn’t require you to sacrifice database functionality. IBM delivers the same core database function
Java Database Best Practices
Book by George Reese – Unlike other books on this topic, which focus on a single way to do things, Java Database Best Practices takes you through a wide variety of different ways to store and access data, enabling you to learn which “persistence model” is most appropriate for each type of applicatio
Ellison Says PeopleSoft Will Change Its Mind
By Michael Liedtke – Oracle Corp. Chairman Larry Ellison on Tuesday predicted rival business software maker PeopleSoft Inc. eventually will embrace his hostile takeover bid, although he didn’t rule out the possibility of sweetening the $6.3 billion offer for a second time.
AppsWorld – Oracle unveils collaboration applications
Oracle has introduced three collaboration applications and an enhanced product lifecycle management tool for its E-Business Suite.
Transact-SQL Debugger Limitations and Troubleshooting Tips for SQL Server 2000
This article describes the limitations of Transact-SQL Debugger in SQL Server 2000. This article also provides guidelines and directions to troubleshoot basic problems related to Transact-SQL Debugger. However, this is not an exhaustive list, and some problems may be specific to your environment.
XML-based portals equal less Web services pain
By Matt Hines – Experts at last week’s DCI show said that the portal is becoming a crucial infrastructure component of Web services, and that basing them on standards such as XML will help enable future Web services implementations.
Regular Expressions in T-SQL
From SQLTeam – This article comes to us from Cory Koski. Cory writes “I recently had the problem of trying to search for a regular expression in a database field. There is no version of SQL Server that supports regular expressions natively, but I discovered a way to add all sorts of regular expressi
It’s Official: SOAP 1.2 Is a Standard
By Darryl K. Taft – The World Wide Web Consortium has released Version 1.2 of the Simple Object Access Protocol (SOAP) as a formal standard. The Cambridge, Mass.-based W3C released SOAP 1.2 as a full W3C Recommendation Tuesday, the organization’s language for making a specification an officia
Attaching and Detaching Databases on SQL Server
Alexander Chigrik explains how to move a database, or database file to another server or disk using sp_detach_db and sp_attach_db system stored procedures to detach the database and then attach it again.