concept SQL Server instance in category sql server

This is an excerpt from Manning's book SQL Server 2008 Administration in Action. Login to get full access to this book.

Configuring a SQL Server instance for soft NUMA is a two-step process. First, the instance is configured with CPU affinity, as in this example, which configures an instance to use CPUs 0–3:

Figure 5.1. A simple failover clustering example in which a SQL Server instance can move from one cluster server to another in the event of failure

Even with strong network security and authentication models in place, a SQL Server instance is far from secure if those with legitimate access to a SQL Server instance have more access than what they actually need. With a significant percentage of security breaches performed as inside jobs, the importance of least privilege is not to be underestimated.