Automation: Granting Read Perms for Developers
Category:
devops
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?”
Speaking at SQLSaturday #51 in Nashville on August 21st!
Category:
webcasts-and-conference-sessions
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.
Learning that Presenting is Worth Doing
Category:
tsql-programming
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?”
Why To Do Some of the Grunt Work
Category:
devops
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.
Error Configuring DataCollector: A collection set cannot start without a schedule
Category:
database-administration
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.)
Change Data Capture vs Change Tracking
Category:
database-administration
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.
DBA Checklists: Check out Free OneNote in Office Live
Category:
devops
OneNote in Office online makes it easy to create and share notebooks with many checklists. The checklists include version tracking.