My 2011 PASS Summit Submissions

I wasn’t sure that I would submit anything, but in the end I committed to a few events in Seattle...

Restoring Editions

A row has no row number

It seems that every month I have someone asking the question about ordering or row numbers for a query. Let’s...

The Titanic Cloud

The outage at Amazon's Web Services recently affected a lot of different companies. However not everyone was affected. The reach of the cloud and the competition for attention means that while we have to learn to expect failures, they are not necessarily evenly distributed.

Replication DR

Heaps

Cascading Human Error

The recent Amazon AWS outage was blamed on human error. Steve Jones notes that the more interconnected our systems are, the more likely that a human error might cause cascades between the systems.

T-SQL Tuesday #18 Coming Next Week

Other than the week I hosted it, I’ve been caught off guard by T-SQL Tuesday most months. This time I...

Disaster Recovery Planning

Foreign Keys Help Performance

I have always put FKs into my database for data integrity purposes. I’ve worked on enough applications that didn’t have...