Jeff Moden (6/6/2016)
...and want to get started show up for SQL Saturday?
Apparently, none of them because they all claimed more than 5 years experience with most of the DBA hopefuls claiming more than 10. They think they don't need such a thing.
As for newbie training, one of the biggest problems is that almost no one teaches the proper way to "count" in SQL Server. It's truly the starting point for how a SELECT actually works behind the scenes but almost no one teaches it. I believe it's the key to understanding especially when it comes to writing high performance code even if you never have a reason to actually "count" in SQL Server.
Would love to check out your precon; the only trouble is I was planning on three days for the event, and for me to get to Pittsburgh would take an entire day. I suppose I could pull it off if either (1) I tacked on an extra day, or (2) I fly out instead of driving, but either option would mean more $$$ out of my pocket, which is something I'm trying to avoid. Of course, I have a few months to think about it, not to mention that there's no guarantee that I'll get chosen to speak, so we'll see what happens.
I am by no means a SQL MVP or even a DBA, nor do I pretend to be. I know enough SQL for what I need to do. I figured that introductory-level presentations would be something that I could handle (so far, all my SQL Saturday presentations have been along the professional development/soft skill tracks). Kinda like having a practitioner take care of you rather than an MD. 🙂
I am curious as to what you mean by the "proper way to count." I'm assuming that you mean more than the simple "select count(*) from table" sort of thing.