April 1, 2013 at 8:41 am
Best of luck, Lynn, and be safe.
April 1, 2013 at 8:51 am
Sean Lange (4/1/2013)
Grant Fritchey (4/1/2013)
Lynn Pettis (3/31/2013)
Yes, I am sure about doing this, but I am both anxious and excited about going. It may not be the safest place but having talked to several friends and soldiers that have been there I feel safe enough going. Having an opportunity to actually be there working with our soldiers and our allies, it is the right thing to do.
Best of luck, and keep in touch, very regularly, when you go.
+1
Lynn, do you know yet when you are heading out?
Not sure if that is good or bad. I know if I had something like this looming I would just as soon get started. Waiting around would put my nerves so far beyond I would barely be able to function.
_______________________________________________________________
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/
April 1, 2013 at 9:20 am
Lynn Pettis (4/1/2013)
Sean Lange (4/1/2013)
Grant Fritchey (4/1/2013)
Lynn Pettis (3/31/2013)
Yes, I am sure about doing this, but I am both anxious and excited about going. It may not be the safest place but having talked to several friends and soldiers that have been there I feel safe enough going. Having an opportunity to actually be there working with our soldiers and our allies, it is the right thing to do.
Best of luck, and keep in touch, very regularly, when you go.
+1
Lynn, do you know yet when you are heading out?
The date I have been told at this time is June 23rd.
I do not doubt that this will be an interesting experience.
My wishes for your safe return,
R.
April 2, 2013 at 5:58 am
You know, silly thing, but it'd be nice if you could specify credentials for a Windows Auth connection in SSMS...
I've got two logins, one for "normal" use which has no access to SQL, and an "admin" login which does. Sure I can right-click and run as, but that's a nusciance, and 30 seconds out of my day each time...
😀
April 2, 2013 at 8:05 am
jasona.work (4/2/2013)
You know, silly thing, but it'd be nice if you could specify credentials for a Windows Auth connection in SSMS...I've got two logins, one for "normal" use which has no access to SQL, and an "admin" login which does. Sure I can right-click and run as, but that's a nusciance, and 30 seconds out of my day each time...
😀
And it is this sort of crap that causes people to just use their admin login all the time.
Either you have the perms or you don't. Make it simple and just have the one login.
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
April 2, 2013 at 9:15 am
SQLRNNR (4/2/2013)
jasona.work (4/2/2013)
You know, silly thing, but it'd be nice if you could specify credentials for a Windows Auth connection in SSMS...I've got two logins, one for "normal" use which has no access to SQL, and an "admin" login which does. Sure I can right-click and run as, but that's a nusciance, and 30 seconds out of my day each time...
😀
And it is this sort of crap that causes people to just use their admin login all the time.
Either you have the perms or you don't. Make it simple and just have the one login.
I think you can do a shorcut and bury the Run As in it.
April 2, 2013 at 9:23 am
Can somebody help here. http://www.sqlservercentral.com/Forums/Topic1437758-391-1.aspx
I know it isn't too difficult I just can't seem to figure out what they want.
_______________________________________________________________
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/
April 2, 2013 at 9:49 am
Greg Edwards-268690 (4/2/2013)
SQLRNNR (4/2/2013)
jasona.work (4/2/2013)
You know, silly thing, but it'd be nice if you could specify credentials for a Windows Auth connection in SSMS...I've got two logins, one for "normal" use which has no access to SQL, and an "admin" login which does. Sure I can right-click and run as, but that's a nusciance, and 30 seconds out of my day each time...
😀
And it is this sort of crap that causes people to just use their admin login all the time.
Either you have the perms or you don't. Make it simple and just have the one login.
I think you can do a shorcut and bury the Run As in it.
That's how I had to do it at my last place. Include /SAVECRED and you don't have to keep entering your password, except when it get's changed.
Rodders...
April 2, 2013 at 12:58 pm
SQLRNNR (4/2/2013)
jasona.work (4/2/2013)
You know, silly thing, but it'd be nice if you could specify credentials for a Windows Auth connection in SSMS...I've got two logins, one for "normal" use which has no access to SQL, and an "admin" login which does. Sure I can right-click and run as, but that's a nusciance, and 30 seconds out of my day each time...
😀
And it is this sort of crap that causes people to just use their admin login all the time.
Either you have the perms or you don't. Make it simple and just have the one login.
Maybe a more useful scenario is when you want to test security with other logins.
For example an unattended domain account used to run the SSRS reports and you want to check if it can access the ReportDB correctly.
Just thinking out of the box here 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 2, 2013 at 6:09 pm
Koen Verbeeck (4/2/2013)
SQLRNNR (4/2/2013)
jasona.work (4/2/2013)
You know, silly thing, but it'd be nice if you could specify credentials for a Windows Auth connection in SSMS...I've got two logins, one for "normal" use which has no access to SQL, and an "admin" login which does. Sure I can right-click and run as, but that's a nusciance, and 30 seconds out of my day each time...
😀
And it is this sort of crap that causes people to just use their admin login all the time.
Either you have the perms or you don't. Make it simple and just have the one login.
Maybe a more useful scenario is when you want to test security with other logins.
For example an unattended domain account used to run the SSRS reports and you want to check if it can access the ReportDB correctly.
Just thinking out of the box here 🙂
I can see having an account or two around for things like that (we all have to test perms now and again). I also would not advocate that such an account not be disabled unless in use for very specific durations for said testing.
That said, having each admin user have an account that is privileged and one that is not wreaks of over zealousness and stupidity imnho. In my experience, any user with two accounts will use one and shun the other. It doesn't lessen the exposure risk much if any.
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
April 2, 2013 at 6:48 pm
I just saw a rather disconcerting event (which was in my favor) where a local white hat broke open my PC's administrator password in about 20 seconds from a cold reboot.
Reminded me of the desperate need to encrypt your hard drive.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
April 3, 2013 at 2:02 am
Sean Lange (4/2/2013)
Can somebody help here. http://www.sqlservercentral.com/Forums/Topic1437758-391-1.aspxI know it isn't too difficult I just can't seem to figure out what they want.
Touched.
It will still be tricky, even with a full explanation.
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
April 3, 2013 at 3:49 am
The date I have been told at this time is June 23rd
Good luck. I know plenty of civilians working out there supporting our troops and as long as you follow the rules it's safe enough and they seem to have plenty of fun too.
April 3, 2013 at 7:22 am
Can somebody help here. http://www.sqlservercentral.com/Forums/Topic1437758-391-1.aspx%5B/quote%5D
I'm fairly sure he's trying to front load the Qty into the Aging column which is actually a capacity. I've put a better explanation in the thread which will hopefully add some clarity. Damned if I know how you'd achieve it though and the data structure he's working from seems bizarre.
April 3, 2013 at 7:31 am
FunkyDexter (4/3/2013)
Can somebody help here. http://www.sqlservercentral.com/Forums/Topic1437758-391-1.aspx%5B/quote%5D
I'm fairly sure he's trying to front load the Qty into the Aging column which is actually a capacity. I've put a better explanation in the thread which will hopefully add some clarity. Damned if I know how you'd achieve it though and the data structure he's working from seems bizarre.
Yeah it is quite strange. Thanks to you and Chris. The OP seems like somebody who is willing to help but the language barrier is a challenge. The requirements are as strange as the ddl.
_______________________________________________________________
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/
Viewing 15 posts - 39,286 through 39,300 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply