Editorials

Error Handling Techniques

by Ben Taylor

Error Handling Techniques
In my opinion, Error handling is one of most important skills in enterprise level software. Often, handling errors is an afterthought, and is enhanced more often through need to debug code rather than a planned approach.

I like to think of error handling with a few different dynamics.

  • Managing the Proccess Flow
    • Continue Processing
    • Stop the process
  • Notification
    • Raise error to the end user
    • Log Error
    • Send Alert
  • Severity
    • Debug
    • Information
    • Warning
    • Severe
    • Fail

Any error could have any combination of these dynamics. Having a centralized error handling framework makes writing the code a lot easier.

Tomorrow we’ll consider comments from our readers on Error handling along with some techniques in SQL Server.

Send your comments to btaylor@sswug.org.

Cheers,

Ben

$$SWYNK$$

Featured White Paper(s)
Office 365 SharePoint Online – Architectural Considerations
Written by AvePoint

The goal of this white paper is to clarify strategies f… (read more)

Featured Script
Proper Case for Names with Mac Mc support
Proper Cases a string. Used for names. Takes into account McExceptions…. (read more)

Tags:
Author: Ben TaylorBen is a Relational Database veteran starting in the early eighties on DEC Vax database systems such as Bloom and Harvest. He has specialized in SQL engines for more than two decades, with a primary focus on Microsoft SQL Server. Ben has worked with small and large databases for both OLAP and OLTP working on systems for many industries such as Medical (Medical Claims and Eligibility Warehouse, HMO Provider Management, Enrollment), Financial (credit card processing, mortgage, stock portfolio management), Manufacturing (Assembly Line and Product Assemblies), Sales, Auto Auctions and more.