This week in episode 022 I’m joined by Gail Shaw who is a fellow SQL Server MVP and a SQL Server Consultant from Johannesburg, South Africa. Gail is a major question answerer on some of the forums where she answers lots of SQL Server programming questions. During this weeks episode Gail and I talk through some of the biggest problems that she sees in questions that are asked. This includes things like BEGIN TRANSACTION, COMMIT and ROLLBACK TRANSACTION, as well as a single stored procedure that does everything, and of the biggest issues that she sees online error handling, or more specifically the lack of error handling and the improper use of error handling.
Podcast: Play in new window | Download