How to Add Content to SQLCLR.net

Any registered user can submit Articles and Examples to the site for consideration of publication on the site.  One of the primary goals of this site is to create a community driven resource for information about using CLR inside SQL Server.  However, in the interests of ensuring that the content is of an appropriate nature, all new content will require approval by one of the site administrators before being published live.

To submit an Article or Example for Review:

  1. Register on the site as a user.
  2. Login to the site.
  3. Click the Create Article Link under Articles/Examples.

    Create Article Image 

 

 

 

 

  1. Add a Title
  2. Select the Category or Categories that this post best fits under.
  3. Provide a brief synopsis in the Summary box.  Formating can be accomplished through the toolbars.
  4. Scroll down to the Article Details, and provide the information that you wish to share in detail here. 
  5. If you need to leave a contribution and return to it later, you can Save it, or when you are complete, you can click Publish Now to submit it for approval.

Some guidelines to follow:

  1. Post content that is applicable to the use of CLR in SQL Server, and content that supports your articles implementation.  This site is not intended to be an all things SQL site, and has a specific focus.  Any posting not aligned with this focus may not be approved.  However, that being said, the following can/will be considered acceptable:

    -  Supporting references and TSQL code that relate to or support the content of an article.
    -  TSQL Impementations created that outperform a common CLR Implementation.
    -  Other content as approved by the site administrator or one of the content managers on the site. 
  2. Source code can be used inside of Articles to the extent that it helps make the point of the article.  T-SQL and CLR are both allowed.
  3. If possible, please provide a C# and a VB.NET example of your source code.  If this is not possible, don't worry, one of the site administrators will try to flag the article for update later with the missing code type.  This will help those who have trouble following examples not in the language they are familiar with.
  4. It is best to not make changes to the center section of the Create Article form.  These items will be removed in a coming release of this site for non-admin users.  If you change these, they will be reset before the article is published.

Remember that this is a community site, and the information contained within will be used by people who might not know as much as you.  Please be detailed enough for the average person to follow your information to the extent possible.  Most of all have fun, and enjoy contributing to the SQL community at large so that others may learn from your experience.

Survey

Which of the following CLR objects are you currently using in SQL Server?
Submit Survey  View Results

Links

  Search

What's New

 Subscribe in a reader

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.
Building a SAFE HttpUtility Class for SQL CLR by Jonathan Kehayias

This Article covers how to build a SQL Safe version of the System.Web.HttpUtility class methods HtmlEncode and HtmlDecode.  Source code is provided in the Examples area for these specific methods to be used in SQL CLR as User-Defined Functions with a SAFE Permission Set.

Recent Examples


Copyright 2007 by SQLCLR.net Terms Of Use Privacy Statement
Website graphics provided by Matt Green Designs
Page generated in 0.2968693 seconds.

All information and example code on this site is provided 'as-is', without any express or implied warranty. In no event will the authors be held liable for any damages arising from its use.

This site is in no way affiliated with Microsoft. Unless specifically stated otherwise, nothing should be construed to represent the official positions or opinions of Microsoft and/or its Employees.