May 11, 2016 at 9:11 am
Sigh...I wish I could filter out old threads.
May 11, 2016 at 9:16 am
BLOB_EATER (5/11/2016)
Hugo what is your definition of 400 then?
Somewhere between level 300 and level 500.
In other words, similar to level 500 but slightly less deep.
To explain this with an example, here are 5 sessions on merge:
Level 100: No separate session, included in a management-level overview of cool SQL Server features that enable devs to tackle hard problems with ease.
Level 200: Overview of how MERGE can replace separate insert, update, and delete statements, including an overview of most syntax features and a quick warning about the most relevant side effects.
Level 300: Start with quick overview of what MERGE does and present its syntax. Compare its performance and maintainability to separate insert, update, and delete. Show in more detail how to adapt triggers to MERGE.
Level 400: Expect that the effect and syntax of MERGE are known. Show the execution plan and explain the steps taken internally, and wrap this back to performance. Or, alternatively (do not try to do both in a single 400-level session!), focus on the various steps taken internally to acquire, upgrade, release, and escalate locks, and wrap this back to some of the locking-related issues with MERGE. In either case, finish the session with concrete usable advice on how to levarage what you have shown and/or how to avoid the pitfalls.
Level 500: Similar to level 400, but you might pick less specific topics and dig deeper, or cover more topics because you can go a bit faster. Allthough it would not hurt, it is not really required to wrap up the session with concrete tips on how to put the knowledge to use - the audience is smart enough to figure that out by themselves. (Or they are just as geeky as you and enjoy endulging in the internals even if they get no practical knowledge out of it).
would you expect someone that has been to level 400 training to be able to grasp your 500 training?
I actually try to make sure that people who have been to level 300 training can graps my level 500 sessions. So level 400 should definitely not be a problem.
(Note that I do not have very many level 500 sessions in my portfolio, most are level 300 and level 400, with only a few at level 200 and 500)
May 11, 2016 at 9:47 am
Phil Parkin (5/11/2016)
Eirikur Eiriksson (5/11/2016)
Sean Lange (5/11/2016)
WHY OH WHY can we not get the spam under control on this site? Every morning it is about 2 spams for every actual thread when looking at active threads. I am afraid we are missing people who actually need help, and it is really frustrating to wade through all the rubbish.Somehow this continues to be a problem, maybe this could be solved with some of the new Azure Machine Learning capabilities;-)
😎
exec xp_SpamSpanker(New in 2016) may help.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 11, 2016 at 10:04 am
SQLRNNR (5/11/2016)
Phil Parkin (5/11/2016)
Eirikur Eiriksson (5/11/2016)
Sean Lange (5/11/2016)
WHY OH WHY can we not get the spam under control on this site? Every morning it is about 2 spams for every actual thread when looking at active threads. I am afraid we are missing people who actually need help, and it is really frustrating to wade through all the rubbish.Somehow this continues to be a problem, maybe this could be solved with some of the new Azure Machine Learning capabilities;-)
😎
exec xp_SpamSpanker(New in 2016) may help.
That movie had so many classic scenes. They still make me smile almost every time.
May 11, 2016 at 10:22 am
Phil Parkin (5/11/2016)
Eirikur Eiriksson (5/11/2016)
Sean Lange (5/11/2016)
WHY OH WHY can we not get the spam under control on this site? Every morning it is about 2 spams for every actual thread when looking at active threads. I am afraid we are missing people who actually need help, and it is really frustrating to wade through all the rubbish.Somehow this continues to be a problem, maybe this could be solved with some of the new Azure Machine Learning capabilities;-)
😎
exec xp_SpamSpanker(New in 2016) may help.
So that's why I kept getting an error, I was writing it like this:
exec xp_SpankSpamer
😀
May 11, 2016 at 10:46 am
Ed Wagner (5/11/2016)
jasona.work (5/11/2016)
Ed Wagner (5/11/2016)
Grumpy DBA (5/11/2016)
jasona.work (5/11/2016)
Jeff Moden (5/10/2016)
Grumpy DBA (5/10/2016)
jasona.work (5/10/2016)
Dang, now I want sliders for lunch...
6 sliders, order of fries, order of deep-fried mozzarella sticks, large Coke...
Not sure where in the dirty mitten you reside but have you ever had Bate's in Livonia or Hunter House in Birmingham? My preference is Bate's, they serve up some of the best sliders around - puts White Castle to shame.
Didn't know you lived in Michigan. We should get all the thread denizens from the SE Corner together for some beef'n'brew sometime.
Could always plan a meet up here: http://www.kbrewery.com/[/url]
No idea what the food is like, but my cousin loves their beers...
Oh man, Kuhnhenn beers are awesome... a friend visited their new location on Groesbeck (used to be a home and garden store) and was disappointed with the food. Regardless, I would like to try it some time soon.
So, your grumpiness, where are you located?
If it's convenient for everyone, there's a PASS SPID (SQL PASS In Detroit) meeting tomorrow at 6:00 at the Microsoft Office in Southfield. http://www.eventbrite.com/e/sql-pass-in-detroit-presents-brian-davis-runbooks-and-azure-automation-tickets-25329970624?utm_campaign=reminder_attendees_48hour_email&utm_medium=email&utm_source=eb_email&utm_term=eventname
Decided to go ahead and sign up for this one, even though we're not using, and won't be using (at least in the forseeable future) Azure. I expect I'll find ideas I can carry back to use on my systems anyways.
Well, I hope to meet you in person tomorrow night. We're in the same situation as you are with Azure, but there's usually something you can take away from the presentation. If nothing else, you get to meet other people with a passion for SQL Server.
I'll keep an eye out, I'll be coming right from work.
May 11, 2016 at 3:00 pm
I'll be there. We normally head over to shields afterwards. They've got a decent bit o' beer on tap, good food, and it's just a hop-skip-and-jump away.
Shifting gears, I'm starting to go to all these Azure meetings. Drove to Lansing last night for one. I have to know what I'm talking about if I'm going to argue against it. 😀
--Jeff Moden
Change is inevitable... Change for the better is not.
May 12, 2016 at 1:16 am
Is it wrong that I no longer have the desire to do SQL certification exams? Do I need to look in the mirror and slap myself very hard?
Don't get me wrong I am super motivated on learning, but, the MCSE doesn't mean much to me anymore....... Oh man where is my mentor! :ermm:
May 12, 2016 at 1:45 am
BLOB_EATER (5/12/2016)
Is it wrong that I no longer have the desire to do SQL certification exams? Do I need to look in the mirror and slap myself very hard?Don't get me wrong I am super motivated on learning, but, the MCSE doesn't mean much to me anymore....... Oh man where is my mentor! :ermm:
Does MCSE still mean "Must Consult Someone Experienced"?
Thomas Rushton
blog: https://thelonedba.wordpress.com
May 12, 2016 at 1:47 am
BLOB_EATER (5/12/2016)
Is it wrong that I no longer have the desire to do SQL certification exams? Do I need to look in the mirror and slap myself very hard?Don't get me wrong I am super motivated on learning, but, the MCSE doesn't mean much to me anymore....... Oh man where is my mentor! :ermm:
Given the inverse relationship between the length of the list of qualifications on a cv and the likelihood of a candidate answering GETDATE() to the question "name one method of getting the date in TSQL" (see a bazillion previous posts), I'd say no, unless it's for your own satisfaction. Which it clearly ain't.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
May 12, 2016 at 2:06 am
Maybe they lied about getting it? Or went to a fake boot-camp style thing. (It took me many attempts to get it ).
Just wondering if they are actually valued by the "real" people and not key-word searchers online. I don't know, my feelings towards them have changed over the past 18months. The EX - MCM one, well that's a different story right?
May 12, 2016 at 3:02 am
BLOB_EATER (5/12/2016)
Is it wrong that I no longer have the desire to do SQL certification exams? Do I need to look in the mirror and slap myself very hard?Don't get me wrong I am super motivated on learning, but, the MCSE doesn't mean much to me anymore....... Oh man where is my mentor! :ermm:
Having no certs at all, ever, of any kind (with Microsoft, I had a Sybase cert back in '95)....
Nope!
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 12, 2016 at 3:08 am
Grant Fritchey (5/12/2016)
BLOB_EATER (5/12/2016)
Is it wrong that I no longer have the desire to do SQL certification exams? Do I need to look in the mirror and slap myself very hard?Don't get me wrong I am super motivated on learning, but, the MCSE doesn't mean much to me anymore....... Oh man where is my mentor! :ermm:
Having no certs at all, ever, of any kind (with Microsoft, I had a Sybase cert back in '95)....
Nope!
Says it all really doesn't it!
Time to move the "renew your certs" email to the junk folder. 😛
May 12, 2016 at 3:38 am
BLOB_EATER (5/12/2016)
Is it wrong that I no longer have the desire to do SQL certification exams? Do I need to look in the mirror and slap myself very hard?Don't get me wrong I am super motivated on learning, but, the MCSE doesn't mean much to me anymore....... Oh man where is my mentor! :ermm:
After the slap in the face that was the end of the MCM certs (and the way that MSL did it), no more MS cert exams. I'm done.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 12, 2016 at 3:48 am
GilaMonster (5/12/2016)
BLOB_EATER (5/12/2016)
Is it wrong that I no longer have the desire to do SQL certification exams? Do I need to look in the mirror and slap myself very hard?Don't get me wrong I am super motivated on learning, but, the MCSE doesn't mean much to me anymore....... Oh man where is my mentor! :ermm:
After the slap in the face that was the end of the MCM certs (and the way that MSL did it), no more MS cert exams. I'm done.
How was it done? No pre-engagement/consultation with current MCMs? Or was it an un-announced random email?
p.s. was the MCSM a watered-down version of MCM? Or the same thing?
Viewing 15 posts - 54,046 through 54,060 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply