Remote Security

As more and more people look to work away from inside traditional networks, security becomes an issue. As a data professional, Steve Jones reminds you to be sure that your data is protected.

SQL Slammer

It's been seven years since SQL Slammer, the worst SQL Server security worm struck. Steve Jones remembers that time.

T-SQL Tuesday Topics

I was asked to host a T-SQL Tuesday, and I accepted.

Once again, my fingers move a bit faster than...

New Looks

It’s been quite a few years since I updated the Hawaiian shirt wardrobe. I bought a series of 5 shirts...

SQL Saturday Advice - Extra Food

No matter whether you provide the food or have people pay for it, it seems that at every SQL Saturday...

Boulder SQL Server User’s Group - Common SQL Server Mistakes

The first iteration of my presentation on Common SQL Server Mistakes, based on the various things I’ve seen in the...

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.