(Laurence Moroney) Multiple Active Result Sets (MARS) is a new feature of ADO.NET 2.0 that allows multiple queries or stored procedures to be performed on a single connection. The result of this is that you can get and manage multiple, forward-only, read-only result sets on a single connection. Prio
Other News
Exploring SQL Server and the .NET CLR
(Vidya Vrat Agarwal) This article reveals the collaboration of .NET CLR with SQL Server 2005 and how .NET CLR generated managed code help developers to implement database objects.
Process Atom 1.0 with XSLT
(Uche Ogbuji) Atom 1.0 is the emerging Internet Engineering Task Force (IETF) standard for Web feeds — information updates on Web site contents. Since Atom is an XML format, XSLT is a powerful tool for processing it. In this tutorial, the author looks at XSLT techniques for processing Atom document
WSDL and Schema Parser
(Thanh Dao) If you want to aggregate a web service with your application service, or if you are trying to implement someone else’s WSDL, then you need to pay attention while viewing them. That means you are encountering the web service interoperability problem. That was the problem I had too, and I
Oracle Certifies PeopleSoft Apps on Fusion Middleware Stack
(Renee Boucher Ferguson) Oracle Corp. announced that it has certified its PeopleSoft Enterprise applications to run on Oracle Fusion Middleware 10g Release 2, a move that will provide more integration capabilities for Enterprise users—and streamline the upgrade path to Oracle’s next-generation appli
Basic SQL Server security resources
(Serdar Yegulalp) Keeping SQL Server secure is not a simple matter of applying hotfixes. The self-education required to keep SQL Server safe is far reaching, covering a number of different topics. This collection of quick resources will help you understand the scope and dimension of SQL Server secur
Handling Null Values in Oracle
(MS Sridhar) Oftentimes, a query will return null values for some of the columns in a query. However, to display “null” as the value in the generated report isn’t a very effective way to display this information. Oracle provides an easy solution for this problem.
Authentication in IIS
(Joe Lima) We often think about security measures as ways of protecting resources by preventing access to them. The need for authentication arises because, in the real world, keeping people out of protected areas is only half the battle. Authentication is about letting certain people (or processes)
An interview with Peter DeBetta
(Douglas Reilly) I have wanted to interview Peter DeBetta ever since I read his latest book, Introducing Microsoft SQL Server 2005 for Developers . Although it’s not the only book about SQL Server on the market, I found it particularly enjoyable.
MySQL Stored Functions
(Ian Gilfillan) If procedural programming is new to you, you may be wondering what the difference is between a Stored Procedure and a Stored Function. Not too much really. A function always returns a result, and can be called inside an SQL statement just like ordinary SQL functions. A function param