I think I'm pretty much done with the chapter for the next Inside SQL Server book on the SQL Server Query Optimizer. I'm just waiting for comments from a few technical reviewers. Lots and lots of code/query examples - too many! I'm hoping that this will...

One of the greatest lessons I've learned in building software is that every technical implementation has a human element to how it is used, perceived, and interpreted. While I've seen my share of poor technical solutions to problems, sometimes the most...

I'd like to talk about storage.. well, backup. Not SQL Server backup, just "I wish to keep a copy of all of my files and make sure that I don't lose everything if the house burns down". This happens to include my SQL Server databases, though that's not...

I often find customers who question the value of database-enforced integrity constraints. While people often create primary keys, the foreign ones are perhaps a bit more .... well, foreign. Let's start at the beginning. In traditional, old-school database...