SQL Saturday Presentations

The two first weekends in August I were in Cape Town and Johannesburg respectively presenting at SQL Saturday events. I had a great time, and the audience were terrific. My employer Derivco graciously gave me some “swag” to hand out, and that went down a treat. Thanks Derivco!!

After the events some people have emailed me and asked for the presentations, so I thought I’d upload them to SlideShare, so anyone that are interested can get to them. Seeing that I recently switched to a new blog platform, Octopress, and I a couple of days ago came across a SlideShare plugin for Octopress - I decided to test it out by posting the presentations here on my blog.

The two presentations I did were based about the “weird/wonderful (or not so wonderful)” things we have experienced at Derivco in our live production environments:

  • SQL Real World Error Handling - Gotcha’s when doing error-handling in SQL Server
  • Message Queues in SQL Server - Enhance performance by using queues in SQL Server

SQL Real World Error Handling

This presentation talks about strange scenarios that can catch unaware developers out when mixing the new way of handling errors introduced in SQL Server 2005, with what we used to do before:

BEGIN TRY
  -- do some stuff that may cause an error
END TRY
BEGIN CATCH
  --handle error, and perhaps re-raise
END CATCH
DECLARE @err int;
EXEC dbo.Some_Proc
SET @err = @@ERROR
IF(@err <> 0)
BEGIN
  --do error "stuff"
END

Message Queues in SQL Server

Here I discussed the findings from research at Derivco about the most efficient implementations of queues inside SQL Server.

If anyone are interested in discussing this more, please post a comment.


Blog Feed:

To automatically receive more posts like this, please subscribe to my RSS/Atom feed in your feed reader!

Installing Octopress on Windows Testing, Testing, Anyone Out There?

Related Articles

comments powered by Disqus