Chapter 5
Additional Security for an Internet Facing SQL Server and Application
Information in this chapter:
• SQL CLR
• Extended Stored Procedures
• Protecting Your Connection Strings
• Database Firewalls
• Clear Virtual Memory Pagefile
• User Access Control (UAC)
• Other Domain Policies to Adjust
• Summary
SQL CLR
When the SQL CLR was introduced in Microsoft SQL Server 2005, it was probably one of the most misunderstood and misused features of SQL Server. Part of this was due to the dual marketing message that Microsoft was putting out. When you spoke with those from the .NET and database developer side of Microsoft, they said that SQL supported the CLR and that you could use it to solve all your database problems. When you spoke with those ...
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.
