A sign will be henceforth posted on my office door which reads: “PLEASE FOCUS YOUR ATTENTION ON THE COMMAND PROMPT.”
And I will always make sure to remember to be careful when working with the Engine of the Devil.
It’s sort of like Daylight Savings time for #TSQL2sday. Since PASS is next week and we’ll all be busy tweeting from the convention center instead of talking to one another face to face (or the opposite, take your pick), we’re blogging a week early.
This month’s topic is hosted by Paul Randal (blog | twitter), and the topic is “Why are DBA skills necessary?”
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.”
So I was chatting with @SQLChicken the other night, and I made this comment…
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?”
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.
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?”
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.
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.)
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.
Copyright (c) 2024, Catalyze SQL, LLC; all rights reserved. Opinions expressed on this site are solely those of Kendra Little of Catalyze SQL, LLC. Content policy: Short excerpts of blog posts (3 sentences) may be republished, but longer excerpts and artwork cannot be shared without explicit permission.
