Common SQL Server – Not Indexing FKs

This series looks at Common SQL Server mistakes that I see many people making in SQL Server.

Foreign Keys
It’s way too...

Plan for Capacity

It is important that you are monitoring your system to handle the capacity increases as it grows. Steve Jones notes that FourSquare recently had to deal with this.

Database Mirroring Connection Strings - Automatic Failover

I saw a post recently from Hugo Shebbeare that reminded me of something that I’ve seen asked often on the...

Living Moore's Law

eBay has quite a new data center in Utah, replacing all their hardware on a two year cycle. Steve Jones thinks that would be a challenge, and an exciting one at that.

Copyright

This is actually amazing. A talk on what YouTube does with copyright and how they view it, from TED. It’s...

Software Assurance Cuts Back

Software Assurance from Microsoft is losing a benefit and Steve Jones comments.

Kindle v iPad

I don’t have either, but I ran across this comparison on the devices. It says get both, if you’re a...

Risk Analysis

This Friday Steve Jones asks about your spending on Disaster Recovery and is it in line with the risks involved.

SQL Saturday Advice – Speaker Communication

Recently I was at an event and a speaker wasn’t able to make a session. There was a minor scramble,...

T-SQL Tuesday #12 - Misconceptions

It’s time for T-SQL Tuesday again, and I’m happy to participate again. This is a monthly blog party started by...