August 1, 2011 at 7:41 pm
Hi,
I am not sure whether I can ask a general question here, sorry I am posting in wrong place.
Who will write the end-user report scripts ( business logic based). no SSRS
As a DBA I can write db/server backup/monitoring/performance/troubleshoot scripts.
My manager is keep on assigning me developer tasks. How to decline work politely? Please advice.
Appriciate your help.
August 1, 2011 at 8:38 pm
laddu4700 (8/1/2011)
Hi,I am not sure whether I can ask a general question here, sorry I am posting in wrong place.
Who will write the end-user report scripts ( business logic based). no SSRS
As a DBA I can write db/server backup/monitoring/performance/troubleshoot scripts.
My manager is keep on assigning me developer tasks. How to decline work politely? Please advice.
Appriciate your help.
As a DBA - I write all kinds of code for SQL Server. I also create SSIS packages, SSRS reports, adhoc queries and basically anything else the end users need or require.
I also code review report procedures written by the developers/report writers when needed. Offer advice to the same on how to improve performance, reduce code, reduce temp table usage where possible, etc...
Because I am not in a development shop and most of the systems I support are vendor supplied, I do not get the chance to write a lot of CRUD procedures or business logic (in stored procedures). But, if I were in that kind of shop - you bet I would be writing those also.
Honestly, if you don't want to do anything except traditional production support DBA tasks - then you are probably at the wrong company. You need to find another company where they only require you to do those types of tasks and don't ask for anything else.
As to who specifically writes report procedures - well, in your organization it sounds like you are one of the individuals who is going to be tasked with that. It could be that the developers are really busy and your manager is trying to give you an opportunity for more work - and the opportunity to work with the developers to develop a better relationship.
My recommendation would be to take the opportunity to learn more about the data, the application, the users and the environment.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 2, 2011 at 12:28 pm
What is wrong with the tasks you're assigned to?
Sounds like you don't want to "get your hands dirty"... 😉
It all depends on the organization you're working for. At some places there'll be a designated dev group and the DBA needs to verify / approve the code (if at all). At other places, a DBA works close together with the dev team and they learn from each other for the benefit of the company. And finally, there are places without any developers where the DBA mostly manages 3rd party software and needs to write occasional end-user code.
To me it sounds strange that you're looking for arguments not to write some end-user scripts. I never met a DBA asking such a question...
August 2, 2011 at 12:34 pm
laddu4700 (8/1/2011)
I am not sure whether I can ask a general question here, sorry I am posting in wrong place.Who will write the end-user report scripts ( business logic based). no SSRS
As a DBA I can write db/server backup/monitoring/performance/troubleshoot scripts.
My manager is keep on assigning me developer tasks. How to decline work politely? Please advice.
It looks like you are a fine "production support dba" - don't want to add "development support" skills to your resume?
On the other hand, if you can prove without reasonable doubt your production support tasks are taking the best part of eight hours a day you can argue that you have no bandwith available 😉
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply