May 6, 2013 at 5:14 am
Lynn Pettis (5/5/2013)
Ninja's_RGR'us (5/5/2013)
SQLRNNR (5/5/2013)
GilaMonster (5/5/2013)
Ninja's_RGR'us (5/4/2013)
Lynn Pettis (5/4/2013)
GilaMonster (5/4/2013)
Err... I don't know what to thinkhttp://www.sqlservercentral.com/Forums/Topic1449451-1550-1.aspx
And as long as he has been around you'd think he'd know this.
How many situations have you NEVER encountered?
I've never encountered that particular situation.
This illustrates that this issue like many others can be solved with a little logic and thought. One doesn't necessarily need to have experienced it to figure out how to resolve it.
That question was ANYTHING but trivial.
What if he's planning his first big migration and never used that tool / setting? he has the ok to shut down that prod DB but can't shut down the server.
How does he back out if something goes wrong? What if someone steals is connection (by accident)? What if that program AUTO reconnects NON stop (like Navision).
Can you kill your own spid from that same connection?
If I log back in the same server on another DB, can I then kill the connection and switch context to take back control?
I've heard of DAC, could it work in this situation (and what's the main pitfall)... if so I'll take the time to study it.
What if this setting happens within a job that somehow gets killed or stopped by an unforseen event, how will I recover from that?
People come here for guidance. They need help with what they don't know they don't know. 99+% of the folks know how to google, use books online and their support group. You guys need to look past the words and understand what the ops are actually living (all the way up to how they feel).
That's how I stopped that guy from killing himself 2 years ago. Many of you were flat out ignoring him or making it worse by "not so useful comments".
First, I am not aware of anyone trying to kill himself 2 years ago on ssc (of course I was working with Oracle then and not spending much time here during that time), and second it also comes from knowing the history of the poster.
Maybe it isn't trivial to the OP, but it is obvious that he did no research into the problem before posting the question. Tell me, when you run into something you have never experienced before, is the first thing you do jump on the internet on to a forum looking for help or do you start researching the issue trying to figure out what is happening (or happened) first then ask for help when you realize that you need additional guidance? I go for the later as I learn better from doing my own research first rather than just having someone give me the answer.
I threw a few queries into google and I didn't immediately get an answer. I'm sure theres a google search term that would throw back a link to a simple explanation, but I'm not so sure its an obvious one. Maybe he tried a few search terms, got unsatisfactory results, and popped in here to post a query. Being concerned about getting locked out is a fairly common pattern, and if he isn't routinely in a server administrator role, I could see him being unfamiliar with the command usage and subsequently hopping on here and tossing a question out before even using the command. It is not an abuse of anybody's time here on his part, I've never seen an impolite word from him, and I'm sure he didn't expect this sort of behavior from you guys as a result of him posting such a harmless question. I know I wouldn't have expected it.
May 6, 2013 at 5:23 am
Ninja's_RGR'us (5/5/2013)
That question was ANYTHING but trivial.How does he back out if something goes wrong? What if someone steals is connection (by accident)? What if that program AUTO reconnects NON stop (like Navision).
I have to agree with Ninja on this. We have an application domain account that keeps logging back onto our databases when it loses connection, so I could very easily run into this problem. I get kicked off, suddenly the app account (which isn't a person account) logs into the database and now I can't get back in?
Absolutely I can see this pain coming. Absolutely I see it not being a trival question.
May 6, 2013 at 5:49 am
Brandie Tarvin (5/6/2013)
Ninja's_RGR'us (5/5/2013)
That question was ANYTHING but trivial.How does he back out if something goes wrong? What if someone steals is connection (by accident)? What if that program AUTO reconnects NON stop (like Navision).
I have to agree with Ninja on this. We have an application domain account that keeps logging back onto our databases when it loses connection, so I could very easily run into this problem. I get kicked off, suddenly the app account (which isn't a person account) logs into the database and now I can't get back in?
Absolutely I can see this pain coming. Absolutely I see it not being a trival question.
Hopefully that app account is something other than SA and is a domain account.
And if the backend db is expected to be down, and this is a web application, I usually shut the web site down to aboid this.
But you may not have that luxury.
May 6, 2013 at 6:05 am
Greg Edwards-268690 (5/6/2013)
Brandie Tarvin (5/6/2013)
Ninja's_RGR'us (5/5/2013)
That question was ANYTHING but trivial.How does he back out if something goes wrong? What if someone steals is connection (by accident)? What if that program AUTO reconnects NON stop (like Navision).
I have to agree with Ninja on this. We have an application domain account that keeps logging back onto our databases when it loses connection, so I could very easily run into this problem. I get kicked off, suddenly the app account (which isn't a person account) logs into the database and now I can't get back in?
Absolutely I can see this pain coming. Absolutely I see it not being a trival question.
Hopefully that app account is something other than SA and is a domain account.
Well, duh. @=)
And if the backend db is expected to be down, and this is a web application, I usually shut the web site down to aboid this.
But you may not have that luxury.
We don't. The app account is used for multiple applications, only some of them web apps. To be clear though, I haven't actually run into this problem. I'm just saying that I totally get why the OP is freaking out about it because if I did run into this problem, I'd be freaking out too.
May 6, 2013 at 7:01 am
Brandie Tarvin (5/6/2013)
Ninja's_RGR'us (5/5/2013)
That question was ANYTHING but trivial.How does he back out if something goes wrong? What if someone steals is connection (by accident)? What if that program AUTO reconnects NON stop (like Navision).
I have to agree with Ninja on this. We have an application domain account that keeps logging back onto our databases when it loses connection, so I could very easily run into this problem. I get kicked off, suddenly the app account (which isn't a person account) logs into the database and now I can't get back in?
Absolutely I can see this pain coming. Absolutely I see it not being a trival question.
Well, after rereading the question, hard to say. It is very short on any facts appearing to be more of a what if than I just had this happen to me, and if it was a just happened to me there is nothing to say what he had done to try and correct the the problem before coming here.
Hate to say it, but looks to me like a lack of initiative and/or problem solving skills. Both critical skills to the work that we do on a day to day basis. And this appears to be a person who has been working with SQL Server for about 8 years.
May 6, 2013 at 11:14 am
I don't recall anyone saying the question was trivial - my recollection is that someone noted that for someone with his apparent level of experience, it seemed that there was no research done elsewhere, and the question did not say it was actually happening. (And actually, I just looked at the actual post again, and the reply was calm and rational, and the guy said "thanks" - all very low-key!) I can see where there could be some consternation if/when this does happen (I've actually seen the "single user" thing, but I happened to be the user who got in, so I was able to just reset it), but not to the point of suicide, surely. That would indicate a depth of unwellness better addressed outside of an online forum, yes? Not trying to be catty or snide here, just expressing my perspective.
Donna
May 6, 2013 at 12:02 pm
dbursey (5/6/2013)
I don't recall anyone saying the question was trivial - my recollection is that someone noted that for someone with his apparent level of experience, it seemed that there was no research done elsewhere, and the question did not say it was actually happening. (And actually, I just looked at the actual post again, and the reply was calm and rational, and the guy said "thanks" - all very low-key!) I can see where there could be some consternation if/when this does happen (I've actually seen the "single user" thing, but I happened to be the user who got in, so I was able to just reset it), but not to the point of suicide, surely. That would indicate a depth of unwellness better addressed outside of an online forum, yes? Not trying to be catty or snide here, just expressing my perspective.Donna
Thank you.
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 7, 2013 at 4:43 am
Some pictures of a couple of people you may know of from the Medieval evening as SQLbits...
Cheers,
Rodders...
May 7, 2013 at 4:48 am
rodjkidd (5/7/2013)
Some pictures of a couple of people you may know of from the Medieval evening as SQLbits...Cheers,
Rodders...
Ah, Templar photo-bombing at it's best. WHOOP!
"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 7, 2013 at 5:35 am
rodjkidd (5/7/2013)
Some pictures of a couple of people you may know of from the Medieval evening as SQLbits...Cheers,
Rodders...
Why do I suddenly have Mel Brooks belting out "The Inquisition" running through my head?
Now I want to go watch "History of the World..."
Send in the NUNS!
😀
May 7, 2013 at 5:44 am
rodjkidd (5/7/2013)
Some pictures of a couple of people you may know of from the Medieval evening as SQLbits...Cheers,
Rodders...
I didn't see you Rod, but bumped into a few folks I know from the Maidenhead group and elsewhere.
Some of those lectures were inspired.
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 7, 2013 at 6:38 am
Grant, Jason, Chris
Best photo bomb ever! I had the camera on sports / burst mode so I have 4 /5 shots... Now you see him / now you don't / now you see him sort of thing!
It was a very good SQL Bits, learnt alot, I think I managed 100% on the sessions I picked. I have in the past picked one or two that looked like something I could use but for whatever reason wasn't the right one to pick.
Chris, well I was in one of the helper tops and yellow / green / red jester hat! I did keep an eye out for you. I have to say though, being a helper, while fun, does suck up alot of the mingling time you have. Especially on the Saturday with the increased numbers. But I didn't see you!
One person did leave a message for me at the front desk and I finally met up with him around lunch time!
Cheers,
Rodders...
May 7, 2013 at 8:00 am
The guy in the brown top (or "jack") in the bottom right quadrant of this pic - that's my medikit exactly, and my own mother wouldn't recognise me in it. I caught the last 15 minutes of Grant Fritchey's talk on saturday morning when he was playing the audience, and wished I'd been there from the start; Hugo K's excellent MERGE presentation, and one about the new analytical functions in 2012 which was "fair". Friday night was awesome and helped take my mind off a friend's funeral the day before. Freakin' freaky. Funeral with bow, programming conference with bow.
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 7, 2013 at 8:11 am
Oops I was Hugo's room monitor... I took a picture of the people in the room, where you there by then? He joked that I should take the session...
I liked his session, but then I've only written two MERGE statements in anger!
Rodders...
May 7, 2013 at 8:24 am
Middle right, 15-20 minutes early. It was good, very thorough. Some excellent questions were asked - not too edge-case.
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
Viewing 15 posts - 39,616 through 39,630 (of 66,688 total)
You must be logged in to reply to this topic. Login to reply