Poecilonym Madness! is my latest question that tests your knowledge of creating/dropping tables, views, and synonyms. Here’s the fun part – there are six correct answers to this one, that should be enough to challenge you on a Friday!
Read more "Poecilonym Madness-Question of the Day"I Gotta See the Code is a security question about viewing the code to a stored procedure. Two points if you get figure out all the correct answers! So far it’s working out to be a hard question, only 17% getting all of them.
Read more "I Gotta See the Code–Question of the Day"Status and Name Please is my latest Question of the Day at SQLServerCentral. This is a fairly easy question, but it combines two topics – substring and the user USER_NAME() function. One point if you get it right! So far close to 50-50 results. Think you can get it right?
Read more "Status and Name Please-Question Of The Day"If you haven’t noticed by now I’ve been writing quite a few questions of the day for SQLServerCentral. It started, as things often do, as just something to do that was different (before this year, my last one was in 2006!) but it’s grown beyond that. It’s a really interesting short form of writing and […]
Read more "A Sherlockian Question Of the Day & Why I’m Writing Questions"Access Granted or Not? is my latest Question Of The Day and I think it represents a pretty good troubleshooting scenario, a user can connect to one database but not another using the same Windows credentials. It’s one of those questions generated from a learning moment of my own, I had to figure out the […]
Read more "Access Granted or Not? Question of the Day"Get User In Reporting Services is my newest question to be published at SQLServerCentral.com as a “Question of the Day”. Interestingly so far 71% of people are getting one of the three correct answers, but 84% are also picking the same wrong answer. Can you figure it out?
Read more "Get User In Reporting Services-Question of the Day"One of the things I’m trying to do now is include a link to a blog(ger) in the explanation. That might be because they wrote something that inspired me to write a question (such as http://www.statisticsparser.com/) or because they wrote something that adds value to the topic, something over and above (or just better) than […]
Read more "Writing A Question Of the Day–More Notes"Running Out of Foreign Keys is live today. Nothing too interesting about this one, a straight forward question where you know the answer or you don’t (though maybe with a few tempting answers for those that don’t quite know). Not as much fun to write these kinds of questions and this one of course is […]
Read more "Running Out of Foreign Keys-Question of the Day"Drop Me? No, I Don’t Think So is my latest question of the day and has to do with dropping a login (or trying to at least). Two points if you get it right! As I write this early in the day 38% are getting it correct, so it’s a medium hardness. Re-reading it –it’s […]
Read more "Drop Me? No, I Don't Think So–Question of the Day"The most recent one I wrote was a “question from error message” pattern. An experienced DBA should get it easily, a new one may struggle, and that’s good. I saw as I wrote it there were two ways to frame it; pick the “best” answer and pick “all” the answers. Best is subjective and I […]
Read more "Writing Another Question of the Day"
SQLAndy 