Blogs

TSQL Tuesday #11: Messages and the Clammy Seduction of the Print Statement

Note: Updated 10/28 based on conversation in the comments, and 12/10 with Denali info.

This month’s #tsql2sDay is hosted by Sankar Reddy, and the topic is roughly, “Things you thought you knew, but didn’t.

Continue reading

For Your Review: Inappropriate PASS Sessions

So I was chatting with @SQLChicken the other night, and I made this comment…

Continue reading

Automation: Granting Read Perms for Developers

Yeah, you heard me.

“But Kendra, why would we want to grant developers read  permissions? And why would we automate  it? And at what point did you lose your mind?”

Continue reading

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

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

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

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

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

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

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

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