August 7, 2015 at 6:04 am
Ed Wagner (8/7/2015)
Koen Verbeeck (8/7/2015)
Brandie Tarvin (8/7/2015)
Grant Fritchey (8/7/2015)
Jeff Moden (8/6/2015)
I've got just the ride for you, Grant. I gave up on the handheld weapons. I'd like to introduce you to the new, improved THVPL (Tactical High Velocity Porkchop Launcher). Rumor has it that it could replace the A10 Wart Hog! (scroll down...)SWEET!
I'll take two.
What's the ROI on that?
My boss will want to know before we put in our order. 😛
Over 9000 😎
The real question is where we'd store the THVPLs until they're needed. We'd need to have our own strike team - the THVPST. It would also use an awful lot of potential bacon by using the whole hog. The image, however, is priceless. 😛
Storing them for Jeff is easy, he lets the Air National Guard hold on to them, then when he needs a strike calls over and whistles one up...
August 7, 2015 at 7:14 am
jasona.work (8/7/2015)
Ed Wagner (8/7/2015)
Koen Verbeeck (8/7/2015)
Brandie Tarvin (8/7/2015)
Grant Fritchey (8/7/2015)
Jeff Moden (8/6/2015)
I've got just the ride for you, Grant. I gave up on the handheld weapons. I'd like to introduce you to the new, improved THVPL (Tactical High Velocity Porkchop Launcher). Rumor has it that it could replace the A10 Wart Hog! (scroll down...)SWEET!
I'll take two.
What's the ROI on that?
My boss will want to know before we put in our order. 😛
Over 9000 😎
The real question is where we'd store the THVPLs until they're needed. We'd need to have our own strike team - the THVPST. It would also use an awful lot of potential bacon by using the whole hog. The image, however, is priceless. 😛
Storing them for Jeff is easy, he lets the Air National Guard hold on to them, then when he needs a strike calls over and whistles one up...
You do realize that you're going to be receiving requests for tours of the hangar. 😛
August 7, 2015 at 7:37 am
Ed Wagner (8/7/2015)
jasona.work (8/7/2015)
Ed Wagner (8/7/2015)
Koen Verbeeck (8/7/2015)
Brandie Tarvin (8/7/2015)
Grant Fritchey (8/7/2015)
Jeff Moden (8/6/2015)
I've got just the ride for you, Grant. I gave up on the handheld weapons. I'd like to introduce you to the new, improved THVPL (Tactical High Velocity Porkchop Launcher). Rumor has it that it could replace the A10 Wart Hog! (scroll down...)SWEET!
I'll take two.
What's the ROI on that?
My boss will want to know before we put in our order. 😛
Over 9000 😎
The real question is where we'd store the THVPLs until they're needed. We'd need to have our own strike team - the THVPST. It would also use an awful lot of potential bacon by using the whole hog. The image, however, is priceless. 😛
Storing them for Jeff is easy, he lets the Air National Guard hold on to them, then when he needs a strike calls over and whistles one up...
You do realize that you're going to be receiving requests for tours of the hangar. 😛
A few months back, I found that if I turn left when I get off the freeway heading home, instead of right, it takes you right outside the base fence and you can look in to see the A10s parked in the outdoor shelters (think really big car ports.)
Now I've got an urge to get home and load up FSX and do some flights out of Selfridge...
August 7, 2015 at 11:00 am
Another day, another "how do we prevent sysadmins from doing something" post. Which almost always boils down to essentially "we don't trust anyone, and we think this will be more secure."
But, the good DBAs get fed up with the "we don't trust you" attitude and leave, the less-good ones stay, and things get steadily worse.
At least where I work, despite being fairly high security, they're not trying to find ways to keep me from doing certain things, but instead use a combination of trust (imagine that) that I won't do something that would be a problem, and using an audit to record said actions.
That I can live with.
If it were "you need to revoke your ability to add users with sysadmin privileges so that you can't add a back-door account for yourself," I'd laugh, explain to them why this isn't possible, and if they insisted start job hunting...
August 7, 2015 at 11:06 am
Ed Wagner (8/7/2015)
It would also use an awful lot of potential bacon by using the whole hog.
Sometimes you just have to go "whole hog" on certain problems. 😀
--Jeff Moden
Change is inevitable... Change for the better is not.
August 7, 2015 at 12:16 pm
jasona.work (8/7/2015)
Another day, another "how do we prevent sysadmins from doing something" post. Which almost always boils down to essentially "we don't trust anyone, and we think this will be more secure."But, the good DBAs get fed up with the "we don't trust you" attitude and leave, the less-good ones stay, and things get steadily worse.
At least where I work, despite being fairly high security, they're not trying to find ways to keep me from doing certain things, but instead use a combination of trust (imagine that) that I won't do something that would be a problem, and using an audit to record said actions.
That I can live with.
If it were "you need to revoke your ability to add users with sysadmin privileges so that you can't add a back-door account for yourself," I'd laugh, explain to them why this isn't possible, and if they insisted start job hunting...
One has to "love" that thread!.
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
August 7, 2015 at 12:30 pm
SQLRNNR (8/7/2015)
jasona.work (8/7/2015)
Another day, another "how do we prevent sysadmins from doing something" post. Which almost always boils down to essentially "we don't trust anyone, and we think this will be more secure."But, the good DBAs get fed up with the "we don't trust you" attitude and leave, the less-good ones stay, and things get steadily worse.
At least where I work, despite being fairly high security, they're not trying to find ways to keep me from doing certain things, but instead use a combination of trust (imagine that) that I won't do something that would be a problem, and using an audit to record said actions.
That I can live with.
If it were "you need to revoke your ability to add users with sysadmin privileges so that you can't add a back-door account for yourself," I'd laugh, explain to them why this isn't possible, and if they insisted start job hunting...
One has to "love" that thread!.
Link?
--Jeff Moden
Change is inevitable... Change for the better is not.
August 7, 2015 at 12:38 pm
Jeff Moden (8/7/2015)
SQLRNNR (8/7/2015)
jasona.work (8/7/2015)
Another day, another "how do we prevent sysadmins from doing something" post. Which almost always boils down to essentially "we don't trust anyone, and we think this will be more secure."But, the good DBAs get fed up with the "we don't trust you" attitude and leave, the less-good ones stay, and things get steadily worse.
At least where I work, despite being fairly high security, they're not trying to find ways to keep me from doing certain things, but instead use a combination of trust (imagine that) that I won't do something that would be a problem, and using an audit to record said actions.
That I can live with.
If it were "you need to revoke your ability to add users with sysadmin privileges so that you can't add a back-door account for yourself," I'd laugh, explain to them why this isn't possible, and if they insisted start job hunting...
One has to "love" that thread!.
Link?
Probably this: http://www.sqlservercentral.com/Forums/Topic1709275-2799-1.aspx
August 7, 2015 at 12:53 pm
Luis Cazares (8/7/2015)
Jeff Moden (8/7/2015)
SQLRNNR (8/7/2015)
jasona.work (8/7/2015)
Another day, another "how do we prevent sysadmins from doing something" post. Which almost always boils down to essentially "we don't trust anyone, and we think this will be more secure."But, the good DBAs get fed up with the "we don't trust you" attitude and leave, the less-good ones stay, and things get steadily worse.
At least where I work, despite being fairly high security, they're not trying to find ways to keep me from doing certain things, but instead use a combination of trust (imagine that) that I won't do something that would be a problem, and using an audit to record said actions.
That I can live with.
If it were "you need to revoke your ability to add users with sysadmin privileges so that you can't add a back-door account for yourself," I'd laugh, explain to them why this isn't possible, and if they insisted start job hunting...
One has to "love" that thread!.
Link?
Probably this: http://www.sqlservercentral.com/Forums/Topic1709275-2799-1.aspx
Gosh...glad I don't work there.
50k post update - just over 50 more to go. :w00t:
_______________________________________________________________
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/
August 7, 2015 at 12:59 pm
Sean Lange (8/7/2015)
50k post update - just over 50 more to go. :w00t:
5 more to get to page 1K for me.
August 7, 2015 at 1:04 pm
Luis Cazares (8/7/2015)
Jeff Moden (8/7/2015)
SQLRNNR (8/7/2015)
jasona.work (8/7/2015)
Another day, another "how do we prevent sysadmins from doing something" post. Which almost always boils down to essentially "we don't trust anyone, and we think this will be more secure."But, the good DBAs get fed up with the "we don't trust you" attitude and leave, the less-good ones stay, and things get steadily worse.
At least where I work, despite being fairly high security, they're not trying to find ways to keep me from doing certain things, but instead use a combination of trust (imagine that) that I won't do something that would be a problem, and using an audit to record said actions.
That I can live with.
If it were "you need to revoke your ability to add users with sysadmin privileges so that you can't add a back-door account for yourself," I'd laugh, explain to them why this isn't possible, and if they insisted start job hunting...
One has to "love" that thread!.
Link?
Probably this: http://www.sqlservercentral.com/Forums/Topic1709275-2799-1.aspx
Thanks, Luis. I had to post...I'll probably regret it later, but I felt compelled to. It doesn't have to be that hard.
August 7, 2015 at 1:41 pm
jasona.work (8/7/2015)
Jeff Moden (8/6/2015)
Grant Fritchey (8/5/2015)
jasona.work (8/5/2015)
GilaMonster (8/5/2015)
jasona.work (8/5/2015)
GilaMonster (8/5/2015)
Snippets and a whole pile of script files saved in DropBox and on a creditcard-shaped flash drive (which I need to update).And to get back on topic:
"What book do I read to become expert on advanced database internals" (paraphrased)
I don't think my reply of "All of them" was appreciated.
What, you mean there's no magic "you're an expert now" book for SQL?
Ideally in a Cliffs' Notes edition?
I'm sorry, I'll get on that right away for you. It should be done in about 8 years.
That won't work, I need it yesterday because I screen-scraped a couple blogs (this one: http://www.scarydba.com/ and this one: http://sqlinthewild.co.za/) and pawned them off as my own to get a DBA job!
(I KID! I'd never do such a thing! Please don't kill me!)
On a side note, anyone want my summer cold? I'll even drive to your house and deliver it in person...
No need. I'm on way to your house....
I've got just the ride for you, Grant. I gave up on the handheld weapons. I'd like to introduce you to the new, improved THVPL (Tactical High Velocity Porkchop Launcher). Rumor has it that it could replace the A10 Wart Hog! (scroll down...)
So *THAT'S* what they're looking to replace the A10s at Selfridge ANG with!
I wondered why I was hearing both jet engines and squeeling pigs overhead...
I would hate to be the cleanup crew in the weapons locker....
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
August 7, 2015 at 3:26 pm
Jeff Moden (8/7/2015)
SQLRNNR (8/7/2015)
jasona.work (8/7/2015)
Another day, another "how do we prevent sysadmins from doing something" post. Which almost always boils down to essentially "we don't trust anyone, and we think this will be more secure."But, the good DBAs get fed up with the "we don't trust you" attitude and leave, the less-good ones stay, and things get steadily worse.
At least where I work, despite being fairly high security, they're not trying to find ways to keep me from doing certain things, but instead use a combination of trust (imagine that) that I won't do something that would be a problem, and using an audit to record said actions.
That I can live with.
If it were "you need to revoke your ability to add users with sysadmin privileges so that you can't add a back-door account for yourself," I'd laugh, explain to them why this isn't possible, and if they insisted start job hunting...
One has to "love" that thread!.
Link?
You found it.
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
August 7, 2015 at 4:30 pm
SQLRNNR (8/7/2015)
Jeff Moden (8/7/2015)
SQLRNNR (8/7/2015)
jasona.work (8/7/2015)
Another day, another "how do we prevent sysadmins from doing something" post. Which almost always boils down to essentially "we don't trust anyone, and we think this will be more secure."But, the good DBAs get fed up with the "we don't trust you" attitude and leave, the less-good ones stay, and things get steadily worse.
At least where I work, despite being fairly high security, they're not trying to find ways to keep me from doing certain things, but instead use a combination of trust (imagine that) that I won't do something that would be a problem, and using an audit to record said actions.
That I can live with.
If it were "you need to revoke your ability to add users with sysadmin privileges so that you can't add a back-door account for yourself," I'd laugh, explain to them why this isn't possible, and if they insisted start job hunting...
One has to "love" that thread!.
Link?
You found it.
So did I and I've responded to it....we had to implement a 'home grown' solution for something similar and it has been nothing but headaches trying to do our work on those 'locked down' databases - but the headache is mainly for the user. There's three servers that I cannot access at all, even when I'm on call. I have to escalate whenever anything happens on them. So the requester gets reminded that I cannot do the work and will have to wait until the approved DBA gets written permission (email) to do the work and is then granted the proper access to begin the work. But it is what they wanted......
-SQLBill
-SQLBill
August 7, 2015 at 5:00 pm
SQLBill (8/7/2015)
SQLRNNR (8/7/2015)
Jeff Moden (8/7/2015)
SQLRNNR (8/7/2015)
jasona.work (8/7/2015)
Another day, another "how do we prevent sysadmins from doing something" post. Which almost always boils down to essentially "we don't trust anyone, and we think this will be more secure."But, the good DBAs get fed up with the "we don't trust you" attitude and leave, the less-good ones stay, and things get steadily worse.
At least where I work, despite being fairly high security, they're not trying to find ways to keep me from doing certain things, but instead use a combination of trust (imagine that) that I won't do something that would be a problem, and using an audit to record said actions.
That I can live with.
If it were "you need to revoke your ability to add users with sysadmin privileges so that you can't add a back-door account for yourself," I'd laugh, explain to them why this isn't possible, and if they insisted start job hunting...
One has to "love" that thread!.
Link?
You found it.
So did I and I've responded to it....we had to implement a 'home grown' solution for something similar and it has been nothing but headaches trying to do our work on those 'locked down' databases - but the headache is mainly for the user. There's three servers that I cannot access at all, even when I'm on call. I have to escalate whenever anything happens on them. So the requester gets reminded that I cannot do the work and will have to wait until the approved DBA gets written permission (email) to do the work and is then granted the proper access to begin the work. But it is what they wanted......
-SQLBill
-SQLBill
I feel for you. It's these kinds of things that just makes it an absolute nightmare at some places.
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
Viewing 15 posts - 49,936 through 49,950 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply