Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««3,9293,9303,9313,9323,933»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Wednesday, April 3, 2013 7:37 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 7:14 AM
Points: 23,082, Visits: 31,623
I'm curious, how do most of you like your dihydrogen monoxide, straight or flavored?



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1438329
Posted Wednesday, April 3, 2013 7:42 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 3:49 PM
Points: 2,441, Visits: 6,433
Straight but sparkling.

--------------------------------------------------------------------------
A little knowledge is a dangerous thing (Alexander Pope)

In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)
Post #1438333
Posted Wednesday, April 3, 2013 7:45 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 6:44 AM
Points: 389, Visits: 2,318
SQLRNNR (4/2/2013)
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.


Having a normal user account and just elevating privileges when needed used to be pretty common practice, "don't run as root" is a common refrain in the unix world, and when I was a VMSer it was a normal mode of working day to day with reduced privileges and only setting privileges when needed. I can absolutely understand the psychology behind your comment however, I rarely see a windows centric administrator who didn't want full privileges all the time and there are some folks that will view other people's accepted practices as "stupid and overzealous" if they have certain personal attributes I'm all too familiar with.

Just sayin!
Post #1438338
Posted Wednesday, April 3, 2013 7:51 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 6:53 AM
Points: 961, Visits: 4,997
Lynn Pettis (4/3/2013)
I'm curious, how do most of you like your dihydrogen monoxide, straight or flavored?


Depending on the time of day, either straight or filtered through ground-up and roasted Coffea arabica or Coffea robusta...
You know, just gotta have the daily dose of 1,3,7-trimethyl-1H-purine-2,6(3H,7H)-dione 3,7-dihydro-1,3,7-trimethyl-1H-purine-2,6-dione
Post #1438346
Posted Wednesday, April 3, 2013 8:02 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 6:34 AM
Points: 2,755, Visits: 7,203
Lynn Pettis (4/3/2013)
I'm curious, how do most of you like your dihydrogen monoxide, straight or flavored?


straight and not in my lungs.


--------------------------------------
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
Post #1438357
Posted Wednesday, April 3, 2013 8:18 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:09 AM
Points: 7,136, Visits: 13,524
Lynn Pettis (4/3/2013)
I'm curious, how do most of you like your dihydrogen monoxide, straight or flavored?


I don't drink water, fish frolic in it.


“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

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
Exploring Recursive CTEs by Example Dwain Camps
Post #1438365
Posted Wednesday, April 3, 2013 8:22 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 24, 2014 2:51 PM
Points: 2,607, Visits: 17,910
Lynn Pettis (4/3/2013)
I'm curious, how do most of you like your dihydrogen monoxide, straight or flavored?


Straight.
Post #1438371
Posted Wednesday, April 3, 2013 8:25 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:03 AM
Points: 13,138, Visits: 11,978
Lynn Pettis (4/3/2013)
I'm curious, how do most of you like your dihydrogen monoxide, straight or flavored?


Fermented with barley and hops.


_______________________________________________________________

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 Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1438377
Posted Wednesday, April 3, 2013 8:29 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 3:49 PM
Points: 2,441, Visits: 6,433
Sean Lange (4/3/2013)
Lynn Pettis (4/3/2013)
I'm curious, how do most of you like your dihydrogen monoxide, straight or flavored?


Fermented with barley and hops.


+1


--------------------------------------------------------------------------
A little knowledge is a dangerous thing (Alexander Pope)

In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)
Post #1438382
Posted Wednesday, April 3, 2013 9:03 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 6:36 AM
Points: 2,954, Visits: 5,266
Chad Crawford (4/3/2013)
Lynn Pettis (4/3/2013)
I'm curious, how do most of you like your dihydrogen monoxide, straight or flavored?


Straight.


Mostly straight, not sparkling...

Twice a day caffeinated, unless it's conference season, then every hour!

Oh and Lynn, good luck with the change of scenery!

Rodders...



Post #1438416
« Prev Topic | Next Topic »

Add to briefcase «««3,9293,9303,9313,9323,933»»»

Permissions Expand / Collapse