Transactional Replication

Converting OR to Union

When I looked at indexing for queries containing predicates combined with OR, it became clear that the are some restrictive...

Transparent database encryption

Database Mirroring

Are all updates split into delete-insert?

This should be another quick one.
Earlier I saw a forum post where someone asserted that SQL always executes an update...

T-SQL Tuesday: Disasters don’t just come in huge

So we’re supposed to talk about disasters we’ve had or discuss disaster recovery technologies. I’m going to take a slightly...

On the exorcism of Ghost Records

There was a question earlier on one of the SQL forums as to whether or not Ghost Cleanup overwrote the...

PASS Summit Session Votes

I blogged a week ago about the sessions that I submitted for the PASS Summit this year. At the point...

On Transactions, errors and rollbacks

Do errors encountered within a transaction result in a rollback?
It seems, at first, to be a simple question with an...

Pass summit abstracts

I missed the Pass summit last November for a number of reasons, but I’m hoping I can attend this year....