(John Pallatto) Microsoft’s corporate customers may have another reason to take their time upgrading to Vista. The latest one is that the current version, Microsoft’s SQL Server 2005 Service Pack 1, released in April 2006, won’t work with Vista or with the related Longhorn server.
Author: SSWUG Research
Oracle RAC Administration – Part 8: Hands on syntax check
(Tarry Singh) As promised, in this article we will check the syntax on our console. These commands are carried out against a working 4-node Oracle 10g R2 cluster. The OS is RHEL 4.2/Centos 4.2 running on Virtual machines, on an ESX Server. Each server has 1200MB RAM, Dual CPU or better said as 2 vCP
DB2 9 for z/OS Roars to Life
(Craig S. Mullins) DB2 9 for z/OS, the latest version of IBM’s stalwart mainframe relational DBMS, delivers a plethora of new features and functions. First among these new features is XML support as a native data type, but that’s not all there is. IBM has also added more SQL functionality, improved
ASP.NET Tip: Sending Mail with ASP.NET 2.0
(Eric Smith) In ASP.NET 2.0, Microsoft deprecated the System.Web.Mail namespace and replaced it with System.Net.Mail. The new library introduces some new features, but it also includes some bugs in how mail is sent.
Working XML: Serve friendlier RSS and Atom feeds
(Benoit Marchal) RSS and Atom feeds are popping up like mushrooms on Web sites. They are popular because they offer a simple mechanism for loyal visitors to register with a site and be notified of updates. Still they are not always easy on users, particularly those with older browsers. This article
DataBound TreeView
(Jorge Bay Gondra) Like so many others, when I needed to use the TreeView control, I found myself doing a Load method adapting the data from a DataTable or a DataView into the TreeView, over and over again. Furthermore, I had to maintain the same data in the control if the values changed.
Applied Reflection: Creating a dynamic Web service to simplify code
(Zach Smith) Many developers are using Web services to communicate with their business logic, and there are a lot of advantages to this. This approach allows a wide range of flexibility in the architecture that would otherwise be very hard to come by. However, there are also a few disadvantages. One
Cut out the Middle-Man: Use Informix Dynamic Server with J/Foundation to host a Java application service
(Guy F. Bowerman) IBM Informix Dynamic Server (IDS) user-defined routines (UDRs) can be written in C, Java, and Stored Procedure Language (SPL). A recently documented extension to Java UDR support – codenamed Solano – is the ability to host a Java application service, such as an HTTP server, directl
I just moved to DB2 V8. What happened to my column names?
(Willie Favero) This is a question that I hear quite a bit, although the frequency is dropping off a bit.
Finding the highest COUNT in a GROUP BY query
(Rudy Limeback) I retrieve two columns named SuperVisor and totalcontracts using this query: select SuperVisor, count(ContractNo) as totalcontracts from Contract group by SuperVisor Now I want to get the maximum of totalcontracts from the retrieved data using a select statement. (R)