September 14, 2016 at 11:30 am
Brandie Tarvin (9/14/2016)
SQLRNNR (9/14/2016)
Brandie Tarvin (9/14/2016)
SQLRNNR (9/14/2016)
Ed Wagner (9/14/2016)
SQLRNNR (9/13/2016)
Here's a fun one. Client developer demands prod access because he used Entity Framework and now EFW has to manage the production database design. It gets better - EFW has to have sysadmin access so he can manage the server as well as the database schema from the application.Heh - it sounds like you have a fun conversation scheduled for today. 😉
Yup. The dev is a part of a much larger IT shop but did say "he is a 1 man IT shop".
His team said he is in for a rude awakening.
And this is the point where I would put a scrubbed copy of a production db down in a dev environment, restore on a daily or weekly basis (depending on the frequency of schema changes) and say "Here you go. Have fun on this sandbox server. Don't call me when you break it."
He'd get his sysadmin, but no prod, and I'd get to test my db backups. @=)
Oh it gets prettier - he created the prod box and is trying to box everybody else out. He deployed it without anybody knowing and is transitioning services to it.
Yup - that bad.
The awakening is coming.
Can his box be blocked via AD from network?
Forget I said that. Use AD to block his user account. @Toad him (as we used to say on the MUSH). Block all his access and see what he does then.
September 14, 2016 at 1:59 pm
Brandie Tarvin (9/14/2016)
Brandie Tarvin (9/14/2016)
SQLRNNR (9/14/2016)
Brandie Tarvin (9/14/2016)
SQLRNNR (9/14/2016)
Ed Wagner (9/14/2016)
SQLRNNR (9/13/2016)
Here's a fun one. Client developer demands prod access because he used Entity Framework and now EFW has to manage the production database design. It gets better - EFW has to have sysadmin access so he can manage the server as well as the database schema from the application.Heh - it sounds like you have a fun conversation scheduled for today. 😉
Yup. The dev is a part of a much larger IT shop but did say "he is a 1 man IT shop".
His team said he is in for a rude awakening.
And this is the point where I would put a scrubbed copy of a production db down in a dev environment, restore on a daily or weekly basis (depending on the frequency of schema changes) and say "Here you go. Have fun on this sandbox server. Don't call me when you break it."
He'd get his sysadmin, but no prod, and I'd get to test my db backups. @=)
Oh it gets prettier - he created the prod box and is trying to box everybody else out. He deployed it without anybody knowing and is transitioning services to it.
Yup - that bad.
The awakening is coming.
Can his box be blocked via AD from network?
Forget I said that. Use AD to block his user account. @Toad him (as we used to say on the MUSH). Block all his access and see what he does then.
We are working through it now. We will see what can be done to rectify the situation.
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
September 15, 2016 at 5:06 am
You know it's going to be one of those days when one of the kittens throws himself on the clean clothes you just laid out on the bed and keeps going back to them every time you try to move him off so you can get dressed for work.
And yes, he's over a year old, but he still acts like a kitten. He even thinks he's still tiny.
EDIT: Fixed spelling error.
September 15, 2016 at 5:32 am
Did anyone else get two copies of a newsletter yesterday?
I received the Stairway to U-SQL Level 8 at 3:59 p.m. and 6:24 p.m. (Eastern time, U.S.) yesterday. Didn't receive a newsletter at all for Tuesday.
September 15, 2016 at 5:59 am
Brandie, also got the Stairway to U-SQL twice today
September 15, 2016 at 6:42 am
Jo Pattyn (9/15/2016)
Brandie, also got the Stairway to U-SQL twice today
I got stairway to U yesterday; introduction to R today. Looks like we're going to go over the entire alphabet. 😉
September 15, 2016 at 10:47 am
Brandie Tarvin (9/15/2016)
Did anyone else get two copies of a newsletter yesterday?I received the Stairway to U-SQL Level 8 at 3:59 p.m. and 6:24 p.m. (Eastern time, U.S.) yesterday. Didn't receive a newsletter at all for Tuesday.
Yes, mis-schedule on our part. Two from Tues.
September 15, 2016 at 3:06 pm
Anyone here planning to (or thinking about) going to Live! 360 Orlando?
As a speaker, I have been given a special registration code that triggers a cheaper price $500 off the standard registration price (or $100 off the current Super Early Bird price).
See my blog if you want to know more, or register diectly using this link (with the code pre-populated).
September 15, 2016 at 3:36 pm
I submitted an abstract, but it was turned down, so no (and frankly I'm just about travelled-out this year)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 15, 2016 at 4:54 pm
Hugo Kornelis (9/15/2016)
Anyone here planning to (or thinking about) going to Live! 360 Orlando?As a speaker, I have been given a special registration code that triggers a cheaper price $500 off the standard registration price (or $100 off the current Super Early Bird price).
See my blog if you want to know more, or register diectly using this link (with the code pre-populated).
I'll see you there. I was sure that I hadn't submitted, but somehow I'm on the schedule.
September 15, 2016 at 7:18 pm
Okay, I'm at a loss to explain this one. It's a mystery worth looking at.
http://www.sqlservercentral.com/Forums/Topic1818131-3077-1.aspx
Edited to add: Although he is showing them as heaps, adding primary keys to both tables makes no difference to the results either.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 16, 2016 at 1:28 am
Steve Jones - SSC Editor (9/15/2016)
Hugo Kornelis (9/15/2016)
Anyone here planning to (or thinking about) going to Live! 360 Orlando?As a speaker, I have been given a special registration code that triggers a cheaper price $500 off the standard registration price (or $100 off the current Super Early Bird price).
See my blog if you want to know more, or register diectly using this link (with the code pre-populated).
I'll see you there. I was sure that I hadn't submitted, but somehow I'm on the schedule.
And that that right there Steve, is proof that you have done too much this year and need a break 😉
Rodders...
September 16, 2016 at 6:01 am
These posts offering ways to get rid of weight loss? What? Eat more SPAM. Eat more pies. Icecream. Cakes.
All works for me... 😉
Thomas Rushton
blog: https://thelonedba.wordpress.com
September 16, 2016 at 6:05 am
ThomasRushton (9/16/2016)
These posts offering ways to get rid of weight loss? What? Eat more SPAM. Eat more pies. Icecream. Cakes.All works for me... 😉
I never thought there'd be a day where I wished for a CAPTCHA field where there wasn't one 😛
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Viewing 15 posts - 55,816 through 55,830 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply