February 14, 2013 at 4:15 am
Does Ask SSC require a different user login than SSC? I'm logged in here, but it won't let me post an answer to someone else's question without logging in again.
February 14, 2013 at 4:19 am
Brandie Tarvin (2/14/2013)
Does Ask SSC require a different user login than SSC? I'm logged in here, but it won't let me post an answer to someone else's question without logging in again.
Yes you need a different account, you can then link the two together but it doesnt transfer points or act as a SSO relationship.
February 14, 2013 at 4:39 am
anthony.green (2/14/2013)
Brandie Tarvin (2/14/2013)
Does Ask SSC require a different user login than SSC? I'm logged in here, but it won't let me post an answer to someone else's question without logging in again.Yes you need a different account, you can then link the two together but it doesnt transfer points or act as a SSO relationship.
This is damn annoying. It won't let me reuse my email address.
February 14, 2013 at 4:42 am
Brandie Tarvin (2/14/2013)
anthony.green (2/14/2013)
Brandie Tarvin (2/14/2013)
Does Ask SSC require a different user login than SSC? I'm logged in here, but it won't let me post an answer to someone else's question without logging in again.Yes you need a different account, you can then link the two together but it doesnt transfer points or act as a SSO relationship.
This is damn annoying. It won't let me reuse my email address.
Highly strange, I have my SSC and AskSSC accounts on the same email, not registered before and forgot about it?
February 14, 2013 at 4:54 am
Brandie Tarvin (2/14/2013)
anthony.green (2/14/2013)
Brandie Tarvin (2/14/2013)
Does Ask SSC require a different user login than SSC? I'm logged in here, but it won't let me post an answer to someone else's question without logging in again.Yes you need a different account, you can then link the two together but it doesnt transfer points or act as a SSO relationship.
This is damn annoying. It won't let me reuse my email address.
Yeah, I'm on the same email addy. You should be able to.
"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
February 14, 2013 at 5:04 am
Grant Fritchey (2/14/2013)
Brandie Tarvin (2/14/2013)
anthony.green (2/14/2013)
Brandie Tarvin (2/14/2013)
Does Ask SSC require a different user login than SSC? I'm logged in here, but it won't let me post an answer to someone else's question without logging in again.Yes you need a different account, you can then link the two together but it doesnt transfer points or act as a SSO relationship.
This is damn annoying. It won't let me reuse my email address.
Yeah, I'm on the same email addy. You should be able to.
Nope. Not letting me. The Open ID process keeps erroring out on me.
Of course, SSC has been kicking me off several times over the past few weeks and forcing me to re-login, so something must be going on with my account. SIGH.
February 14, 2013 at 5:14 am
I've got the same issue as Brandie. I can't seem to log into Ask with my SSC login.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 14, 2013 at 5:45 am
GilaMonster (2/13/2013)
Personally I find LMGTFY to be incredibly condescending, I'd feel quite insulted if someone gave me that kind of reply. I'll do the search for people if I don't think they are, but what I post is the link to the google search results.
In some cases it may even be they do google it, and either don't understand, or realise that due to lack of experience their BS detector isn't up to assessing the value of the results.
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
February 14, 2013 at 5:50 am
Koen Verbeeck (2/14/2013)
I've got the same issue as Brandie. I can't seem to log into Ask with my SSC login.
The two dont act like a single sign on, but you can link your accounts together.
When you go to auth setting in Ask and select SSC, you need to use your email address registered to your ssc account, not your ssc screen name in the box on Ask, so you get an openid link like
http://www.sqlservercentral.com/openid/antg1985@hotmail.xxx.xxx
February 14, 2013 at 2:36 pm
Brandie Tarvin (2/13/2013)
I'm going to SQL Saturday in Omaha, NE. But I'm afraid that and the Jax (and probably Orlando) events are the only SQL Server related events I'll be able to afford.
See you in NE. 🙂
February 15, 2013 at 9:41 am
Hey Brandie, speaking of your account problems, did you ever get the problem where you can't get DMs fixed?
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
February 15, 2013 at 1:47 pm
So here's an idle question that no-one will see because it is right before the weekend.
Apostrophes are fairly common in names. Why do we still use ' as a text indicator in databases? Why haven't we (meaning people who design systems) created a unique symbol that we can place at either end of a text string? Instead of 'Brian O''Malley''s Restaurant (O''Hare location)', we could simply have 8Brian O'Malley's Restaurant (O'Hare location)8. No exceptioning, no confusion. If I want to put the query into a table so it can be used by email, it ends up being something like
INSERT INTO ThisTable(QueryValue)
VALUES('SELECT AField, AnotherField FROM RestaurantLocation WHERE RestaurantName = ''Brian O''Malley''s Restaurant (O''Hare location)''')
Which is a mess. Instead, it could be
INSERT INTO ThisTable(QueryValue)
VALUES(8SELECT AField, AnotherField FROM RestaurantLocation WHERE RestaurantName = 8Brian O'Malley's Restaurant (O'Hare location)88)
And that doesn't even get into trying to pull data from Oracle where I've ended up with strings with ''''''' on each side and that's not even attempting to exception in-string apostrophes.
Of course, it'd likely be something other than 8, I used that because it was easily copied, pasted and viewable.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
February 15, 2013 at 1:51 pm
Stefan Krzywicki (2/15/2013)
Why do we still use ' as a text indicator in databases? Why haven't we (meaning people who design systems) created a unique symbol that we can place at either end of a text string?
makes sense to me, but it has to one of the basic 101? or so available keyboard strokes to be useful, right? if i have to hit shift_alt+0831 or something every time i need a quote-type indicator, instead of a single key stroke, that'd get old real fast.
dunno, maybe the tilde ~ or the lefty-quote ` would be better choice?
Lowell
February 15, 2013 at 1:57 pm
Lowell (2/15/2013)
Stefan Krzywicki (2/15/2013)
Why do we still use ' as a text indicator in databases? Why haven't we (meaning people who design systems) created a unique symbol that we can place at either end of a text string?makes sense to me, but it has to one of the basic 101? or so available keyboard strokes to be useful, right? if i have to hit shift_alt+0831 or something every time i need a quote-type indicator, instead of a single key stroke, that'd get old real fast.
dunno, maybe the tilde ~ or the lefty-quote ` would be better choice?
I should think we could either have keyboards with that symbol on it or use one of the other keys instead of shift. Alt+1 or Ctrl+1 should do fine. They added a windows or apple key to most keyboards these days, so they can certainly add something like that. Heck, there's even space! They could use half the space of Backspace or the | \ key. Make the right Shift key a little smaller and put it in there and there's room for 2 new characters.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
February 15, 2013 at 2:29 pm
Stefan Krzywicki (2/15/2013)
I should think we could either have keyboards with that symbol on it or use one of the other keys instead of shift. Alt+1 or Ctrl+1 should do fine.
Well, Ctrl+1 is already assigned a specific meaning by default in SSMS, so that wouldn't do. Maybe Alt+1 would be OK.
They added a windows or apple key to most keyboards these days, so they can certainly add something like that. Heck, there's even space! They could use half the space of Backspace or the | \ key. Make the right Shift key a little smaller and put it in there and there's room for 2 new characters.
No, don't use the |\ key - I (and many others who type in computer languages other than SQL) use those symbols quite a lot. Half the space of backspace or cutting the size of rhe right Shift key is going to screw up people's touch typing. Maybe part of the Enter key could go - probably alright for me as I think I always hit the bit of it on the asdfg row but might be bad news for other people. Do most keyboards have two unused slots either side of the up key - if so, maybe those spaces could be used?
But keyboard space is a tiny part of the problem; presumably you want to be able to put it in a string and it needs to be an 8-bit character. Where are you going to put it in which code pages? Presumably you require a change to the unicode standard so that it is assigned an 8-bit value in the unicode variants where there are single byte characters? This sort of stuff can take a very long time to get through standards bodies.
Tom
Viewing 15 posts - 38,956 through 38,970 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply