2011: More Nerdy Drawrings (TSQL Tuesday #14)
Category:
database-administration
This month’s #tsql2sDay is hosted by Jen McCown ( blog | twitter ) and Jen’s question is “What techie resolutions have you been pondering, and why?”
Category: database-administration
Filling in Data Potholes with Recursive CTEs
Category:
database-administration
Imagine that you are writing a script that looks at data grouped by the minute. You notice that there are no rows for some minutes, and you’d like to display a value when that is the case, probably showing a count of zero.
SQLPASS Day 1 and 2: Please Focus Your Attention on the Command Prompt
Category:
database-administration
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.
TSQL Tuesday #12: Why Are DBA Skills Necessary? Fido, Please Turn Your Head And Cough.
Category:
database-administration
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?”
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.
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