April 23, 2013 at 8:40 am
Brandie Tarvin (4/22/2013)
Hey guys, I need your help please. On Wednesday we're having a "bring the kids to work day" and I'm helping out. I've been asked to "train" the kids on my job. It's a small group of 8-12 year olds and I need 30-45 minutes worth of fun activities that give them an idea of what I do.Anyone have any thoughts?
A lot of games need a data layer. Maybe you could work with them to design a back-end for a 20 Questions-like game. The database would need to store data on famous people and using the answers to Yes/No questions whittle down the candidates. May not be do-able in that time frame, but it's a thought.
April 23, 2013 at 9:27 am
jasona.work (4/23/2013)
Frickin fracking g***amn locked down idiot nitwit domains!!!Fracking place implemented / started enforcing a policy that prevents ANY accounts from having the "replace a process level token" privilege, thereby BREAKING ALL the Agent jobs that run DTS / SSIS packages on 3 different servers!
I can't re-add any accounts to the privilege because it's handled by the GPO, can't (quickly) get the policy modified, can't have the servers put in the "exception" group where I COULD add accounts...
I'm sorely tempted to find out who's behind creating these GPOs, and forwarding the PO'ed e-mails and calls to them...
GRRR.
OK, thanks, just needed to vent on this...
Jason
(Now where's my prozac / valium / alcohol?)
Thanks for the laugh.
Sysadmins have a bigger communication issue than dba's - and people say dba's don't communicate well.
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 23, 2013 at 12:49 pm
Thankfully, one of the sysadmins was able to work with me to work around the problem for now (granted the service account the needed privs)
I found an MSDN article which I forwarded on to one of the people involved in requesting "exceptions" to policies that indicates that if the Agent service account doesn't have these privileges, proxies won't work.
Only took almost all day to get this worked out...
Jason
April 23, 2013 at 12:58 pm
jasona.work (4/23/2013)
Thankfully, one of the sysadmins was able to work with me to work around the problem for now (granted the service account the needed privs)I found an MSDN article which I forwarded on to one of the people involved in requesting "exceptions" to policies that indicates that if the Agent service account doesn't have these privileges, proxies won't work.
Only took almost all day to get this worked out...
Jason
That's good it worked out.
Unfortunate it took sooo long.
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 23, 2013 at 5:30 pm
jasona.work (4/23/2013)
Frickin fracking g***amn locked down idiot nitwit domains!!!Fracking place implemented / started enforcing a policy that prevents ANY accounts from having the "replace a process level token" privilege, thereby BREAKING ALL the Agent jobs that run DTS / SSIS packages on 3 different servers!
I can't re-add any accounts to the privilege because it's handled by the GPO, can't (quickly) get the policy modified, can't have the servers put in the "exception" group where I COULD add accounts...
I'm sorely tempted to find out who's behind creating these GPOs, and forwarding the PO'ed e-mails and calls to them...
GRRR.
OK, thanks, just needed to vent on this...
Jason
(Now where's my prozac / valium / alcohol?)
Oddly enough, that's pretty much the way I'd handle it. Not the prozac with a beer popsicle kicker. 😛 That comes later. I mean once I determined what the problem was, I'd send a couple of emails out to the "gods" to advise them that the systems were down because of an unannounced change to an unreasonable policy and they need to roll the change back until they figure out how to do it without bringing every reasonable system to it's knees.
Then I'd go to the bar. 😛 Hopefully I wouldn't run into the folks making these changes on the way because I wouldn't want to get to the bar via a term in jail. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
April 23, 2013 at 5:32 pm
Steve Thompson-454462 (4/23/2013)
Brandie Tarvin (4/22/2013)
Hey guys, I need your help please. On Wednesday we're having a "bring the kids to work day" and I'm helping out. I've been asked to "train" the kids on my job. It's a small group of 8-12 year olds and I need 30-45 minutes worth of fun activities that give them an idea of what I do.Anyone have any thoughts?
A lot of games need a data layer. Maybe you could work with them to design a back-end for a 20 Questions-like game. The database would need to store data on famous people and using the answers to Yes/No questions whittle down the candidates. May not be do-able in that time frame, but it's a thought.
Heh... to complicated. Just take Jason.A to work and let him entertain the kids with stories of GPO's as if they were dragons. 😛
--Jeff Moden
Change is inevitable... Change for the better is not.
April 23, 2013 at 6:28 pm
SQLRNNR (4/23/2013)
jasona.work (4/23/2013)
Frickin fracking g***amn locked down idiot nitwit domains!!!Fracking place implemented / started enforcing a policy that prevents ANY accounts from having the "replace a process level token" privilege, thereby BREAKING ALL the Agent jobs that run DTS / SSIS packages on 3 different servers!
I can't re-add any accounts to the privilege because it's handled by the GPO, can't (quickly) get the policy modified, can't have the servers put in the "exception" group where I COULD add accounts...
I'm sorely tempted to find out who's behind creating these GPOs, and forwarding the PO'ed e-mails and calls to them...
GRRR.
OK, thanks, just needed to vent on this...
Jason
(Now where's my prozac / valium / alcohol?)
Thanks for the laugh.
Sysadmins have a bigger communication issue than dba's - and people say dba's don't communicate well.
Depends on the sysadmin and the dba - in my experience there are very few of either who communicate well - the ones who do are mostly the ones who end up having one of those roles (while often having a lot of other responsibilities too) by accident. If anything, both are slightly worse than us developers, slightly better than PH bosses.
Best way to ensure that a meeting will achieve nothing useful (except entertain those who get to see the clandestine video of it): have a paranoid dba, a paranoid sysadmin, a developer who thinks the idea of restricting processes or logins to have only those privileges that they need, and a manager who knows all about IT because he once played with Excel and all about team building because he attended a course on communicating via Powerpoint get together to determine a resonable security policy for the server, database, apps, and end-users.
Tom
April 23, 2013 at 6:40 pm
Jeff Moden (4/23/2013)
Heh... to complicated. Just take Jason.A to work and let him entertain the kids with stories of GPO's as if they were dragons. 😛
That's too risky; if the kids have been reading the wrong stuff they'll be seeing the GPO's as heroic dragons and the DBAs as foul thread.
Safer would be to present the sysadmins as evil sorcerors casting foul black magic spells upon the system's GPO defenses to make them betray their purpose and harm the system instead of defending it.
Tom
April 23, 2013 at 7:44 pm
L' Eomot Inversé (4/23/2013)
Jeff Moden (4/23/2013)
Heh... to complicated. Just take Jason.A to work and let him entertain the kids with stories of GPO's as if they were dragons. 😛That's too risky; if the kids have been reading the wrong stuff they'll be seeing the GPO's as heroic dragons and the DBAs as foul thread.
Safer would be to present the sysadmins as evil sorcerors casting foul black magic spells upon the system's GPO defenses to make them betray their purpose and harm the system instead of defending it.
How many others caught the reference to the Dragon Riders of Pern??
April 24, 2013 at 4:14 am
Lynn Pettis (4/23/2013)
L' Eomot Inversé (4/23/2013)
Jeff Moden (4/23/2013)
Heh... to complicated. Just take Jason.A to work and let him entertain the kids with stories of GPO's as if they were dragons. 😛That's too risky; if the kids have been reading the wrong stuff they'll be seeing the GPO's as heroic dragons and the DBAs as foul thread.
Safer would be to present the sysadmins as evil sorcerors casting foul black magic spells upon the system's GPO defenses to make them betray their purpose and harm the system instead of defending it.
How many others caught the reference to the Dragon Riders of Pern??
<raises hand>
April 24, 2013 at 4:19 am
Lynn Pettis (4/23/2013)
L' Eomot Inversé (4/23/2013)
Jeff Moden (4/23/2013)
Heh... to complicated. Just take Jason.A to work and let him entertain the kids with stories of GPO's as if they were dragons. 😛That's too risky; if the kids have been reading the wrong stuff they'll be seeing the GPO's as heroic dragons and the DBAs as foul thread.
Safer would be to present the sysadmins as evil sorcerors casting foul black magic spells upon the system's GPO defenses to make them betray their purpose and harm the system instead of defending it.
How many others caught the reference to the Dragon Riders of Pern??
So long since I read those that I totally missed it. Haven't even thought about them in many moons.
My thought question: Have you ever been told that your query runs too fast?
My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.
Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St
April 24, 2013 at 6:16 am
Jeff Moden (4/23/2013)
Steve Thompson-454462 (4/23/2013)
Brandie Tarvin (4/22/2013)
Hey guys, I need your help please. On Wednesday we're having a "bring the kids to work day" and I'm helping out. I've been asked to "train" the kids on my job. It's a small group of 8-12 year olds and I need 30-45 minutes worth of fun activities that give them an idea of what I do.Anyone have any thoughts?
A lot of games need a data layer. Maybe you could work with them to design a back-end for a 20 Questions-like game. The database would need to store data on famous people and using the answers to Yes/No questions whittle down the candidates. May not be do-able in that time frame, but it's a thought.
Heh... to complicated. Just take Jason.A to work and let him entertain the kids with stories of GPO's as if they were dragons. 😛
Gather 'round little children, and let me spin you a tale of the near past future...
A tale of a great and powerful wizard people called "DBA" who had to venture forth against the horrific and evil dragons known to all as the "GPOs."
These GPOs were attended and guarded by their vicous and uncaring minions, the "SysAdmin" clan...
😀
April 24, 2013 at 7:05 am
dwain.c (4/24/2013)
Lynn Pettis (4/23/2013)
L' Eomot Inversé (4/23/2013)
Jeff Moden (4/23/2013)
Heh... to complicated. Just take Jason.A to work and let him entertain the kids with stories of GPO's as if they were dragons. 😛That's too risky; if the kids have been reading the wrong stuff they'll be seeing the GPO's as heroic dragons and the DBAs as foul thread.
Safer would be to present the sysadmins as evil sorcerors casting foul black magic spells upon the system's GPO defenses to make them betray their purpose and harm the system instead of defending it.
How many others caught the reference to the Dragon Riders of Pern??
So long since I read those that I totally missed it. Haven't even thought about them in many moons.
Probably been about (dare I say it) 30 years or there abouts since I read any of the Dragon Riders of Pern books, but it jumped right out at me when I read it.
April 24, 2013 at 7:06 am
jasona.work (4/24/2013)
Jeff Moden (4/23/2013)
Steve Thompson-454462 (4/23/2013)
Brandie Tarvin (4/22/2013)
Hey guys, I need your help please. On Wednesday we're having a "bring the kids to work day" and I'm helping out. I've been asked to "train" the kids on my job. It's a small group of 8-12 year olds and I need 30-45 minutes worth of fun activities that give them an idea of what I do.Anyone have any thoughts?
A lot of games need a data layer. Maybe you could work with them to design a back-end for a 20 Questions-like game. The database would need to store data on famous people and using the answers to Yes/No questions whittle down the candidates. May not be do-able in that time frame, but it's a thought.
Heh... to complicated. Just take Jason.A to work and let him entertain the kids with stories of GPO's as if they were dragons. 😛
Gather 'round little children, and let me spin you a tale of the near past future...
A tale of a great and powerful wizard people called "DBA" who had to venture forth against the horrific and evil dragons known to all as the "GPOs."
These GPOs were attended and guarded by their vicous and uncaring minions, the "SysAdmin" clan...
😀
Does not the great wizard also have a dog named Kerberos at his side?
April 24, 2013 at 7:31 am
Lynn Pettis (4/23/2013)
L' Eomot Inversé (4/23/2013)
Jeff Moden (4/23/2013)
Heh... to complicated. Just take Jason.A to work and let him entertain the kids with stories of GPO's as if they were dragons. 😛That's too risky; if the kids have been reading the wrong stuff they'll be seeing the GPO's as heroic dragons and the DBAs as foul thread.
Safer would be to present the sysadmins as evil sorcerors casting foul black magic spells upon the system's GPO defenses to make them betray their purpose and harm the system instead of defending it.
How many others caught the reference to the Dragon Riders of Pern??
Is the inference that Anne McCaffrey is "the wrong stuff"?
Although the idea of entertaining through story is a good one, surely Brandie can spin a tale of DBA woe and intrigue to delight. Or, heck, pull out some Phil Factor and have at thee...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
Viewing 15 posts - 39,496 through 39,510 (of 66,688 total)
You must be logged in to reply to this topic. Login to reply