When working with SQL 2005, there are times when you need to perform several aggregate functions, or to define a view that needs to be stored only during the execution of a particular query. A Common Table Expression (CTE) does just that; it helps in the definition and manipulation of query related
Other News
Virtual Web Application using ASP.NET Whidbey
(Saravana Kumar) Virtual web application is a sample applicatoin created to demonstrate the capabilities of ASP.NET 2.0. In this application i have used following new features of ASP.NET 2.0 –File System Provider [VirtualPathProvider] –Master Page –Client Callback Feature –Login and Mem
2006 XML.com Reader Survey
(Kendall Grant Clark) If you’ve been paying attention to XML.com this year, you’ll have noticed that we’re in the midst of an editorial transition. We think–and most industry observers seem to agree–that the era of core XML development is more or less over. We’ve got sensible ways to handle XML fr
FIX: An access violation occurs and the Analysis Services service unexpectedly quits during the Startup process in Microsoft SQL Server 2000 Analysis Services
In Microsoft SQL Server 2000 Analysis Services, an access violation occurs and the Analysis Services service unexpectedly quits during the Startup process. This problem occurs after you install SQL Server 2000 Analysis Services hotfix build 8.0.1028 or SQL Server 2000 Analysis Services hotfix build
Converting an EJB 2.0 Entity Bean to EJB 3.0
(Deepak Vohra) The Enterprise JavaBeans (EJB) 3.0 specification has facilitated the development of EJBs, by providing an annotations-based API in which the remote/local and home/local home interfaces are not required. The deployment descriptors that form the basis of an EJB 2.0 entity bean are also
Oracle ‘Worm’ Exploit Gets Ominous Tweak
(Ryan Naraine) Exploit code for a malicious worm capable of wreaking havoc through Oracle databases has been tweaked and published, prompting a new round of warnings that an actual attack is inevitable.
Simplifying Application Maintenance with Visual Basic 2005
(Brad McCabe) Learn to use some of the new features of Visual Basic 2005 such as compiler warnings and refactoring support to simplify the process of maintaining your existing applications.
XML Attributes
(Jan Egil Refsnes) XML attributes are normally used to describe XML elements, or to provide additional information about elements. From HTML you can remember this construct: . In this HTML example SRC is an attribute to the IMG element. The SRC attribute provides additional i
Scenarios, Patterns, and Implementation Guidance for Web Services Enhancements (WSE) 3.0
To design, develop, and deploy secure Web services, architects and developers must learn new technologies, and consider new threats associated with exposing functionality on potentially hostile networks. To prepare you to meet these challenges (both now on Web Service Enhancements 3.0 and in the fut
Understanding IBM U2 XML Features
(LeRoy F. Dreyfuss) This article reviews the XML capabilities within IBM UniData and IBM UniVerse. Learn the various functions within the databases to develop robust applications that can communicate with any system using XML. Explore the U2 XDOM and XMAP APIs and how to produce XML documents from t