September 1, 2016 at 10:27 am
GilaMonster (9/1/2016)
I uploaded the slide-deck in progress. Comments?http://www.sqlsaturday.com/554/Sessions/Details.aspx?sid=53948
I don't know who else (if anyone) is on the panel. Guess it'll be a surprise on the day.
Looking good. Maybe consider adding a brief example of the types of projects (high level of course) SQL Devs work on and / or what people (job types) they might find themselves working with?
On the other hand you said you only had 30 minutes? So this might be enough and you might still not get through it.
September 1, 2016 at 10:28 am
Jeff Moden (9/1/2016)
People correctly say "Use them when appropriate" but most newbies aren't qualified to figure out what's actually appropriate.
That's not true! When I was a noob, I knew to use cursors for EVERYTHING.
:w00t:
September 1, 2016 at 10:28 am
Lynn Pettis (9/1/2016)
Jeff Moden (9/1/2016)
GilaMonster (9/1/2016)
I uploaded the slide-deck in progress. Comments?http://www.sqlsaturday.com/554/Sessions/Details.aspx?sid=53948
I don't know who else (if anyone) is on the panel. Guess it'll be a surprise on the day.
Looks good, Gail.
Just a couple of things that I'd include if I got volunteered for such a thing.
I can't speak for others but I owe a great amount of my personal success, not only in forums but on the job, to being able to rapidly create large volumes of test data that closely mimics what the tables being queried will actually contain. This is especially important where no such quantity of data exists on new projects and, of course, when building things like functions. It's also necessary to know how to put that data out on a file similar to what you might receive if you're designing some form of ETL whether it be in T-SQL or some tool such as SSIS.
You might even want to run a narrow example of something like that just to show them how fast it can run to wet their appetite.
Knowing how to interrogate execution plans is also a key. Although it may be a bit of an advanced subject for newbies, they should at least learn how to turn it on and start looking and learning. For example, do you really want that Index Seek, which turns out to be executing 60,000 times because of an improper index selection?
Learning some of the basic but uber important stuff, like SARGability, very early will make a new Developer's life a whole lot easier, as well.
Last but not least, no newbie should be allowed to use a Cursor or While loop for at least the first year because it's too easy to fall back on. People correctly say "Use them when appropriate" but most newbies aren't qualified to figure out what's actually appropriate.
IMPORTANT!! Find a mentor! Doesn't have to be someone at work or even locally. I credit ssc for much of what I have learned, and Jeff Moden is just one of the many heavy hitters that have had an big impact on my knowledge of SQL Server over the past 11 years and I have been working with SQL Server since 96 (SQL Server 6.5).
+1
September 1, 2016 at 10:31 am
Took a look at local weather over lunch time and immediately saw:
83° Mostly Cloudy
feels like 90°
H 84° / L 77°
UV Index 4 of 10
? Thunder start 2:15 pm
? Thunder stop 7:00 pm
OH COME ON! The hurricane hasn't even made landfall yet and now I have to deal with almost 5 hours of thunderstorms? REALLY?
Siiiiiiiiiiiiggggggggghhhhhhhh. Better make sure my laptops & phone are charged up.
September 1, 2016 at 10:35 am
Brandie Tarvin (9/1/2016)
Took a look at local weather over lunch time and immediately saw:83° Mostly Cloudy
feels like 90°
H 84° / L 77°
UV Index 4 of 10
? Thunder start 2:15 pm
? Thunder stop 7:00 pm
OH COME ON! The hurricane hasn't even made landfall yet and now I have to deal with almost 5 hours of thunderstorms? REALLY?
Siiiiiiiiiiiiggggggggghhhhhhhh. Better make sure my laptops & phone are charged up.
And work wonders why I don't want to go to Tampa.
September 1, 2016 at 1:24 pm
And his forced vacation from SSC did nothing to motivate White Horse from his berating ways. Who let him back in?
September 1, 2016 at 1:33 pm
Lynn Pettis (9/1/2016)
And his forced vacation from SSC did nothing to motivate White Horse from his berating ways. Who let him back in?
Odd...I can't find it. And when going to his articles I figured I would see him in the discussion but all the discussion threads throw an error.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
September 1, 2016 at 1:37 pm
Sean Lange (9/1/2016)
Lynn Pettis (9/1/2016)
And his forced vacation from SSC did nothing to motivate White Horse from his berating ways. Who let him back in?Odd...I can't find it. And when going to his articles I figured I would see him in the discussion but all the discussion threads throw an error.
Check http://www.sqlservercentral.com/Forums/Topic978608-392-2.aspx
September 1, 2016 at 1:39 pm
djj (9/1/2016)
Sean Lange (9/1/2016)
Lynn Pettis (9/1/2016)
And his forced vacation from SSC did nothing to motivate White Horse from his berating ways. Who let him back in?Odd...I can't find it. And when going to his articles I figured I would see him in the discussion but all the discussion threads throw an error.
Check http://www.sqlservercentral.com/Forums/Topic978608-392-2.aspx
Actually, here.
September 1, 2016 at 1:46 pm
Lynn Pettis (9/1/2016)
djj (9/1/2016)
Sean Lange (9/1/2016)
Lynn Pettis (9/1/2016)
And his forced vacation from SSC did nothing to motivate White Horse from his berating ways. Who let him back in?Odd...I can't find it. And when going to his articles I figured I would see him in the discussion but all the discussion threads throw an error.
Check http://www.sqlservercentral.com/Forums/Topic978608-392-2.aspx
Actually, here.
He was actually showing improvement in other threads. Well, nothing lasts forever.
September 1, 2016 at 1:54 pm
djj (9/1/2016)
Sean Lange (9/1/2016)
Lynn Pettis (9/1/2016)
And his forced vacation from SSC did nothing to motivate White Horse from his berating ways. Who let him back in?Odd...I can't find it. And when going to his articles I figured I would see him in the discussion but all the discussion threads throw an error.
Check http://www.sqlservercentral.com/Forums/Topic978608-392-2.aspx
He must have a massive copy and paste response library. So many of his responses have more to do with ring knocking and being condescending than they do with the actual topic at hand. He reminds me of those guys holding a "REPENT: the end is near" sign.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
September 1, 2016 at 3:25 pm
Luis Cazares (9/1/2016)
Lynn Pettis (9/1/2016)
djj (9/1/2016)
Sean Lange (9/1/2016)
Lynn Pettis (9/1/2016)
And his forced vacation from SSC did nothing to motivate White Horse from his berating ways. Who let him back in?Odd...I can't find it. And when going to his articles I figured I would see him in the discussion but all the discussion threads throw an error.
Check http://www.sqlservercentral.com/Forums/Topic978608-392-2.aspx
Actually, here.
He was actually showing improvement in other threads. Well, nothing lasts forever.
I was really enjoying the quiet while he was away. I suppose all good things must end.
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
September 2, 2016 at 2:02 am
Lynn Pettis (9/1/2016)
And his forced vacation from SSC did nothing to motivate White Horse from his berating ways. Who let him back in?
"Forced vacation"... I can think of several interpretations of that... 😀
Thomas Rushton
blog: https://thelonedba.wordpress.com
September 2, 2016 at 12:48 pm
ThomasRushton (9/2/2016)
Lynn Pettis (9/1/2016)
And his forced vacation from SSC did nothing to motivate White Horse from his berating ways. Who let him back in?"Forced vacation"... I can think of several interpretations of that... 😀
Yeah, there are several meanings to it.
However, here in the US, this is the start of Labor Day weekend. We'll have a whole lot of people traveling, padding the weekend with extra days to take the end-of-summer vacation and grilling. I hope everyone has a safe weekend.
September 2, 2016 at 3:00 pm
Ed Wagner (9/2/2016)
I hope everyone has a safe weekend.
It's the beginning of the SQLSaturday madness for me. 3 SQL Saturdays, 3 cities, 3 weeks
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
Viewing 15 posts - 55,636 through 55,650 (of 66,815 total)
You must be logged in to reply to this topic. Login to reply