MERS

The foreclosure issues that are occurring in the US might be due to database issues at one company. Steve Jones notes that when your database is the legal system of record, it has to be accurate.

SQL Server 2008 - CDC Retention

I had done a little work with CDC last year, experimenting with the way that it handles changes in your...

The SQL Rally Pre Conference Seminars

There’s a change in how pre-conference seminars are being picked for the SQL Rally event next year in Orlando, FL....

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...