This one is live today, it’s about Powershell and restoring databases, based on some scripting I had been working on. It should be an easy question for you – how’s that for a challenge?
Read more "Question of the Day: Check, Please"It’s been a while since I wrote a question of the day for SQLServerCentral. I wrote Pounds of Formatting Fun after running through the FORMAT function a few times as part of exam prep because it’s something I rarely(!) use. I’ll have to write more soon, crafting a good/useful question is fun.
Read more "New Question of the Day – Pounds of Formatting Fun"An SSIS question! How’s that for a change of pace? SSIS Column Export is, as you might well surmise, about the export column transform. I used it recently to export a kazillion or so images and thought it would be a nice, middle of the road question. Give it a try.
Read more "SSIS Column Export-Question of the Day"This past weekend I started writing notes for what I’m calling Project Moriarty, what I hope will be five questions in a row that have to be solved individually, but then based on information in the questions and correct answers will lead those that complete the challenge to solve the overall challenge posed by Moriarty. […]
Read more "Project Moriarty"The Case Of the Downward Pointing Arrow is written as an abbreviated mystery, Sherlock Holmes style. Had to laugh at the comment about me being Moriarty in disguise! No one has so far figured out the identity of the client mentioned in the question.
Read more "The Case Of the Downward Pointing Arrow-Question of the Day"Another trivia question today, this one about figuring out which of the options provided has a particular negative identity seed. See if you can get A Deeply Planted Seed right and earn one point for the effort!
Read more "A Deeply Planted Seed-Question of the Day"What is 268435456? is the Friday question of the day. It’s a trivia question, but maybe an interesting one for all that. Better than 50% getting it right, not bad for a Friday question!
Read more "What is 268435456?"The Great Escape is the question today, one I think you will like because…it’s about LIKE! It’s a head scratcher. The comments on this one so far have been really good and that’s good, I need to look for more arcane topics (LIKE is common, the ESCAPE part is not). So far people are being […]
Read more "The Great Escape-Question of The Day"No Files For You is another Question Of The Day. I ended up making this one just a little more ambiguous than I meant to, interesting to see the different takes on it in the comments. I’ll say again, reading that stuff, what a great way to learn about writing (question writing anyway).
Read more "No Files For You"Reading, Writing, and Riskmetic is another Question of the Day, this one about how to allow developers to understand performance while giving not giving them more access than needed. Great conversation that followed it, in particular read the comment here by Gail Shaw.
Read more "Reading, Writing, and Riskmetic-Question of the Day"
SQLAndy 