Developers constantly ask about placing the latest code\feature\process\third party applications onto Production Database Servers.
I’m building an FAQ to supply Developers – as this could save me having very similar conversations .
Some other reasons for retaining a process is :
a) Maintain database standards such as ISO-11179 Naming Conventions and SQL DDL and
b) Server standards such as Should libraries be installed on database servers ?
c) Maximsing SQL Server system redundancy and high availability
Create a helpdesk request , outlining requirements. A member of the DBA Team will supply you with documentation. The documentation will request information regarding: Management requirements,Capacity Planning , Database Engine,Security, SSIS,SSAS,SSRS and Master Data Services.
A meeting will be organized to complete the requirements documentation
Create a change request . Add a member of the DBA team as an approver, who’ll review the code and advise on impact
Yes, but certain conditions must be met. As the DBA team we’d like :
Yes. There are already implementations of these features on Production Servers. Some of the key questions to discuss are : a) is this a third party vendor requirement – if so , is there internal support if troubleshooting is required.
b) If you’re planning on implementing SSIS for migrating data , outline the workflow and impact on other resources
Request a meeting with a DBA team member to discuss options
Yes. Keep in mind , generally database servers only host SQL servers. There would have to be a strong reason to process jobs on the database server. Justification is required.
SQL server – Pre size a database
SQL Server – DBA productivity and less is more