(Don Schlichting) This article focuses on using a stored procedure to insert a new record from data collected on a web page, then passing an identity value created from that row back to the web page. In the previous articles in this series, Part One described the benefits of using stored procedures
Author: SSWUG Research
Getting notified when application throws an error
(Abey George) It’s better to be informed by your application rather than the client telling that they have got an error. This is pretty simple which I have used in my previous project. The solution lies in the Global.asax file. When ever the application throws an error, the Application_Error met
Printing with Formatting in VB .NET
(Jereme Guenther) Here is a quick summary for those who just want the code and don’t want to read the history. I have searched all over the Web for good printing code and was unable to find it. I have created a printing class that allows text to be formatted at the character level. It has taken me a
Building a Database Driven Hierarchical Menu using ASP.NET 2.0
(Michael Libby) This tutorial will show you how to store hierarchical menu data in a single database table and how to retrieve and transform that data for display in Microsoft’s Menu.
Scaling Out SQL Server 2005
This article explains the different technologies that are available for scaling out a SQL Server 2005 database application, focusing on the factors that go into deciding which solution(s) to use in your application.
Pitfalls of SQL Server sprawl
(Hilary Cotter) The boom in uncontrolled and uncoordinated SQL Server deployments has led to numerous challenges for the enterprise. (R)
An AJAX Caching Strategy
(Bruce Perry) The ability of AJAX applications to make an HTTP connection behind the scenes to fetch small bits of information is one of the powerful tools that the modern browser APIs come equipped with. For most browsers (e.g., Firefox 1.5, Safari 2.0, Opera 8.5), the engine behind this task is th
A Deep Blue View of DB2 Performance: IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS
(Paolo Bruni, Marcelo Antonelli, Norbert Heck, John Jenkins and Ernie Mancill) IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS represents the effort on converging OMEGAMON XE for DB2 and DB2 Performance Expert into one product that retains the best features of each. This new tool gives you
Oracle Unwraps RFID Edge Server Upgrades
(Laurie Sullivan) Oracle Corp. rolled out upgrades to Oracle Sensor Edge Server. Oracle Sensor Edge Server, an important piece in Oracle Fusion Middleware 10g, lets companies integrate a variety of products from existing IT infrastructures with RFID and sensor networks
OLAP Watch: IBM DB2 AphaBlox 8.3
(Vladimir Stojanovski) An updated release of Alphablox (8.3) was released to select customers in December, 2005, with some minor improvements. The previous release, version 8.2 was made available way back in December, 2004. Not familiar with this OLAP product? I’ll be happy to elucidate.