Some book reviews

When I’m not busy writing about SQL Server, I quite enjoy reading books about it that look at things from a different point of view. I’ve been catching up on my reading lately, but getting behind on my book reviews. So here’s a few reviews I’d been meaning to write for some time. The authors […]

TechEd 2007 in Hong Kong – I’ll be there

In just over a month, I’ll be at TechEd 2007 Hong Kong. I’ll be delivering a preconference talk on (what else) SQL Server 2005 and a number of breakout sessions. Check the SQLskills Upcoming Events for more information. The folks in Hong Kong always put on an excellent show, and I’m very much looking forward to it. In […]

MERGE, JOINS, and determinism

SQL Server 2008 will contain an ANSI SQL standard MERGE statement with extensions. Listening to the webcast last Friday, there's a fairly straightforward way to describe how this works. Let's go back to first principals. Relational databases support two ways to do UPDATE and DELETE; positioned updates and searched updates. In a positioned update, you […]