TRY/CATCH - The Great Way to Handle Exceptions in SQL 2005/8

This is based on the original post in Franglais.

The goal of this post is to explain how to handle errors...

Balancing Priorities

This one isn't a technical post, but it's entirely appropriate to those of us in the IT field. Today was a...

Other Desktops

The USB not in Hyper-V thing is annoying. It actually made me stop and consider my alternatives for a desktop....

Notes on SQLSaturday #7

I flew up to Birmingham Friday for SQLSaturday #7 organized by John Baldwin from Steel City SQL and a lot...

Reminder - SQLSaturday #12 in Portland is June 6, 2009

Ken Starnes from the Portland group will be having their first event on June 6th. I like the way they've...

Security Basics: Understanding the Surface Area

When it comes to securing a system, it's important to understand how it might be attacked. That's what surface area...

SQL Server Encryption - Hashing Collisions

A hash is a computation that transforms one set of data into another (hopefully smaller) set of data. So a...

Upcoming Speaking Engagements

For those who are interested, I've got a couple of speaking engagements coming up in the next two weeks. I'll be speaking...

Changing Server Default Collation

An interesting problem develops when the standard default collation for SQL Server isn't appropriate. Working with clients here in the...

Found a Bug in SQL Server 2005

It doesn’t happen often but every once in a while you may be the lucky person to find a previously...