Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 50,446 through 50,460 (of 66,712 total)

You must be logged in to reply to this topic. Login to reply

Sean Lange SSC Guru Points: 286590 More actions · Answer 1

Sean Lange (9/1/2015)
Alvin Ramard (9/1/2015)
Sean Lange (9/1/2015)
Alvin Ramard (9/1/2015)
SQLRNNR (9/1/2015)
GilaMonster (9/1/2015)
Ed Wagner (9/1/2015)
ZZartin (9/1/2015)
Steve Jones - SSC Editor (9/1/2015)
Passwords: http://www.pcworld.com/article/2978316/security/tired-of-memorizing-passwords-a-turing-award-winner-came-up-with-this-algorithmic-trick.html
Now if only all websites used the same algorithm to determine whether a password is strong enough.....
That's a neat approach and one I've never even considered. What I do know for sure is that having all these passwords are a complete pain. I hate using any single password for more than one thing, so they pile up.
Use a password manager and stop worrying.
+100
My password manager will let me know how good my passwords are and whether or not I've used them for more than one site.
I use KeePass and it will generate a new password for every time I need a new one. They are sufficiently ridiculous but you can copy and paste the password so you don't have to remember them. You just have to remember the master password to open your personal data file.
Do you have to copy and paste passwords to log in to a site? LastPass can usually log you in automatically.
Ohhh that sounds pretty slick. Can you share your passwords across devices easily? It is super handy to have all my passwords right on my phone, laptop and desktop.

Ahh you have to upgrade to LastPass Premium to get portability. Will have to investigate and see what the monthly charge is for that.

_______________________________________________________________

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/

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 2

I'm paying $12 per year for LastPass. Well worth it in my opinion.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

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]

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

Sean Lange (9/1/2015)
Alvin Ramard (9/1/2015)
SQLRNNR (9/1/2015)
GilaMonster (9/1/2015)
Ed Wagner (9/1/2015)
ZZartin (9/1/2015)
Steve Jones - SSC Editor (9/1/2015)
Passwords: http://www.pcworld.com/article/2978316/security/tired-of-memorizing-passwords-a-turing-award-winner-came-up-with-this-algorithmic-trick.html
Now if only all websites used the same algorithm to determine whether a password is strong enough.....
That's a neat approach and one I've never even considered. What I do know for sure is that having all these passwords are a complete pain. I hate using any single password for more than one thing, so they pile up.
Use a password manager and stop worrying.
+100
My password manager will let me know how good my passwords are and whether or not I've used them for more than one site.
I use KeePass and it will generate a new password for every time I need a new one. They are sufficiently ridiculous but you can copy and paste the password so you don't have to remember them. You just have to remember the master password to open your personal data file.

Last word on the subject....

LastPass

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

Sean Lange (9/1/2015)
Sean Lange (9/1/2015)
Alvin Ramard (9/1/2015)
Sean Lange (9/1/2015)
Alvin Ramard (9/1/2015)
SQLRNNR (9/1/2015)
GilaMonster (9/1/2015)
Ed Wagner (9/1/2015)
ZZartin (9/1/2015)
Steve Jones - SSC Editor (9/1/2015)
Passwords: http://www.pcworld.com/article/2978316/security/tired-of-memorizing-passwords-a-turing-award-winner-came-up-with-this-algorithmic-trick.html
Now if only all websites used the same algorithm to determine whether a password is strong enough.....
That's a neat approach and one I've never even considered. What I do know for sure is that having all these passwords are a complete pain. I hate using any single password for more than one thing, so they pile up.
Use a password manager and stop worrying.
+100
My password manager will let me know how good my passwords are and whether or not I've used them for more than one site.
I use KeePass and it will generate a new password for every time I need a new one. They are sufficiently ridiculous but you can copy and paste the password so you don't have to remember them. You just have to remember the master password to open your personal data file.
Do you have to copy and paste passwords to log in to a site? LastPass can usually log you in automatically.
Ohhh that sounds pretty slick. Can you share your passwords across devices easily? It is super handy to have all my passwords right on my phone, laptop and desktop.
Ahh you have to upgrade to LastPass Premium to get portability. Will have to investigate and see what the monthly charge is for that.

Besides the portability etc, one thing that is nice is how easy LastPass makes it to share a password or group of passwords with a couple of other individuals.

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

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 5

SQLRNNR (9/1/2015)
Sean Lange (9/1/2015)
Sean Lange (9/1/2015)
Alvin Ramard (9/1/2015)
Sean Lange (9/1/2015)
Alvin Ramard (9/1/2015)
SQLRNNR (9/1/2015)
GilaMonster (9/1/2015)
Ed Wagner (9/1/2015)
ZZartin (9/1/2015)
Steve Jones - SSC Editor (9/1/2015)
Passwords: http://www.pcworld.com/article/2978316/security/tired-of-memorizing-passwords-a-turing-award-winner-came-up-with-this-algorithmic-trick.html
Now if only all websites used the same algorithm to determine whether a password is strong enough.....
That's a neat approach and one I've never even considered. What I do know for sure is that having all these passwords are a complete pain. I hate using any single password for more than one thing, so they pile up.
Use a password manager and stop worrying.
+100
My password manager will let me know how good my passwords are and whether or not I've used them for more than one site.
I use KeePass and it will generate a new password for every time I need a new one. They are sufficiently ridiculous but you can copy and paste the password so you don't have to remember them. You just have to remember the master password to open your personal data file.
Do you have to copy and paste passwords to log in to a site? LastPass can usually log you in automatically.
Ohhh that sounds pretty slick. Can you share your passwords across devices easily? It is super handy to have all my passwords right on my phone, laptop and desktop.
Ahh you have to upgrade to LastPass Premium to get portability. Will have to investigate and see what the monthly charge is for that.
Besides the portability etc, one thing that is nice is how easy LastPass makes it to share a password or group of passwords with a couple of other individuals.

If someone shares any password where I work, it's serious grounds for termination.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
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.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Ed Wagner SSC Guru Points: 287026 More actions · Answer 6

Jeff Moden (9/1/2015)
SQLRNNR (9/1/2015)
Sean Lange (9/1/2015)
Sean Lange (9/1/2015)
Alvin Ramard (9/1/2015)
Sean Lange (9/1/2015)
Alvin Ramard (9/1/2015)
SQLRNNR (9/1/2015)
GilaMonster (9/1/2015)
Ed Wagner (9/1/2015)
ZZartin (9/1/2015)
Steve Jones - SSC Editor (9/1/2015)
Passwords: http://www.pcworld.com/article/2978316/security/tired-of-memorizing-passwords-a-turing-award-winner-came-up-with-this-algorithmic-trick.html
Now if only all websites used the same algorithm to determine whether a password is strong enough.....
That's a neat approach and one I've never even considered. What I do know for sure is that having all these passwords are a complete pain. I hate using any single password for more than one thing, so they pile up.
Use a password manager and stop worrying.
+100
My password manager will let me know how good my passwords are and whether or not I've used them for more than one site.
I use KeePass and it will generate a new password for every time I need a new one. They are sufficiently ridiculous but you can copy and paste the password so you don't have to remember them. You just have to remember the master password to open your personal data file.
Do you have to copy and paste passwords to log in to a site? LastPass can usually log you in automatically.
Ohhh that sounds pretty slick. Can you share your passwords across devices easily? It is super handy to have all my passwords right on my phone, laptop and desktop.
Ahh you have to upgrade to LastPass Premium to get portability. Will have to investigate and see what the monthly charge is for that.
Besides the portability etc, one thing that is nice is how easy LastPass makes it to share a password or group of passwords with a couple of other individuals.
If someone shares any password where I work, it's serious grounds for termination.

I'm in the same situation at work with sharing passwords.

I tried KeyPass once, but never really populated it fully. I know there was a portable version you can put on a flash drive and run it right from there. I'm going to have to check out LastPass and compare it. I really should have them in a program somewhere...they don't usually have memory problems. 😉

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Chad Crawford SSChampion Points: 11610 More actions · Answer 7

Ed Wagner (9/1/2015)
Jeff Moden (9/1/2015)
SQLRNNR (9/1/2015)
Sean Lange (9/1/2015)
Sean Lange (9/1/2015)
Alvin Ramard (9/1/2015)
Sean Lange (9/1/2015)
Alvin Ramard (9/1/2015)
SQLRNNR (9/1/2015)
GilaMonster (9/1/2015)
Ed Wagner (9/1/2015)
ZZartin (9/1/2015)
Steve Jones - SSC Editor (9/1/2015)
Passwords: http://www.pcworld.com/article/2978316/security/tired-of-memorizing-passwords-a-turing-award-winner-came-up-with-this-algorithmic-trick.html
Now if only all websites used the same algorithm to determine whether a password is strong enough.....
That's a neat approach and one I've never even considered. What I do know for sure is that having all these passwords are a complete pain. I hate using any single password for more than one thing, so they pile up.
Use a password manager and stop worrying.
+100
My password manager will let me know how good my passwords are and whether or not I've used them for more than one site.
I use KeePass and it will generate a new password for every time I need a new one. They are sufficiently ridiculous but you can copy and paste the password so you don't have to remember them. You just have to remember the master password to open your personal data file.
Do you have to copy and paste passwords to log in to a site? LastPass can usually log you in automatically.
Ohhh that sounds pretty slick. Can you share your passwords across devices easily? It is super handy to have all my passwords right on my phone, laptop and desktop.
Ahh you have to upgrade to LastPass Premium to get portability. Will have to investigate and see what the monthly charge is for that.
Besides the portability etc, one thing that is nice is how easy LastPass makes it to share a password or group of passwords with a couple of other individuals.
If someone shares any password where I work, it's serious grounds for termination.
I'm in the same situation at work with sharing passwords.
I tried KeyPass once, but never really populated it fully. I know there was a portable version you can put on a flash drive and run it right from there. I'm going to have to check out LastPass and compare it. I really should have them in a program somewhere...they don't usually have memory problems. 😉

I use KeePass and have been very happy with it. Sync to all of my devices (via DropBox), one key-stroke autofill on the web, SSMS, RDP, or any other app on my PC (not my phone unfortunately, copy/paste there) and I only have to remember one password. I believe LastPass also has those features as well, except perhaps interfacing with non-browser software. I know everyone will have different requirements, but KeePass has been perfect for me.

rodjkidd SSCoach Points: 15916 More actions · Answer 8

First set of pictures from SQL Sat Oslo;

https://www.flickr.com/photos/127113040@N04/albums/72157655786116433

Just the 900 odd still to go through :O

Wonderful event, well worth the trip over.

Cheers,

Rodders...

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 9

SQLRNNR (9/1/2015)
Sean Lange (9/1/2015)
Alvin Ramard (9/1/2015)
SQLRNNR (9/1/2015)
GilaMonster (9/1/2015)
Ed Wagner (9/1/2015)
ZZartin (9/1/2015)
Steve Jones - SSC Editor (9/1/2015)
Passwords: http://www.pcworld.com/article/2978316/security/tired-of-memorizing-passwords-a-turing-award-winner-came-up-with-this-algorithmic-trick.html
Now if only all websites used the same algorithm to determine whether a password is strong enough.....
That's a neat approach and one I've never even considered. What I do know for sure is that having all these passwords are a complete pain. I hate using any single password for more than one thing, so they pile up.
Use a password manager and stop worrying.
+100
My password manager will let me know how good my passwords are and whether or not I've used them for more than one site.
I use KeePass and it will generate a new password for every time I need a new one. They are sufficiently ridiculous but you can copy and paste the password so you don't have to remember them. You just have to remember the master password to open your personal data file.
Last word on the subject....
LastPass

+1000

Been very happy with it since I started using it.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

jasona.work SSC Guru Points: 50117 More actions · Answer 10

Thursday before a 3-day weekend in the US = The place starting to clear out already...

Tomorrow's going to be even quieter...

Luis Cazares SSC Guru Points: 183706 More actions · Answer 11

I'm starting to hear some crickets. 😀

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 12

If I weren't planning on 2 weeks vacation real soon, I'd be off tomorrow.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

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]

Sean Lange SSC Guru Points: 286590 More actions · Answer 13

jasona.work (9/3/2015)
Thursday before a 3-day weekend in the US = The place starting to clear out already...
Tomorrow's going to be even quieter...

Nice and quiet around here today. They even gave us an extra "jean's day" today. I suspect tomorrow this place will be empty. Finally a chance to get somewhat caught up.

_______________________________________________________________

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/

jasona.work SSC Guru Points: 50117 More actions · Answer 14

Luis Cazares (9/3/2015)
I'm starting to hear some crickets. 😀

I think even the crickets have gone home already...

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 15

AAAAARRRRGGGHHHH!

The STUPID! It burns.

No, no links. Just needed to scream in agony for a moment. Go about your lives.

"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