June 2012 - Posts

• Awesome videos on Agile

  The following videos are a must-see for anyone interested in Agile methodology: Decisions, Decisions Embracing Uncertainty Patterns of Effective Delivery Enjoy! Read More... Posted Monday, June 18, 2012 4:45 PM by Alexander Kuznetsov | 0 Comments Filed under: Agile Development

• Yet another use of OUTER APPLY in defensive programming

  When a SELECT is used to populate variables from a subquery, it fails to change them if the subquery returns nothing - and that can lead to subtle bugs. We shall use OUTER APPLY to eliminate this problem. Prerequisites All we need is the following mock Read More... Posted Wednesday, June 06, 2012 5:58 PM by Alexander Kuznetsov | 2 Comments Filed under: Defensive programming, Transact SQL

• Catching multiple exceptions on the client is robust and easy

  Maria Zakourdaev has just demonstrated that if our T-SQL throws multiple exceptions, ERROR_MESSAGE() in TRY..CATCH block will only expose one. When we handle errors in C#, we have a very easy access to all errors. The following procedure throws two exceptions: Read More... Posted Wednesday, June 06, 2012 1:30 PM by Alexander Kuznetsov | 7 Comments Filed under: Error Handling, Transact SQL