Monthly Archives: September 2010

No Guarantees

The keynote for SQL Saturday #52 in Denver, that didn’t go as smoothly as I’d like due to technical difficulties, however I am hoping I got my point across. Here’s what I wanted to say: Who does p90x? Body for … Continue reading

Posted in Blog | Tagged ,

The Design Investment

How much of an investment should you make in learning design? Steve Jones talks about why we should learn how to do it right. Continue reading

Posted in Editorial | Tagged ,

Grabbing SWAG

It’s getting close to the time for the SQLServerCentral party events this fall, and time to start gathering up SWAG to give to people. In the past, I’ve hosted a SQLServerCentral party at the PASS Summit, and it’s always been … Continue reading

Posted in Blog | Tagged ,

Common SQL Server Mistakes – Indexing Every Column

If one index helps speed up queries, than more indexes should help more, right? They do, but they also come at a price. Both in performance during data modifications (insert/update/delete), and in terms of space since each index must be … Continue reading

Posted in Blog | Tagged , , ,

SQL Saturday#52 – Colorado Recap

This past weekend was the first SQL Saturday in Colorado, and it went very well. I think everyone enjoyed it, the organizers were pleased, and I’m hoping that we end up with 2, or more, events next year. This was … Continue reading

Posted in Blog | Tagged ,

Hot Skills

What are the hot skills for 2011? Steve Jones talks about one that you might not have thought about. Continue reading

Posted in Editorial | Tagged

People are talking about you

I was listening to a friend give a presentation on getting a job recently. In the presentation, Chris Shaw, the speaker, mentioned my Modern Resume presentation, which was cool, but he also said something interesting in his talk. He said … Continue reading

Posted in Blog | Tagged ,

Food Drive

Don’t forget the food drive tomorrow for SQL Saturday #52 in Colorado. Please bring food, or even clothing/blankets, that can be donated to local people. I’ll be taking a portion back to the food back for my local area, and … Continue reading

Posted in Blog | Tagged ,

A day of rest

Not quite a day of rest, likely some chores in advance of another busy weekend at the ranch. I’m taking today off for a few reasons. Originally I had planned it as my kids were out of school and we … Continue reading

Posted in Blog | Tagged ,

Common SQL Server Mistakes – Multi Row DML Triggers

How often have you seen someone write a DML trigger like this: create trigger mytrigger on Mytable for insert as declare @id intselect @id = id from inserted update xx set yyy = zzwhere id = @id return There seems … Continue reading

Posted in Blog | Tagged , , ,