{"action":"opened","issue":{"url":"https://api.github.com/repos/karally/SDE-Github-Integration/issues/9","repository_url":"https://api.github.com/repos/karally/SDE-Github-Integration","labels_url":"https://api.github.com/repos/karally/SDE-Github-Integration/issues/9/labels{/name}","comments_url":"https://api.github.com/repos/karally/SDE-Github-Integration/issues/9/comments","events_url":"https://api.github.com/repos/karally/SDE-Github-Integration/issues/9/events","html_url":"https://github.com/karally/SDE-Github-Integration/issues/9","id":478595451,"node_id":"MDU6SXNzdWU0Nzg1OTU0NTE=","number":9,"title":"T1399: Use dedicated server for SQL server software (Microsoft SQL Server)","user":{"login":"karally","id":35115645,"node_id":"MDQ6VXNlcjM1MTE1NjQ1","avatar_url":"https://avatars3.githubusercontent.com/u/35115645?v=4","gravatar_id":"","url":"https://api.github.com/users/karally","html_url":"https://github.com/karally","followers_url":"https://api.github.com/users/karally/followers","following_url":"https://api.github.com/users/karally/following{/other_user}","gists_url":"https://api.github.com/users/karally/gists{/gist_id}","starred_url":"https://api.github.com/users/karally/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/karally/subscriptions","organizations_url":"https://api.github.com/users/karally/orgs","repos_url":"https://api.github.com/users/karally/repos","events_url":"https://api.github.com/users/karally/events{/privacy}","received_events_url":"https://api.github.com/users/karally/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2019-08-08T17:19:54Z","updated_at":"2019-08-08T17:19:54Z","closed_at":null,"author_association":"OWNER","body":"- Ensure Single-Function Member Servers are Used:\n It is recommended that SQL Server software be installed on a dedicated server. This architectural consideration affords security flexibility in that the database server can be placed on a separate subnet allowing access only from particular hosts and over particular protocols. Degrees of availability are easier to achieve as well - over time, an enterprise can move from a single database server to a failover to a cluster using load balancing or to some combination thereof.\n\n \n\n It is difficult to see any reasonably adverse impact to making this architectural change, once the costs of making the change have been paid. Custom applications may need to be modified to accommodate database connections over the wire rather than on the host (i.e. using TCP/IP instead of Named Pipes). Additional hardware and operating system licenses may be required to make these architectural changes.\n\n"}}
{"actor":{"display_login":"karally"}}