September 18, 2015 at 11:26 am
Steve Jones - SSC Editor (9/18/2015)
Sorry, missed the "I".I don't use LastPass. I think everyone should use a password manager. Whether it's LastPass, 1Password, Key Pass, Password Safe, personal choice. Pick one, use it, encourage others to use them.
I've also used a separate db in a team to control shared, system passwords for joint systems that we run. For example, we've sometimes had a specific login for an applictation to hit a db, so we put it in the shared db.
Steve, do you use the free or premiere edition of Password Safe?
September 18, 2015 at 12:05 pm
Premier?
I always download from here: http://passwordsafe.sourceforge.net/. For the mobiles, I have purchased the version that allows dropbox sync.
September 18, 2015 at 1:01 pm
Why do they keep teaching this kind of stuff? http://www.sqlservercentral.com/Forums/Topic1720978-169-1.aspx
Then people wonder why there's crappy code everywhere.
September 18, 2015 at 1:17 pm
Luis Cazares (9/18/2015)
Why do they keep teaching this kind of stuff? http://www.sqlservercentral.com/Forums/Topic1720978-169-1.aspxThen people wonder why there's crappy code everywhere.
Student learns cursor
Student becomes teacher
Teacher teaches cursor
Student learns cursor
....
September 18, 2015 at 1:21 pm
Luis Cazares (9/18/2015)
Why do they keep teaching this kind of stuff? http://www.sqlservercentral.com/Forums/Topic1720978-169-1.aspxThen people wonder why there's crappy code everywhere.
Ha ha. I replied to that one as well. I said that I wouldn't hire anyone who solved this type of problem with a cursor. The best part is the student really did it without a cursor and the cursor they created is really doing nothing. It isn't even close to what I think the instructor is looking for from the cursor.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 18, 2015 at 2:00 pm
Student: Teacher, do you want the solution based on your methodology, or the correct solution? 😀
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
September 18, 2015 at 2:05 pm
Alvin Ramard (9/18/2015)
Student: Teacher, do you want the solution based on your methodology, or the correct solution? 😀
Guessing that won't work out too well. We all have to keep in mind that those who can't do, teach. 😛 This is unfortunately very true in the technology industry.
And of course, those who can't teach, coach. Err...wait a minute...I am a coach. Crap I guess that means I can't do or teach. Oh well. It is just a game that most Americans don't understand anyway. :hehe:
_______________________________________________________________
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 18, 2015 at 2:11 pm
Okay, I'm going to give the instructor the benefit of the doubt. Maybe lesson 1 is cursor and lesson 2 is set-based and there will be a discussion of why set-based is better.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 18, 2015 at 2:18 pm
Jack Corbett (9/18/2015)
Okay, I'm going to give the instructor the benefit of the doubt. Maybe lesson 1 is cursor and lesson 2 is set-based and there will be a discussion of why set-based is better.
Possible.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
September 18, 2015 at 2:20 pm
Alvin Ramard (9/18/2015)
Jack Corbett (9/18/2015)
Okay, I'm going to give the instructor the benefit of the doubt. Maybe lesson 1 is cursor and lesson 2 is set-based and there will be a discussion of why set-based is better.Possible.
Hopefully
September 18, 2015 at 2:27 pm
Sean Lange (9/18/2015)
Alvin Ramard (9/18/2015)
Student: Teacher, do you want the solution based on your methodology, or the correct solution? 😀Guessing that won't work out too well. We all have to keep in mind that those who can't do, teach. 😛 This is unfortunately very true in the technology industry.
And of course, those who can't teach, coach. Err...wait a minute...I am a coach. Crap I guess that means I can't do or teach. Oh well. It is just a game that most Americans don't understand anyway. :hehe:
Watch it, there is another coach here. What's neat about my team is watching Coach Greco. We got players trying things that he couldn't get his Varsity team to do last season. And some of these girls were on the Varsity team.
We may be getting our butts kicked right now, but the girls are keep a positive look on things. They know they are building the future and they don't have unreasonable expectations. They know they are playing against teams where the girls have been playing together for years. Plus, the teams we are playing are mostly HS seniors and we have four seniors on the team, maybe six juniors, ten sophomores, and two freshmen. Most of these girls have never played competitive soccer, some have only played few years, there are a few who have played developmental and rec level for years.
September 18, 2015 at 2:32 pm
Luis Cazares (9/18/2015)
Alvin Ramard (9/18/2015)
Jack Corbett (9/18/2015)
Okay, I'm going to give the instructor the benefit of the doubt. Maybe lesson 1 is cursor and lesson 2 is set-based and there will be a discussion of why set-based is better.Possible.
Hopefully
If you are going to teach cursors, use a situation where the use of the technology makes sense, not where a set based solution is better.
September 18, 2015 at 3:07 pm
Luis Cazares (9/18/2015)
Alvin Ramard (9/18/2015)
Jack Corbett (9/18/2015)
Okay, I'm going to give the instructor the benefit of the doubt. Maybe lesson 1 is cursor and lesson 2 is set-based and there will be a discussion of why set-based is better.Possible.
Hopefully
I'll start holding my breath... NOT!
IMO, Set-based should be taught first. Then cursors for those instances where they are truly needed.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
September 18, 2015 at 4:05 pm
Jack Corbett (9/18/2015)
Okay, I'm going to give the instructor the benefit of the doubt. Maybe lesson 1 is cursor and lesson 2 is set-based and there will be a discussion of why set-based is better.
Or the prof came from an oracle background?
Or from a dev background?
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
September 18, 2015 at 4:10 pm
SQLRNNR (9/18/2015)
Jack Corbett (9/18/2015)
Okay, I'm going to give the instructor the benefit of the doubt. Maybe lesson 1 is cursor and lesson 2 is set-based and there will be a discussion of why set-based is better.Or the prof came from an oracle background?
Or from a dev background?
My one year on the dark side, all the queries I wrote were set-based. The only time I needed a cursor was when I needed to return a result set back to the application. That was done using a reference cursor.
Viewing 15 posts - 50,641 through 50,655 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply