|
Vote For It - Server Side Compiles in SQL CLR by Jonathan Kehayias
Greg Low a SQL Server MVP, has submitted a very compelling Connect item 265266, Add server-side compilation ability to SQL CLR which aims to remove the requirement to develop SQLCLR assemblies external to SQL Server. Read about this suggestion here, and vote for it by visiting the Connect site to let Microsoft know you think it is important. |
Using CLR Impersonation to Access Resources Outside of SQL Server by Jonathan Kehayias
Traditionally if you had a need to access a file or other resource outside of SQL Server, the SQL Server service account was required to have appropriate file system access to the folder or path containing the file. With CLR integration, this is no longer an absolute requirement. Identity Impersonation will allow you to implicitly or explicitly change the execution context inside of a SQLCLR Function, Procedure, or Trigger. |
Using an Application Configuration (app.config/web.config) File in SQL Server CLR Integration by Jonathan Kehayias
A common part of programming in .NET is to use an configuration file to store configuration information in an easily modifiable location. The app.config or web.config file is an invaluable inclusion in most .NET projects and developers may need to maintain this functionality as a part of logic sharing between objects in the database and the application as well. This article will demonstrate how to configure your SQLCLR project to use Configuration Files in SQL. |
|