Issue: 2003 - November/December

  • Rod Paddock Editorial November December 2003 Issue
  • Product News November/December 2003
  • Many products are taking advantage of the enhanced exception management features that the .NET Framework provides, yet very few are going the extra mile to provide instant solutions.
  • ASP.NET has considerably raised the bar for Web development with very rich developer functionality built into a flexible and highly extensible object model.If you have a background of hand-coding ASP or other scripting or CGI-style technology, .NET's redundant code reduction and development process simplification seems almost too good to be true. But data binding for controls leaves a lot to be desired in terms of ease-of-use and reading the data back into the data sourc...See More
  • ADO.NET is a powerful toolbox but it's not a software magic wand.To get the most out of ADO.NET classes, developers must fully understand the model and study a few best practices. Based on years of real-world experience with ADO, ADO.NET provides a richer set of more powerful tools. But, ADO.NET is not designed to be an out-of-the-box tool that reduces any programming work to just point-and-click. In this article, you'll learn about common best practices for using three ...See More
  • All database developers should know about MySQL.MySQL is an open source database that you can use to develop robust applications without paying the steep licensing fees attached to other database systems.
  • Using Oracle as your database in the .NET environment is relatively simple, except when returning JDBC ResultSets from Java stored procedures. The Microsoft and Oracle .NET data provider drivers allow for easy access to data from SQL queries and PL/SQL stored procedures. There is not, however, a simple interface to return ResultSet data from a Java stored procedure to a .NET client.
  • Visual Studio .NET provides an incredible leap forward from its predecessor in terms of functionality, but eventually, every developer finds a sought-after feature that just seems overlooked. VS.NET provides great features and capabilities, from intelligent wizards to very useful drag-and-drop functionality such as that provided by the Server Explorer tool window. If there's a problem, it could be one of too much success. A simple stroll through the IDE reveals feature a...See More
  • We've all faced those irritable questions about our applications running in production. Typically a system administrator will spring one on you on a Friday afternoon just when you're finishing out the week with a game of foosball. Why did this request fail? What is causing so many disk IO spikes? What requests are failing as a result of this error? Why is the application running so slowly? Why are all the resources being gobbled up on the Web server? These questions ofte...See More
  • Replication figures as one of the more prominent features of SQL Server 2000.Replication is a complex application that uses a combination of stored procedures and executables to distribute and copy data between SQL Server databases. If you take care not to get lost in the details and confused by occasionally misleading terms, replication can be an important component in the database architecture of a SQL Server application. In this article, you'll learn about the termino...See More
  • Nov/Dec .Finalize() column