The Basics of TRY CATCH Blocks–#SQLNewBlogger

I was working with a customer and discussing how to do error handling. This is a short post that looks at how you can start adding TRY.. CATCH blocks...

Using Table Hints in a Query

A New Word: Apolytus

apolytus– n. the moment you realize you are changing as a person, finally outgrowing your old problems like a reptile shedding its skin, already able to twist back around...

Book Review: 100 SQL Server Mistakes

I was approached by Manning Publications and asked to review 100 SQL Server Mistakes and How to Avoid Them. They gave me a free copy of the book (and...

Missing the Office

Steve talks about being back in an office today, at a customer where everyone comes in every day.

Restoring the Resource Database

Familiar Sights

Yesterday was a long day in London. I arrived late in the am, and as I was walking from the plane to the border check, I went down the...

Express In-Memory OLTP

A New Word: the Wends

the wends– n. the frustration that you’re not enjoying an experience as much as you should, which prompts you to try plugging in various through combinations to trigger anything...

Default Objects in Clones