(Hilary Cotter) As a SQL Server DBA, you most likely have to support a range of SQL Server versions, from SQL Server 7.0 to 2005. While it may be rare to come across version 6.5 still in production, I discover it at client sites more frequently than I am willing to admit. So how can you work effecti
Author: SSWUG Research
XHTML2RTF: An HTML to RTF conversion tool based on XSL
(Emmanuel Kartmann) This article describes a conversion tool which takes an HTML document as input and generates a Microsoft Word document for printing.
Project Raptor
Project Raptor is a new, free graphical tool that enhances productivity and simplifies database development tasks. With Project Raptor, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well
We’re entering the Oracle Time Zone
(James F. Koopmann) A few articles back I wrote on a comparison between the DATE datatype and the TIMESTAMP datatype. This article goes one step further and explores Oracle’s TIME ZONE feature of the TIMESTAMP datatype. In particular, Oracle has added the “WITH TIME ZONE” and the “WITH LOCAL TIME ZO
See why ASP.NET and MySQL is a powerful combination
(Tony Patton) MySQL has emerged as a viable option when choosing a database platform. A good testimonial to MySQL’s power lies in the many companies utilizing it, which include Google, The Associated Press, and NASA. The cost of ownership associated with open source software is usually cited when de
SOA and Web Services Soup to Nuts
(Erin Cavanaugh) Though Web services are intended to simplify communications, developing them manually can be anything but simple. Altova has added visual Web services development and implementation capabilities to two of its most popular products, giving developers the ability to build a Web servic
An emerging XML Web services security infrastructure
(Ed Tittel) Anybody who’s been following application development trends for any time knows that Web Services is fast becoming the veritable "hot seat" of the development world. It’s where the action (and the money) is, and has become a line of business if not an outright obsession for everybody from
The Baker’s Dozen: 13 Reasons to Upgrade to Visual Studio 2005
(Kevin S. Goff) Visual Studio 2005 offers language, data handling, and development environment enhancements that are sure to please many developers. Programmers who are currently using Visual Studio .NET 2003 will find many ways to write more efficient code and increase their overall productivity.
Highly Available Architectures and Capacity Planning with WebSphere Remote Server V5.1.2.1
(Chris McCollum, Byron Braswell, Ryan Brown, Ivor Castelino, Kevin Collins, Maria Koshkina, Anant Kumar and Chris Li) This redbook will help you configure and optimize the new release of WebSphere Remote Server V5.1.2.1 in a IBM Retail Environment for SuSE Linux V2.0 environment. (pdf)
Using Global/Distributed Transactions in Java/JDBC with Oracle Real Application Clusters
(Sachin Shetty) This document describes some of the ways to leverage the high availability features of Oracle Real Application Cluster (RAC) databases by moving the load balancing functionality from the Oracle server/Oracle driver to your application. In this article, I discuss the ways to achie