Beginning SQL Server™ 2005 Administration

Chapter 12. Administering SQL CLR Programming Objects

The objective of this chapter is to show you, the system administrator, how to manage the configuration and the settings related to maintaining the security and stability of SQL Common Language Runtime (CLR) database objects. The discussion presents you with some simple examples of CLR program code, but because this is not a programming book, I will use very basic code examples that you can obtain from Books Online and the Microsoft Web site. The purpose is to show you how to manage these objects after they have been created.

Databases and Programming

When Dan asked me to write this chapter, I immediately asked him how he intended for this topic to fit neatly into a book about database administration. You see, I'm a programmer primarily, and database administration has always been the thing that the other guys at the other end of the IT shop did.

If you're a career database administrator, then you probably know that I represent the contingent of unruly coders who often want to deploy precarious, custom-built applications on your servers. In the process of finding new and creative ways to solve problems with program code, programmers tend to break things. Because the administrator's job is to maintain a stable and secure server environment, it would naturally make sense to keep programmers (and their pesky program code) as far away from the servers as possible.

If you are a developer and you are reading this, you may think that I ...