While I agree that people need to learn new things (I'm in the process of learning a fair bit about AWS myself... and, unfortunately, am learning that it's not all that it's cracked up to be), I find that email@example.com is spot on. A lot of people don't actually learn anything very well even those in very public positions where you would expect them to be actual "experts" instead of what seems like casual users with a really nasty case of the Kruger-Dunning syndrome.If you want a taste of what I'm talking about, see the results of the following search...
Spend some real time looking at the questions on those links... and the answers. The questions are pretty decent (although not at a Senior Level, IMHO, in most cases) but the answers are usually either horribly 100 level, are flat out wrong, or are actually worse than wrong. A simple example is this question and answer...
Q13. What is the difference between clustered and non clustered index in SQL?
The differences between the clustered and non clustered index in SQL are :
Clustered index is used for easy retrieval of data from the database and its faster whereas reading from non clustered index is relatively slower. Clustered index alters the way records are stored in a database as it sorts out rows by the column which is set to be clustered index whereas in a non clustered index, it does not alter the way it was stored but it creates a separate object within a table which points back to the original table rows after searching. One table can only have one clustered index whereas it can have many non clustered index.
A really big problem with some of these links is that they're published by people/businesses that claim to be in the SQL Training business. From what I've seen of the answers to the questions, these folks aren't any smarter about SQL Server than those asking questions on forums that are easily answered by a trip to BOL or Yabingooducklehoo. 😀
So, while I certainly appreciate learning new things, I'd really like to see people learn about what they already have and don't really know squat about. That's not popular with a lot of people because of the "school boy" bragging rights a lot of people go after. Know something about everything is great but, if things like SQL are what you do, you should at least know enough about how to write a SARGable query to get data from a single table for a particular month.
I also saw a recent article on some questions that you should pose to someone that interviewing for Senior Database Developer position. The question being asked are pretty awesome but the provided coded test data harness looks like a total newbie wrote it, violates several simple best practices, and that goes for most of the coded examples, the first two of which are based on blatantly obvious non-SARGable predicates. The people in the discussions have called the author out on a couple of things but then their answers also suck at a 100 level or less.
I look at stuff like this and constantly ask myself "Is THIS what the current average knowledge is out in real life"? If it is (and I, unfortunately expect it is), then no wonder people keep looking for new stuff because they have no clue what they're doing with the old stuff.
If you want to really make yourself valuable, learn how to better do what you're already working with and stop with the "Oh look! SQUIRREL!!!" attitude. I'm not suggesting that someone like Grant (who already knows a huge amount about SQL Server) give up his endeavors with AWS but it would be refreshing to see all the people out there that claim that SQL Server and T-SQL is part of what they do learn it at least at a 101 level instead of veering off for the next "shiny object" that they also won't learn well enough.
is pronounced "ree-bar
" and is a "Modenism
" for R
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".
"Dear Lord... I'm a DBA so please give me patience because, if you give me strength, I'm going to need bail money too!"
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)