Patch Week

My email account started getting notices of Windows patches yesterday, indicating it’s patch week again. If you manage Windows devices,...

Dropping a Row

How important is it that your server record all changes to every row? Probably very important and that is one of the foundations on which RDBMS platforms are built. Steve Jones talks about this being a difference with some NoSQL systems, and why it might not be acceptable to most businesses.

T-SQL Tuesday #18 – My CTE

It’s time for T-SQL Tuesday again, and it’s number 18. Hard to believe it’s been a year and a half...

Identity Reseed

Tiered Storage

Storage costs are constantly rising, especially for databases as we gather more and more data. However not all of our data is necessarily the same priority or requires the same hardware. Steve Jones talks about the benefits you might get if you can tier your storage.

Performance Counters

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.