(Stéphane Faroult) One of the most hailed extensions brought to SQL in recent years has been these functions that Oracle calls analytic functions, DB2 calls OLAP functions, and SQL Server 2005 calls ranking functions–but which MySQL, so far, still lacks. The good news is that they can be (relativel
Other News
Integrating .NET and SAP 101
(Paul Kimmel) Negative opinions about SAP’s ERP product probably wouldn’t get past my editor. If my opinions were indicated here about performance, elegance, or the fun factor of using mySAP ERP R/3, more than likely SAP will litigate. Suffice it to say that this product must appeal to businesses an
Using the new Deployment Wizard in IDS Cheetah
(Abhishek Mathur) Learn about a new wizard coming in the new version of IBM Informix Dynamic Server (IDS), code-named “Cheetah” — customize install options to pick and choose the features and functions you want, enabling you to minimize the footprint and control the install with much greater granul
Oracle users cancel European conference
(Peter Sayer) Oracle users have cancelled their user conference – with one month’s notice and no explanation.
Installation gotchas for Oracle Linux , Oracle RAC 10gR2 and VMware ESX 3.0.1
(Tarry Singh) As I said on my blog, I have been trying to setup Oracle Linux 10gR2 RAC on Oracle Enterprise Linux 4.4 with VMware ESX 3.0.1 as our chosen platform for Virtualization. This article mentions several issues that we will try to cover all in one go. If that’s not possible, we’ll finish it
LEFT OUTER JOIN without using LEFT OUTER JOIN
(Rudy Limeback) I would like to ask whether is it possible that I can get the same result as LEFT OUTER JOIN without using LEFT OUTER JOIN? Thanks. (R)
MSXML: In with the new, out with the old, and some word on pending futures
(Ed Tittel) One reads the occasional tech news story that blogs are becoming an important avenue for corporate communications, but that kind of message didn’t really sink in completely — at least not for your humble author — until I started trolling around in various Microsoft development team blo
Animating your XAML Apps
(Mike Gold) XAML is not only useful for describing the controls on your forms. XAML provides a means for drawing graphics in your window. The graphics can be stationary or animated and they can all be described in XML. In this article we will take a look at some of the capability of drawing to th
Filtering Custom Paged Results
(Scott Mitchell) The ASP.NET 2.0 data web controls – the GridView, DetailsView, and FormView – all provide built-in paging support that can be enabled at the tick of a checkbox. Unfortunately, this built-in paging support is very inefficient when paging through large amounts of data since it naively
INTERSECT and EXCEPT [DB2 9 for z/OS]
(Craig Mullins) With this blog entry I am introducing a new series in which I will briefly blog about the new feature of DB2 9 for z/OS. Today’s entry will cover the new INTERSECT and EXCEPT keywords