Chapter 4
Securing the Instance
Information in this chapter:
• What to Install, and When
• SQL Authentication and Windows Authentication
• Password Change Policies
• Auditing Failed Logins
• Renaming the SA Account
• Disabling the SA Account
• Securing Endpoints
• Stored Procedures as a Security Measure
• Minimum Permissions Possible
• Instant File Initialization
• Linked Servers
• Using Policies to Secure Your Instance
• SQL Azure Specific Settings
• Instances That Leave the Office
• Securing “Always On”
• Securing Contained Databases
• Summary
What to Install, and When?
When building a new Microsoft SQL Server, proper security planning starts even before you launch the SQL Server installer. Each component of the Microsoft SQL Server product ...
Get Securing SQL Server, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
