Blogs

Speaking at SQLSaturday #51 in Nashville on August 21st!

Speaking at SQLSaturday #51 in Nashville on August 21st!

on July 28, 2010

A while back, I submitted a few abstracts to  a couple SQLSaturday presentations around the country. I just picked places I’ve never visited which seem unique, and where I’d like to make a quick vacation of it and spend a few days exploring town before having fun at a SQLSaturday and meeting new people.

Continue reading

Learning that Presenting is Worth Doing

Learning that Presenting is Worth Doing

on July 13, 2010

This month’s T-SQL Tuesday topic is hosted by Robert Davis and the topic is “How do you learn? How do you teach? What are you learning or teaching?”

Continue reading

Why To Do Some of the Grunt Work

Why To Do Some of the Grunt Work

on July 1, 2010

Part of this past week I’ve spent doing a new SQL Server 2008 R2 installation and configuration on a Windows 2008 R2 cluster. I  haven’t done an install end-to-end in quite a while– I have teammates who take care of it while following our installation checklist document.

Continue reading

Error Configuring DataCollector: A collection set cannot start without a schedule

Error Configuring DataCollector: A collection set cannot start without a schedule

on June 26, 2010

When setting up data collection using the GUI, configuration failed halfway through setup. At the point  of failure I found there were SQL Agent jobs for collections visible, but nothing appearing  in Management Studio under Management\Data Collection. The Data Collection icon still had the ‘off’ down red arrow. (I manually refreshed it for good measure to make sure.)

Continue reading

Change Data Capture vs Change Tracking

Change Data Capture vs Change Tracking

on June 23, 2010

Here is a quick taxonomy of Change Data Capture and Change Tracking. I’m going to keep this short, but if you really want all the details, skip to the links at the bottom for complete information.

Continue reading

DBA Checklists: Check out Free OneNote in Office Live

DBA Checklists: Check out Free OneNote in Office Live

on June 21, 2010

OneNote in Office online makes it easy to create and share notebooks with many checklists. The checklists include version tracking.

Continue reading

Haikus for SQL Saturday #43

Haikus for SQL Saturday #43

on June 14, 2010

SQL Saturday #43 was held in Redmond, Washington on June 12. It was tons of fun: great sessions, lots of interesting people to meet, and a well organized day where everything happened on time as if by magic.

Continue reading