Meme Monday – Stupid Questions

This month we have an interesting topic for Meme Monday. This is hosted by Thomas LaRock and the topics revolve in some way around SQL Server. As Tom brought up, the saying is that “there are no stupid questions.” I have long disagreed with that statement. I think many people would disagree but it is a tool used by instructors to invoke questions from the crowd. I think there are plenty of stupid questions. For me, a stupid question is simply a question to which you already know the answer.

A common question that I hear that could fall into that category is “How do I select information out of table ZYX?”

For that question, pick your response du jour. Typically the response may be preceded with at least one question trying to garner more information such as “Well, what data do you want to select from the table?” If they can answer this question, then the first question seems a bit on the stupid side since they already know the essential pieces to the answer of their question. This holds true, so long as the data retrieval is a basic SELECT.

Some of the beauty of SQL Server is the complexity that it holds. Some of that complexity is right before our eyes. And some of that requires a little bit of diving into the internals to figure out what is happening or even why it is complex.

Announcing…the book At long last the wait is over. After much blood, sweat and more blood and sweat, the next edition of the SQL Server Recipes book is finished. This edition brings several changes and quite a bit of re-write. It has been updated for many of the new SQL Server 2014 (well, new, at[…]

What is that default setting? SQL server does a fantastic job of having numerous settings at the server level and at the database level predefined for you. Additionally, the OS has a bunch of settings that are predefined. These are notoriously the default settings. Or as some would say: “Set it and Forget it Settings.”[…]

Quick run the other way! PASS Summit will never be the same! Why? Well, because for the first time in the history of me, I have been selected to speak at such a prestigious event. Isn’t that just crazy? In some ways it seems crazy. When I received the email I was exhilarated and completely astonished.[…]

One of my pet-peeves (and consequently frequent topic of discussion) is finding database settings (or any setting that has changed) without knowing about it. Worse yet is finding that the change has occurred and nobody claims to have any knowledge of it or having done the deed. This happened again recently where a database was[…]

Dan “L” Greenland (1935 ~ 2015) Dan “L” Greenland, 80, passed away June 30, 2015. Born June 3, 1935 in Highland, Utah, to William John and Cressie Althera Loveridge Greenland. He grew up in Highland and attended schools in American Fork. Graduated from American Fork High School in 1953. Married his high school sweetheart, Eleanor Bunker, October 21,[…]

As we begin to get a grasp of all that is available with SQL Server 2016 and all of the new features, it is a great idea to see what else has been made available to us in order to help support and troubleshoot these new features. With that, it is well worth a look[…]