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.
Haikus for SQL Saturday #43
Category:
webcasts-and-conference-sessions
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.
DBAs Needed on Microsoft Connect
Category:
database-administration
Update from Kendra (2018)** - Microsoft Connect has been retired. The current feedback system is here: https://feedback.azure.com/forums/908035-sql-server