May 28, 2019 at 1:12 pm
I just can't believe some people. I requested our DBA to gather statistics from sys.dm_exec_procedure_stats in production and store them in a non-production database for analysis without compromising permissions.
Yesterday he emailed to notify that the process had been implemented. Today, when I'm looking for the table and can't find it, I ask him for it. He just created it on production and offered to copy it whenever I need it. I ASKED FOR THE TABLE TO AVOID HAVING TO REQUEST IT EVERY SINGLE TIME!
I'm really not sure how I should reply to him.
May 28, 2019 at 1:15 pm
I just can't believe some people. I requested our DBA to gather statistics from sys.dm_exec_procedure_stats in production and store them in a non-production database for analysis without compromising permissions. Yesterday he emailed to notify that the process had been implemented. Today, when I'm looking for the table and can't find it, I ask him for it. He just created it on production and offered to copy it whenever I need it. I ASKED FOR THE TABLE TO AVOID HAVING TO REQUEST IT EVERY SINGLE TIME! I'm really not sure how I should reply to him.
I'd just go with "I think we misunderstood each other..." and explain again what you needed. Don't cast blame, even if it is their fault.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 28, 2019 at 1:18 pm
Luis Cazares wrote:I just can't believe some people. I requested our DBA to gather statistics from sys.dm_exec_procedure_stats in production and store them in a non-production database for analysis without compromising permissions. Yesterday he emailed to notify that the process had been implemented. Today, when I'm looking for the table and can't find it, I ask him for it. He just created it on production and offered to copy it whenever I need it. I ASKED FOR THE TABLE TO AVOID HAVING TO REQUEST IT EVERY SINGLE TIME! I'm really not sure how I should reply to him.
I'd just go with "I think we misunderstood each other..." and explain again what you needed. Don't cast blame, even if it is their fault.
Either that, or the porkchop launcher.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
May 28, 2019 at 2:28 pm
Good advice from "the warm-and-fuzzy DBA"
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 28, 2019 at 2:31 pm
Not only would I follow that advice, but I'd have that discussion in person then follow up with a bulleted email of the "requirements" discussed, asking for the DBA to respond with verification via email once the task had been completed. This way, everything is also in writing for if / when the DBA either fails to understand or something else comes up regarding this project.
May 28, 2019 at 2:39 pm
Good advice from "the warm-and-fuzzy DBA"
Ha! From the "I've burned way too many bridges and finally realize that throwing torches is a bad idea" DBA. I may learn slowly, but eventually, I learn.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 28, 2019 at 3:18 pm
Not only would I follow that advice, but I'd have that discussion in person then follow up with a bulleted email of the "requirements" discussed, asking for the DBA to respond with verification via email once the task had been completed. This way, everything is also in writing for if / when the DBA either fails to understand or something else comes up regarding this project.
Did I miss some <sarcasm> </sarcasm> tags?
412-977-3526 call/text
May 28, 2019 at 3:52 pm
No. Why would I put sarcasm tags? It's just good standard practice for this sort of thing to ensure everyone is on the same page.
May 28, 2019 at 3:58 pm
Those were good advises. I just had to cool down. He even knows that what they did defeats the purpose because I need to request the table to be copied every time I need it updated. The question would be why didn't he mentioned that before so we could figure out something else. Well, it's all part of knowing how to deal with certain people and "company policies".
May 28, 2019 at 4:01 pm
Luis, can he replicate it down for you?
May 28, 2019 at 4:28 pm
Luis, can he replicate it down for you?
Apparently no. I asked him if the copying process could be automated and he just mentioned that it couldn't because they're in different locations/networks.
I'm sure that there should be a way to do it, but I'm blindfolded when trying to comment anything from the productive environments.
May 28, 2019 at 4:41 pm
From my experience, replication can happen between networks / locations. In fact, that was one of the things in the SQL 2000 cert training books. I remember it clearly because I was still trying to wrap my head around the network issues involved and had to ask KKC (my spouse) some questions on that.
At the very least, he should be able to whip up a DB Mail query once daily to package the data in a file and send it to you automatically for you to import into a lower environment. Or create an isolated database in which this table is the only thing and give you read access to that.
There are a lot of ways around this problem. It just sounds like this DBA isn't interested in helping you or the corporate strictures are so tight, no one can see out of their silos.
May 28, 2019 at 4:49 pm
Or do a simple differential insert periodically into a table you (Luis) can read from. Let the data accumulate and you can do with it what you will. I agree with Brandie - it sounds like the DBA isn't interested in working with you to get something done.
May 28, 2019 at 5:21 pm
We use a fairly powerful read only user in all of our environments.
I tend to put links to policies in emails rather than reiterate them because unasked for instructions are best handled by phone or an in person visit, followed up by an email.
412-977-3526 call/text
May 28, 2019 at 7:49 pm
Ok...
I just can't believe some people. I requested our DBA to gather statistics from sys.dm_exec_procedure_stats in production and store them in a non-production database for analysis without compromising permissions. Yesterday he emailed to notify that the process had been implemented. Today, when I'm looking for the table and can't find it, I ask him for it. He just created it on production and offered to copy it whenever I need it. I ASKED FOR THE TABLE TO AVOID HAVING TO REQUEST IT EVERY SINGLE TIME! I'm really not sure how I should reply to him.
How often did you ask for it previously?
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 15 posts - 63,631 through 63,645 (of 66,738 total)
You must be logged in to reply to this topic. Login to reply